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:
- Add to Carts =
SUM(add_to_carts)
--> Website Analytics table
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 13 days ago