Learn how to set up and customize data exports from your LinkedIn Ads account to Google Sheets, BigQuery, and Looker Studio with SyncRange.
Overview
After connecting your LinkedIn Ads account, you can configure exports to send your advertising data to Google Sheets, BigQuery, or Looker Studio. This allows you to analyze campaign performance, track audience insights, monitor creative effectiveness, and create comprehensive advertising reports based on your LinkedIn Ads data.
Prerequisites
Before configuring LinkedIn Ads exports, make sure you have:
Verified that your LinkedIn connection is active and working properly
At least one active campaign in your LinkedIn Ads account
Creating a LinkedIn Ads Export
Follow these steps to create a new LinkedIn Ads export:
Navigate to the Export Builder
From your dashboard, go to "Export Builder" and click "Create New Export".
Select LinkedIn as the Data Source
Choose "LinkedIn" from the list of available data sources.
Select Your LinkedIn Ads Account
If you have multiple LinkedIn Ads accounts connected, select the account you want to export data from.
Choose Your Destination
Select the Google Sheet, BigQuery dataset, or Looker Studio where you want to export your LinkedIn Ads data.
Configure Export Settings
Set up the export configuration as described in the sections below.
The LinkedIn export configuration screen
Save Your Export
Click "Create Export" to save your configuration and create the export.
Export Configuration Options
When configuring a LinkedIn Ads export, you have several options to customize what data is exported and how it's organized:
Basic Settings
Configure the fundamental settings for your export:
Export Name: Give your export a descriptive name to help you identify it later
Date Preset: Choose the date range for your export data (matches Meta's preset options):
Today, Yesterday
Last 3, 7, 14, 28, 30, or 90 days
This month, Last month
This quarter
This year, Last year
Maximum (1 year of data)
Custom range: exact start and end dates (maximum 1 year). One-time historical pull: scheduled runs are paused while this is selected; use Run now. Choose a LinkedIn preset again to re-enable a recurring schedule.
Data Tabs
LinkedIn Ads exports are organized by data types, with each type creating a separate tab in your destination. The interface uses a tab-based layout where you can configure each data type independently:
The tab interface for configuring different data types
Available data tabs include:
Campaigns: Campaign-level data including performance metrics and settings
Campaign Groups: Campaign group information and aggregated performance
Creatives: Ad creative details and performance data
Shares: Content shares and their performance metrics
Video Ads: Video ad performance and engagement metrics
Insights: Detailed campaign insights and analytics
Account: Account-level information and settings
Audience: Audience targeting and demographic data
Conversions: Conversion tracking and attribution data
For each data tab, you can:
Enable/Disable: Choose whether to include this data type in your export by selecting columns
Time Granularity: For analytics tabs (Campaigns, Campaign Groups, Creatives, Shares, Video Ads), choose how to break down data over time: All (aggregated), Daily, Monthly, or Yearly. Use Daily for time-series analysis; use All for a single row per campaign/creative with totals
Set Data Handling: Choose whether to append new data or replace existing data
Select Columns: Choose which specific data fields to include for this data type
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:
LinkedIn limits the number of analytics metrics you can export per request. The interface will show you how many metrics you've selected and warn you if you exceed the limit. Keep your selection under 18 analytics metrics to avoid hitting LinkedIn's API limits.
You can use the "Select All" and "Deselect All" buttons to quickly manage your column selections.
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. When enabled, each export adds new rows to the destination and leaves existing rows. When disabled, the destination is fully refreshed and existing data is removed.
Pro Tip
Use the append option for data you want to track over time (like campaign performance or conversion data), and use replace for data that represents current state (like campaign settings or creative details).
Best Practices
Start Simple: Begin with just one or two data tabs and a few essential columns
Focus on Key Metrics: Select only the columns you actually need for your analysis
Respect API Limits: Keep your analytics metrics selection under 18 to avoid hitting LinkedIn's API limits
Consider Sheet Size: Be mindful that exporting too many columns or rows can make your destination slow or hit size limits
Use Appropriate Date Ranges: Choose a date range that matches your reporting needs
Append Strategically: Use append for historical data tracking, but be aware that it will increase your destination size over time
Create Multiple Exports: Instead of one large export with everything, create separate focused exports for different purposes
Check Your Exports: After creating an export, run it manually and verify the data before setting up automation
Monitor API Usage: LinkedIn has rate limits, so avoid running exports too frequently
Troubleshooting
Missing Data
If your export is missing expected data:
Verify that you've selected the appropriate columns for the data tab
Check if the date range is appropriate for the data you're looking for
Ensure that the data exists in your LinkedIn Ads account
Check if you have the necessary permissions to access that data
Verify that your campaigns are active and have data for the selected date range