Circle Separator4 mins read

How to Export Snapchat Ads to Excel

The quickest way to move Snapchat Ads data into Excel is a 3-step process: export a report from Snapchat Ads Manager as a CSV file, open or import it in Excel, then check the data types. For recurring reporting, use the Snapchat Marketing API or a third-party connector instead of repeating manual downloads.

Snapchat Ads to Excel: Choose the Right Method

Your requirementBest methodWhy
One-off campaign reportSnapchat Ads Manager exportFastest option with no technical setup
Weekly or daily reportingSnapchat Marketing APISupports repeatable reporting and automation
Refreshable workbook connectionExcel connectorReduces manual downloads, but may involve vendor costs and permissions
Large or highly detailed reportSnapchat Marketing API asynchronous reportCan return CSV or Excel files for broad reporting requests

For most advertisers, start with the Ads Manager export. Move to Power Query when you are combining recurring files, and use the API when you need scheduled reporting.

How to Export Snapchat Ads Data from Ads Manager

Export Snapchat Ads data by downloading a CSV report from Ads Manager:

  1. Sign in to Snapchat Ads Manager.
  2. Select the relevant ad account.
  3. Open the menu and choose Manage Ads.
  4. Select the reporting level:
    • Campaigns
    • Ad Sets
    • Ads
  5. Select Columns and choose the metrics you need.
  6. Select Download.
  7. Choose the report configuration, date range and columns.
  8. Select Export.

Snapchat documents this process as a CSV export containing the selected metrics, dates and reporting level. Excel can open the downloaded file directly, or you can import it through Power Query.

How to Import a Snapchat Ads CSV into Excel

Import the CSV through Excel's From Text/CSV option:

  1. Open Excel.
  2. Go to Data.
  3. Select Get Data > From File > From Text/CSV.
  4. Select the Snapchat Ads CSV file.
  5. Check the delimiter, column names and data types.
  6. Select Load to create an Excel table.
  7. Select Transform Data if you need to clean or reshape the report first.

Power Query can detect CSV delimiters, identify column headers and assign data types. It can load the result into an Excel table or PivotTable.

Use separate sheets for:

  • Raw Snapchat Export: the untouched downloaded data
  • Clean Data: corrected data types, names and formatting
  • Pivot Tables: campaign and ad performance summaries
  • Dashboard: charts and key performance indicators
  • Notes: date range, account, currency and attribution settings

Keep the raw export unchanged. That gives you an audit copy and makes it easier to replace the source file when you download a new report.

Which Snapchat Ads Metrics Should You Export?

Export the columns that match your campaign objective. Common Snapchat Ads fields include:

  • Campaign name and ID
  • Ad Set name and ID
  • Ad name and ID
  • Reporting date
  • Spend
  • Impressions
  • Reach
  • Swipe-ups
  • Video views
  • Video completion
  • Landing page views
  • Leads
  • Purchases or other conversion events
  • Cost per result
  • Conversion value
  • Return on ad spend

Snapchat's Ads API documentation includes metrics such as spend, impressions, swipe-ups, video views, landing page views and native leads. The available metrics depend on the ad format, objective and report configuration.

Use IDs as Well as Names

Export campaign, ad set and ad IDs whenever possible. Names can change in Ads Manager, while IDs provide a more stable way to match records across reports.

IDs are useful when you:

  • Append multiple reports
  • Compare historical campaign versions
  • Build Power Query transformations
  • Join Snapchat data with sales or analytics data

How to Automate Snapchat Ads Reporting in Excel

Use a folder of CSV files, the Snapchat Marketing API or a third-party connector, depending on how often you need updated data.

Option 1: Combine CSV Exports from a Folder

To combine recurring downloads in Excel:

  1. Export each Snapchat Ads report with the same columns.
  2. Save every CSV file in one folder.
  3. In Excel, select Data > Get Data > From File > From Folder.
  4. Combine the files in Power Query.
  5. Apply the same cleaning steps to each file.
  6. Refresh the query when you add a new export.

Microsoft Power Query can import similarly structured files from a folder and combine them into one table.

This method still requires a download from Snapchat, but it removes the need to combine each file manually.

Option 2: Connect Through the Snapchat Marketing API

The Snapchat Marketing API provides campaign reporting at hourly, daily and total granularity. It suits agencies, brands and analysts that need scheduled data collection or a reporting database.

A typical workflow is:

  1. Create and authorize an application in Snap Business Manager.
  2. Authenticate with Snapchat using OAuth 2.0.
  3. Request campaign, ad set or ad statistics.
  4. Save the response as CSV, Excel or database records.
  5. Load the output into Excel through Power Query.
  6. Refresh the workbook when new data is available.

Snapchat uses OAuth 2.0 access tokens. The returned data depends on the permissions associated with the authorized account.

For large reporting requests, Snapchat supports asynchronous reports. These reports can be generated in CSV or Excel format and downloaded after processing. Snapchat recommends asynchronous reporting for large or broad breakdown queries because standard requests may time out or hit size limits.

Option 3: Use a Snapchat Ads Excel Connector

A third-party connector may work when you need a refreshable workbook but do not want to build and maintain an API integration.

Before choosing a connector, check:

  • Whether it supports Snapchat Ads reporting rather than only campaign management
  • Available campaign, ad set and ad dimensions
  • Supported attribution windows
  • Refresh frequency
  • Historical data limits
  • Read-only or write-back access
  • Data storage and authentication practices
  • Subscription cost

For a small number of manual reports, a connector may add more setup than it removes. For a reporting team managing multiple accounts, it can reduce repeated downloads.

Snapchat Ads and Excel Data Issues to Check

Spend May Use Micro-Currency in API Reports

Snapchat's API documentation describes monetary values in micro-currency. If an API response returns spend in micro-currency, divide the value by 1,000,000 before presenting it as the local currency amount.

Do not apply this conversion to every native Ads Manager export. First check whether the downloaded file already displays normal currency values.

Keep Attribution Settings Consistent

Two Snapchat reports can show different conversion results when they use different:

  • Swipe attribution windows
  • View attribution windows
  • Date ranges
  • Time zones
  • Campaign or ad breakdowns
  • Conversion event definitions

Use the same settings when comparing reports. Record them in a Notes sheet so another person can understand how the workbook was created.

Check Excel Data Types

Excel may import some values as text, particularly:

  • Spend
  • Percentages
  • Currency values
  • IDs with leading zeros
  • Date fields
  • Blank or unavailable metrics

Use Power Query to set numeric, date and text types before building formulas or PivotTables. Microsoft recommends Transform Data when the imported CSV needs editing before it is loaded into Excel.

A Static CSV Does Not Update Automatically

Opening a Snapchat export in Excel gives you a local copy of the report. It does not retrieve new Snapchat data automatically.

For refreshable reporting, you can:

  • Replace the source CSV in the same folder and refresh Power Query
  • Add recurring exports to a folder query
  • Connect Excel to an API output
  • Use a Snapchat Ads connector

Power Query can refresh connected data sources after the query has been created.

The Best Snapchat Ads to Excel Workflow

Set up the workbook in this order:

  1. Export one report from Snapchat Ads Manager and confirm that the columns and currency values are correct.
  2. Save the untouched file in a Raw Snapchat Export sheet or source folder.
  3. Use Power Query when you need to clean one file or combine recurring exports.
  4. Move to the Snapchat Marketing API when downloads need to run on a schedule or cover multiple accounts.
  5. Record the account, date range, currency and attribution settings in the workbook.

For most teams, this keeps the first report simple without preventing a later move to repeatable reporting.

Next Read