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.
| Step | Purchases | Where it comes from |
|---|---|---|
| Meta reports | 120 | Ads Manager, default attribution setting (7-day click, 1-day view, 1-day engage-through) |
| − seen, not clicked (1-day view) | −30 | Ads Manager: Compare attribution settings |
| − liked, commented or shared (1-day engage-through) | −4 | Ads Manager column |
| − duplicate purchase events | −6 | Events Manager purchases vs Shopify orders, same days |
| − clicked the ad, a later click from another channel won | −14 | Estimate from a sample of Shopify order journeys |
| − clicked the ad, Shopify couldn't link the visit | −8 | Estimate: direct orders Meta credits to a click |
| + Shopify credits Facebook/Instagram, Meta didn't count | +12 | Estimate: older clicks, unmatched buyers, organic posts |
| = Shopify orders credited to Facebook/Instagram | 70 | Shopify 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
- Meta: click-through attribution counts link clicks; engage-through (March 2026)
- Meta for Developers: 7-day and 28-day view windows removed from the Insights API (January 2026)
- Shopify Help Center: marketing reports and last non-direct click
- Meta for Developers: deduplicating Pixel and Conversions API events
- Jon Loomer: Meta ads attribution in 2026
