Jepto

Help Center

Close
Frequently Asked Questions

Frequently Asked Questions

Clients

Clients

Users

Users

Insights

Insights

Automation Jobs

Automation Jobs

Insights

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

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

Data Warehouse | Google Data Studio

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 Connector Fields

Integrations | Google Data Studio

Data Studio Parameters

Integrations | 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 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 Questions

Automation | Google Business Profile

Google Business Profile Location Updates

Automation | Google Business Profile

Google Business Profile Reporting Timezone

Data Warehouse | Google Business Profile

Google Reviews

Automation | 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

Add comment from Slack

Comments | Slack

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

Data Warehouse | Google Data Studio

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 Connector Fields

Integrations | Google Data Studio

Data Studio Parameters

Integrations | 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 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 Questions

Automation | Google Business Profile

Google Business Profile Location Updates

Automation | Google Business Profile

Google Business Profile Reporting Timezone

Data Warehouse | Google Business Profile

Google Reviews

Automation | 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

Choose article...
Data Warehouse | Google Business Profile

Free Connector to Data Warehouse field comparison

Free Data Warehouse Type Description

Local post search views

localPostViewsOnSearch

NumericInteger The number of times the local post was viewed on Google Search.

Local post call to action

localPostPhoneClicks

NumericInteger The number of times the call-to-action button was clicked on Google.

Local post call to action

postCallToAction

TextString The URL that users are sent to when clicking through the promotion.

Store Code

storeCode

TextString External identifier for this location, which must be unique inside a given account. This is a means of associating the location with your own records.

Date

date

CalendarTimestamp Date represented in ISO 8601 extended format (hh:mm)

Direct searches

directSearches

NumericInteger The number of times resource was shown when searching for location directly

Location Name

locationName

TextString Location name should reflect your business's real-world name, as used consistently on your storefront, website, and stationery, and as known to customers.

Discovery searches

discoverySearches

NumericInteger The number of times the resource was shown as a result of a categorical search (for example, restaurant).

Chain (Brand) searches

brandedSearches

NumericInteger The number of times a resource was shown as a result of a search for the chain it belongs to, or a brand it sells.

Maps views

viewsOnMap

NumericInteger The number of times the resource was viewed on Google Maps.

Search views

viewsOnSearch

NumericInteger The number of times the resource was viewed on Google Search.

Direction actions

requestDirection

NumericInteger The number of times driving directions were requested.

Owner photo views

photosViewsMerchant

NumericInteger The number of views on media items uploaded by the merchant.

Customer photo views

photosViewsCustomers

NumericInteger The number of views on media items uploaded by customers.

Comment

reviewcomment

TextString The body of the review as plain text with markups.

Created Date

date

CalendarInteger Date represented as (YYYY-MM-DD).

Location

locationId

TextString Location ID

Reply

reviewReply

TextString Reply on the review.

Review Count

totalReviewCount

NumericInteger The total number of reviews in a location.

Review ID

reviewId

NumericInteger The encrypted unique identifier.

Review Replied To

No equivalent

BooleanBoolean Determines if a reply has been left, use the existence of reviewReply.

Reviewer Display Name

reviewerDisplayName

TextString The reviewer display name.

Reviewer Photo URL

reviewerProfilePhotoUrl

TextString The reviewer profile photo URL.

Star Rating

starRating

NumericInteger The star rating of the review.

Star Rating Value

No equivalent

TextString The star rating of the review as a string.

In the GBP Free connector there are some metrics that are created with calculated fields. These aggregate metrics are not part of GBP Pro but can be easily created with a formula in Data Studio.

Field Formula

Total Views

SUM(IFNULL(viewsOnSearch, 0) + IFNULL(viewsOnMap , 0))

Total Actions

SUM(IFNULL(websiteClicks, 0) + IFNULL(requestDirection, 0) + IFNULL(phoneClicks, 0))

Total Searches

SUM(IFNULL(directSearches, 0) + IFNULL(brandedSearches , 0)+ IFNULL(discoverySearches , 0))

Note: Basic formulas often show 'No Data' when working with BigQuery Data Sources, so please use the above formulas as a guide to get past that issue. If you run into any issues please get in contact with support who will be happy to work through your reporting needs.

Calculated Fields in Data Studio

Within Data Studio you can choose to create a calculated field at the Data source level or chart-specific. Wherever possible we recommend to create them at the Data Source level so you can easily reuse the metric across your report without having to maintain multiple formulas. To learn more about the differences and option please see this Google article https://support.google.com/datastudio/answer/6299685

Creating a chart-specific filter


Creating a data source calculated metric

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.