Add to Cart Sessions

add_to_carts

Overview

Add to Cart Sessions (ATC) represents the number of website sessions during which users added items to their shopping cart.

📘

Add to Cart Sessions = 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 Cart Sessions 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 add-to-cart 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 cart sessions 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;