Data Dictionary

Add to Carts

add_to_carts

Overview

Add to Carts (ATC) represents the number of website sessions during which users added items to their shopping cart, offering insight into how effectively your website encourages user engagement and interest in products.

📘

Add to Carts = Total Number of Sessions that Include Add to Cart Actions

The calculation is based on data in the Website Analytics table.

Detailed Breakdown

The formula above is derived from the following components:

Insights and Actions

Add to Carts (ATC) tracks sessions where users added items to their cart, providing a key indicator of product interest and purchase intent.

  • Evaluate Engagement: Monitor add-to-cart actions to assess how well your website and product offerings encourage user interest and interaction.
  • Identify Conversion Opportunities: A high ATC count but low checkout rate may suggest friction points in the checkout process. Analyze and optimize for a seamless user experience.
  • Optimize Product Pages: Pair ATC data with product performance metrics to identify which items drive interest, enabling better targeting and promotional strategies.

Related Metrics

  • Conversion Rate (CR): Helps measure how many sessions with add-to-cart actions result in purchases, identifying opportunities to improve checkout flows.
  • Bounce Rate: Provides context on overall session quality, showing if users are engaging deeply or leaving quickly.
  • Average Order Value (AOV): Complements ATC data by showing the average value of orders initiated during sessions with add-to-cart actions.

Example Use

Prompt

How many add to carts were there in the last 7 days?

Response

Query

SELECT
  SUM(wat.add_to_carts) AS total_add_to_carts
FROM
  web_analytics_table AS wat
WHERE
  wat.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1;

Updated 27 days ago