Hook Rate and Hold Rate: a Sheets calculator for paid-social creative
A Google Sheets template that turns a Meta Ads Manager export into hook rate, hold rate and cost per ThruPlay, so creative decisions rest on retention, not gut feel.
The Social Desk
A working checklist for Meta pixel and Conversions API signal quality, covering event match quality, deduplication, advanced matching and the consent-mode interaction that quietly zeroes your EU signal.
Template · Operator · Filed 18 July 2026
When Meta performance drifts, the first instinct is to blame targeting or creative. Often the real problem is upstream: the signal telling Meta who converted is arriving late, deduplicated wrong, or stripped of the parameters that let Meta match a conversion to a person. Optimisation is only ever as good as the events feeding it.
This is the checklist the Dispatch runs before touching a single campaign. It is a diagnostic, not a fix: it tells you where your signal is leaking, in the order worth checking. Work down it with Events Manager open.
event_id. That is the key Meta uses to recognise the two hits as one event and drop the duplicate.event_name across both channels for the same action; a mismatch defeats deduplication even when the id is present.event_id or a CAPI payload that lost its matching data.Run the checklist top to bottom; the earlier items gate the later ones (deduplication is meaningless if half your events never arrive). But keep EMQ in proportion. It is a proxy, not a KPI. It measures how well-matched your events are, not how many sales you made, and a campaign can perform perfectly well at a middling score. Chase EMQ only until the signal is genuinely healthy, then stop and let the account's results, cost per result and volume, be the thing you actually optimise. A signal you have made technically pristine at the cost of a week you could have spent on offers or creative is a poor trade. Fix the leaks this checklist finds, then get back to the campaign.
More Like This
A Google Sheets template that turns a Meta Ads Manager export into hook rate, hold rate and cost per ThruPlay, so creative decisions rest on retention, not gut feel.
Starter · 10 minutes
The exact columns for a paid-social testing sheet, plus the three decision rules that stop a test being read too early, judged on the wrong number, or forgotten before it teaches you anything.
Starter · 15 minutes
A step-by-step walkthrough of implementing Meta's Conversions API Gateway through Stape, aimed at lifting Event Match Quality without hand-rolling a server.
Operator · 45 minutes · via Jon Loomer