Whathead
  • Builder
  • MCP server
  • Transfer
  • Guardrails
  • Pricing
  • Blog
  • Docs
Log inSign up free
  1. Home
  2. Google Sheets add-on
  3. Google Sheets connector: Snapchat Ads
Google Sheets connector: Snapchat Ads

Snapchat Ads reporting in Google Sheets

Whathead for Google Sheets brings Snapchat Ads data into a spreadsheet from the Snapchat Marketing API. Choose ad accounts, metrics, dimensions and dates in the sidebar and the table writes at your selected cell, refreshing on a schedule if you want. It covers 455 Snapchat metrics and 58 dimensions, including conversions split by swipe-up, view and engaged view, SKAdNetwork installs and Lens metrics. The add-on is free to install; queries need a Whathead trial or plan.

Updated 18 Nov 2026
Get the Sheets add-onSee pricing
Source
Snapchat Marketing API (stats)
Fields
455 metrics, 58 dimensions
Accounts per query
Up to 50
Attribution
Default 1-day view + 28-day swipe, adjustable
Granularity
Total, daily, hourly, or lifetime totals
Availability
Marketplace listing pending; access via support
On this page
Why Snapchat reporting is awkward without a connectorReport types (splits)Metric groupsAttribution and conversion timeBuild a Snapchat reportFAQRelated

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 byDimensions
DefaultAccount, campaign, ad squad, ad, creative
Country / Region / DMACountry code and name, region code and name, DMA
DemographicsGender, age group
Operating system / Device makeiOS or Android, device make
Country and OSBoth at once
Lifestyle categorySnapchat lifestyle category ID and name
Lifetime totalsUnique reach and frequency across the full life of each campaign, ad squad or ad

Metric groups

GroupExamples
DeliveryImpressions, paid impressions, swipes, swipe-up rate, spend, eCPM, eCPSU
ReachUnique impressions, frequency, total reach, earned reach, lifetime reach and frequency
VideoVideo views, 5-second and 15-second views, engaged views, quartiles, completions, screen time, eCPV
Story and engagementStory opens, story completes, profile clicks, landing page views, reminders set
Lens and filterCamera 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 SKANTotal, iOS and Android installs with eCPI; 96 SKAdNetwork fields
LeadsLeads 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

  1. Connect Snapchat in Whathead

    Connect the Snapchat ad accounts in your Whathead workspace first.

  2. Launch the sidebar

    Extensions, Whathead for Google Sheets, Launch sidebar. Sign in with your Whathead account.

  3. Pick fields and dates

    Choose Snapchat Ads, up to 50 accounts, metrics, a split such as Demographics, and a date range.

  4. 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.

Related

  • Whathead for Google Sheets
  • Facebook Ads to Google Sheets
  • TikTok Ads to Google Sheets
  • Snapchat Ads MCP
  • Windsor.ai alternative
  • Supermetrics alternative

Run it from one workspace

Every plan starts with a 14-day free trial. Only successful live work is metered.

Get the Sheets add-onCompare plans
Whathead© 2026 Whathead. Multi-platform ad operations and an Ads MCP server.
Product
PricingMCP serverMeta Ads MCPGoogle Ads MCPCross-platform transferAd anomaly detectionServer-side trackingGoogle Sheets add-onLooker Studio connector
Compare
Supermetrics alternativePipeboard alternativeRyze AI alternativeWhathead vs Meta’s official MCP
Resources
BlogDocsAboutSupportContact
Legal
Terms of ServicePrivacy PolicyRefundsSecurity & DataLog in