LinkedIn Ad is a great way to advertise all professionals in the world! It's the number one social media for companies and freelancers.
Looker Studio is a free dashboarding tool provided by Google that allows you to create fantastic reports based on data from multiple platforms. LinkedIn Ads included.
In this tutorial, we will see how to import your LinkedIn Ads data into Looker Studio and how to create your first report with it.
We first need to connect your LinkedIn Ads account and Looker Studio. To do so, we will use our LinkedIn Ads Looker Studio connector. It will create a data source for Looker Studio, a data source that we will use in a report to display charts with your data.
To do so:
Great, you just created your first LinkedIn Ads data source! Now let's use it in a report.
(If you want to know more about Looker Studio data sources, check this article).
You'll find the blank template report to copy and follow this tutorial with on this link.
If you already know how to create a report, you can find the complete template here and instructions on how to copy it with your data source at the end of this article.
You have 2 options here. You can take the blank template link and follow the tutorial with it. Or create your own report from scratch.
To do so: click the Create report button at the top right from the data source previously created. Looker Studio now creates a report where you are the owner and contains your data source. You'll find more information about the report interface on this page.
Now, I need to choose the essential KPIs. On my LinkedIn Ads, I'm primarily interested in the leads to my website. I want to know how many people saw one of my ads and became a visitor and how much it cost me.
Here's the list of metrics I will use:
And the breakdown I want to see:
Now that we have the metrics and dimensions list let's place them in the report.
Click on Add a chart, then Scorecard. Next, click in canvas to place this scorecard, and change the metric in the configuration panel to Impressions.
Add a bit of style to this scorecard:
Now that we set up the style for one scorecard, copy and paste it. You will keep the style with the copy and must only change the metric in the configuration panel.
I will create calculated fields for the Cost per Lead and Leads Conversion Rate like this :
Formula for Cost per Lead: "SUM(cost in local currency)/SUM( One Click Leads)
Formula for Lead Conversion Rate: "SUM(One Click Leads)/sum(Clicks)"
And to finish this section, we will align and rename the scorecard so it looks good:
And rename some of the metrics, so the name fits better :
We placed scorecards with the overall metrics. Now it's time to add more charts with our chosen dimensions.
At first, I want a simple table by campaigns with my metrics. To do so:
Add all the metrics to the table.
And finally, we will modify the style of the table:
Let's look at audiences now. A great way to display such information is a pie chart. You can quickly identify big and small audiences.
We will use the Member Seniority dimension to know the age range of our audience:
And we can modify the style easily by copying the table and pasting only the style:
Pie-chart does not have an automatic title. We can add one :
A great way to know which ads work better is to see which creative generates the most leads. Now, we already have a table for the campaign. We can re-use it:
Copy and paste the campaign table.
Change the dimension to Creative Ad Thumbnail and keep only Leads metrics.
Finally, change the type of the Creative Ad Thumbnail to images to display images in your report.
Looker Studio displays the last 28 days of data in your report by default. But you can use a Date range control to modify it live:
You can also add a selector to help viewers to filter the data. For example, a simple selector on the Campaign Type Objective can easily focus the report.
To do so:
You can find the complete template here.
You can quickly copy it like this:
And you are ready to go!
If you need help using our connector or creating a report on Looker Studio, don't hesitate to contact us anytime on our chat!
Get all your marketing data in your favorite data activation, database or reporting tools.