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

I. Create Report by Copying Looker Template

Make a copy of a Template
Create a New BigQuery Data Source
Select the BigQuery Table and check the date range box
Adjust the report for your needs

II. Create Report by using Linking API

Choose a pipeline then click "Create Data Studio Report"
Edit default Looker Studio Report
How to find Report ID
How to find Data Source Alias

‍

I. Create Report by using a template

The Linking API provides a reliable interface to configure and forward users directly to a Looker Studio report via a URL. When users follow a Linking API URL they will have a streamlined experience to quickly view and interact with their data.

‍

1. Choose a pipeline then click "Create Data Studio Report"

Clicking "Create Data Studio Report" will already help you to create a Linking API depends on your pipeline configuration and data warehouse settings.

‍

I. 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 Data 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 and check the date range box

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 Data Studio. Ticking the date range box allows Data Studio to communicate with BigQuery to ensure that data is fetched as quickly and efficiently as possible.

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

‍

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 Data Studio Report

Table of Contents

I. Create Report by Copying Looker Template

II. Create Report by using Linking API

I. Create Report by using a template

1. Choose a pipeline then click "Create Data Studio Report"

I. 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 and check the date range box

4. Adjust the report for your needs