GAGA4 MCPv2.11.9

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 / DimensionGA4 API NameTypeDescription
Purchase RevenuepurchaseRevenueMetricGross transaction revenue
TransactionsecommercePurchasesMetricNumber of completed purchase events
Average Order ValueaveragePurchaseRevenueMetricAverage revenue per transaction
Add to CartaddToCartsMetricTotal add_to_cart events
Checkout StartedcheckoutsMetricTotal begin_checkout events
Cart-to-View RatecartToViewRateMetricPercentage of item views added to cart
Purchase-to-View RatepurchaseToViewRateMetricPercentage of item views purchased
Item ViewsitemsViewedMetricTotal times items were viewed
Item RevenueitemRevenueMetricRevenue generated by specific item
Items PurchaseditemsPurchasedMetricNumber of units purchased
Item NameitemNameDimensionProduct title
Item CategoryitemCategoryDimensionProduct collection / category

Step 1 — Revenue & AOV Overview

Track gross performance and transaction trends over time:

text
dimensions: ["date"]
metrics: ["ecommercePurchases", "purchaseRevenue", "averagePurchaseRevenue"]
date_range: last 30 days
order_by: date ASC

Step 2 — Funnel Drop-Off (View → Cart → Checkout → Purchase)

Analyze conversion velocity across the purchase funnel:

text
dimensions: ["sessionDefaultChannelGroup"]
metrics: ["itemsViewed", "addToCarts", "checkouts", "ecommercePurchases",
          "cartToViewRate", "purchaseToViewRate"]
date_range: last 30 days
order_by: ecommercePurchases DESC

Drop-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:

text
dimensions: ["itemName", "itemCategory"]
metrics: ["itemsViewed", "addToCarts", "itemsPurchased", "itemRevenue"]
date_range: last 30 days
order_by: itemRevenue DESC
limit: 20

Step 4 — Revenue by Acquisition Channel

Determine which marketing channels deliver the highest paying customers:

text
dimensions: ["sessionDefaultChannelGroup"]
metrics: ["ecommercePurchases", "purchaseRevenue", "averagePurchaseRevenue"]
date_range: last 30 days
order_by: purchaseRevenue DESC

Three Prompts to Ask Your AI Agent

Copy-paste these prompts into Claude Code, Cursor, or Gemini CLI:

text
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

  1. Open Reports → Monetization → Ecommerce purchases.
  2. Review the table to view Item revenue, Item purchase quantity, and Items viewed.
  3. To view the multi-step funnel, navigate to Explore → Funnel exploration and select the predefined Purchase journey template.