Import LinkedIn Ads API Data To Google Sheets

LinkedIn advertising is a major channel in the advertising industry. Like other marketing channels, it needs reporting. The LinkedIn Ads API (application programming interface) may be hard to understand for others to start and the interface might be confusing to use.

Google Ads is better with reporting since it’s within the Google ecosystem. So, this means that the integration is easier. And you can start interpreting the data quickly. LinkedIn Ads, and other marketing channels like Facebook, don’t have that luxury.

You CAN import LinkedIn Ads data from the API to Google Sheets. You do copy and paste until your eyes and fingers can’t take the mundane task anymore. That’s manual reporting and it’s an unbearable nightmare.

How To Import LinkedIn Ads Data To Google Sheets

To connect LinkedIn Ad data to Google Sheets, you need a Google Sheets add-on. These add-ons are most likely paid add-ons. As mentioned, you can do it manually (for free) to save money. But in perspective, you might want to spend a little bit to save time. You choose.

You’ll use Two Minute Reports for this example. Two Minute Reports imports data from the LinkedIn Ads API directly to Google Sheets in minutes. No required coding skills.

Installing the Google Sheets Add-on

1 – Go to your Google Drive workspace.

2 – Click ‘ + New’ then create a new Google Sheets file.

tmr 0
tmr 00

3 – At the top, click Add-ons. Then click ‘Get add-ons’.

tmr 2

4 – Search for Two Minute Reports. Then install it.

tmr 1

5 – You now have the add-on installed on your Google Sheets workspace.

tmr 3

Import LinkedIn Ads Data Source

1 – Launch the add-on. A navigation pane on the right side will appear.

tmr 15

2 – Click Add + under Data Sources.

tmr 4

3 – Name your data source. Then select LinkedIn Ads.

tmr li1

4 – Log-in to your LinkedIn account.

tmr li2

5 – Link your LinkedIn account to the tool. Go through the login process until the tool instructs you to close the tab since the sign-in is successful.

tmr 9

Import LinkedIn Ads Data Query

This point in the process is the importing data from the LinkedIn Ads API to the spreadsheet.

1 – Click the burger icon. Then click Data Queries. And click ‘Add +’.

tmr 11

2 – Name your data query. Find the LinkedIn data source you imported earlier.

3 – ‘Save on Sheet’ is the location of the sheet where the data is imported to. Add A1 under Cell.

tmr li4

4- Under ‘Query’, select the LinkedIn Ad Account you want to get data from.

5 – Select the date range with whatever you need.

6 – Select the ‘Metrics’ you want to import (Impressions, Clicks, Company Page Clicks, Likes, Comments, etc).

7 – Select the ‘Dimensions’ you want to import (Campaign name, Creative id, etc).

tmr li5

8 – Click ‘Run query’

Viola! You imported your LinkedIn ads data to Google Sheets hassle-free. You can create reporting templates from here depending on your business needs.

Schedule LinkedIn Ads Reports

Two Minute Reports has a scheduling function. This means the spreadsheet will refresh the acquired data from the API. Reports are automated even more.

1 – Click the burger icon. Then click Schedule Refresh. And click ‘New +’.

tmr fb5

2 – Once inside, you can set the terms of the report schedule.

-Name
-Repeats -> This is where you set how often the data refresh happen. Two Minute Reports can do hourly refresh.
-Timezone

tmr li3

3 – You can also set the notification terms. Two Minute Reports can email you a PDF or Excel of the data. You can also decide to have the email contain the sheet content in the email body.

tmr fb7
tmr fb8

4 – Click ‘Save’.

Scheduling will help when you need to report on LinkedIn Ads overtime. No more copy and paste every day, or every week, or every month.

Bonus: How To Add User Permissions on LinkedIn

1 – Go to your LinkedIn Campaign Manager dashboard. Pick one Ad Account.

tmr li6

2 – Once inside the Ad Account, click the gear icon on the upper right. Then click ‘Manage access’.

tmr li7

3 – Click ‘Edit’ then click ‘+ Add user to account’.

tmr li8

4 – Add either the name of the user’s LinkedIn name or LinkedIn Profile URL. Give the user at least ‘Viewer’ access.

tmr li10
tmr li9

5 – Click ‘Save Changes’. That user should now have the ability to import LinkedIn Ads data into Google Sheets.

Conclusion – LinkedIn Ads Reporting in Google Sheets is Now Easy To Do

This is one of the many add-ons to connect LinkedIn Ads data in Google Sheets. Another add-on to consider is Supermetrics. These are the current methods to do API integrations between third-party tool. These add-ons cost money but the benefits outweigh more.

Avoid import and export spreadsheet hell. Maintain everything in Google Sheets with tools if needed. Stop wasting time on repetitive tasks. Start focusing on important stuff that impacts the business. Hire an digital analyst to help you.


About The Author

Francis Angelo Reyes

Francis is the owner and runs Lupage Digital. With 4 years of experience, Francis writes everything he knows about digital marketing. There’s a large knowledge gap between developers and digital marketers. Francis is the middleman between where the non-technical and technical meet.