How to Import Creatives Data from LinkedIn Ads into Excel

Analyzing creative performance is crucial for LinkedIn Ads success. Instead of manual exports, you can create a direct connection between LinkedIn Ads and Excel to access all your creative data.

This guide shows you how to import LinkedIn Ads Creatives data into Excel for better creative optimization.

How to Import LinkedIn Ads Creatives Data into Excel

Step 1: Install Coefficient and Connect Your LinkedIn Ads Account

First, you’ll need to install the Coefficient add-in and connect it to your LinkedIn Ads account:

1. Open Excel
2. Go to the Insert tab
3. Click Get Add-ins
4. Search for “Coefficient” and install it from the Office Add-ins store
5. Once installed, open the Coefficient sidebar
6. Click “Import from…” to see available data sources

Step 2: Select LinkedIn Ads as Your Data Source

Now you’ll need to select LinkedIn Ads and authenticate your account:

1. In the Coefficient sidebar, select “Marketing” from the categories
2. Choose “LinkedIn Ads” from the available marketing integrations
3. Click “Connect” and follow the authentication prompts to link your LinkedIn Ads account
4. Once connected, you’ll see the available data objects from LinkedIn Ads

Step 3: Import LinkedIn Ads Creatives Data

After connecting your account, you can import your Creatives data:

1. Select “Creatives” from the list of available objects
2. Choose the specific creative fields you want to import (type, status, content, etc.)
3. Apply any filters needed (by campaign, status, etc.)
4. Select where to import the data in your spreadsheet
5. Click “Import” to bring the creatives data into Excel

With your creatives data in Excel, you can analyze which ad content performs best, identify patterns in successful creatives, and make data-driven decisions about future creative development.