Jepto

Help Center

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 (Formerly Google My Business)

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

Add comment from Slack

Comments | Slack

Analysis

Analysis

Anomalies Bulk Action

Anomaly Detection

Anomaly Algorithm

Anomaly Detection

Anomaly Detection

Integrations | Webhook

Anomaly Job Common Errors

Anomaly Detection

Attributes

Local Listings

Authentication

Integrations | Make

Automation: Google Review

Integrations | Webhook

Automation: Page Status Checker

Integrations | Webhook

Budget Common Errors

Budget Tracking

Budget Settings

Budget Tracking

Budget Status

Budget Tracking

Budget Tracker Webhook Payload

Integrations | Webhook

Budget history

Budget Tracking

Budgets Bulk Actions

Budget Tracking

Bulk Action

Local Listings

Bulk Upload Images

Local Listings | Media

Calendar

Social Posts

Categories

Local Listings | Categories & Services

Categories Bulk Action

Local Listings | Categories & Services

Category and Service List

Local Listings | Categories & Services

Connecting Zapier

Integrations | Zapier

Connecting to Slack

Integrations | Slack

Cover Photo Guide

Local Listings | Media

Create a Looker Studio Report for Facebook Ads

Data Warehouse | Google Looker Studio

Create a Looker Studio Report for Google Search Console

Data Warehouse | Google Looker Studio

Creating a Looker Studio Report

Data Warehouse | Google Looker Studio

Creating a Pipeline

Data Warehouse

Data Source Metrics

KPI Forecasting | Microsoft Ads

Data Source Metrics

KPI Forecasting | Google Analytics

Data Source Metrics

KPI Forecasting | Facebook Ads

Data Source Metrics

KPI Forecasting | Google Ads

Data Sources

Data Sources

Draft Posts

Social Posts

Edit default Looker Studio Report

Data Warehouse | Google Looker Studio

Editing a Pipeline

Data Warehouse

Error Posts

Social Posts

Facebook Ads Fields

Data Warehouse | Facebook Ads

Facebook Ads KPI

KPI Forecasting | Facebook Ads

Facebook Ads destination URL checker

Automation | Facebook Ads

Fast Reply

Reviews

Getting Started

Frequently Asked Questions

Google Ads change history

Automation | Google Ads

Google Ads destination URL checker

Automation | Google Ads

Google Analytics change history

Automation | Google Analytics

Google Analytics change history Insight

Insight | Google Analytics

Google BigQuery Permissions

Data Warehouse | BigQuery

Google Business Profile Change History

Automation | Google Business Profile

Google Business Profile Change History Insight

Insight | Google Business Profile

Google Business Profile Fields

Data Warehouse | Google Business Profile

Google Business Profile Listing Answers

Automation | Google Business Profile

Google Business Profile Listing Answers Insight

Insight | Google Business Profile

Google Business Profile Listing Questions

Automation | Google Business Profile

Google Business Profile Listing Questions Insight

Insight | Google Business Profile

Google Business Profile Pending Updates

Automation | Google Business Profile

Google Business Profile Pending Updates Insight

Insight | Google Business Profile

Google Business Profile Reporting Timezone

Data Warehouse | Google Business Profile

Google Review Change History

Automation | Google Business Profile

Google Review Change History Insight

Insight | Google Business Profile

Google Reviews

Automation | Google Business Profile

Google Reviews Insight

Insight | Google Business Profile

Google Search Console Fields

Data Warehouse | Google Search Console

Google Sheets for Budgets

Budget Tracking | Google Sheets

Google Sheets format

KPI Forecasting | Google Sheets

Grant access to BigQuery data

Data Warehouse | Google Looker Studio

How to use Regex and Examples

Frequently Asked Questions

Image Categories

Local Listings | Media

KPI Common Errors

KPI Forecasting

KPI Forecasting

Integrations | Webhook

KPI Forecasting

KPI Forecasting

KPI Insight

Insights

KPI Seasonal Trends

KPI Forecasting

KPI Status

KPI Forecasting

KPI Yearly Seasonality

KPI Forecasting

KPI history

KPI Forecasting

KPIs Bulk Actions

KPI Forecasting

Local Profiles

Local Listings

Logo Photo Guide

Local Listings | Media

Looker Studio Parameters

Integrations | Google Looker Studio

Managed BigQuery

Data Warehouse | BigQuery

Management - Looker Studio Connector Fields

Integrations | Google Looker Studio

Media

Local Listings | Media

Media Bulk Actions

Local Listings | Media

Media Description

Local Listings | Media

Media Pacing

Local Listings | Media

Media file requirements

Local Listings | Media

Microsoft Ads destination URL checker

Automation | Microsoft Ads

Opening Hours Display

Local Listings | Google Business Profile

Page status checker

Automation | Website

Performance

Local Listings

Pipeline Extensions

Data Warehouse

Platforms

Local Listings | Platforms

Portfolio

Clients

Post Types

Social Posts | Google Business Profile

Published Posts

Social Posts

Questions and Answers

Local Listings

Refresh data source fields

Data Warehouse | Google Looker Studio

Robots.txt change detection

Automation | Website

Rolling Average

KPI Forecasting

Scheduled Posts

Social Posts

Search Console Activity

Automation | Google Search Console

Search Console Activity Insight

Insight | Google Search Console

Search Console keyword movement

Automation | Google Search Console

Search Console keyword movement Insight

Insight | Google Search Console

Search Keywords

Local Listings

Sending Slack Notifications

Integrations | Slack

Services

Local Listings | Categories & Services

Services Bulk Action

Local Listings | Categories & Services

Social Posts

Social Posts

Submit a Ticket

Frequently Asked Questions

The Funnel-Stage Terms

Extension | Explorer

UTM Tagging

Social Posts

Update Looker Studio Fields

Integrations | Google Looker Studio

Variables

Settings

Visibility

Local Listings

Watchers

Comments

Webhook Logs

Integrations | Webhook

Add comment from Slack

Comments | Slack

Analysis

Analysis

Anomalies Bulk Action

Anomaly Detection

Anomaly Algorithm

Anomaly Detection

Anomaly Detection

Integrations | Webhook

Anomaly Job Common Errors

Anomaly Detection

Attributes

Local Listings

Authentication

Integrations | Make

Automation: Google Review

Integrations | Webhook

Automation: Page Status Checker

Integrations | Webhook

Budget Common Errors

Budget Tracking

Budget Settings

Budget Tracking

Budget Status

Budget Tracking

Budget Tracker Webhook Payload

Integrations | Webhook

Budget history

Budget Tracking

Budgets Bulk Actions

Budget Tracking

Bulk Action

Local Listings

Bulk Upload Images

Local Listings | Media

Calendar

Social Posts

Categories

Local Listings | Categories & Services

Categories Bulk Action

Local Listings | Categories & Services

Category and Service List

Local Listings | Categories & Services

Connecting Zapier

Integrations | Zapier

Connecting to Slack

Integrations | Slack

Cover Photo Guide

Local Listings | Media

Create a Looker Studio Report for Facebook Ads

Data Warehouse | Google Looker Studio

Create a Looker Studio Report for Google Search Console

Data Warehouse | Google Looker Studio

Creating a Looker Studio Report

Data Warehouse | Google Looker Studio

Creating a Pipeline

Data Warehouse

Data Source Metrics

KPI Forecasting | Microsoft Ads

Data Source Metrics

KPI Forecasting | Google Analytics

Data Source Metrics

KPI Forecasting | Facebook Ads

Data Source Metrics

KPI Forecasting | Google Ads

Data Sources

Data Sources

Draft Posts

Social Posts

Edit default Looker Studio Report

Data Warehouse | Google Looker Studio

Editing a Pipeline

Data Warehouse

Error Posts

Social Posts

Facebook Ads Fields

Data Warehouse | Facebook Ads

Facebook Ads KPI

KPI Forecasting | Facebook Ads

Facebook Ads destination URL checker

Automation | Facebook Ads

Fast Reply

Reviews

Getting Started

Frequently Asked Questions

Google Ads change history

Automation | Google Ads

Google Ads destination URL checker

Automation | Google Ads

Google Analytics change history

Automation | Google Analytics

Google Analytics change history Insight

Insight | Google Analytics

Google BigQuery Permissions

Data Warehouse | BigQuery

Google Business Profile Change History

Automation | Google Business Profile

Google Business Profile Change History Insight

Insight | Google Business Profile

Google Business Profile Fields

Data Warehouse | Google Business Profile

Google Business Profile Listing Answers

Automation | Google Business Profile

Google Business Profile Listing Answers Insight

Insight | Google Business Profile

Google Business Profile Listing Questions

Automation | Google Business Profile

Google Business Profile Listing Questions Insight

Insight | Google Business Profile

Google Business Profile Pending Updates

Automation | Google Business Profile

Google Business Profile Pending Updates Insight

Insight | Google Business Profile

Google Business Profile Reporting Timezone

Data Warehouse | Google Business Profile

Google Review Change History

Automation | Google Business Profile

Google Review Change History Insight

Insight | Google Business Profile

Google Reviews

Automation | Google Business Profile

Google Reviews Insight

Insight | Google Business Profile

Google Search Console Fields

Data Warehouse | Google Search Console

Google Sheets for Budgets

Budget Tracking | Google Sheets

Google Sheets format

KPI Forecasting | Google Sheets

Grant access to BigQuery data

Data Warehouse | Google Looker Studio

How to use Regex and Examples

Frequently Asked Questions

Image Categories

Local Listings | Media

KPI Common Errors

KPI Forecasting

KPI Forecasting

Integrations | Webhook

KPI Forecasting

KPI Forecasting

KPI Insight

Insights

KPI Seasonal Trends

KPI Forecasting

KPI Status

KPI Forecasting

KPI Yearly Seasonality

KPI Forecasting

KPI history

KPI Forecasting

KPIs Bulk Actions

KPI Forecasting

Local Profiles

Local Listings

Logo Photo Guide

Local Listings | Media

Looker Studio Parameters

Integrations | Google Looker Studio

Managed BigQuery

Data Warehouse | BigQuery

Management - Looker Studio Connector Fields

Integrations | Google Looker Studio

Media

Local Listings | Media

Media Bulk Actions

Local Listings | Media

Media Description

Local Listings | Media

Media Pacing

Local Listings | Media

Media file requirements

Local Listings | Media

Microsoft Ads destination URL checker

Automation | Microsoft Ads

Opening Hours Display

Local Listings | Google Business Profile

Page status checker

Automation | Website

Performance

Local Listings

Pipeline Extensions

Data Warehouse

Platforms

Local Listings | Platforms

Portfolio

Clients

Post Types

Social Posts | Google Business Profile

Published Posts

Social Posts

Questions and Answers

Local Listings

Refresh data source fields

Data Warehouse | Google Looker Studio

Robots.txt change detection

Automation | Website

Rolling Average

KPI Forecasting

Scheduled Posts

Social Posts

Search Console Activity

Automation | Google Search Console

Search Console Activity Insight

Insight | Google Search Console

Search Console keyword movement

Automation | Google Search Console

Search Console keyword movement Insight

Insight | Google Search Console

Search Keywords

Local Listings

Sending Slack Notifications

Integrations | Slack

Choose article...
Data Warehouse | Google Looker Studio

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
  1. Choose a pipeline

II. Copy an existing Looker Report
  1. Make a copy of a Report

  2. Create a New BigQuery Data Source

  3. Select the BigQuery Table

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

Create a new data source

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.

Sorry about that. What did you find most unhelpful?
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.