Learn how to set up and customize data exports from your Meta (Facebook) advertising accounts to Google Sheets.
After connecting your Meta account, you can configure exports to send your advertising data to Google Sheets. This allows you to analyze campaign performance, track ad metrics, monitor audience insights, and create custom reports based on your Meta advertising data.
Before configuring Meta exports, make sure you have:
Follow these steps to create a new Meta export:
From your dashboard, go to "Export Builder" and click "Create New Export".
Choose "Meta" from the list of available data sources.
If you have multiple ad accounts connected, select the ad account you want to export data from.
Select the Google Sheet where you want to export your Meta data.
Set the date range and, if needed, select which platforms (e.g. Instagram only) to include for performance data. Then set up tabs and columns as described in the sections below.
The Meta export configuration screen
Click "Create Export" to save your configuration and create the export.
When configuring a Meta export, you have several options to customize what data is exported and how it's organized:
Meta exports are organized by data types, with each type creating a separate tab in your Google Sheet:
The tab interface for configuring different data types
Available data tabs include:
For each data tab, you can select which columns (fields) to include in your export.
For each data tab, you can select which columns (fields) to include in your export:
The column selection interface for a data tab
Each data tab has its own set of available columns. Some common columns include:
| Data Tab | Example Columns |
|---|---|
| Campaigns | ID, Name, Status, Objective, Budget, Start Time, End Time, Spend, Results |
| Ad Sets | ID, Name, Campaign ID, Status, Budget, Targeting, Optimization Goal, Bid Strategy |
| Ads | ID, Name, Ad Set ID, Status, Creative, Preview URL, Impressions, Clicks, CTR |
| Insights | Date Start, Date Stop, Campaign ID, Ad Set ID, Ad ID, Account ID, Platform, Impressions, Reach, Frequency, Clicks, CTR, CPC, Spend, Purchases, Omni Add to Cart, Omni Purchases, Purchase Conversion Value, Purchases (1d Click), Purchases (7d Click), Purchases (1d View), Purchases (7d View), and more |
| Date | Date Start, Date Stop, Account ID, Platform, Impressions, Reach, Frequency, Clicks, CTR, CPC, Spend, Omni Add to Cart, Omni Purchases, Purchase Conversion Value, and other metrics. One row per time period (day/week/month) for the whole ad account. |
| Insights (Campaigns) | Same metrics as Insights, with Campaign ID, Campaign Name, and Platform. One row per campaign per time period. Time granularity selectable. |
| Insights (Ad Sets) | Same metrics as Insights, with Ad Set ID, Ad Set Name, and Platform. One row per ad set per time period. Time granularity selectable. |
| Insights (Ads) | Same metrics as Insights, with Ad ID, Ad Name, and Platform. One row per ad per time period. Time granularity selectable. |
| Audiences | ID, Name, Description, Size, Type, Creation Time, Rule |
You can use the "Select All" and "Deselect All" buttons to quickly manage your column selections.
You can specify the date range for which you want to export data using Meta's preset date ranges:
These date presets are Meta API presets and are used to filter data for all data types, including Campaigns, Ad Sets, Ads, and Insights. Even when a tab has no data (for example, no audiences or no activity in the date range), the export still writes the column headers so the sheet or table is created with the correct structure.
In Export Settings, you can limit performance data to specific Meta platforms. This applies only to the Date and Insights tabs (including Insights, Insights (Campaigns), Insights (Ad Sets), and Insights (Ads)).
The Campaigns, Ad Sets, Ads, and Audiences tabs are not filtered by platform—they always include all entities in your ad account. Only the performance metrics in the Date and Insights tabs are limited to the platforms you select.
When you use a platform filter, a Platform column is available in the Date and Insights tabs. You can include it in your column selection to see which platform (e.g. instagram, facebook) each row belongs to. If you leave all platforms unchecked, this column will be empty because data is aggregated across all platforms.
For each data tab, you can choose how to handle the exported data:
The append option is particularly useful for building historical datasets over time, especially for Insights and Date data. When enabled, new data will be added to existing rows rather than replacing them.
The Date tab provides account-level performance metrics—one row per time period for the entire ad account (no campaign/ad set/ad breakdown). You can choose time granularity: daily (default), weekly, or monthly. This is useful for high-level time-series analysis and account totals.
The Insights (Campaigns), Insights (Ad Sets), and Insights (Ads) tabs also support time granularity (daily, weekly, monthly) and give you performance broken down by that dimension.
Insights and dimension tabs ensure complete date coverage per entity: if an entity had no impressions on a day, you still get a row for that date with empty metrics. The Date tab outputs one row per time period for the account, with empty metrics when there is no activity.
Append Mode Behavior:
Each data tab includes an Account ID field that can be used to identify which Meta Ad Account the data belongs to. This is especially useful if you're exporting data from multiple ad accounts.
If your export is missing expected data:
If your export fails with errors:
If you notice differences between exported data and Meta Ads Manager reports:
