This Looker Studio agency dashboard was created for a who needed to combine data for several clients inside a single dashboard and be able to filter all data by client. The dashboard was used for client reporting during weekly meetings
Data Source
Facebook Ads
Analysis Tool
Google Data Studio
When you go from managing one Facebook Ads account to multiple, it becomes a lot harder to view all of your data in one place. A common solution is to create a Looker Studio agency dashboard to automatically extract and combine all the data in one place.
Managing campaign budgets becomes even more difficult when several people are involved into running the ads. Having the data from all the media buyers in a single Looker Studio agency dashboard helps to track performance of the whole team and translates into better management.
Finally, marketing agencies have a need to report on their activity to their clients on a regular basis. Looker Studio is ideal for this job because it is a free tool and requires no licensing to share data with your clients. By creating a Looker Studio agency dashboard you can share real-time updates on your PPC activity to your clients.
The data was extracted using the Vidi Corp Facebook Ads connector. The authentication process works in the following way
This way when a new client opens access to this email, the data for the new client is added automatically.
The first Looker Studio dashboard page shows an agency-level overview of the Facebook Ads activity. The client filter at the top can be used to view the data for a specific client or for all the clients together.
High-level metrics are shown for the selected client including ad spent, revenue, ROAS, impressions, cost per purchase and etc.
Trend charts are shown below for CPM for last 7 days and last 30 days.
Similar 7 day and 30 day trends are also important for the Looker Studio agency dashboard including the number of clicks, impressions, ad spent, ROAS, number of purchases and revenue.
For example you can see that in the last 2 days the gap between the clicks and impressions increased significantly indicating problems with click-through-rate. One of the goals from there is to narrow this gap.
You can also see that revenue spiked on 20th of June whereas the purchases didn’t increase by all that much. This indicates that the clients bought more expensive products on 20th of June. The agency management can review the offers that were advertised on this day and decide to continue with these offers.
Each metric on the Looker Studio agency dashboard is broken down by month and shown for all the months this year.
You can see that the number of overall impressions per month decreased throughout the year whereas the number of clicks increased which highlights improvements in CTR.
At the same time ROAS has been decreasing throughout the year which is a cause of concern and perhaps requires management attention.
In is also important for agencies to analyse the performance by campaign, adset and ad on their Looker Studio Dashboard. This part of the dashboard helps to identify which campaigns have high CTR/ROAS, which ones need to be optimised or discontinued.
Finally, it is important for a Looker Studio agency dashboard to break down the performance by age, gender and location. Number of clicks is analysed by state, age group and device to better understand the demographics of target audience.
For example, you can see on this page that most users that click on an ad do this via a mobile phone. You can also see that the company primarily targets 25-45 year olds with their ads.
Our consultants have created Looker Studio agency dashboards for the industry leaders including TubeScience and NP Digital (owned by Neil Patel).
We have also created a series Looker Studio dashboards for Google which highlights our level of technological know-how.
We would love to help you build your Looker Studio agency dashboard! Simply reach out to us now!
Support
All the support you need – when you need it. From 1-hour quick fix support to longer-term partnership that drives your business forward.
Consultancy
Advanced data thinking, creative ideas and the best Power Platform practices to unlock the true potential of your business data.
Training
Succeess shouldn’t be a one-off. When we train you teams user adoption surges and your Power Platform results radically improve.
