Connect Facebook Ads to Google Data Studio with Windsor.ai

facebook logo 1

+

data studio

Finally, all your marketing data from Facebook Ads available in Google Data Studio

About Facebook Ads

Facebook Ads is a social media advertising platform which allows businesses and individuals to advertise to their target audiences on Facebooks social media platform.

About Google Data Studio

Google Data Studio helps you visualise your data in customisable reports and dashboards. Connect your analytics, media or raw data and start creating dashboards.

Connecting Facebook Ads to Google Data Studio

If you want to build your own data studio report from scratch, keep reading the below description. Or else, if you already know the basics of google data studio, you can copy our Facebook ads dashboard template and save both your time and effort.

Google data studio is the best free tool available in the market to help marketers built and share their dashboards. But the only drawback is, it allows the user to connect to Google’s platforms only like Google Analytics, Google Ads, and google my business.

Hence, it’s a problem for those marketers who depends on different platforms to collect data like Facebook ads, Snapchat, outbrain, LinkedIn ads, Taboola, Twitter ads, Microsoft advertising, etc.
Out of the different social media platforms,

Facebook ads is one of the most popular platforms. Windsor.ai gives you a stepwise tutorial on how to create a Facebook ads overview dashboard using the Windsor.ai connector.

Reasons to build this report

Before knowing the ways of creating a Facebook ads overview dashboard, let’s first discuss the need for building the same.

    • It offers a quick health check to your Facebook ads account
    • You can monitor both your client’s and your own KPI’s quite easily
    • It gives you an overview of the performance of your Facebook ad campaigns
    • When you can easily access all your relevant business data 24/7, you can know audience fatigue, twist campaigns as and when required, identify your best future target audience.
    • The best part is that you can share the dashboard with anyone as it’s perfect for teamwork.

Already learned a lot through theory, let’s start with the real steps to create the Facebook ads dashboard.

Steps to add Facebook ads as a data source to your dashboard

Soon after opening a new document in data studio, drift to the bottom right corner of the page and click “click new data source” to add the data from your Facebook ads into the report.


Step 1: Link to your Facebook Ads accounts.

Search and click on “Facebook Ads by Windsor.ai” from the connector gallery.
Next, click the “authorize” button to authorize the connector. Once you have connected with your multiple Facebook accounts, select the account you want to extract data from; you get other additional options like reporting time zone and conversion window if you desire to adjust them. Once you are satisfied with all your selections, click on the connect button at the top right corner.

Step 2: Fields editing and custom metrics creation

Next, you will come across an entire list of available dimensions and metrics. Here, at this step, you get the chance to make your calculated fields and retitle metrics. Once you are satisfied and happy with the metrics you made, click “Add to report”.
Further, you can at any time check the data sources connected to your dashboard simply by clicking on the “resource” button located at the top of the dashboard and then choosing “manage data sources”.
Once you have completed all the above steps, your Facebook ads accounts get linked to the dashboard. And you can immediately start visualizing your data.

Step 3: Report outlining, adding key metrics and its trend line

At the first step of outlining your report, name your dashboard with the help of a text widget. You can further adjust the font, font color, and size just at the immediate right-hand menu when your text box is still selected.

Step 4: Add date

Add a date filter for the dashboard for a quick evaluation. Just click on the date tool located at the top and then select the date range that you want to see as default as soon as you open the dashboard. In the same way, you can also modify the colors and fonts on the right-hand menu.

Step 5: Visually break it up into different units

Look at the top of the dashboard to find a rectangle widget. Using it, add a colored line to break up units. You may also add text to the divider to highlight the upcoming section name.

Step 6: Specify the metrics

Now select the metrics that specify the overall health of the account. These metrics are typically clicking, ROAS, conversions, impressions, CPC, amount spent. Remember that these metrics vary depending upon the type of your business and ad campaigns.

If you further want to make the scorecard metrics more visible, you may simply add a colored background with the help of the Rectangle tool.
Once you are done and you are satisfied with the content and designs, click on “add a chart” and select “scorecard with compact numbers” from the dropdown list. On the first rectangle, keep the scorecard. And from the right-hand menu’s “data” tab, change the metric. You may even change the size, color, and font in the “style” section.

Step 7: Add metrics to different scorecards

Copy and paste the created scorecard and add different metrics to every copied scorecard.

Step 8: Set up time series graphs

Create time series graphs to display the development of the metrics over time. For doing it, go to the “add chart” section and select the time-series graph type. You may add one more metric to the chart simply by heading over to the right and clicking the button, add metric.

Copy and paste the time series graph and then add multiple metrics to the graph.

Check out how it works with a free trial.

Templates for Facebook Ads and Google Data Studio

Windsor.ai: Connecting all marketing data

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Start a free trial today.

Integrate all your data and measure what matters.