shopify-admin-order-attribution-report

Generate Shopify order attribution reports by aggregating UTM revenue per channel.

174|18|Updated Apr 11, 2026
One-click install
npx skills add https://github.com/40RTY-ai/shopify-admin-skills --skill shopify-admin-order-attribution-report
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: shopify-admin-order-attribution-report
Source: https://github.com/40RTY-ai/shopify-admin-skills/tree/main/skills/order-intelligence/shopify-admin-order-attribution-report
Command: npx skills add https://github.com/40RTY-ai/shopify-admin-skills --skill shopify-admin-order-attribution-report

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manual revenue tracking by marketing channel is slow and error-prone because UTM attribution is scattered across analytics tools rather than grounded in first-party Shopify order data.

Core Features & Use Cases

  • UTM extraction from order landing URLs: Parses utm_source, utm_medium, and utm_campaign (and optionally term/content) from each paid order’s landingPageUrl query string.
  • Channel rollups for revenue and AOV: Aggregates attributed orders, total revenue, and average order value (AOV) by a chosen grouping dimension such as source, medium, campaign, or source_medium.
  • Read-only reporting for attribution drift: Produces a CSV report (or JSON output) without mutations, suitable for weekly or monthly marketing attribution checks.

Quick Start

Run the shopify-admin-order-attribution-report skill for mystore.myshopify.com for the last 30 days and output a human-readable CSV grouped by source.

Frequently Asked Questions about shopify-admin-order-attribution-report

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a Shopify UTM attribution report for marketing channels?

Group Shopify revenue by UTM source by parsing the query string of each order's landingPageUrl. The report aggregates total revenue, order counts, and average order value per source, outputting a human-readable CSV grouped by the specified dimension.

Can I attribute Shopify order revenue to specific marketing campaigns?

Yes, you can attribute Shopify order revenue to specific marketing campaigns by extracting utm_campaign parameters from order landing page URLs. The report aggregates attributed revenue, order counts, and AOV per campaign for campaign performance analysis.

What is the best way to calculate AOV by traffic source using Shopify order data?

Calculate AOV by traffic source by querying Shopify GraphQL orders, extracting utm_source from landingPageUrl, and aggregating total revenue and order counts per source. This yields the average order value for storefront-driven attribution scenarios.

Does this attribution reporting method require write access to my Shopify store?

No, this attribution reporting method uses read-only GraphQL orders querying with pagination. It produces a CSV or JSON report without mutations, ensuring safe weekly or monthly marketing attribution checks without altering store data.

How does the report handle orders with missing or malformed UTM parameters?

The report applies robust handling for missing or malformed UTM data, ensuring orders without proper UTM tagging do not break the aggregation logic. It cleanly aggregates revenue and AOV for successfully parsed marketing channels.

Can I apply a lookback period to Shopify revenue analytics for specific marketing channels?

Yes, you can apply lookback periods to Shopify revenue analytics to filter paid orders within a specific timeframe. The report aggregates revenue, order counts, and AOV per marketing channel based on the requested lookback window.