How to Import Analytics Data from LinkedIn Ads into Excel

Tracking LinkedIn Ads performance requires easy access to your analytics data. Instead of manual exports that quickly become outdated, you can create a live connection between LinkedIn Ads and Excel.

This guide shows you how to import LinkedIn Ads Analytics data directly into Excel for better reporting and decision-making.

How to Import LinkedIn Ads Analytics 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 Analytics Data

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

1. Select “Analytics” from the list of available objects
2. Configure any filters you want to apply (date range, campaigns, metrics, etc.)
3. Choose where to import the data in your spreadsheet
4. Click “Import” to bring the data into Excel
5. Optional: Set up automatic refreshes to keep your data updated

Once imported, you can analyze your LinkedIn Ads Analytics data directly in Excel. Create pivot tables, charts, and custom calculations to gain deeper insights into your campaign performance.