Google Sheets LinkedIn Ads Overview Report

Linkedin ads Google sheets

LinkedIn is a social networking site that primarily focuses on business connections. It is one of the most well-known social media sites in the world. As of April 2022, LinkedIn had at least 828.1 million members based on advertising audience reach estimates.

Therefore, it is imperative that as a B2B marketer, corporate organization, or small business, you get detailed reporting on your marketing effort on LinkedIn.

However, the LinkedIn Ads dashboard doesn’t provide a comprehensive visualization for effective reporting, making it difficult to make informed decisions about your marketing approach.

To make sense of the data on the LinkedIn Ads dashboard, you need some understanding of its analytics tool, which takes up time and resources you don’t necessarily have.

This blog post reveals how you can connect LinkedIn Ads to Google sheets using Windsor.ai  connector that can help you go through this process easily.  

Let’s dig in!

 

Connect Linkedin Ads to Windsor.ai

 

Step 1 :

Login or Register in Windsor.ai’ website.

 

Step 2 :

Grant access to your Linkedin Ads Account

 

 

Step 3 :

click on Google sheet as show below and copy your API KEY

Google Sheets API

 

Step 4 :

Add Windsor.ai’s Extension to Google sheets.

Google sheet extension windsor.ai

 

Step 5:

Copy The template with clicking on File -> Make a copy
Template Link :  Google Sheet Linkedin Ads Overview Report

Copy tempalte google sheet

 

Step 6 :

Clear all data from the Raw Data Sheet

Step 7 :

Under Extensions in the top ribbon of Google Sheets, select “Add Data & Analytics by Windsor.ai“, then “Login” and Paste your API KEY there:

 

Paste your API KEY GOOGLE SHEETS

Step 8 :

Now under “Add Data & Analytics by Windsor.ai” extension press on Get Data into Sheets, then Add new query.

 

 

Select Data Source, Linkedin Ads account, Field and Data range. Now click on Load Data and your template should be ready.
PS : Make Sure in the Target sheet Name to Write ” Raw Data”