Why Snapchat reporting is awkward without a connector
Snapchat's stats API separates swipe-up and view conversions, limits daily queries to 31 days and hourly queries to 7, and keeps reach and lifetime metrics in their own endpoints. Exports from Ads Manager do not keep the same columns from week to week. Whathead handles these rules for you: it splits long ranges into allowed windows, sends lifetime fields to the lifetime report, and keeps column names stable so formulas and charts do not break.
Report types (splits)
| Split by | Dimensions |
|---|---|
| Default | Account, campaign, ad squad, ad, creative |
| Country / Region / DMA | Country code and name, region code and name, DMA |
| Demographics | Gender, age group |
| Operating system / Device make | iOS or Android, device make |
| Country and OS | Both at once |
| Lifestyle category | Snapchat lifestyle category ID and name |
| Lifetime totals | Unique reach and frequency across the full life of each campaign, ad squad or ad |
Metric groups
| Group | Examples |
|---|---|
| Delivery | Impressions, paid impressions, swipes, swipe-up rate, spend, eCPM, eCPSU |
| Reach | Unique impressions, frequency, total reach, earned reach, lifetime reach and frequency |
| Video | Video views, 5-second and 15-second views, engaged views, quartiles, completions, screen time, eCPV |
| Story and engagement | Story opens, story completes, profile clicks, landing page views, reminders set |
| Lens and filter | Camera saves and shares, earned impressions, Lens play time |
| Conversions (280 fields) | Purchases, add to cart, start checkout, content views, sign ups, saves, each with value and split by swipe-up, view and engaged view |
| App installs and SKAN | Total, iOS and Android installs with eCPI; 96 SKAdNetwork fields |
| Leads | Leads and cost per lead |
Attribution and conversion time
Each query has an attribution window made of a view window (none, 1, 3 or 6 hours, 1 or 7 days) and a swipe window (1, 7 or 28 days). The default is Snapchat's own: 1-day view plus 28-day swipe. Engaged-view conversions always use Snapchat's fixed 2-day window. Conversions can be shown by conversion time (Snapchat's default) or by impression time.
Creative dimensions include headline, brand name, call to action, web view URL, deep link URL, thumbnail, image, preview and media file URLs, so a creative report can show the actual asset next to its numbers.
Build a Snapchat report
Connect Snapchat in Whathead
Connect the Snapchat ad accounts in your Whathead workspace first.
Launch the sidebar
Extensions, Whathead for Google Sheets, Launch sidebar. Sign in with your Whathead account.
Pick fields and dates
Choose Snapchat Ads, up to 50 accounts, metrics, a split such as Demographics, and a date range.
Refresh or schedule
Run it now, or schedule hourly, daily, weekly or monthly refreshes that run on Whathead servers.
Frequently asked questions
How do I get the add-on?
The public Google Workspace Marketplace listing is not live yet. Email [email protected] from your Whathead account address and the team will help you get access.
Is it free?
Installing is free. Queries need an active Whathead trial or any paid plan, from $29 a month with a 14-day free trial.
Why do my conversions differ from Snapchat Ads Manager?
Check the attribution window and conversion time on the query. The default matches Snapchat's 1-day view and 28-day swipe at conversion time.
Can I report reach for a full month?
Yes for the total of a range up to 92 days, which is Snapchat's limit for reach. For reach over a campaign's whole life, use the Lifetime totals split.
Which permissions does the add-on ask for?
Three: access to the current spreadsheet only, the sidebar, and calls to www.whathead.com. It cannot read your Drive or other spreadsheets.
Run it from one workspace
Every plan starts with a 14-day free trial. Only successful live work is metered.