技能创建器
skill-creator
创建、改进和评估自定义技能,把专业流程转化为可重复使用的 AI 能力。
ecommerce-analysis【数据与研究】Revenue, conversion rate, AOV, and funnel drop-off using GA4 ecommerce events.
独立 GitHub 快照 · 自动分类 · 以原作者文档为准
Revenue, conversion rate, AOV, and funnel drop-off using GA4 ecommerce events.
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 |
dimensions: ["date"]
metrics: ["ecommercePurchases", "purchaseRevenue", "averagePurchaseRevenue"]
date_range: last 30 days
order_by: date ASC
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.
dimensions: ["itemName", "itemCategory"]
metrics: ["itemsViewed", "addToCarts", "itemsPurchased", "itemRevenue"]
date_range: last 30 days
order_by: itemRevenue DESC
dimensions: ["sessionDefaultChannelGroup"]
metrics: ["ecommercePurchases", "purchaseRevenue", "averagePurchaseRevenue"]
date_range: last 30 days
order_by: purchaseRevenue DESC
itemId or itemSku cannot be combined with session-level metricsecommercePurchases cannot be combined with eventCount in the same query