Ecommerce analysis

Skill surendranb/google-analytics-mcp/skills/ecommerce-analysis

Revenue, conversion rate, AOV, and funnel drop-off using GA4 ecommerce events.From its SKILL.md

Install

npx -y skills add surendranb/google-analytics-mcp --skill ecommerce-analysis

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

SKILL.md

2.4 KB, as published. Nobody here has run it

Ecommerce Analysis

Revenue, conversion rate, AOV, and funnel drop-off using GA4 ecommerce events.

When to use

You have purchase, add_to_cart, begin_checkout events in GA4
You want to measure revenue, conversion rate, or average order value
You want to find where users drop off in the purchase funnel

Correct metric and dimension names

GA4 ecommerce uses specific API names — do not guess:

Concept	GA4 API name
Revenue	`purchaseRevenue`
Transactions	`ecommercePurchases`
AOV	`averagePurchaseRevenue`
Add to cart	`addToCarts`
Checkout started	`checkouts`
Cart-to-view rate	`cartToViewRate`
Purchase-to-view rate	`purchaseToViewRate`
Item views	`itemsViewed`
Item revenue	`itemRevenue`
Items purchased	`itemsPurchased`
Product name	`itemName`
Product category	`itemCategory`
Transaction ID	`transactionId`

Step 1 — Revenue overview

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

Step 2 — Funnel: views → cart → checkout → purchase

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

Drop-off between stages = 1 - (next_stage / current_stage). The biggest drop-off is the highest-leverage fix.

Step 3 — Top products

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

Step 4 — Revenue by channel

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

Incompatible combinations to avoid

itemId or itemSku cannot be combined with session-level metrics
ecommercePurchases cannot be combined with eventCount in the same query
Use separate queries for item-level and session-level analysis

What to report

Revenue trend over the period
Funnel conversion rates and biggest drop-off point
Top 10 products by revenue
Best-performing acquisition channel by revenue and AOV