Facebook Ads Data Studio Template : Free Advertising Report

Data Studio is a great free reporting tool for online marketing. It can also work with Facebook Ads, in addition to Google products, To get the most out of Google Data Studio use third-party data sources like Facebook Ads, Microsoft Bing Ads, LinkedIn Ads, Amazon Ads and more!

Google provides out of the box reports for Google Ads and Google Analytics, Google Webmaster and more. You may have downloaded one of our data studio templates before, if not check out our Google Ads Data Studio Template and Google Analytics Data Studio report template. In this article, we specifically discuss how to use Facebook Ads with Google Data Studio. 

In this article we discuss how our Facebook Ads report template can be applied to different industries and business goals. As Facebook has lots of campaign formats, reporting can vary by the type of campaigns you use. So, there are a few templates that you can mix and match based on your requirements. 

As mentioned Facebook has various campaign objectives which allow you target people at different stages of their purchase funnel – and to align your marketing funnel accordingly. Some of the most popular campaign types include Facebook Website Conversions, Facebook Lead Ads and Facebook Messages, but their are many more which are listed below. 

  1. Awareness is top of the funnel (Cold Traffic)
  2. Consideration is mid-funnel.  (Warm Traffic)
  3. Conversion is bottom of the funnel. (Hot Traffic)

To learn more about campaign objectives, you can read this article:  Types of Facebook Ads Campaign Objectives

Facebook Ads Campaign Objectives Cropped

With different campaign goals, the type of reporting you need for Facebook Ads campaign management varies. Sometimes companies may only be using a few campaign objectives, or others  may use them all. These objectives (campaign types) all have different measurement techniques and optimisation events – so the reporting metrics can vary considerably. For example, Facebook Lead Ads are captured on Facebook, where as leads captured on a website (offsite) are considered Website Conversions. 

When you capture leads on Facebook you use Facebook Lead Ads campaign objective- and when you capture leads on your website, you use Facebook Website Conversions campaign type. Facebook reporting is therefore heavily influenced by the campaign objectives you choose, which are based on your business goals. A few templates have been created to cover the main campaign objectives, and it is easy to copy pages from one template to the other based on your requirements. 

You can add The report also has a page for campaign objectives. You can also use the filter on the menu bar to filter by campaign objective. 

Menu Bar to Filter Page Data

The report consists of several pages with a left-hand navigation menu.  Each page also has a menu bar to filter the data. You can filter each report page by campaign name, campaign objective, placement, ad set, ad (adverts), age and gender. 

The left-hand side has a calendar which can be changed based on the reporting period you want to view. 

Template Types - by Campaign Objective

We have included some example reports below for some of the more frequently used campaign objectives. For example Conversions and Lead Ads.

The first two examples are Website conversions. The first being for e-commerce and the second for lead generation / professional services. The third example is for Facebook Lead Ads

Website Conversions- eCommerce Report

The first report example is for e-commerce companies to measure their marketing campaigns. This includes around 8 images of various pages that make up this report template. 

Overview Report

This overview report contains summary at a glance stats. The charts used include scorecards which provide a comparison of the calendar period selected in the top right corner. As with all pages of the report, you can change the calendar in the top right corner for any date range. A table is also included. It is also possible to include some visuals and make this table smaller. 

Campaigns Report

This report page gives a breakdown of campaigns including key metrics such as spend, revenue and ROAS.

The bottom right corner has an option to scroll through all campaigns within your Facebook Ads account. 

Ad Sets Report

As with campaigns, the ad set report lets you sort the table and hover over the pie charts for more data. 

Adverts Creatives Report

This report lets you view the performance of adverts on Facebook. You can use the menu bar at the top left of the report to filter by campaigns, or campaign objectives. The black area lists the image advert you are using, including ad name and ad ID. 

Pixel Event Report

This report shows you pixel event report such as page view, view content, add to cart, initiate checkout and purchase. The initiate checkout is blank in this case, as it event code is not installed.

Demographics Report

The placements report shows, where your ads are currently running. This could be on Facebook, Instagram, Messenger or even the Audience network which consists of third-party apps and websites. You can breakdown by performance to help decide if you want to run your ads on all of these placements.

Placements/Platforms Report

Placements are where your Facebook Ads are shown. This could include Facebook, Instagram and the Facebook Audience Network. You can select the default automatic Facebook placements, or you can fine tune your own list. 

Summary of Facebook eCommerce report.

This Facebook Google Data Studio report template is designed for conversions of campaign objectives. It focusses on website sales (purchases/sales). Other campaign reports can be used for different campaign objectives, or they can be merged into one large report with many pages. 

Website Conversions- Lead Gen Report

This report template is used for website conversions objective, but to record leads.  It suits professional services companies that record the number of leads. Conversions can be recorded within Facebook by using a Lead Pixel Event, or using a custom conversion (destination URL thank you page). 

Campaigns Report - Website Conversions Objective

This report template is used for website conversions objective, but to record leads.  It suits professional services companies that record the number of leads. Conversions can be recorded within Facebook by using a Lead Pixel Event, or using a custom conversion (destination URL thank you page). 

Campaign Objectives - Website Conversions Objective (Leads)

This report page gives a breakdown of campaigns including key metrics such as spend, revenue and ROAS.

The bottom right corner has an option to scroll through all campaigns within your Facebook Ads account. 

Ad Sets- (Website Conversions Leads Objective)

This report page gives a breakdown of ad sets including key metrics such as spend, revenue and ROAS.

The bottom right corner has an option to scroll through all ad sets within your Facebook Ads account. 

Adverts - (Website Conversions Objective)

This report page gives a breakdown of ad sets including key metrics such as spend, revenue and ROAS.

The bottom right corner has an option to scroll through all ad sets within your Facebook Ads account. 

Demographics - (Website Conversions Objective)

The page of this report gives a breakdown of your prospects and customers.  Y+ou can see the key performance indicator by age, gender, campaign, objective, ad set, creatives, placements.

Facebook Pixel: Conversion Tracking

You can use the Facebook Pixel Conversion Tracking Script to record leads and sales. You can expand upon this basis by tracking every page as a step in your marketing funnel

Placements- (Website Conversions Objective)

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Summary of Website Conversions (Website Leads)

Capturing leads on your website and optimising your campaigns for these is perhaps the most widely used campaign format. It is measurable ROI direct response marketing, and everyone loves seeing ROI!

Lead Ads - Leads Captured on Facebook

This report is for generation Leads on Facebook by using Facebook Lead Ads instead of Website Conversions.

It is still good to install the pixel with the lead event as some conversions still happen on your website from Facebook Ads- even if you are only using Facebook Lead Ads.

Overview - (Leads Ads Objective)

When running one campaigns it is also possible for other conversions types to happen.  For example if you are using Facebook Lead Ads, sometimes you also get website conversions from Facebook Ads (for example a contact us form on your website). Highlighted in the green boxes is the number of Facebook Leads and the cost per lead. Highlighted in the yellow boxes are the number of website leads recorded and the cost per website lead. Only Lead ads are running, so to measure true ROI it is important to also be aware of conversions that are happening on Facebook and off Facebook. In the report below, we have a breakdown of scorecards. Scorecards also show the change as a percentage. The change in the period before whatever is selected in the calendar to view

Campaigns - (Leads Ads Objective)

This is the campaigns report page. It shows campaigns performance metrics by impressions, total spend and cost per lead (on Facebook via Lead Ads). 

Ad Sets - (Leads Ads Objective)

Each campaign contains at least one ad set. This report provides the impressions, spend, and cost per lead by ad set. 

Demographics - (Leads Ads Objective)

The pie charts give a performance breakdown by age and gender by impressions, reach and spend.  The table chart provides a more detailed breakdown of dimensions by age.

Summary

Get our our latest Facebook Ads Template for Google Data Studio. We also have a free webinar if you want to learn more!

Support & Assistance

Our templates are very comprehensive. However, if required, we can also assist with custom report design, at an hourly rate of $70 dollars per hour. (£50 pounds). 

Additionally, if you need help with Facebook Ads Management, we are a specialist Facebook Advertising Agency and here to assist! Click on these links to learn more!

Liam Holmes

Liam Holmes

6 thoughts on “Facebook Ads Data Studio Template : Free Advertising Report”

    1. Hi Alex,

      Facebook does not have its own connector for data studio (at least not yet).
      Having a third party option is required to get your FB data in Data Studio. We cover this on the next page, along with the links to the free templates.

      Best Regards,
      One PPC

  1. Hi, I want to use the template but I get error message. May I get any support? Could you please send me via email or sth?

    Bests,
    Goksu

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top