Agent skill
GA4 Ecommerce Analysis: Revenue, AOV & Funnel Drop-off
Analyze e-commerce performance in Google Analytics 4: calculate revenue trends, average order value (AOV), item-level performance, and multi-step checkout funnel drop-offs.
When to use
- You track standard GA4 e-commerce events (
view_item,add_to_cart,begin_checkout,purchase) - You want to measure gross revenue, conversion rates, or average order value
- You need to identify where prospective buyers abandon the checkout funnel
- You want to evaluate acquisition channel profitability and return on ad spend (ROAS)
Correct E-Commerce API Names
GA4 e-commerce queries require exact API field names:
| Metric / Dimension | GA4 API Name | Type | Description |
|---|---|---|---|
| Purchase Revenue | purchaseRevenue | Metric | Gross transaction revenue |
| Transactions | ecommercePurchases | Metric | Number of completed purchase events |
| Average Order Value | averagePurchaseRevenue | Metric | Average revenue per transaction |
| Add to Cart | addToCarts | Metric | Total add_to_cart events |
| Checkout Started | checkouts | Metric | Total begin_checkout events |
| Cart-to-View Rate | cartToViewRate | Metric | Percentage of item views added to cart |
| Purchase-to-View Rate | purchaseToViewRate | Metric | Percentage of item views purchased |
| Item Views | itemsViewed | Metric | Total times items were viewed |
| Item Revenue | itemRevenue | Metric | Revenue generated by specific item |
| Items Purchased | itemsPurchased | Metric | Number of units purchased |
| Item Name | itemName | Dimension | Product title |
| Item Category | itemCategory | Dimension | Product collection / category |
Step 1 — Revenue & AOV Overview
Track gross performance and transaction trends over time:
dimensions: ["date"]
metrics: ["ecommercePurchases", "purchaseRevenue", "averagePurchaseRevenue"]
date_range: last 30 days
order_by: date ASCStep 2 — Funnel Drop-Off (View → Cart → Checkout → Purchase)
Analyze conversion velocity across the purchase funnel:
dimensions: ["sessionDefaultChannelGroup"]
metrics: ["itemsViewed", "addToCarts", "checkouts", "ecommercePurchases",
"cartToViewRate", "purchaseToViewRate"]
date_range: last 30 days
order_by: ecommercePurchases DESCDrop-off calculation: 1 - (next_stage_count / current_stage_count). Identify whether the largest bottleneck is cart abandonment (view → cart) or checkout friction (checkout → purchase).
Step 3 — Top Products by Revenue
Identify revenue drivers and product-level conversion rates:
dimensions: ["itemName", "itemCategory"]
metrics: ["itemsViewed", "addToCarts", "itemsPurchased", "itemRevenue"]
date_range: last 30 days
order_by: itemRevenue DESC
limit: 20Step 4 — Revenue by Acquisition Channel
Determine which marketing channels deliver the highest paying customers:
dimensions: ["sessionDefaultChannelGroup"]
metrics: ["ecommercePurchases", "purchaseRevenue", "averagePurchaseRevenue"]
date_range: last 30 days
order_by: purchaseRevenue DESCThree Prompts to Ask Your AI Agent
Copy-paste these prompts into Claude Code, Cursor, or Gemini CLI:
1. "Summarize our e-commerce performance for the past 30 days compared to the prior 30 days. Report purchaseRevenue, ecommercePurchases, and averagePurchaseRevenue."
2. "Audit our checkout funnel drop-off by acquisition channel over the last 60 days. Which channel experiences the highest cart-to-view rate and purchase rate?"
3. "List our top 15 products by gross revenue over the past 90 days. Include itemsPurchased, itemRevenue, and calculate the purchase-to-view conversion rate."How to Check Manually in the GA4 Console
- Open Reports → Monetization → Ecommerce purchases.
- Review the table to view
Item revenue,Item purchase quantity, andItems viewed. - To view the multi-step funnel, navigate to Explore → Funnel exploration and select the predefined Purchase journey template.