How to Import Accounts Data from LinkedIn Ads into Excel

Managing multiple LinkedIn Ads accounts requires consolidated visibility. With Coefficient, you can bring all your LinkedIn Ads accounts data directly into Excel for better oversight and reporting.

This guide shows you how to import LinkedIn Ads Accounts data into Excel quickly and efficiently.

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

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

1. Select “Accounts” from the list of available objects
2. Choose the specific account fields you want to import (name, status, currency, etc.)
3. Select the destination in your spreadsheet where you want the data to appear
4. Click “Import” to bring the account data into Excel
5. Optional: Set up automatic refreshes to keep your data updated

Once imported, you can use Excel’s features to analyze and visualize your LinkedIn Ads account information, track account status changes, and monitor budgets across multiple accounts.