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
Put the question live
Copy the question and options from the Survey kit tab into a survey app that adds an app block to Shopify's new Thank you page. Place a test order and check the question appears.
Paste the month's answers
Export order ID, date and answer and paste them into the Answers tab. The Mapping tab turns answers into channels; unrecognised answers show as Unmapped.
Type the platform numbers
On Settings, type total orders from Shopify. On Compare, type each paid channel's reported purchases and spend for the same dates, with the same attribution setting every month.
Read the ratio and the trend
Compare shows said ÷ reported and survey-based cost per order per channel. Monthly charts the Meta ratio and flags any month it moves by 0.15 or more.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Rule | Condition | Default |
|---|---|---|
| Question | One question, one tap, optional | "How did you hear about us?" |
| Options | Every paid channel by the name buyers use, plus Friend or family and Other | 6 to 8 options |
| Where | Shopify's upgraded Thank you page, as an app block | Survey app with a Thank you page block |
| Estimated orders | Channel's share of answers × total orders | |
| Said ÷ reported | Estimated orders ÷ platform-reported purchases | Same dates, same attribution setting |
| Under 0.5 | Platform claims far more than buyers remember | |
| 0.5 to 0.8 | Platform claims more than buyers remember | |
| Over 1.25 | Buyers credit it more than the platform counts | |
| Monthly change | Ratio moves 0.15 or more in a month | 0.15 |
| Minimum answers | Answers in the month | 100 |
Worked review example
Fictional store, October: 1,000 orders, all answered. Meta reported 612 purchases on $18,000 ($29.41 each); 341 buyers said Instagram or Facebook, so said ÷ reported is 0.56 and the survey-based cost per order is $52.79.
TikTok reported 118 purchases on $6,000; 162 buyers named TikTok (ratio 1.37). Platform numbers alone would move money from TikTok to Meta; the survey alone would do the opposite. Both need a test before a big move.
What this template does and does not establish
A survey records what buyers remember, not what caused the sale, and buyers who answer may differ from those who don't. Platform counts include view-through, engage-through and modelled conversions, so a gap is expected. We give no response-rate benchmark because we found none we trust. The ratio bands are rules of thumb. Example data is fictional. No account connection, macros or automatic changes.
Primary references
- Jon Loomer: Meta ads attribution in 2026
- Shopify: checkout upgrade deadlines
- Shopify: upgrading and replacing your Thank you and Order status pages
