Separate order-level and item-level counts before a marketing report compares conversion rates. The download provides a specific review process. It does not make decisions or act in an account.
Download the free skill
One complete Markdown file. No subscription, checkout or fabricated setup files.
Download SKILL.mdWhat to provide
Ecommerce event export, item rows, order IDs, metric scopes, session counts and period.
How it works
- Label each metric as event, order, item, user or session scope using supplied definitions.
- Join item rows to order IDs without counting an order once per item.
- Calculate rates only with compatible numerator and denominator. Missing scope blocks a rate.
- Return a scope crosswalk and reproducible counts; do not change event setup or claim a conversion lift.
The output
metric | scope | source rows | distinct order IDs | numerator/denominator | valid rate | gap
Worked fictional example
Fictional two orders contain three and two items: five items, two orders. With ten sessions, order conversion is20%, not50% item count called order conversion.
Checks and limits
Preserve source versions and original values. Unknowns stay unknown. Use a qualified reviewer for regulated, legal or hiring decisions. No send, share, account change, schedule, ledger update or payment is authorized. No live account test is claimed.
More marketing workflows · How-to guides
Method: reviewed source. Demand lead: GSC report generation11 and marketing copilot37 throughSep29; distinct from general metric definitions. These are site-query cluster impressions and method evidence, not exact new-topic monthly search volume or a traffic promise. Checked October 4, 2026.