How to Import Post-level Insights Data from LinkedIn Pages into Excel

Importing your LinkedIn Pages Post-level Insights data into Excel enables deeper analysis of individual post performance, content type effectiveness, and audience preferences beyond what LinkedIn’s native analytics provides.

With Coefficient, you can establish a live connection that keeps your post data current in Excel without manual exports, helping you identify which content resonates most with your audience.

Step-by-Step Guide to Importing LinkedIn Pages Post-level Insights into Excel

Step 1: Install Coefficient in Excel

First, add the Coefficient add-in to Excel:

1. Open Excel
2. Click on the “Insert” tab in the ribbon
3. Select “Get Add-ins”
4. Search for “Coefficient” in the Office Add-ins store
5. Click “Add” to install the Coefficient add-in

Step 2: Connect to LinkedIn Pages and Import Post-level Insights Data

After installing Coefficient, follow these steps to import your Post-level Insights data:

1. Open the Coefficient sidebar in Excel
2. Click “Import” to see available data sources
3. Select “LinkedIn Pages” from the marketing connectors list
4. Log in with your LinkedIn credentials when prompted
5. From the object list, select “Post-level Insights”
6. Choose which metrics you want to import (e.g., impressions, clicks, engagement rate, reactions)
7. Apply any filters if needed (e.g., date range, post type)
8. Click “Import” to bring the data into your spreadsheet

Step 3: Set Up Auto-Refresh (Optional)

To ensure your Post-level Insights data remains up-to-date:

1. Select your imported Post-level Insights data in Excel
2. In the Coefficient sidebar, click “Refresh”
3. Choose “Set up auto-refresh”
4. Select your preferred refresh schedule (hourly, daily, or weekly)
5. Configure any notification settings
6. Click “Save” to enable automatic updates