How to Import Ad Spend CSV and Calculate Real ROAS for Shopify

Meta Ads says you made $22,000 last month. Shopify says $15,000. Which number do you trust for ROAS?

If you said Meta, you are over-counting revenue and under-counting your real cost per acquisition. If you said Shopify, you are closer to the truth — but now you need to connect ad spend to Shopify revenue without granting an app OAuth access to your ad accounts (and hoping it does not accidentally pause a campaign).

There is a third way: export your ad spend as a CSV, match it to your Shopify Orders CSV, and calculate ROAS yourself. No API tokens. No attribution black box. No $50/month subscription. This guide shows you exactly how.

Why CSV beats OAuth for ad spend tracking

Most profit-tracking apps ask for OAuth access to your Meta, Google, and TikTok ad accounts. That means read access to every campaign, audience, and creative — and sometimes write access that can pause or edit campaigns. Three problems with this:

• Attribution inflation: the ad platforms report their own revenue numbers, which overcount by 15-40% because they credit any purchase within a click window, even if the customer came back via email or organic search.
• OAuth fragility: tokens expire, API changes break syncs, and you discover two weeks later that your "live" dashboard was frozen the whole time.
• Privacy risk: you are handing a third-party app the keys to your ad account. A bug or breach on their end can expose or alter your campaigns.

CSV export is the manual, boring, reliable alternative. You pull the numbers yourself, on your schedule, and match them to the revenue source you actually trust: Shopify.

Step 1: Export your Shopify Orders CSV

In Shopify Admin, go to Orders, click Export, select All orders for the date range you want (typically last 30 days), and choose Orders by day or Plain CSV. Shopify emails you a CSV file. Download it.

This file contains every order, its total, payment method, and — importantly — the landing_site and referrer data that tells you where the traffic came from.

Step 2: Export ad spend from each platform

Meta (Facebook/Instagram) Ads

In Ads Manager, go to Reporting, create a breakdown by day, select Amount spent and Purchases columns, set your date range, and click Export as CSV. You get a row per day with total spend.

Google Ads

In Google Ads, go to Reports > Predefined reports > Performance > Time (by day). Add the Cost column, set your date range, and download as CSV.

TikTok Ads

In TikTok Ads Manager, go to Reporting > Custom reports, select spend by day, and export as CSV.

Step 3: Calculate ROAS

ROAS is simple division. The trick is matching the right numbers:

Here is a worked example for a store spending $5,000 on Meta ads in June:

What ROAS do you actually need to be profitable?

Break-even ROAS depends entirely on your gross margin. The formula:

Above break-even covers product cost only. To cover refunds, payment fees, shipping gaps, and still leave profit, add a 30-50% buffer. So a 30% margin store needs roughly 4.3x-5.0x ROAS to be genuinely profitable after all costs. Use the Profit Calculator to find your real margin first.

Merging multiple ad platforms into one view

If you run ads on Meta, Google, and TikTok simultaneously, you want blended ROAS plus per-platform breakdowns. The CSV approach handles both:

1. Blended ROAS: sum all platform spend, divide by total Shopify revenue for the period. Fast, simple, good for a sanity check.
2. Per-platform ROAS: match each platform's spend to Shopify orders attributed to that source via UTM parameters in the landing_site column. More accurate, shows which platform is actually driving profitable orders.

The free CSV Profit Checker handles the Shopify side automatically. The free ad-spend CSV tool matches Meta, Google, and TikTok spend to your orders by date and UTM source to show real ROAS. When you want the complete audit (3-dimension Score breakdown, SKU ranking, and PDF for your accountant), the $9 one-time Pro report adds it.

The attribution gap you cannot close with CSVs (and why that is fine)

CSV matching cannot do multi-touch attribution — it cannot tell you that a customer saw a Meta ad, ignored it, got an email three days later, then bought via Google branded search. If you spend $100K+/month on ads and need that level of detail, you need a tool like TripleWhale or Northbeam.

But for the 90% of Shopify merchants spending under $30K/month on ads, last-click UTM matching via CSV gets you within 5-10% of the truth, without a $219+/month subscription. That is more than accurate enough to decide which campaigns to scale and which to kill.

Do it now

Export your Shopify Orders CSV and your ad spend CSVs for the last 30 days. Drop the Shopify file into the CSV Profit Checker, then use the free ad-spend tool to match spend to orders and see real ROAS — not the inflated number Meta shows you. When you want the complete audit (Score breakdown, SKU ranking, fix list, and PDF), the $9 one-time Pro report covers it. The truth in under a minute, no subscription required.