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 Business Profile

Google Business Profile Fields

Transferring your Google Business Profile data into Google Big Query is quick and hassle-free. To make analyzing easy in Data Studio the data is broken down into entities in a single table. Each entity represents a type of data.

The process of moving your data into Big Query begins by fetching your historic data, with the timeframes of each entity shown below. After this a daily update is performed, some entities have a delay to when new data is available and is also shown in the table below.

Data Studio Report Template - Need some inspiration for reporting? Copy this template https://datastudio.google.com/reporting/3006aaf4-50bb-4d1e-967c-560de2e9516a

Entity date ranges for syncing

Entity Historic Data Period Daily Update Schedule

Review

From 96 months ago up to 1 day ago 1 day ago

Insight

From 18 months ago up to 4 days ago 4 days ago

Local Post

From 18 months ago up to 1 day ago 1 day ago

Media

From 18 months ago up to 1 day ago 1 day ago

Media Customer

From 18 months ago up to 1 day ago 1 day ago

Question

From 18 months ago up to 1 day ago 1 day ago

Answer

From 18 months ago up to 1 day ago 1 day ago

Search Keyword

From last month up to 36 months ago 1st day of the month for the previous month

Metric Performance

From 18 months ago up to 4 days ago 4 days ago

Performance

Field Type Description

mapsImpressionsDesktop

NumericInteger Business impressions on Google Maps on Desktop devices. Multiple impressions by a unique user within a single day are counted as a single impression.

searchImpressionsDesktop

NumericInteger Business impressions on Google Search on Desktop devices. Multiple impressions by a unique user within a single day are counted as a single impression.

searchImpressionsMobile

NumericInteger Business impressions on Google Search on Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression.

mapsImpressionsMobile

NumericInteger Business impressions on Google Maps on Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression.

conversations

NumericInteger The number of message conversations received on the business profile.

directionRequests

NumericInteger The number of times a direction request was requested to the business location.

callClicks

NumericInteger The number of times the business profile call button was clicked.

webClicks

NumericInteger The number of times the business profile website was clicked.

bookings

NumericInteger The number of bookings received from the business profile.

foodOrders

NumericInteger The number of food orders received from the business profile.

desktopImpressions

NumericInteger Impressions on Google Search and Maps on Desktop devices. Multiple impressions by a unique user within a single day are counted once.

mobileImpressions

NumericInteger Impressions on Google Search and Maps on Mobile devices. Multiple impressions by a unique user within a single day are counted once.

searchImpressions

NumericInteger Impressions on Google Search on Mobile and Desktop devices. Multiple impressions by a unique user within a single day are counted once.

mapsImpressions

NumericInteger Impressions on Google Maps on Mobile and Desktop devices. Multiple impressions by a unique user within a single day are counted once.


Location

Field Type Description

name

TextString Google identifier for this location in the form: accounts/{accountId}/locations/{locationId}

locationId

TextString Location ID

entityType

TextString Entity type

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.

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.

primaryCategory

TextString Category that best describes the core business this location engages in.

primaryPhone

TextString A phone number that connects to your individual business location as directly as possible.

additionalPhones

TextString Up to two phone numbers (mobile or landline, no fax) at which your business can be called, in addition to your primary phone number.

address

TextString A precise, accurate address to describe your business location.

additionalCategories

TextString Additional categories to describe your business.

websiteUrl

TextString A URL for this business.

regularHours

TextString Operating hours for the business.

specialHours

TextString Special hours for the business.

serviceArea

TextString Service area businesses provide their service at the customer's location.

labels

TextString A collection of free-form strings to allow you to tag your business.

adWordsLocationExtensions

TextString Additional information that is surfaced in AdWords.

latlng

TextString User-provided latitude and longitude. When creating a location, this field is ignored if the provided address geocodes successfully.

openInfo

TextString Indicates the location other information

openInfoStatus

TextString A flag that indicates whether the location is currently open for business.

attributes

TextString Attributes for this location.

metadata

TextString Additional non-user-editable information.

languageCode

TextString The language of the location.

priceLists

TextString Describes your business in your own voice and shares with users the unique story of your business and offerings.

profile

TextString Describes your business in your own voice and shares with users the unique story of your business and offerings.

relationshipData

TextString All locations and chain related to this one.

date

CalendarDate Date represented as YYYY-MM-DD

dateTime

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

followers

TextString Total number of followers for the location.

locationAverageRating

NumericNumeric The location's average rating

totalReviewCount

TextString The daily total number of reviews in a location. NOTE: To display the total number of reviews in Data Studio, use the MAX aggregation. For the number of reviews over a given time period use the reviewId metric with COUNT aggregation.

insertId

TextString For Jepto Use only

Media

Field Type Description

mediaFormat

TextString The format of this media item.

mediaLocationAssociation

TextString Describes how this media item is connected to its location.

mediaGoogleUrl

TextString Google-hosted URL for this media item.

mediaThumbnailUrl

TextString Where provided, the URL of a thumbnail image for this media item.

mediaDimensions

TextString The dimensions (width and height) in pixels.

mediaDescription

TextString Description for this media item.

Media Customer

Field Type Description

mediaCustomerMediaFormat

TextString The format of this media customer item.

mediaCustomerLocationAssociation

TextString Describes how this media item is connected to its location.

mediaCustomerGoogleUrl

TextString Google-hosted URL for media customer item.

mediaCustomerThumbnailUrl

TextString Where provided, the URL of a thumbnail image for media customer item.

mediaCustomerDimensions

TextString The dimensions (width and height) in pixels.

mediaCustomerDescription

TextString Description for media customer item.

mediaCustomerAttribution

TextString Attribution information for customer media items.

mediaCustomerSourceUrl

TextString A publicly accessible URL where the media item can be retrieved from.

mediaCustomerDataRef

TextString A reference to media item binary data as obtained by the media.

Local Post

Field Type Description

postId

TextString Google identifier for this post in the form: accounts/{accountId}/locations/{locationId}/localPosts/{postId}

postLanguageCode

TextString The language of the local post.

postSummary

TextString Description/body of the local post.

postCallToAction

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

postEventTitle

TextString Title of the post event.

postEventDetails

TextString Event information.

postState

TextString The state of the post, indicating what part of its lifecycle it is in.

postMedia

TextString The media associated with the post.

postMediaUrl

TextString The media URL associated with the post.

postSearchUrl

TextString The link to the local post in Google search.

postTopicType

TextString The topic type of the post: standard, event, offer, or alert.

postAlertType

TextString The type of alert the post is created for.

postOffer

TextString Additional data for offer posts.

postPublishDate

CalendarTimestamp Time of the creation of the post.

Question

Field Type Description

questionUpvoteCount

NumericInteger The number of upvotes for the question.

answerUpvoteCount

NumericInteger The number of upvotes for the answer.

questionAuthorProfilePhotoUrl

TextString Photo URL of the author of the question

question

TextString The content of the question.

questionAuthorDisplayName

TextString The author of the of question.

Answer

Field Type Description

answerAuthorDisplayName

TextString Display name of the author of the answer

answerAuthorProfilePhotoUrl

TextString Photo URL of the author of the answer

topAnswers

TextString A list of answers to the question, sorted by upvotes.

totalAnswerCount

NumericNumeric The total number of answers posted for this question.

answer

TextString The answer to the question.

Review

Field Type Description

reviewId

TextString The encrypted unique identifier.

reviewerProfilePhotoUrl

TextString The reviewer profile photo URL

reviewerDisplayName

TextString The reviewer display name

reviewReply

TextString Reply on the review

reviewReplyDate

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

starRating

NumericInteger The star rating of the review.

reviewComment

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

Search Keyword

Note: This data is only available at the monthly level. If you are using Google Data Studio to display this data please ensure that the date range of your chart covers the first day of the month you wish to show data for.

Field Type Description

searchKeyword

TextString The lower-cased string that the user entered.

searchThreshold

NumericInteger A threshold that indicates that the actual value is below this threshold.

searchVolume

NumericInteger The sum of the number of unique users that used the keyword in a month, aggregated for each month requested.

Deprecated Fields

These fields have been removed from the data source so they are no longer supported, although they may be available in your Data Warehouse it is not recommended that they be used for reporting as we cannot verify their accuracy.

Field Replacement Field Discontinuation Date

directSearches

none Feb 2023

discoverySearches

none Feb 2023

brandedSearches

none Feb 2023

viewsOnMap

mapsImpressionsDesktop


mapsImpressionsMobile

Feb 2023

viewsOnSearch

searchImpressionsDesktop


searchImpressionsMobile

Feb 2023

websiteClicks

webClicks

Feb 2023

phoneClicks

callClicks

Feb 2023

requestDirection

directionRequests

Feb 2023

photosViewsMerchant

none Feb 2023

photosViewsCustomers

none Feb 2023

photosCountCustomers

none Feb 2023

photosCountMerchant

none Feb 2023

totalPostViewsOnSearch

none Feb 2023

totalPostPhoneClicks

none Feb 2023

locationState

metadata

Feb 2023

locationKey

metadata

Feb 2023

priceLists

FoodMenus


ServiceLists

Feb 2023

mediaInsights

none Feb 2023

mediaCustomerInsights

none Feb 2023

Data Source Notes

  • locationAverageRating - Historic data is calculated by dividing the review scores by the number of total reviews for each day. From the day the pipeline is setup and moving forward, the average rating is taken from the API. In rare cases there may be discrepancies between the calculated value of the average rating and the rating shown on the Google Business Profile location are due to the way Google can look at other factors to determine the score, as outlined in their help article here.

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.