Close



Frequently Asked Questions



Frequently Asked Questions

Clients



Clients

Users



Users

Insights



Insights

Insight | Google Search Console

Google Search Console

Insight | Google Business Profile

Google Business Profile

Insight | Google Ads

Google Ads

Insight | Google Analytics

Google Analytics

Insight | Website

Website

Insight | Facebook Ads

Facebook Ads

Insight | Microsoft Ads

Microsoft Ads

Automation Jobs



Automation Jobs

Automation | Google Search Console

Google Search Console

Automation | Google Business Profile

Google Business Profile

Automation | Google Ads

Google Ads

Automation | Google Analytics

Google Analytics

Automation | Website

Website

Automation | Facebook Ads

Facebook Ads

Automation | Microsoft Ads

Microsoft Ads

KPI Management



KPI Management

KPI Management | Google Analytics

Google Analytics

KPI Management | Google Ads

Google Ads

KPI Management | Google Business Profile

Google Business Profile

KPI Management | Facebook Ads

Facebook Ads

KPI Management | Microsoft Ads

Microsoft Ads

KPI Management | Google Sheets

Google Sheets

Budget Tracking



Budget Tracking

Budget Tracking | Google Sheets

Google Sheets

Anomaly Detection



Anomaly Detection

Data Warehouse



Data Warehouse

Data Warehouse | Google Looker Studio

Google Looker Studio

Data Warehouse | BigQuery

Google BigQuery

Data Warehouse | Google Business Profile

Google Business Profile (Formerly Google My Business)

Data Warehouse | Google Search Console

Google Search Console

Data Warehouse | Facebook Ads

Facebook Ads

Local Listings



Local Listings

Reviews



Reviews

Settings



Settings

Integrations



Integrations

Integrations | Google Looker Studio

Google Looker Studio

Integrations | Slack

Slack

Integrations | Zapier

Zapier

Integrations | Make

Make

Integrations | Webhook

Webhook

Comments



Comments

Comments | Slack

Slack

Extensions



Extension

Extension | Explorer

Branch 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 Tracking

Budget Tracking

Budget Tracking

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