General
Data Sources | General
Connections
Data Sources | Connections
Fields & Formulas
Data Sources | Fields & Formulas
Creating & Sharing
Reports | Creating & Sharing
Report Editing
Reports | Editing
Report Config
Reports | Report Config
Chart Cards
Reports | Chart Cards
Content Cards
Reports | Content Cards
General
Data Chat | General
General
AI | General
General
Clients | General
General
Integrations | General
Webhook — Local & Reviews
Integrations | Webhook — Local & Reviews
Webhook — Automation Payloads
Integrations | Webhook — Automation Payloads
MCP
Integrations | MCP
Webhook — Other
Integrations | Webhook — Other
Account & Billing
Settings | Account & Billing
Users
Settings | Users
Comments & Notes
Settings | Comments & Notes
Notifications
Settings | Notifications
FAQ
Settings | FAQ
Other
Settings | Other
General
KPI Forecasting | General
Settings & Status
KPI Forecasting | Settings & Status
Seasonality
KPI Forecasting | Seasonality
Metrics by Source
KPI Forecasting | Metrics by Source
General
Budget Tracking | General
General
Anomaly Detection | General
General
Automation Jobs | General
Change History
Automation Jobs | Change History
URL & Page Checkers
Automation Jobs | URL & Page Checkers
Local & Reviews
Automation Jobs | Local & Reviews
Search Console
Automation Jobs | Search Console
Managing Insights
Insights | Managing Insights
Change History
Insights | Change History
URL & Page
Insights | URL & Page
Local & Reviews
Insights | Local & Reviews
Other Insight Types
Insights | Other Insight Types
General
Local Listings | General
Profiles & Content
Local Listings | Profiles & Content
Performance & Activity
Local Listings | Performance & Activity
Media
Local Listings | Media
Categories & Services
Local Listings | Categories & Services
General
Reviews | General
General
Social Posts | General
Creating Posts
Social Posts | Creating Posts
Managing Posts
Social Posts | Managing Posts
Pipelines
Data Warehouse | Pipelines
Access & Credits
Data Warehouse | Access & Credits
Source Fields
Data Warehouse | Source Fields
Data Studio
Data Warehouse | Data Studio
BigQuery
Data Warehouse | BigQuery
General
Clients | General
General
Integrations | General
MCP
Integrations | MCP
Webhook — Automation Payloads
Integrations | Webhook — Automation Payloads
Webhook — Local & Reviews
Integrations | Webhook — Local & Reviews
Webhook — Other
Integrations | Webhook — Other
Account & Billing
Settings | Account & Billing
Users
Settings | Users
Comments & Notes
Settings | Comments & Notes
Notifications
Settings | Notifications
FAQ
Settings | FAQ
Other
Settings | Other
Settings | Account & Billing
Insights | Managing Insights
Integrations | General
Settings | Comments & Notes
Settings | Users
Reports | Creating & Sharing
AI | General
AI | General
Reports | Content Cards
Anomaly Detection | General
Anomaly Detection | General
Anomaly Detection | General
Insights | Other Insight Types
Anomaly Detection | General
Integrations | Webhook — Other
Anomaly Detection | General
Local Listings | General
Reviews | General
Reports | Chart Cards
Local Listings | Profiles & Content
Data Warehouse | Pipelines
Integrations | Webhook — Automation Payloads
Integrations | Webhook — Automation Payloads
Integrations | Webhook — Automation Payloads
Integrations | Webhook — Automation Payloads
Integrations | Webhook — Local & Reviews
Integrations | Webhook — Automation Payloads
Integrations | Webhook — Local & Reviews
Integrations | Webhook — Local & Reviews
Integrations | Webhook — Local & Reviews
Integrations | Webhook — Automation Payloads
Automation Jobs | General
Automation Jobs | General
Integrations | Webhook — Automation Payloads
Integrations | Webhook — Automation Payloads
Integrations | Webhook — Automation Payloads
Automation Jobs | General
Integrations | Webhook — Automation Payloads
Integrations | Webhook — Automation Payloads
Insights | Managing Insights
Reports | Chart Cards
Reports | Creating & Sharing
Budget Tracking | General
Budget Tracking | General
Budget Tracking | General
Budget Tracking | General
Budget Tracking | General
Budget Tracking | General
Integrations | Webhook — Other
Budget Tracking | General
Budget Tracking | General
Local Listings | General
Local Listings | Media
Social Posts | General
Settings | Account & Billing
Reports | Editing
Reports | Creating & Sharing
Local Listings | Categories & Services
Local Listings | Categories & Services
Local Listings | Categories & Services
Settings | Users
Settings | Other
Clients | General
Clients | General
Reports | Chart Cards
Settings | Notifications
Data Sources | General
Integrations | General
Integrations | General
Integrations | MCP
Data Sources | Connections
Data Sources | Connections
Data Sources | Connections
Data Sources | Connections
Data Sources | Connections
Data Sources | Connections
Local Listings | Media
Data Warehouse | Data Studio
Data Warehouse | Data Studio
Data Warehouse | Data Studio
KPI Forecasting | General
Reports | Creating & Sharing
Reports | Report Config
Reports | Creating & Sharing
Clients | General
Data Warehouse | Data Studio
KPI Forecasting | General
Data Warehouse | Pipelines
Data Warehouse | BigQuery
Social Posts | Creating Posts
Automation Jobs | General
Social Posts | Creating Posts
Anomaly Detection | General
Automation Jobs | General
Reports | Editing
Data Sources | General
Data Sources | General
Data Sources | General
Data Warehouse | Data Studio
Data Warehouse | Access & Credits
Data Warehouse | Access & Credits
Data Warehouse | Access & Credits
Clients | General
Settings | Users
Settings | Comments & Notes
Data Sources | General
Reports | Chart Cards
Social Posts | Managing Posts
Social Posts | Creating Posts
Data Warehouse | Data Studio
Settings | Notifications
Data Warehouse | Pipelines
Settings | Comments & Notes
Settings | Notifications
Settings | Notifications
Social Posts | Managing Posts
Data Warehouse | Pipelines
KPI Forecasting | Metrics by Source
Automation Jobs | URL & Page Checkers
Insights | URL & Page
Data Warehouse | Source Fields
KPI Forecasting | Metrics by Source
Reviews | General
Reports | Report Config
Reports | Report Config
Data Sources | General
Data Sources | Fields & Formulas
Data Warehouse | Source Fields
Settings | FAQ
Settings | FAQ
Data Sources | Connections
Data Sources | Connections
Automation Jobs | Change History
Insights | Change History
KPI Forecasting | Metrics by Source
Automation Jobs | URL & Page Checkers
Insights | URL & Page
Automation Jobs | Change History
Insights | Change History
KPI Forecasting | Metrics by Source
Data Warehouse | BigQuery
Automation Jobs | Change History
Insights | Change History
KPI Forecasting | Metrics by Source
Data Warehouse | Source Fields
Automation Jobs | Local & Reviews
Insights | Local & Reviews
Automation Jobs | Local & Reviews
Insights | Local & Reviews
Automation Jobs | Local & Reviews
Insights | Local & Reviews
Data Warehouse | Source Fields
Data Sources | Connections
Data Sources | Connections
Automation Jobs | Change History
Insights | Change History
Automation Jobs | Local & Reviews
Insights | Local & Reviews
Data Warehouse | Source Fields
Data Warehouse | Source Fields
Budget Tracking | General
KPI Forecasting | Settings & Status
Data Warehouse | Data Studio
Data Chat | General
Settings | Comments & Notes
Local Listings | Profiles & Content
Settings | Other
Settings | FAQ
Reports | Content Cards
Reports | Content Cards
Local Listings | Media
Insights | Managing Insights
Insights | Managing Insights
Integrations | General
Integrations | MCP
KPI Forecasting | Settings & Status
KPI Forecasting | Settings & Status
KPI Forecasting | General
Integrations | Webhook — Other
KPI Forecasting | Settings & Status
Insights | Other Insight Types
KPI Forecasting | General
KPI Forecasting | Seasonality
KPI Forecasting | Settings & Status
KPI Forecasting | Seasonality
Reports | Chart Cards
Local Listings | Performance & Activity
Local Listings | Performance & Activity
Local Listings | Profiles & Content
Local Listings | Media
Integrations | MCP
Data Warehouse | BigQuery
Data Warehouse | BigQuery
Data Warehouse | Data Studio
Settings | Other
Data Chat | General
Local Listings | Media
Local Listings | Media
Local Listings | Media
Social Posts | General
Local Listings | Media
Local Listings | Media
Data Chat | General
KPI Forecasting | Metrics by Source
Automation Jobs | URL & Page Checkers
Insights | URL & Page
Reports | Chart Cards
Local Listings | Profiles & Content
Data Chat | General
Automation Jobs | URL & Page Checkers
Insights | URL & Page
Reports | Report Config
Reviews | General
Data Warehouse | Pipelines
Local Listings | General
Clients | General
Social Posts | Creating Posts
Reports | Creating & Sharing
Social Posts | Managing Posts
Local Listings | Profiles & Content
Data Warehouse | Data Studio
Reports | Report Config
Insights | Managing Insights
Reviews | General
Reports | Editing
Reports | Report Config
Reports | Report Config
Insights | Managing Insights
Reviews | General
Reviews | General
Reviews | General
Automation Jobs | URL & Page Checkers
Insights | URL & Page
Automation Jobs | URL & Page Checkers
KPI Forecasting | Settings & Status
Clients | General
Reports | Chart Cards
Social Posts | Managing Posts
Automation Jobs | Search Console
Insights | Other Insight Types
Automation Jobs | Search Console
Insights | Other Insight Types
Local Listings | General
Clients | General
Reports | Creating & Sharing
Integrations | General
Local Listings | Categories & Services
Local Listings | Categories & Services
Settings | Account & Billing
Reports | Creating & Sharing
Social Posts | General
Settings | FAQ
Settings | Account & Billing
Reports | Content Cards
Data Sources | Fields & Formulas
Reports | Report Config
Reports | Content Cards
Settings | Account & Billing
Data Sources | Fields & Formulas
Reviews | General
Settings | Account & Billing
Clients | General
Data Warehouse | Data Studio
Settings | Users
Settings | Users
Social Posts | General
Settings | Other
Local Listings | Performance & Activity
Settings | Comments & Notes
Integrations | Webhook — Other
Settings | FAQ
This guide helps you update Google Business Profile reports when moving from the Jepto Free connector to Data Warehouse.
The field names are not always the same between the two connectors. Use the field-mapping table below to update existing Looker Studio reports and calculated fields.
The table below shows the equivalent Data Warehouse field for each Free connector field, along with its data type and description.
| Free | Data Warehouse | Type | Description |
|---|---|---|---|
Local post search views | localPostViewsOnSearch |  Integer | The number of times the local post was viewed on Google Search. |
Local post call to action | localPostPhoneClicks | Integer | The number of times the call-to-action button was clicked on Google. |
Local post call to action | postCallToAction |  String | The URL that users are sent to when clicking through the promotion. |
Store Code | storeCode | String | 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 |  Timestamp | Date represented in ISO 8601 extended format (hh:mm) |
Direct searches | directSearches | Integer | The number of times resource was shown when searching for location directly |
Location Name | locationName | String | 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 | Integer | The number of times the resource was shown as a result of a categorical search (for example, restaurant). |
Chain (Brand) searches | brandedSearches | Integer | 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 | Integer | The number of times the resource was viewed on Google Maps. |
Search views | viewsOnSearch | Integer | The number of times the resource was viewed on Google Search. |
Direction actions | requestDirection | Integer | The number of times driving directions were requested. |
Owner photo views | photosViewsMerchant | Integer | The number of views on media items uploaded by the merchant. |
Customer photo views | photosViewsCustomers | Integer | The number of views on media items uploaded by customers. |
Comment
reviewcomment
String Created Date
date
Integer Location
locationId
String Reply
reviewReply
String Review Count
totalReviewCount
Integer Review ID
reviewId
Integer Review Replied To
No equivalent
Boolean Reviewer Display Name
reviewerDisplayName
String Reviewer Photo URL
reviewerProfilePhotoUrl
String Star Rating
starRating
Integer Star Rating Value
No equivalent
String
Some metrics available in the Free connector are calculated fields rather than direct Data Warehouse fields. Recreate these metrics in Looker Studio using the formulas below.
| 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 can show “No Data” when used with BigQuery data sources. Use the formulas above as a guide. Contact Jepto support if you need help adapting them to your report.
You can create calculated fields at either the data-source level or the chart level.
Create fields at the data-source level whenever possible. This makes the metric reusable throughout the report and avoids maintaining the same formula in multiple charts.
For more information, see the Looker Studio calculated fields guide.
Use a chart-specific filter when a calculation or filter should apply only to one chart.
Use a data-source calculated metric when the same calculation should be available across multiple charts in the report.
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
Oops! Something went wrong while submitting the form.
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
Oops! Something went wrong while submitting the form.