Free editable template

Meta vs Shopify attribution reconciler

Stop arguing about which dashboard is right. Log one row a week, see the gap split into view-through, engage-through, duplicates, other channels and lost links, get flags when tracking breaks, and budget with MER instead of either platform's count.

By GaaS editorial · Sources checked · 8 worksheet rows

Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.

How to use the template

Log one week at a time

Copy Meta's spend and purchases split by click, view and engage-through, Shopify's orders, revenue and orders credited to Facebook and Instagram, and your post-purchase survey answers. Use the same seven days and time zone in every tool.

Read the flags

The log works out Meta ROAS, Shopify-credited ROAS, MER (store revenue ÷ all ad spend), the Meta ÷ Shopify ratio, the share of view and engage-only purchases and survey-implied orders. Red means Meta counted more purchases than the store had orders: check for duplicate events first.

Bridge the gap

Pick a week. The view and engage-through steps fill in from the log; add your estimates for duplicates, other channels, lost links and sales Meta missed. A small 'unexplained' remainder means you understand your gap; a big one points at tracking.

Use each number for its job

Budget the total with MER. Compare ads inside Meta with Meta's numbers. Judge whether Meta deserves more money with the survey and a lift test. Watch the Meta ÷ Shopify ratio for sudden jumps that mean tracking changed.

Preview the worksheet

Every row shown here is included in the download. Scroll the table horizontally on a small screen.

StepPurchasesWhere it comes from
Meta reports120Ads Manager, default attribution setting (7-day click, 1-day view, 1-day engage-through)
− seen, not clicked (1-day view)−30Ads Manager: Compare attribution settings
− liked, commented or shared (1-day engage-through)−4Ads Manager column
− duplicate purchase events−6Events Manager purchases vs Shopify orders, same days
− clicked the ad, a later click from another channel won−14Estimate from a sample of Shopify order journeys
− clicked the ad, Shopify couldn't link the visit−8Estimate: direct orders Meta credits to a click
+ Shopify credits Facebook/Instagram, Meta didn't count+12Estimate: older clicks, unmatched buyers, organic posts
= Shopify orders credited to Facebook/Instagram70Shopify marketing report, last non-direct click

Worked review example

Fictional example week: Meta reports 120 purchases ($9,600, a 3.2 ROAS on $3,000). Shopify has 300 orders ($24,000) and credits 70 to Facebook and Instagram. With $1,800 spent elsewhere, MER is 5.0.

30 of Meta's purchases were view-only and 4 engagement-only, straight from Ads Manager columns. Estimated duplicates (6), later clicks from other channels (14), lost links (8) and sales Meta missed (+12) close the rest of the gap. 66 of 180 survey answers named Facebook or Instagram, implying about 110 orders.

What this template does and does not establish

The bridge explains the difference between two counts; it does not measure how many sales Meta's ads caused, which needs a controlled lift or holdout test. Steps after view and engage-through are estimates from samples. Survey answers are what customers remember. Meta changes attribution settings and API windows often, so weeks with different settings are not comparable. Example weeks are fictional, not benchmarks.

Primary references

Continue the work