Free editable template

"How did you hear about us?" post-purchase survey kit

Get a second opinion on Ads Manager. Buyers answer one optional question after checkout; the sheet maps answers to channels, estimates orders per channel, divides them by each platform's own count, and tracks that said-to-reported ratio every month so you see when Meta's numbers drift from what buyers remember.

By GaaS editorial · Sources checked · 10 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

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.

RuleConditionDefault
QuestionOne question, one tap, optional"How did you hear about us?"
OptionsEvery paid channel by the name buyers use, plus Friend or family and Other6 to 8 options
WhereShopify's upgraded Thank you page, as an app blockSurvey app with a Thank you page block
Estimated ordersChannel's share of answers × total orders
Said ÷ reportedEstimated orders ÷ platform-reported purchasesSame dates, same attribution setting
Under 0.5Platform claims far more than buyers remember
0.5 to 0.8Platform claims more than buyers remember
Over 1.25Buyers credit it more than the platform counts
Monthly changeRatio moves 0.15 or more in a month0.15
Minimum answersAnswers in the month100

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

Continue the work