Shopify Marketing shows clicks and conversions, but connecting ad spend to revenue is manual hell. Facebook says 4x ROAS, Google says 6x, but your bank account doesn't match. You need one view showing which channels truly pay back after refunds and fees.
Your first run is free - no card.
Get a ready-to-use file with everything you need
All platforms compared: Facebook, Google, TikTok side-by-side
Channels ranked by true ROAS after refunds
Exact $ to shift from losers to winners
Compare 1-day, 7-day, 28-day ROAS - see platform tricks
Real outcomes for your Shopify business
Find wasted spend: Identify $2,000-$10,000/month on losing channels that look good in-platform but don't pay back
Know what to cut: Clear winner/loser ranking with exact $ to shift for optimal ROAS
One source of truth: Stop juggling Facebook, Google, TikTok dashboards - compare apples to apples
What this Excel Decision Kit tracks from your Shopify data
(Shopify revenue from ads) ÷ (Total spend across all platforms) after refunds
Ad spend ÷ new customers acquired (deduping multi-touch)
Platforms ranked by ROAS with $ wasted on losers and $ to reallocate to winners
Compare 1-day, 7-day, 28-day attribution - see how each platform games numbers
What ad platforms claim vs. what you actually kept after returns
From platform spend to real revenue attribution
Definition: (Total revenue from ads) ÷ (Total ad spend across all platforms)
Source: Order revenue + ad spend from all channels
Granularity: Overall, by channel, by campaign
Definition: (Total ad spend) ÷ (New customers acquired)
Source: Ad spend + new customer identification
Granularity: By channel, by campaign
Definition: Channels ranked by ROAS, with $ wasted if continued at current spend
Source: ROAS comparison + spend allocation
Granularity: Ranked list with reallocation recommendations
What makes Shopify different and how we handle it
order.source_name: Online Store, facebook, instagram, google
order.client_details.landing_site: first page customer landed on
customer.created_at: for new vs. repeat customer attribution
Shopify-specific setup in 6 steps
Authorize access to orders and marketing attribution data
Export spend from Facebook, Google, TikTok and upload (or connect platforms directly)
Match Shopify's source_name to your ad platform names
Choose 7-day or 28-day click attribution to match how platforms report
Excel shows blended ROAS, per-channel breakdown, and winner/loser ranking
See exact $ to shift from losing channels to winners for optimal spend
Start automating your Shopify reporting today and save hours every week.
Our report recipes are designed by e-commerce experts who understand what metrics matter most for your business decisions.
Connect your platforms in minutes, not hours. Our OAuth2 integration makes setup secure and simple.
Reports are delivered in perfectly formatted Excel files that work seamlessly with your existing workflow.
Our report recipes are designed to provide actionable insights and recommendations for your business.
Common questions for Shopify users
We use order.source_name and landing_site for basic attribution. For precision, import UTM parameters from your analytics tool.
Basic attribution still works from source_name, but it's less accurate. We'll recommend installing Pixel for better future tracking.
Critical: we subtract refunds from revenue before calculating ROAS. Channels driving high returns get penalized appropriately.
Yes - see 1-day, 7-day, and 28-day ROAS side-by-side. Understand how platforms cherry-pick windows to look better.
We separate new customer acquisition (CAC) from repeat purchases. Channels with high repeat rates have better long-term ROI.
"Facebook claimed 5x ROAS but after refunds and multi-touch deduping, it was 1.8x. Google was the real winner at 4.2x. We cut Facebook 60% and scaled Google."
Kevin Tran
Performance Marketing Manager, Athletic Apparel Direct
$84K annual wasted spend eliminated
True ROAS improved from 2.1x to 3.8x
Other decision kits for your Shopify data
Connect your Shopify account and generate your first reconciliation in under 5 minutes. First report free.
No card • Keep the file forever • Cancel anytime