Powerpop Analytics – Cart Analysis
What is Cart Analysis?
Cart Analysis is a reporting feature that tracks how customers interact with their shopping carts. It shows how many visitors add items to their cart, how much revenue is left behind when purchases are not completed, and which product categories, items, or brands are most often abandoned. This helps identify lost sales opportunities and guides strategies to recover them.
Number of Visitors with Open Orders
Shows how many visitors currently have items in their carts but haven’t completed checkout. In this period, there were 29 visitors, which is a 21.6% decrease compared to last week.
Trendline in Charts
In the Number of Visitors with Open Orders chart, you will notice a trendline displayed below the main data points.
A trendline is a line that shows the overall direction or pattern of the data over time. It helps you quickly see whether the number of visitors with open orders is increasing, decreasing, or staying consistent.
Example:
On 2025-08-12, the metric
COUNT_DISTINCT(visitor_id) = 158
means there were 158 unique visitors with open orders on that day.
The trendline smooths out these daily values so you can easily identify long-term patterns rather than focusing only on daily fluctuations.
Revenue Left in Carts
Displays the total value of products that were added to carts but not purchased. The amount is 31.3k, reflecting a 71% decrease compared to last week, meaning fewer high-value items were abandoned.
This chart also includes a trendline showing the value of items left in shopping carts.
Example:
On a given day, the metric
SUM(item_value) = 11.6m
means there was 11.6 million in revenue left in carts.
The trendline makes it easy to see if the total value of abandoned carts is rising, falling, or stable over time.
Cart Filled Contacts
Represents the number of contacts who added items to their cart.
- For example: This reached 443 contacts, an increase of 66.5% compared to last week, showing stronger engagement.
Abandoned Product Categories
It identifies the product categories most often left in carts. The leading categories are:
- Office & Printing Paper – 284 carts
- Archiving & Filing Supplies – 218 carts
- Writing Instruments – 154 carts
- Beverages (Water & Mineral Water) – 107 carts
- Folders & Organizers – 97 carts
- Hygiene Products – 96 carts
Most Abandoned Products
Highlights the specific products most frequently abandoned. Examples include:
- High-value tech equipment – 8.3M
- Bulk office paper (2,500 sheets) – 2.2M
- Presentation equipment – 572k
- Standard office paper (500 sheets) – 129k
- Office furniture – 116k
Entries Display Options
You can also adjust how many items are displayed by selecting: 10, 50, 200, or All entries.
This lets you quickly switch between a smaller overview and a more detailed product list.
Table Navigation
You can navigate through the table by clicking the page numbers (1, 2, 3, 4, 5, and so on).
Top Abandoned Brands
Shows the brands with the highest value of abandoned products. For privacy, brand names are anonymized here, but the trend shows:
- Brand A – 8.3M
- Brand B – 2.2M
- Brand C – 790k
- Brand D – 599k
- Brand E – 166k
Cart Values by Visitors
This table shows how shopping cart values are distributed among visitors. It helps you understand customer purchasing behavior based on the size of their cart.
Key columns include:
- Cart Value (e.g., 0, 500, …) – The monetary value of items placed in a visitor’s cart.
- Number of Visitors – How many visitors fall into that cart value range.
- Percentage of All Visitors – What share of your total visitors this group represents.
This breakdown makes it easy to see whether most visitors are adding only small amounts to their carts or if higher-value carts are more common.
Visitor Carts
A detailed table of all visitor carts including cart information, products, values, and quantities. Allows closer tracking of cart activity for personalization or recovery strategies.
Columns include:
- created_at – Date and time the cart was created
- visitor_id – Unique identifier for the visitor
- email – Visitor’s email (if available)
- item_name – Product name in the cart
- qty – Quantity of the product
- item_value – Value of the selected item(s)
- cart_value_bin_50 – Cart value grouped into ranges of 50
| created_at | visitor_id | item_name | qty | item_value | cart_value_bin_50 | |
|---|---|---|---|---|---|---|
| 2025-08-09 | 5c3e36eb-fd48-4527-a1b9-728e0c0d0ba2 | msvadlenkova@sandprofile.com | Pytle na odpadky - bílé, 30 l, 20 ks | 2 | 66.4 | 4500 |
| 2025-08-11 | 6851694a-882d-4755-8e69-914b3000d9f9 | lucie@iamprague.eu | Dezinfekční prostředek Sanytol - univerzální, 500 ml | 5 | 650 | 4500 |
| 2025-08-03 | eb4765d2-fb6c-4c30-96d8-b639abc467a5 | brozova@alem.cz | Drátěný stojánek na vizitky Q-Connect - černý | 3 | 152.7 | 9000 |
| 2025-08-05 | f0a69699-6b1c-42bb-9174-32dafbbe52a4 | N/A | Kuličkové pero Spoko 112 - modrá náplň, 0.5 mm | 30 | 330 | 5000 |
| 2025-08-04 | dd0a98f7-81fe-4443-a10f-872f57447a3 | N/A | Polštářek do razítka 6/4910, zelený | 1 | 112 | 3500 |
Customer Decision Time
Shows the average time a visitor takes from adding items to their cart until making a decision (either purchasing or abandoning).
Helps analyze shopping behavior - whether customers make fast, impulse-driven decisions or take longer to evaluate before completing or abandoning their cart.
Cart Basket Size vs. Time Needed
A chart that compares the number of items in a visitor’s cart (basket size) against the time taken to complete or abandon the cart.
Reveals whether larger baskets are linked to longer decision times, or if decision-making is consistent regardless of cart size.
This chart uses circles to represent the relationship between the value of items in a cart and the time customers need to complete their purchase.
- Each circle represents a group of carts.
- The size of the circle shows how many unique carts fall into that group.
- The position of the circle reflects the cart’s value and the average time needed before purchase.
Example:
The largest green circle may display these values:
1000– Minimum total cart value (MIN(total_cart_items_value))- Average time to purchase – e.g.,
ROUND(AVG(minutes_to_purchase)/60,0)= average hours before purchase - Count of carts –
COUNT_DISTINCT(cart_id)= total unique carts in that group.
This visualization helps you quickly identify whether higher-value baskets take longer to complete or if smaller carts are purchased more quickly.
Filters and Controls
Each table and chart includes filters to customize the data view:
- Cart Status: inCheckout, open, purchased
- Time: Current Month (default)
Additionally, the three-dot icon on the side of each widget provides extra options:
- Force Refresh – Updates the data immediately.
- Enter Full Screen – Expands the widget view for easier analysis.
- View Query – Displays the query used to generate the data.
- View as a Table – Switches to table format for detailed review.
- Share – Copies a permalink to the clipboard or shares the cart data via email.
Continue Learning:
Explore how Powerpop Analytics helps track customer payments and revenue metrics in the next article — Powerpop Analytics: Billing.