Meta Ads report template
A ready Meta Ads report template: columns, sources, formulas, and auto-refresh in Google Sheets. Copy the structure into your own sheet.
A daily Meta Ads report template: spend, impressions, clicks, CTR, CPC, and results by campaign. Data refreshes on a schedule and the sheet is ready to merge with your CRM.
Read more
Report preview
| Campaign | Date | Impressions | Clicks | CTR | CPC | Spend | Results |
|---|---|---|---|---|---|---|---|
| Campaign A | 2026-07-30 | 48,000 | 1,240 | 2.6% | $0.48 | $595 | 46 |
| Campaign B | 2026-07-30 | 31,500 | 820 | 2.6% | $0.41 | $336 | 29 |
Preview values illustrate the table structure. Real figures will come from your sources after the report is configured.
Columns
- date, campaign_name, adset_name, ad_name
- impressions, clicks, ctr, cpc, cpm, reach, frequency
- spend, results, cost_per_result
- Add attribution columns: leads, deals, revenue, roas (Agency plan and above)
Data sources
- Meta Ads (1 account) — spend, impressions, clicks, results
- CRM (optional) — leads and deals for attribution
How to set up
- Start with LightLead and connect your Meta Ads ad account via OAuth
- Add a report: source Meta Ads, period last_7_days, grouped by date and campaign
- Pick metrics: spend, impressions, clicks, ctr, cpc, cpm, results
- Set a schedule (daily) — the data will refresh automatically
Formulas
- CTR = clicks / impressions × 100
- CPC = spend / clicks
- CPM = spend / impressions × 1,000
- ROAS = revenue / spend × 100 (calculated metric, requires attribution)
Template copy
A ready Google Sheets file to copy is not published yet. Write to [email protected] and we will send a copy link once the template is ready.
Daily campaign performance recipe: https://docs.lightlead.space/recipes/advertising/daily-campaign-performance
Read next
Start with LightLead free
Create your first report — spend, leads, and attribution in Google Sheets.
Create your first report