Home SEO How To Construct A Fb Advertisements Dashboard In Google Knowledge Studio

How To Construct A Fb Advertisements Dashboard In Google Knowledge Studio


Fb Advertisements are an essential a part of many companies’ digital advertising and marketing methods.

Whether or not the target is to construct consciousness or generate gross sales and income, measuring and reporting on marketing campaign efficacy may be difficult.

It’s possible you’ll surprise, are my Fb Advertisements working? Or ought to I make investments my advertising and marketing funds elsewhere?

The Fb Advertisements platform means that you can create reviews with knowledge sliced and diced in many various methods, offering nice insights into the adverts’ efficiency.

Nevertheless, Fb Advertisements reporting may be overwhelming and complicated.

Even a easy dashboard will help you increase the bar and elevate your reporting to a brand new degree.

On this column, you’ll discover ways to just do that utilizing a Google Knowledge Studio dashboard to your Fb Advertisements efficiency reporting.

Why You Want A Fb Advertisements Dashboard

There isn’t any lack of reporting options on the market, however Google Knowledge Studio, in our opinion, tops the record.

It’s straightforward to make use of, quick, and most significantly, it’s free.

There are additionally a number of further advantages, beginning together with your potential to natively import knowledge from Google Analytics.

Which means you possibly can measure the effectiveness of your Fb campaigns and evaluate how they do in opposition to the efficiency of different channels.

Moreover, a dashboard lets you simply manipulate the information and current it in a number of reviews or charts.

However that’s not all. From the consumer perspective, dashboards are a lot simpler to handle than reviews when analyzing and evaluating knowledge units and/or date ranges.

How To Get Began With Google Knowledge Studio And Fb Advertisements

Whereas Google Knowledge Studio is a tremendous device within the digital marketer’s arsenal, integrating Fb Advertisements knowledge requires just a few further steps in comparison with Google’s native platforms reminiscent of Google Advertisements, Google Analytics, and so on.

Concern not. Numerous guide and automatic options permit you to import the information from Fb Advertisements into Knowledge Studio.

Whichever you select, it’s best to nonetheless have the ability to obtain a good looking and worthwhile dashboard for you and what you are promoting.

Importing The Knowledge Manually

Let’s begin with a guide import of the information.

1. Exporting The Knowledge

The simplest option to get this underway is to create a downloadable report in Fb Advertisements.

Remember that if you wish to measure the success of your adverts by platform (i.e., Fb, Instagram, and so on.) and/or placement (Instagram Tales, Feed, Proper Hand Column, and so on.) you won’t be able to see metrics reminiscent of Purchases, Purchases Conversion Worth, or Price per buy.

That degree of information is just not accessible on the (Fb Advertisements) platform, so it is usually not accessible by means of the information irrespective of the way you pull it, whether or not by way of the API, a connector, or manually downloaded as in our case.

Conversion knowledge is barely accessible on the high degree.

If you wish to see how your adverts carry out and measure their ROI (return on funding) or ROAS (return on advert spend), you will have to obtain the information damaged down by Marketing campaign, Advert Set, and/or time – solely.

You’ll be able to nonetheless create and obtain a further report that breaks the information down by supply and, due to this fact, Platform and Placement.

Nevertheless, that may solely present you efficiency metrics reminiscent of Impressions, Attain, Clicks, CPC (cost-per-click), CPM (cost-per-thousand impressions), and so on.

There’s nonetheless an important case for utilizing this knowledge to judge and perceive the efficiency of our adverts throughout every platform and placement, and to make use of these classes to optimize the marketing campaign supply.

Step 1: Head to Advertisements reporting and create a brand new report.

creating a new report in FB ads reportingScreenshot from Fb Advertisements Supervisor, June 2022

Step 2: Select the metrics and dimensions to your report.

choosing dimensionsScreenshot from Fb Advertisements Supervisor, June 2022

Right here, it’s essential that you’ve the ultimate end result in thoughts and what knowledge you’ll require for the dashboard.

Step 3: Schedule the report.

scheduling reportsScreenshot from Fb Advertisements Supervisor, June 2022

That is elective, however getting the reviews despatched to your inbox as a substitute of downloading them each single time will make your life a lot simpler!

Step 4: You would possibly want to control the information.

data manipulationScreenshot from writer, June 2022

Aligning the information downloaded from Fb Advertisements would possibly require some small adjustments.

In our instance above, we modified the date column to make sure that Google Knowledge Studio would acknowledge it.

2. Importing The Knowledge

When you obtain the information in a CSV or Excel format, you possibly can import it into Google Sheets.

Step 5: From Excel to Google Sheets.

importing Google Sheets fileScreenshot from Google Sheets, June 2022

If in case you have scheduled the report back to be emailed recurrently, whether or not every day, weekly, or month-to-month, you possibly can automate a few of the steps above.

Options like Zapier permit you to arrange auto-imports of the information from the e-mail attachment instantly into Google Sheets.

Since this may be completely different from setup to setup, we received’t cowl that course of on this information. Nevertheless, a fast Google search ought to assist.

After you import the information, join the sheet to Knowledge Studio as an information supply.

Step 6: Add the information.

adding dataScreenshot from Google Knowledge Studio, June 2022

You’ll solely want to attach the Google Sheet to the Knowledge Studio Dashboard as soon as.

As soon as linked, any adjustments to the information within the sheet shall be mirrored within the dashboard.

When including knowledge to Knowledge Studio from a CSV or Google Sheets, word some actually essential issues.

Deal with metrics reminiscent of attain and frequency and calculated metrics reminiscent of CPC, CPM, and so on., rigorously when combining and aggregating the information.

Extra on that in a couple of minutes. Within the meantime, we will begin designing and constructing our dashboard.

Designing And Constructing The Dashboard

Step 7: Begin including some design and have components.

Google Data StudioScreenshot from Google Knowledge Studio, June 2022

We added a emblem and date vary management in our instance and made them “report-level.”

That signifies that these components shall be copied throughout the entire pages of our dashboard, which may be very helpful!

From right here on, the choices are infinite.

Step 8: Change theme, add the information with scorecards and tables, visualize it with charts, and extra.

Facebook ads dashboard on Google Data StudioScreenshot from Google Knowledge Studio, June 2022

We began with just a few scorecards to point out top-line efficiency and KPIs in our instance.

top-line performance and KPIsScreenshot from Google Knowledge Studio, June 2022

You can too add free textual content to incorporate commentary, insights, and suggestions.

Step 9: Add further options to your dashboard.

add additional featuresScreenshot from Google Knowledge Studio, June 2022

Now you can customise your pages and the way you entry the information with filters, segments, sliders, drop-down lists, and extra.

Going again to our instance, the screenshot above exhibits how utilizing drop-down lists makes it attainable to zoom into subsets of information.

Right here, we will select to phase it by platform (i.e., Instagram, Fb, and so on.).

Rinse And Repeat

And there you could have it – the fundamental steps to create a Knowledge Studio dashboard to your Fb Advertisements.

It’s that straightforward.

You’ll be able to add new knowledge sources, deliver further datasets into the report, and create much more granular and superior reviews inside your dashboards.

Metrics Such As Attain And Frequency

As talked about above, some metrics have to be managed rigorously.

For instance, if we have now a report that features the frequency of the adverts damaged down by week, neither the sum nor common of these values gives you the correct quantity as it could be reported on the Fb Advertisements platform or reviews.

I recommend downloading and including the information for the interval you wish to report on and including it as a separate sheet (or tab if included within the current report).

Calculated Metrics

For values like common click-through-rate, CPC,  CPM, and even ROI (return on funding) and ROAS, I recommend including these as metrics calculated inside Knowledge Studio.

Doing so is easy.

Within the metrics, choose Add Metric, Create Subject, and there you possibly can construct your values.

Word that this isn’t restricted to simply these easy metrics, however you may also create and add your personal metrics.

Platform placement performanceScreenshot from Google Knowledge Studio, June 2022

As an example, you could possibly add values reminiscent of Gross Revenue Margin or different monetary metrics that permit you to higher perceive how what you are promoting is performing in relation to the Fb promoting, and straight from inside the dashboard!

Connectors And Automation

It’s straightforward and fast to create an built-in resolution that depends on manually downloading the information or organising a workflow that makes use of instruments like Zapier.

Nevertheless, there are additionally extra superior choices.

These are significantly helpful for businesses and large-scale companies that want to attenuate guide duties and favor full automation for reliability (i.e., lowering the margin of error) and velocity, particularly when working with giant datasets.

For this goal, our firm makes use of Dataslayer (although there are others, too), a reporting device that gives a strong and easy-to-use Google Sheets connector.

The profit is which you could create and save queries in your sheet with the connector and, as soon as they’re set, can mechanically pull the information and refresh it recurrently.

So, for instance, we might set the question to obtain the information each Monday for the earlier seven days and due to this fact have the Knowledge Studio dashboard mechanically refreshed and up to date each week – with out having to raise a finger.

Remaining Concerns

As we have now seen, making a helpful dashboard requires a little bit of planning and work to arrange.

However the great thing about it’s that dashboards (as a set of reviews and charts) are extraordinarily highly effective and versatile by nature.

Don’t be afraid to begin with a easy model and preserve creating a number of iterations of it with completely different views, tables, charts, and extra.

The time and efforts invested shall be greater than price it!

Extra sources:

Featured Picture: Griboedov/Shutterstock



Please enter your comment!
Please enter your name here