What you can report on
| Group | Examples |
|---|---|
| Delivery and cost | Impressions, reach, frequency, amount spent, CPM, cost per 1,000 people reached |
| Clicks | Link clicks, CTR, CPC, outbound clicks, unique clicks, landing page views and cost per view |
| Conversions (186 fields) | Purchases, purchase value and ROAS split into website, app, on-Facebook and offline; adds to cart, leads, registrations |
| Video | 3-second plays, ThruPlays, 2-second continuous plays, 25% to 100% plays, average play time |
| Engagement and messaging | Post engagements, reactions, comments, shares, saves, messaging conversations started |
| Structure | Campaign, ad set and ad IDs, names, statuses, objective, optimization goal, bid strategy, budgets, dates |
| Creative | Ad body, title, call to action, thumbnail and image URL, destination URL, URL tags, parsed UTM source, medium, campaign, content and term, Instagram post link, preview link |
| Diagnostics | Quality, engagement rate and conversion rate rankings |
| Dynamic creative | Per-asset rows for body, title, image, video, CTA and link assets |
Breakdowns and attribution that match Ads Manager
Split any query by age, gender, country, region, publisher platform, platform position, placement, impression device or action type, and by combinations Meta allows such as action type by age by gender. Whathead picks the right Meta breakdown for the fields you choose, so you do not need to know which pairs the API accepts.
The conversion window defaults to each ad set's own attribution setting, the same as Ads Manager. You can switch a query to 1-day, 7-day or 28-day click, 1-day view, 1-day engaged-view, or combinations such as 7-day click or 1-day view. Conversion time can follow Meta's default, the impression, the conversion, or the mixed mode.
Numbers that add up
Ratios such as CTR, CPC, CPM and ROAS are recalculated from their parts, so totals and subtotals stay correct instead of averaging averages. Names are attributes of IDs, so a renamed campaign does not split into two rows. Long date ranges are split into the request sizes Meta accepts and joined back.
Set up a Facebook Ads report
Connect Meta in Whathead
Connect your Meta ad accounts in your Whathead workspace. The add-on can only read accounts the workspace already has.
Open the sidebar
In Google Sheets: Extensions, Whathead for Google Sheets, Launch sidebar, then sign in.
Build the query
Select the start cell, choose Facebook Ads, accounts, metrics, dimensions and dates. Add filters or a comparison period if you need them.
Schedule it
Refresh one query, the sheet or the whole spreadsheet from the menu, or schedule up to 5 refreshes per spreadsheet. Schedules run on Whathead servers, so the file does not need to be open.
Availability and permissions
The public Google Workspace Marketplace listing for Whathead for Google Sheets is not live yet. Until it is, email [email protected] from the address on your Whathead account and the team will help you get access. The add-on asks for three Google permissions: the current spreadsheet only, its sidebar, and calls to www.whathead.com. It does not read your Drive, Gmail or other spreadsheets.
Frequently asked questions
Is the Facebook Ads connector free?
The add-on is free to install. Running queries needs a Whathead account with an active trial or any paid plan; plans start at $29 a month with a 14-day free trial.
Will the numbers match Ads Manager?
With the default conversion window, Whathead asks Meta to use each ad set's own attribution setting, which is what Ads Manager shows. Different windows will give different conversion counts.
Can I combine several ad accounts in one table?
Yes, up to 100 Meta ad accounts per query. Account ID, name, currency and timezone are available as dimensions.
Can I get hourly data?
Yes. Choose hourly granularity. The hour dimension is in the viewer's time zone, as Meta reports it.
Does it overwrite my own cells?
No. Before writing, the add-on checks the target range and asks before overwriting cells that are not part of a Whathead query.
Can I pull TikTok or Snapchat into the same spreadsheet?
Yes. Each query picks its own source, and the add-on supports 14 sources including TikTok, Snapchat, Google Ads and GA4.
Run it from one workspace
Every plan starts with a 14-day free trial. Only successful live work is metered.