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

Creating a Looker Studio Report

‍
‍

To make it easier to get started, we have templates for both Google Business Profile (Formerly Google My Business), Facebook Ads and Google Search Console.

NOTE: These instructions assume that you have already created a Pipeline, if you haven't please create your pipeline first.

Table of Contents

I. Create Report with a template

Choose a pipeline

II. Copy an existing Looker Report

Make a copy of a Report
Create a New BigQuery Data Source
Select the BigQuery Table
Adjust the report for your needs

I. Create Report by using a template

The Looker Studio Linking API provides a reliable way to configure a report via a URL. When you click on the link within the dashboard, we dynamically create the URL so that you can go straight to creating your report. This flexibility also allows you to set your own report as a template.

1. Choose a pipeline

Select a Pipeline and open the detailed view by clicking on the 'VIEW' text. On the detail drawer, click on the "Create Looker Studio Report" link which will automatically open a new tab with our default template and your data warehouse settings pre-configured.

‍

II. Create Report by Copying Looker Template

1. Make a copy of a Template

Google Search Console Template - https://datastudio.google.com/reporting/2b7c6276-e627-4940-a2d7-8430958bdcbb
Google Business Profile Template - https://datastudio.google.com/reporting/3006aaf4-50bb-4d1e-967c-560de2e9516a
Facebook Template - https://datastudio.google.com/reporting/b320c072-d461-46f4-a536-5167e3dd06de

Open one of the above links and then make a copy by using the overflow menu (three vertical dots) in the top right corner of the Looker Studio report.

2. 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 select BigQuery.

‍

3. Select the BigQuery Table

Select the 'My Projects' option and you should see a Project with the same name as your Jepto Account. If you don't see this, ensure that you have granted access to the Google Account that you are using in Looker Studio.

Ticking the date range box allows Looker Studio to communicate with BigQuery to ensure that data is fetched as quickly and efficiently as possible, which should be pre-selected for you.

Multiple Pipelines

Each Pipeline will create a new Dataset with a unique ID which is difficult to determine when creating a new Data Source in Looker Studio. Therefore to get the ID, navigate to the pipelines page and then click on 'View'. Then underneath the graph expand the 'More Details' section to reveal the Dataset Name.

Click on View to see more details about the Pipeline

Copy the Dataset Name if you need to create a Data Source for a specific Pipeline

4. 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.

If you need any help with customising your report please reach out to our support team who are happy to provide free customisations.

‍

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

Creating a Looker Studio Report

I. Create Report by using a template

1. Choose a pipeline

II. Create Report by Copying Looker Template

1. Make a copy of a Template

2. Create a New BigQuery Data Source

3. Select the BigQuery Table

4. Adjust the report for your needs