Paid Ads​ Looker Studio report template based on Windsor.ai connector — overview

Gala Ivannikova
4 min readMar 26, 2024

--

Among various reports from our template store that may be useful for the ones working with Paid Ads, you may also like Paid Ads​ Template Using Windsor.ai Connector.

It’s a one-page dashboard and it is very easy to you though it gives you a full image of your Paid Ads performance.

But first of all, check our video-overview of this template:

Looker Studio dashboard overview

Primarily, this dashboard starts with main KPIs overview based on Google Ads and Facebook Ads data. As you can see, there are two filters — Data Source and Campaign. Take advantage of them, if you want to present data from a certain data source or campaign only.

In the first section we overview main metrics like Impressions, Clicks, CTR, Cost per Click, Cost, Transactions, Conversion value and ROAS.

Followingly, we have Google Ads and Facebook Ads campaign breakdowns.

In this chart you can enable the drill-down from campaign to Ad Group name and select what metrics you want to show owing to optional metrics feature.

Dashboard back-end

This dashboard is based on only one data source, and it’s not a blended data source. Let me explain to you how I did it — if you purchase this dashboard, it will be extremely useful for you.

To export the data from the ads platforms I used Windsor.ai connector. Click “Add data” and search for Windsor.ai connector in the search field. You will see various connectors by Windsor.ai, but in this case you need a connector called “Windsor.ai”.

When you click it, you will see a field with Account Selector, but in case you haven’t connected any data sources to Windsor.ai yet, you can do it by the link in the note.

After clicking the link, you have a new tab in your browser open.

In the right panel you have to choose the platform you need to extract data from. In this case we need Facebook and Google Ads and if you wish, other ads platforms. You need to authenticate your accounts or log in, if you have already done it before.

Then in your Looker Studio tab you will see your connected accounts after you refresh the page. Select needed accounts and click “Add”.

After it you can use your data source easily by creating charts with it. It already contains data from both Google Ads and Facebook Ads, so you don’t need to create blended data sources.

Some words about Windsor.ai

First of all, the prices are pretty affordable. There are 4 subscription plans — Free, Basic, Standard and Plus. The cheapest subscription is Basic and it costs only 19$. I think that for most of the cases Basic plan would be enough.

You can buy a monthly or annual subscription plan. Most importantly, they have a 30-day trial absolutely for free. It will give you an opportunity to see whether this add-on helps you reach your working goals. Moreover, using my promo code you will get 10% off any plans — gaillereports

If you want to read more about this connector, I have published several articles about this connector. Here is the article with a general overview of Windsor.ai and here I explain how to add a Windsor.ai connector to Google Sheets.

Reminding you that purchasing Paid Ads​ Template Using Windsor.ai Connector from our template store will save you a plenty of time and efforts!

Hope you enjoyed this article!

--

--

Gala Ivannikova

Data Analysis and BI Visualisation in Looker Studio | Gaille Reports founder | Looker Studio online course