Two quick ways to import Facebook Ads data and Facebook Leads to Looker Studio

By Two Minute Reports   •   January 01, 2024   •   10 min read
Two quick ways to import Facebook Ads data and Facebook Leads to Looker Studio

Loved by 4000+ Brands and Agencies across the globe

/images/client/zynga.png
/images/client/cossette.png
/images/client/lupage.png
/images/client/yelp.png
/images/client/kpimedia.png
/images/client/g2.png

How to export Facebook Ads data to Looker Studio in under two minutes?

With Two Minute Reports (TMR), you can build comprehensive Facebook Ads Reports, and automatically pull data from Facebook Ads to Looker Studio; all without a single line of code. 

There are two methods to build your Facebook Ads Looker Studio report using TMR

Method 1 : Connect Facebook Ads to Looker Studio and build a report from scratch

Method 2 : Connect Facebook Ads to Looker Studio using in-built Templates of Two Minute Reports.

Step 0: Getting Started

Logging in - Account_1.png

  • HomeBoth methods start with logging into through the apps portal , or from Home->Two Minute Reports -> Products -> Two Minute Reports for Looker Studio -> Account 

Selecting Team_1.png

  • HomeOnce logged in, you need to select a team to access its dashboard. 
    • HomeIf you work with multiple teams, you need to select the relevant team.  
    • HomeIf you aren’t added to multiple teams, you’ll be redirected to the Connectors Page.   

[NOTE]: Every organization has separate teams with their separate tasks. To ease management workflows, reports, and collaborative projects, Two Minute Reports has the “Teams” feature. This feature allows your organization to create separate groups within the product to enable collaboration.  

  • HomeChoose the relevant data source connector from the connectors page: in this case, click on Facebook Ads.Choosing Connector_1.png

Method 1: Creating a Looker Studio Facebook Ads Report from scratch

Step 1: Adding the Data Source and authorizing through Facebook Ads account 

  • HomeOnce inside the Facebook Ads Connector dashboard, click “Add New” from the Data Sources section to open the “Adding New Data Source” window.Add New_Data Source_1.png
  • HomeName your data source, log into your Facebook Ads account and authorize TMR’s Looker Studio Facebook Ads connector. Naming and Logging in_Add Data Source_1.png
  • HomeWith this step, your Facebook Ads account has been authorised added as one of the data sources.Logging in on FB_Adding Data Source_1.png 

Step 2: Query Configuration

  • HomeNext, we can shift to the “Query Configs” section to start configuring a query to export data from Facebook Ads to Looker Studio.
  • HomeClick “Add New” to open the “Adding New Query Configuration” window.Add Query Config_Query Config_1.png
  • HomeFrom here, select the data source which you’ve already created and click on Next.Next_Query Config_1.png
  • HomeIn the next tab Name the Query, and choose the required Ad Accounts. You can choose 1 or multiple Ad Accounts at the same time.Ad Accounts_Query Config_1.png
  • HomeYou can also modify your data from the Data Options drop-down menu. 
  • HomeOnce you’ve completed configuration, Save to create the Query Config. 

Step 3: Creating the report from the Google Data Studio Dashboard

  • HomeAfter adding data source and query configs, click on the green “Create Report” button to open the “Creating New Data Studio Report” window.Green Button_Query Config_1.png
  • HomeFrom this window, choose the relevant previously created Query Config from the search bar, and click on the Next button.Query Config Select 1_Template_Report.png
  • HomeFrom the next Create Report tab, click on “Create Report from scratch” to open Looker Studio.Report from Scratch_Query Config_1.png
  • HomeOnce Looker Studio opens up, choose the relevant team. Ensure that “Use report template for new reports” is checked. Once done, click on Next to continue.
  • HomeThen, select the relevant Query Config for the data source and click on the Connect button at the top-right corner. This step connects TMR to Looker Studio.Export_Create New Report_1.png
  • HomeThe next window shows all the available Facebook Ads metrics, ready for the report. You can modify the metrics, or click on the Create Report button at the top-right corner.Modify Metrics_Both_Create Report_1.pngCreate Report Final_Create Report_1.png
  • HomeYou’ll then be notified about the addition of new data to the Looker Studio report. Click on Add to Report to authorize the activity. 
  • HomeYou’re now at the Google Data Studio Dashboard, ready to build a report from scratch. All the metrics and dimensions that you might need will be available in the sidebar to add to the report.DAta Studio_New Report.png

To create a table/chart with a particular metric:

  • HomeCreate a table or chart at the desired position.
  • HomeWith the table/chart selected, choose the metrics that you need in your report. Make sure to explore the various categories in the “Metrics” dropdown menu to explore all the metrics available for your report.Unique Post Engagement_Metric_Create New Report_1.png
  • HomeNext, we set the dimensions of the report. Choose the right dimensions to add to your report, under the categories in the “Dimensions” dropdown menu.Month_Dimension_Create New Template_1.png
  • HomeThen, you set the date range: either the preset date ranges, or your custom date range from the sidebar.Date Range_Create Report_1.png

You can repeat the same steps to add the required tables/charts to the new report. 

Method 2: Creating a Facebook Ads Dashboard using templates

Two Minute Reports has a gallery of templates: preset dashboards combining relevant marketing data for specific use cases. Every template is crafted by analysts and marketers for specific purposes. They also reduce the time spent on the report editor, manually creating charts, tables, and graphs. 

Two-Minute Reports Templates

TMR’s templates enable reports to combine the right metrics and dimensions and present them visually within minutes. 

To create a Looker Studio dashboard using templates, follow Steps 1 and 2 from the previous method. 

Step 3: Creating the Looker Studio report

  • HomeAfter adding the data source and configuring the queries, click the green “Create Report” button to open the “Creating New Data Studio Report” window.Green Button_Query Config_1.png
  • HomeFrom this window, choose the relevant previously created Query Config from the search bar, and click on the Next button.Query Config Select 1_Template_Report.png
  • HomeFrom the Create Report tab, you can explore TMR’s templates from the Template Gallery. Once you’ve selected the required template, click on it to open Looker Studio.Choosing Template_Template_1.png
  • HomeOnce Looker Studio opens up, choose the relevant team and check the box next to “Use report template for new reports”. Click on Next to continue.Export_Create New Report_1.png
  • HomeThen, select the relevant Query Config for the data source and click on the Connect button at the top-right corner. This step connects TMR to Looker Studio. 
  • HomeThe next window shows all the available Facebook Ads metrics, ready for the report. You can modify the metrics, or click on the Create Report button at the top-right corner.Modify Metrics_Both_Create Report_1.pngCreate Report Final_Create Report_1.png
  • HomeNext, authorize the data export activity and complete creating the report with preset tables and charts with your metrics.Data Studio_Template.png
  • HomeSet a date range from the dashboard to display the relevant data. You can choose from some of the preset date ranges like “Last 7 days” or “Last Month”, or set your custom date range from the drop-down calendars.Date Range_Template_1.png

And like that, you’ve created your Facebook Ads report on Looker Studio. You can modify the tables/charts, metrics, and dimensions from the TMR Sidebar , and schedule reports to your email to collect data and make timely optimisations.

Start using these quick templates for google sheets Now

1. Facebook Ads vs Google Ads vs LinkedIn Ads

This is a multi data source dashboard, which gets all the main KPI's of Facebook Ads, Google Ads and LinkedIn Ads. You get a collection of scorecards like Amount Spent, Conversions, Impressions, Clicks and Cost per conversion for all 3 data source. A dedicated table chart which compares Cost and Impressions of all 3 data source. You get an impressions Graph and a geo chart for clicks over the word. Do check out the template to get a better perspective of it.

2. Facebook Ads overall Performance

This is a fully loaded Facebook Ads Template which can get you almost all the KPI's a marketer would need to view and analyze. We have Campaign and Ad Analysis with Images, which makes your work much simpler. Comparison graphs are created for Account performance and other KPI's like Conversions, Cost per Conversions, Impressions, Amount Spent etc.. Do check the preview of the Template to get a better perspective.

Why connect Facebook Ads to Looker Studio?

Google Looker Studio (formerly Google Data Studio) is a popular, open-source, tool for report creation and data analysis. The interactive dashboards and the easy-to-use interface enable business owners, analysts, and marketers to stay ahead of multiple sources. 

Ease of Use: 

Looker Studio’s user-friendly interface requires minimal technical expertise. With just a few drags and drops, this coding-free tool helps make complex data manipulation and visualization simpler. 

Data Connectivity: 

With a connector like Two Minute Reports, one can integrate over 75 popular platforms, right from web analytics, to social media platforms. Creating a Looker Studio dashboard with TMR eliminates manual data imports and ensures that your data is up-to-date. 

Visualization Variety:

With Looker Studio’s robust array of graphs, charts and other visual aides, you can effectively communicate and visualize data for all functions. You can create bar charts, line graphs, pie charts, maps, and much more to match your preferences. 

Comprehensive Analysis:

Insightful Metrics and Collaborative Accessibility are key benefits when using Looker Studio to manage your website/app’s performance. You can dissect and analyze data, compare them, and create custom metrics that align with your business goals. 

Collaborative Access:

Building a Looker Studio Dashboard also allows for seamless collaboration between functions in your organization. The ease of accessibility allows teams to work together with real-time data, fostering a highly collaborative environment. 

Customization and Flexibility:

Importing Facebook Ads data into Looker Studio allows you to customize your reports according to your specific needs. Looker Studio also enables proper representation of the metrics and dimensions that are most relevant to your business goals. Looker Studio also allows scheduling reports to be delivered to your email automatically. This ensures constant real-time data, and avoids frequent check-ins. 

Workflow Efficiency:

Setting up automated workflows to channel data from Facebook Ads to Looker Studio, effectively streamlines the data journey from source to analysis. This process ensures seamless synchronization enabling consistent workflow management.

Marketing Strategy Enhancement:

When you export Facebook Ads data into Looker Studio, you can conduct multi-channel analyses to simultaneously evaluate performance across multiple channels. This approach enables you to make data-driven decisions that enhance marketing performance.

The top Facebook Ads data to export: Facebook Ads to Looker Studio

To ensure the most ROI from your Facebook Ad campaigns, it’s absolutely necessary to incorporate a strong strategy- strategy which arises from data, and market trends. Embrace this powerful synergy between Facebook Ads and Google Looker Studio to make data-driven decisions that propel your marketing strategy to new heights!

Below are the top metrics that could determine the success of your marketing efforts! 

Cost

When managing Facebook Ads, it's crucial to focus on various cost metrics. Keep a close eye on your ad spend, ensuring efficiency by monitoring metrics like:

  • HomeCPM and CPC (Cost per Click) for all link clicks.
  • HomeCPP (Cost per Purchase)
  • HomeCost for Unique Link Clicks. 
  • HomeCost per Conversion
  • HomeCost per Action

Performance

Elevate your Facebook Ads performance analysis by tracking key metrics like: 

  • HomeImpressions
  • HomeReach
  • HomeClicks
  • HomeConversions and Conversion Values
  • HomeActions
  • HomeQuality Ranking (relevance and effectiveness of ads)

You can also assess the ROI from your ads by evaluating the Purchase ROAS (Return on Ad Spend). 

Clicks (More)

Gain a deeper understanding of ad engagement through Facebook's Clicks metrics like: 

  • HomeLink clicks 
  • HomeUnique Clicks
  • HomeCTR (Click-through Rate)
  • HomeOutbound Clicks

Action / Engagement

These metrics to track actions and engagement on your content, to gain insights on your page’s social media performance, product pages effectiveness, and overall marketing strategy. 

  • HomeFB Lead Ads Data
  • HomeComments
  • HomeShares
  • HomeReactions
  • HomeAdded-to-Cart
  • HomeCheckouts Initiated

Website Conversions (Facebook Pixel)

Utilize Facebook Pixel to track key website conversion metrics to gain a deeper understanding of campaign effectiveness and to improve operations. Track metrics like: 

  • HomeLanding Page Views
  • HomeWebsite Purchases
  • HomeLeads
  • HomeAdd to Cart
  • HomeCheckouts Initiated
  • HomeCompleted Registrations

TMR also allows you to monitor Website Purchase ROAS to understand the value generated by your ads. 

Campaign Details

Use these Facebook Ads Data points to explore campaign specifics, to craft comprehensive reports. With the following metrics, you can track and optimize your budget and reach your target audience effectively. 

  • HomeName
  • HomeObjective
  • HomeID
  • HomeStatus
  • HomeBudget Details (Daily/Lifetime)
  • HomeStart/End Dates

Action / Engagement Cost

Evaluate how efficient your Ad Spends and refine your campaigns using the following metrics: 

  • HomeCost Per Lead
  • HomeAdd to Carts
  • HomeCheckout (across various channels)
  • HomeCost implications of 
    • HomeLink Clicks
    • HomePost Engagements
    • HomeRegistrations

Instagram Ads

Incorporate Instagram Ads data into your analysis for a holistic view of your social media advertising efforts. Assess the cost-effectiveness of

  • HomeLeads
  • HomePurchases
  • HomeKey actions across Instagram and other platforms

Facebook Leads

Maximize lead generation, optimize ad spend, and enhance targeting strategies by adding the following metrics to your Looker Studio integration: 

  • HomeLead Source
  • HomeDemographics
  • HomeInterests

With these metrics, you can also adjust

  • HomeCampaign Settings
  • HomeCreative elements
  • HomeFollow-up strategies

This Looker Studio - Facebook Ads integration doesn’t just streamline data analysis; a strong report-making connector ensures that every Facebook Advertising aspect is meticulously monitored and optimized. 

Get Google Analytics 4 data in Google Sheets too!

tmr_gds.png

Two Minute Reports is also available as a Google Sheets add-on. This add-on is designed to simplify complex data analysis and visualization, making the best use of Google Sheets’ tools and features.

This add-on allows the creation of detailed reports and dashboards using insights from Facebook Ads without the complexity of manual data entry. TMR for Google Sheets also enables users to develop custom formulae in a user-friendly interface. 

With a seamless Facebook Ads to Looker Studio integration, comprehensive analytical capabilities, and automated workflows, strategic business intelligence has just become quicker and more accessible.

Connect other Platform Data Sources with Google Sheets

Google Ads

Google Ads

Advertising platform for displaying ads on Google's search results pages.

Linkedin Ads

Linkedin Ads

Professional social media platform's advertising data source.

Snapchat Ads

Snapchat Ads

Social media advertising platform for Snapchat users.

Tiktok Ads

Tiktok Ads

Advertisement data on the TikTok social media platform.

FAQs

What are data sources?

The Data source of a report is where you grab data for analysis, comparison, and decision-making. Determining and adding a data source is the first step for report creation.  
 

What are Dimensions?

Dimensions are additional attributes of your website which provide information about it. For example, the “Date” dimension tells the date a visitor visited your website. 
 

How do I connect Facebook Ads to Looker studio?

You can use connectors like Two Minute Reports to create reports, visualize data, and compare data from other platforms.

What data to pull from Facebook ads?

The best data to pull from Facebook Ads varies to your business needs and types. Ensure that your data informs you about your user’s behaviors, your website/app’s performance and User Experience. 

What are “Teams” in Two Minute Reports?

To ensure the management of workflows, reports, and collaborative projects within an organization, Two Minute Reports has the “Teams” Feature. This feature allows your organization to create separate groups within the product to enable collaboration.  
 

What is Two Minute Reports?

It is a connector for Looker Studio, which helps you integrate data from sources like Facebook Ads or Google Analytics to Looker studio, create reports, and analyze data effectively and seamlessly.
 

How to create custom Looker Studio Reports?

Make use of Looker Studio’s robust tools and features to create custom reports. You can also use connectors like Two Minute Reports to utilize their function-based templates.