Close



Frequently Asked Questions



Frequently Asked Questions

Clients



Clients

Users



Users

Data Sources



Data Sources

Insights



Insights

Google Search Console



Insight | Google Search Console

Google Business Profile (Formerly Google My Business)



Insight | Google Business Profile

Google Ads



Insight | Google Ads

Google Analytics 4



Insight | Google Analytics

Website



Insight | Website

Facebook Ads



Insight | Facebook Ads

Microsoft Ads



Insight | Microsoft Ads

Automation Jobs



Automation Jobs

Google Search Console



Automation | Google Search Console

Google Business Profile



Automation | Google Business Profile

Google Ads



Automation | Google Ads

Google Analytics 4



Automation | Google Analytics

Website



Automation | Website

Facebook Ads



Automation | Facebook Ads

Microsoft Ads



Automation | Microsoft Ads

KPI Forecasting



KPI Forecasting

Google Analytics 4



KPI Forecasting | Google Analytics

Google Ads



KPI Forecasting | Google Ads

Google Business Profile



KPI Forecasting | Google Business Profile

Facebook Ads



KPI Forecasting | Facebook Ads

Microsoft Ads



KPI Forecasting | Microsoft Ads

Google Sheets



KPI Forecasting | Google Sheets

Budget Tracking



Budget Tracking

Google Sheets



Budget Tracking | Google Sheets

Anomaly Detection



Anomaly Detection

Data Warehouse



Data Warehouse

Google Looker Studio



Data Warehouse | Google Looker Studio

Google BigQuery



Data Warehouse | BigQuery

Google Business Profile (Formerly Google My Business)



Data Warehouse | Google Business Profile

Google Search Console



Data Warehouse | Google Search Console

Facebook Ads



Data Warehouse | Facebook Ads

Social Posts

Social Posts | Google Business Profile

Local Listings



Local Listings

Google Business Profile (Formerly Google My Business)



Local Listings | Google Business Profile

Platforms



Local Listings | Platforms

Media



Local Listings | Media

Categories & Services



Local Listings | Categories & Services

Reviews



Reviews

Settings



Settings

Integrations



Integrations

Google Looker Studio



Integrations | Google Looker Studio

Slack



Integrations | Slack

Zapier



Integrations | Zapier

Make



Integrations | Make

Webhook



Integrations | Webhook

Comments



Comments

Google Looker Studio



Comments | Slack

Extensions



Extensions

Branch Explorer



Extension | Explorer

Recent Updates



Account Settings

Settings

Acknowledging and Resolving Insights

Insights

Add comment from Slack

Comments | Slack

Adding a User

Users

An overview of Local Listings

Local Listings

An overview of Reviews

Reviews

Analysis

Anomalies Bulk Action

Anomaly Detection

Anomaly Algorithm

Anomaly Detection

Integrations | Webhook

Anomaly Detection Insight

Insights

Anomaly Detection Settings

Anomaly Detection

Anomaly Job Common Errors

Anomaly Detection

Attributes

Local Listings

Authentication

Integrations | Make

Auto Resolving

Insights

Automatic Schema Updates

Data Warehouse

Automation Job Common Errors

Automation Jobs

Automation: Facebook Ads Destination URL Checker

Integrations | Webhook

Automation: Google Ads Change History

Integrations | Webhook

Automation: Google Ads Destination URL Checker

Integrations | Webhook

Automation: Google Analytics Change History

Integrations | Webhook

Automation: Google Business Profile Answer

Integrations | Webhook

Automation: Google Business Profile Change History

Integrations | Webhook

Automation: Google Business Profile Pending Updates

Integrations | Webhook

Automation: Google Business Profile Question

Integrations | Webhook

Automation: Google Review

Integrations | Webhook

Automation: Google Review Change History

Integrations | Webhook

Automation: Microsoft Ads Destination URL Checker

Integrations | Webhook

Automation: Page Status Checker

Integrations | Webhook

Automation: Robots.txt Change Detection

Integrations | Webhook

Automation: Search Console Activity

Integrations | Webhook

Automation: Search Console Keyword Movement

Integrations | Webhook

Automations Bulk Action

Automation Jobs

Budget Campaign Dynamic Filter

Budget Tracking

Budget Common Errors

Budget Tracking

Budget Settings

Budget Tracking

Budget Status

Budget Tracking

Budget Tracker Webhook Payload

Integrations | Webhook

Budget Tracking

Budget Tracking

Local Listings

Local Listings | Media

Calendar

Social Posts

Cancel Subscription

Settings

Create a Looker Studio Report for Facebook Ads

‍
‍

To create a Looker Studio report (formerly Google Data Studio) for Google Search Console data we fetch your data daily and store it in Google BigQuery so its always available, fast and you only pay for the properties you choose.

Table of Contents

Create a Pipeline
Set the Pipeline destination
Make a copy of a Template
Create a New BigQuery Data Source
Connect to your Jepto Data Warehouse Pipeline and Copy the Report
Adjust the report for your needs

1. Create a Pipeline

This step is broken into two different parts, the Source (which will be your Facebook Ad Account) and step 2 the Destination, which will be Google BigQuery.

Navigate to the create Pipeline page (https://app.jepto.com/pipelines/create)
Click on the data source selector to open the connection draw
Choose Facebook Ads from the 'Data Source' dropdown
If you haven't already, add your Facebook Account that has access to your Facebook ad account
Select the Facebook ad account that you want to report on.
Note: Each Facebook ad account utilizes 10 Data Warehouse Credit. During the free trial you will have 10 Data Warehouse Credits to utilize, so you can sync 1 Facebook ad account. If you would like more than this you will need to subscribe to a plan and purchase additional credits.
Set the Timezone of the locations to allow for correct data

2. Set the Pipeline destination

Click on the destination selector to open the connection draw
If you don't already have your own Google Cloud Platform Account choose the 'Google BigQuery (Managed)' option.
NOTE: When you select the Managed option we create you a Google Cloud Platform Project and absorb all costs and maintenance.
Add each user/email that you want to grant access to the data, this should be the email address (Google Account) that you will use to create a Looker Studio report. If the email address you need is not in the list, please add it as a user as the list only contains users who have accepted invites.
NOTE: You can edit a Pipeline after creation, so if you need to add another email which isn't already a user you can create the pipeline first.
Choose a data center that is closest to you

3. Make a copy of a Template

FB Looker Studio Template - https://datastudio.google.com/reporting/b320c072-d461-46f4-a536-5167e3dd06de

Make a copy by using the overflow menu (three vertical dots) in the top right corner of the Looker Studio report.`

4. Create a New BigQuery Data Source

As the template uses a Demo Data Source, you will need to create a new Data Source. Select the bottom option of 'Create data source' and then find 'Jepto - Reporting'.

5. Connect to your Jepto Data Warehouse Pipeline and Copy the Report

Select the pipeline that you want to use as a data source. If failing to connect the pipeline, ensure that you have access control to the Google Cloud Platform.

6. Adjust the report for your needs

Once you connect the Big Query table, the report creation process is the same as any other connector you have previously used.

‍

Was this article helpful?



Nice one!

Thanks a lot for your feedback! If you’d like a member of our support team to respond to you, please send a message here



Please try again

Oops! Something went wrong while submitting the form.



Nice one!

Thanks a lot for your feedback! If you’d like a member of our support team to respond to you, please send a message here



Please try again

Oops! Something went wrong while submitting the form.

Help Center

Create a Looker Studio Report for Facebook Ads

1. Create a Pipeline

2. Set the Pipeline destination

3. Make a copy of a Template

4. Create a New BigQuery Data Source

5. Connect to your Jepto Data Warehouse Pipeline and Copy the Report

6. Adjust the report for your needs