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
Step 4 :
Add Windsor.ai’s Extension to Google sheets.
Step 5:
Copy The template with clicking on File -> Make a copy
Template Link : Google Sheet Linkedin Ads Overview Report
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:
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”