Pull Meta ad insights with hook rate and net revenue per ad
Ready nowSupabase edge functions pull Meta Marketing API ad-level insights (hook rate, holds, results) into meta_ads tables and join sales to ad IDs for net cash per ad; the Meta Ads tab adds CSV upload and ad comments.
Kit
No separate kit. The playbook is self-contained.
You need
| Account | Why | Free or paid | Plan |
|---|---|---|---|
| Meta Business Suite (Pixel, Conversions API, Marketing API) | Facebook and Instagram ads. The funnel fires Pixel events, the attribution system sends server-side Conversions API events, the Meta Ads tab pulls ad-level insights, and social posting reaches your Pages through Zernio. | Free | Business account is free; you pay for ad spend only. Requires a verified business and a domain verification TXT record for the Pixel. |
| Supabase | Postgres database, auth (dashboard logins), row level security, Realtime pulse, Edge Functions and pg_cron for every dashboard, the attribution tables, booking alerts and the Brain state. | Free tier available | Pro (25 USD/mo) for anything a client logs into. The free tier pauses a project after 7 days without traffic and caps an org at 2 active projects; a paused free project took three client dashboards offline at once (a project log). |
| HYROS | Paid attribution for a client running ads; the Channel Attribution tab proxies the HYROS API. Timo built a first-party clone so new clients can skip it. | Paid | Paid only, priced on ad spend (hundreds of dollars a month). Only needed if the client already runs it; otherwise use the first-party attribution system. |
What you bring
- Your ad platform read token
- Your ad exports from Ads Manager, and your ad account ids
- Your definition of which action counts as a result
The steps
- Create the System User token and confirm access
- Create the tables
- Deploy the sync function and run a dry run
- Write for real and schedule it hourly
- Deploy the revenue function
- Build the tab with the decision rules
- Verify against ground truth, not against the page
Get the full playbook
Part of: Get your database sorted