Jepto

Help Center

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

Google Data 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
Settings

Settings

Integrations

Integrations

Integrations | Google Data Studio

Google Data Studio

Integrations | Slack

Slack

Integrations | Zapier

Zapier

Integrations | Make

Make
Comments

Comments

Comments | Slack

Slack
Extensions

Extension

Extension | Explorer

Branch Explorer
Add comment from Slack

Comments | Slack

Analytics - Data Studio Connector Fields

Integrations | Google Data Studio

Anomaly Algorithm

Anomaly Detection

Authentication

Integrations | Make

Budget Settings

Budget Tracking

Budget Status

Budget Tracking

Budget history

Budget Tracking

Connecting Zapier

Integrations | Zapier

Connecting to Slack

Integrations | Slack

Creating a Pipeline

Data Warehouse

Data Source Metrics

KPI Management | Google Ads

Data Source Metrics

KPI Management | Google Analytics

Data Source Metrics

KPI Management | Facebook Ads

Data Source Metrics

KPI Management | Microsoft Ads

Data Source Metrics

KPI Management | Google Business Profile

Data Studio Parameters

Integrations | Google Data Studio

Edit default Looker Studio Report

Data Warehouse | Google Data Studio

Editing a Pipeline

Data Warehouse

Facebook Ads Fields

Data Warehouse | Facebook Ads

Facebook Ads KPI

KPI Management | Facebook Ads

Facebook Ads destination URL checker

Automation | Facebook Ads

Free Connector to Data Warehouse field comparison

Data Warehouse | Google Business Profile

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 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 Location Updates

Automation | Google Business Profile

Google Business Profile Location Updates Insight

Insight | Google Business Profile

Google Business Profile Reporting Timezone

Data Warehouse | 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 Management | Google Sheets

Grant access to BigQuery data

Data Warehouse | Google Data Studio

How to create a Data Studio Report for Facebook

Data Warehouse | Google Data Studio

How to use Regex and Examples

Frequently Asked Questions

KPI Insight

Insights

KPI Seasonal Trends

KPI Management

KPI Status

KPI Management

KPI Target Settings

KPI Management

KPI history

KPI Management

Managed BigQuery

Data Warehouse | BigQuery

Microsoft Ads destination URL checker

Automation | Microsoft Ads

Page status checker

Automation | Website

Pipeline Extensions

Data Warehouse

Portfolio

Clients

Robots.txt change detection

Automation | Website

Rolling Average

KPI Management

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

Sending Slack Notifications

Integrations | Slack

Submit a Ticket

Frequently Asked Questions

The Funnel-Stage Terms

Extension | Explorer

Update Data Studio Fields

Integrations | Google Data Studio

Watchers

Comments

Add comment from Slack

Comments | Slack

Analytics - Data Studio Connector Fields

Integrations | Google Data Studio

Anomaly Algorithm

Anomaly Detection

Authentication

Integrations | Make

Budget Settings

Budget Tracking

Budget Status

Budget Tracking

Budget history

Budget Tracking

Connecting Zapier

Integrations | Zapier

Connecting to Slack

Integrations | Slack

Creating a Pipeline

Data Warehouse

Data Source Metrics

KPI Management | Google Ads

Data Source Metrics

KPI Management | Google Analytics

Data Source Metrics

KPI Management | Facebook Ads

Data Source Metrics

KPI Management | Microsoft Ads

Data Source Metrics

KPI Management | Google Business Profile

Data Studio Parameters

Integrations | Google Data Studio

Edit default Looker Studio Report

Data Warehouse | Google Data Studio

Editing a Pipeline

Data Warehouse

Facebook Ads Fields

Data Warehouse | Facebook Ads

Facebook Ads KPI

KPI Management | Facebook Ads

Facebook Ads destination URL checker

Automation | Facebook Ads

Free Connector to Data Warehouse field comparison

Data Warehouse | Google Business Profile

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 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 Location Updates

Automation | Google Business Profile

Google Business Profile Location Updates Insight

Insight | Google Business Profile

Google Business Profile Reporting Timezone

Data Warehouse | 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 Management | Google Sheets

Grant access to BigQuery data

Data Warehouse | Google Data Studio

How to create a Data Studio Report for Facebook

Data Warehouse | Google Data Studio

How to use Regex and Examples

Frequently Asked Questions

KPI Insight

Insights

KPI Seasonal Trends

KPI Management

KPI Status

KPI Management

KPI Target Settings

KPI Management

KPI history

KPI Management

Managed BigQuery

Data Warehouse | BigQuery

Microsoft Ads destination URL checker

Automation | Microsoft Ads

Page status checker

Automation | Website

Pipeline Extensions

Data Warehouse

Portfolio

Clients

Robots.txt change detection

Automation | Website

Rolling Average

KPI Management

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

Sending Slack Notifications

Integrations | Slack

Submit a Ticket

Frequently Asked Questions

The Funnel-Stage Terms

Extension | Explorer

Update Data Studio Fields

Integrations | Google Data Studio

Watchers

Comments

Choose article...
Data Warehouse | Google Data Studio

How to create a Data Studio Report for Google Business Profile

To create a Data Studio report for Google Business Profile (Formerly Google My Business) data we fetch your data daily and store it in Google BigQuery so its always available, fast and you only pay for the locations you choose.

1. Create a Pipeline

This step is broken into two different parts, the Source (which will be your Google Business Profile Locations) and step 2 the Destination, which will be Google BigQuery.

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

2. Set the Pipeline destination

  1. Click on the destination selector to open the connection draw
  2. 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.
  3. 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 Data 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.
  4. Choose a data center that is closest to you

3. Create a Looker Studio Report

If you already have a report that you would like to add the Google Business Profile data to, go to Step 4.

To create a new report using our default template please follow these steps:

  1. Go to the Data Warehouse page to view your pipelines https://app.jepto.com/pipelines
  2. Click on 'View' of the pipeline you wish to create a report with
  3. Click on 'Create Data Studio report' and the report will load in a new window
  4. Click the button 'Edit and Share' and then 'Acknowledge and save' (This process will add BigQuery as the data source behind the scenes for you)
  5. Adjust the report as necessary

💡Pro Tip: If you are making multiple reports and wish to use your own template, see here for how to set the default template.

4. Add data to an existing report

To add your Google Business Profile data to an existing Looker Studio, you will need to connect to Big Query.

  1. Open your report and click on 'Add Data' in the main menu
  2. Select the 'BigQuery Connector'
  3. Select the 'My Projects' 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.
  4. Select the Dataset and Table. If you have multiple pipelines, see the next section.
    📍Ensure that you tick the box for 'Use date as date range dimension' as this allows Data Studio to communicate with BigQuery to ensure that data is fetched as quickly and efficiently as possible.

Multiple Pipelines

Each Pipeline in Jepto will create a new Dataset within BigQuery. It's best practice to create pipelines per customer to ensure that data is separated and gives you the best performance. As each dataset has a unique ID you will need to refer back to your Jepto pipeline details view to get the corresponding dataset ID. To get the ID, navigate to the pipelines page and then click on 'View'. Then underneath the graph expand the 'Destination Details' section to reveal the Dataset Name.

💡 Pro Tip: If you hover over the Dataset name a copy icon will appear to easily get the value.

Once connected to 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.

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.