Facebook Ads Looker Studio Template

Facebook Ads Looker Studio template was used for  a digital marketing agency, who happens to also be a Facebook marketing partner. They needed to set up automated dashboard to analyse performance of the their PPC and email efforts for every client.

Data Source

Facebook Ads, Klaviyo, Google Analytics

Analysis Tool

Google Data Studio Google Data Studio

Facebook Ads 

This page analyses stages of the funnel and how much it costs to buy one conversion to each stage.

Firstly, key monetary metrics like ad spent, revenue and ROAS are shown as standalone numbers as well as daily trends.

Secondly, Impressions, clicks and CTR analysed to see how many impressions usually result in a click to the website. Percentage of impressions that result in a click and percentage of clicks that result in conversion is also analysed.

Thirdly, cost per landing page view, add to cart and initiate checkout is analysed and trend charts are created to see if the performance gets better or worse over time.

Finally, cost per purchase and average order value is visualised.

FB Ads Looker Studio Template

Facebook Ads – Weekly Performance

The traffic numbers for the purchase funnel are analysed from impression to click on the website link.

Performance by ad placement is analysed e.g. Facebook feed, Instagram story and etc

Clicks by state are analysed to see which states are more interested in a product.

Finally, performance by video ad is analysed.

Facebook Ads Looker Studio Template- weekly performance

Email Marketing

Revenue is analysed by age group, state and device to get a better understanding of customer demographic.

Email campaigns are analysed by revenue and AOV.

Facebook Ads Looker Studio Template -Email Campain

Website Performance

The bottom of the sales funnel is analysed from page view to purchase.

Cost, revenue and cost/revenue ratio are also analysed.

Weekly Performance

Why Use our Facebook Ads Looker Studio Template?

Looker Studio templates for Facebook Ads offer several key advantages:

Shareable reports for team collaboration and client presentations

Easy integration with Facebook Ads accounts

Customizable dashboards for specific reporting needs

Real-time data updates for up-to-date insights

Ways we can help

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.