Configuring Meta Exports

Overview

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.

Prerequisites

Before configuring Meta exports, make sure you have:

• Connected your Meta account (see Connecting Your Meta Account)
• Connected at least one Google Sheet (see Configuring Google Sheets)
• Verified that your Meta connection is active and working properly
• Active campaigns, ad sets, or ads in your Meta ad accounts

Creating a Meta Export

Follow these steps to create a new Meta export:

1. Navigate to the Export Builder

   From your dashboard, go to "Export Builder" and click "Create New Export".

2. Select Meta as the Data Source

   Choose "Meta" from the list of available data sources.

3. Select Your Meta Ad Account

   If you have multiple ad accounts connected, select the ad account you want to export data from.

4. Choose a Google Sheet

   Select the Google Sheet where you want to export your Meta data.

5. Configure Export Settings

   Set up the export configuration as described in the sections below.

   

   The Meta export configuration screen

6. Save Your Export

   Click "Create Export" to save your configuration and create the export.

Export Configuration Options

When configuring a Meta export, you have several options to customize what data is exported and how it's organized:

Data Tabs

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:

• Campaigns: Information about your advertising campaigns
• Ad Sets: Details about your ad sets within campaigns
• Ads: Information about individual ads
• Insights: Performance metrics and analytics data
• Audiences: Information about your custom audiences

For each data tab, you can select which columns (fields) to include in your export.

Column Selection

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, Campaign ID, Ad Set ID, Ad ID, Account ID, Impressions, Reach, Frequency, Clicks, CTR, CPC, Spend, Conversions, Purchases (1d Click), Purchases (7d Click), Purchases (1d View), Purchases (7d View)
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.

Date Range Options

You can specify the date range for which you want to export data using Meta's preset date ranges:

• Today: Data from the current day
• Yesterday: Data from the previous day
• Last 3 days: Data from the previous 3 days
• Last 7 days: Data from the previous week
• Last 14 days: Data from the previous two weeks
• Last 28 days: Data from the previous four weeks
• Last 30 days: Data from the previous month
• Last 90 days: Data from the previous three months
• This month: Data from the current month
• Last month: Data from the previous month
• This quarter: Data from the current quarter
• Maximum: Maximum available data range

These date presets are used by the Meta API to filter data for all data types, including Campaigns, Ad Sets, Ads, and Insights.

Data Handling

For each data tab, you can choose how to handle the exported data:

• Replace (default): Each export run will clear existing data and replace it with new data
• Append: Each export run will add new data rows without removing existing data

The append option is particularly useful for building historical datasets over time, especially for Insights data. When enabled, new data will be added to existing rows rather than replacing them.

Best Practices

• Focus on Key Metrics: Select only the columns you actually need for your analysis to keep your sheets manageable
• Use Multiple Exports: Create separate exports for different purposes (e.g., one for campaign management, another for performance analysis)
• Combine with Other Data: Use Google Sheets to combine your Meta data with data from other sources like Google Analytics or Google Ads
• Regular Scheduling: Set up daily or weekly exports to track performance trends over time
• Append for Historical Data: Use the append option for Insights data to build a historical dataset beyond Meta's standard reporting periods
• Replace for Current State: Use the replace option for Campaigns, Ad Sets, and Ads to always have the current state of your advertising structure

Troubleshooting