Facebook ads report template: the daily sheet an AI agent fills in
A daily report is what makes an agent's work verifiable. Here is the sheet structure we use on our own launches.
Updated: · Meta RDP, agency Meta ad accounts since 2023
Short answer: A daily Facebook ads report is built at the ad set level: date, campaign, ad set, daily budget, spend, impressions, reach, clicks, CTR, leads and cost per lead, plus ad status. A separate sheet lists leads with statuses (qualified, meeting, deal), from which the cost per qualified lead is calculated.
Three sheets
- Summary: totals per ad set: spend, clicks, leads, cost per lead and per qualified lead.
- Daily: one row per ad set per day.
- Leads: every lead with status and source.
Daily fields
| Field | Source |
|---|---|
| Date, campaign, ad set, language, creative | Ads Manager |
| Status and daily budget | Ads Manager |
| Spend, impressions, reach, clicks, CTR | Ads Manager, ad set level |
| Form leads | Leads Center or form export |
Leads sheet
Name, contact, country, budget, language, ad set, ad and source tag. Sales updates the status: new, qualified, meeting, deal, lost. The summary uses these statuses to calculate cost per qualified lead, which matters more than cost per form.
How the agent fills it in
Once a day the agent opens the profile with the ad account, exports yesterday's numbers by ad set and adds rows to the sheet. If an ad is rejected or an ad set is not delivering, the agent notes it in the status column. This is how we run the Kings Investors campaign for Kings Rental Cars since 22 October 2026.