Data reference - Adriel Knowledge Base

Introduction

Google Business Profile (formerly Google My Business) is Google’s platform for managing how a local business appears across Google Search and Google Maps. It captures how customers discover and interact with a business listing — impressions on Maps and Search, calls, website visits, direction requests, bookings, food orders, and messages — as well as the star ratings and text reviews customers leave. The connector exposes two kinds of data through a single data source. Performance metrics (impressions, clicks, calls, and other actions) are read live from the Business Profile Performance API for the selected date range. Reviews (individual ratings, reviewer details, and owner replies, plus the location’s lifetime average rating and total review count) are synced from the My Business API into an Adriel-managed cache. One data source is created per business location. As a local-performance connector, impressions, actions, and review data are standardized so widgets can aggregate alongside other sources without additional configuration. To connect this data source, see How to connect Google Business Profile to Adriel.

Data refresh strategy

This connector combines two data modes with different refresh behavior. Performance data is fetched live; review data is cached and refreshed on a schedule.

Architecture data

Architecture covers the Account → Location hierarchy used to identify the business. Accounts and locations are listed from the My Business Account Management and Business Information APIs when the connection is established and when a business is selected. Each selected location becomes one Adriel data source.

Reports data

Reports data follows two paths depending on the metric:

Performance metrics (impressions, calls, website clicks, direction requests, bookings, food orders, menu clicks, conversations) are fetched on demand. Each dashboard load issues a live request to the Business Profile Performance API for the selected date range and daily granularity; these values are not cached. Daily rows are then aggregated in memory to the requested breakdown (day, week, month, or business).
Reviews are synced into an Adriel-managed cache and refreshed nightly at 3:00 AM UTC. New reviews are inserted and existing reviews are updated in place, keyed on the review ID (an UPSERT strategy), so edited reviews and newly added owner replies are reflected on the next refresh. After the initial full sync, refreshes fetch only recently updated reviews. The location’s lifetime average rating and total review count are read live from the reviews API at query time rather than from the cache.

Architecture levels

Account → Location An Account groups the locations a user manages. A Location is a single business listing (a storefront or service area) and is the reporting boundary in Adriel. Connecting a business provisions one Adriel data source per location selected.

Date range limits

The performance API is queried live per request, so wide daily ranges are capped to keep query sizes manageable:

Breakdown	Max range
Daily	93 days
Weekly	1 year

Ranges beyond these caps are truncated, and data outside the window may not appear. No monthly cap is documented for this connector.

Metrics

Google Business Profile is a schema-flexible source. The fields below are the standard fields Adriel exposes; the exact fields you can report on depend on your Google Business Profile data. Data type uses Adriel’s vocabulary; API Key in code style is the literal source field; italic marks a value Adriel derives.

Google Business Profile fields

Metric	Description	Data type	API Key
Average Rating	Average customer review rating for the location on a 1 to 5 star scale.	Number	`averageRating`
Bookings	Bookings made from the business profile through Reserve with Google.	Number	`BUSINESS_BOOKINGS`
Call Clicks	Clicks on the call button in the business profile.	Number	`CALL_CLICKS`
Conversations	Message conversations received through the business profile.	Number	`BUSINESS_CONVERSATIONS`
Datasource Name	The name of the connected data source.	Text	Adriel-side
Direction Requests	Direction requests made from the business profile.	Number	`BUSINESS_DIRECTION_REQUESTS`
Food Menu Clicks	Daily unique users who clicked to view or interact with menu content on the business profile.	Number	`BUSINESS_FOOD_MENU_CLICKS`
Food Orders	Food orders received from the business profile.	Number	`BUSINESS_FOOD_ORDERS`
Impressions - Desktop Maps	Daily unique users who viewed the business profile on Google Maps on desktop devices.	Number	`BUSINESS_IMPRESSIONS_DESKTOP_MAPS`
Impressions - Desktop Search	Daily unique users who viewed the business profile on Google Search on desktop devices.	Number	`BUSINESS_IMPRESSIONS_DESKTOP_SEARCH`
Impressions - Mobile Maps	Daily unique users who viewed the business profile on Google Maps on mobile devices.	Number	`BUSINESS_IMPRESSIONS_MOBILE_MAPS`
Impressions - Mobile Search	Daily unique users who viewed the business profile on Google Search on mobile devices.	Number	`BUSINESS_IMPRESSIONS_MOBILE_SEARCH`
Is Reviewer Anonymous	Whether the review was posted anonymously.	Text	`reviewer.isAnonymous`
Rating	Star rating given in the review on a 1 to 5 scale.	Number	`starRating`
Review Comment	Review text left by the customer.	Text	`comment`
Review Create Time	Time when the review was originally created.	Date	`createTime`
Review Name	Unique resource name for the review.	Text	`name`
Review Reply Comment	Business owner reply text posted on the review.	Text	`reviewReply.comment`
Review Reply Update Time	Time when the business owner reply was last updated.	Date	`reviewReply.updateTime`
Review Update Time	Time when the review was last updated.	Date	`updateTime`
Reviewer Name	Display name shown for the reviewer.	Text	`reviewer.displayName`
Reviewer Profile Photo URL	Profile photo URL for the reviewer.	Text	`reviewer.profilePhotoUrl`
Row Count	Number of rows returned for the selected grouping.	Number	Adriel-side
Total Review Count	Total number of customer reviews for the location.	Number	`totalReviewCount`
Website Clicks	Clicks on the business profile website link.	Number	`WEBSITE_CLICKS`

Date Calculation

Metric	Description	Data type	API Key
Number Of Days In Current Month	The total number of days in the current calendar month.	Number	Adriel-side
Number Of Days Per Row	The number of days each row of the source represents.	Number	Adriel-side
Remaining Days	The number of days remaining in the selected period.	Number	Adriel-side
Total Duration In Days	The total number of days covered by the selected date range.	Number	Adriel-side

Breakdowns

Google Business Profile fields

Breakdown	Description	API Key
Business	Business profile name.	Adriel-side
Is Reviewer Anonymous	Whether the review was posted anonymously.	`reviewer.isAnonymous`
Rating	Star rating given in the review on a 1 to 5 scale.	`starRating`
Review Comment	Review text left by the customer.	`comment`
Review Create Time	Time when the review was originally created.	`createTime`
Review ID	Encrypted unique identifier for the review.	`reviewId`
Review Name	Unique resource name for the review.	`name`
Review Reply Comment	Business owner reply text posted on the review.	`reviewReply.comment`
Review Reply Update Time	Time when the business owner reply was last updated.	`reviewReply.updateTime`
Review Update Time	Time when the review was last updated.	`updateTime`
Reviewer Name	Display name shown for the reviewer.	`reviewer.displayName`
Reviewer Profile Photo URL	Profile photo URL for the reviewer.	`reviewer.profilePhotoUrl`

General

Breakdown	Description	API Key
Datasource Name	Groups results by connected data source.	Adriel-side
No Grouping	Shows all results as a single combined group.	Adriel-side

Date

Breakdown	Description	API Key
Daily Breakdown	Groups results by calendar day.	Adriel-side
Monthly Breakdown	Groups results by calendar month.	Adriel-side
Weekly Breakdown (Start: Mon)	Groups results by calendar week (Monday start).	Adriel-side
Auto Time Breakdown	Automatically groups results by an appropriate time interval for the selected date range.	Adriel-side
Daily Breakdown	Groups results by calendar day.	Adriel-side
Monthly Breakdown	Groups results by calendar month.	Adriel-side
Quarterly Breakdown	Groups results by calendar quarter.	Adriel-side
Week Date Breakdown	Groups results by the date representing each reporting week.	Adriel-side
Week Number Breakdown (W#)	Groups results by week number in the year.	Adriel-side
Weekly Breakdown (Start: Mon)	Groups results by calendar week (Monday start).	Adriel-side
Weekly Breakdown (Start: Sun)	Groups results into weeks running from Sunday through Saturday.	Adriel-side
Yearly Breakdown	Groups results by calendar year.	Adriel-side

Limitations

Based on the current connector, Google Business Profile has:

Two data modes with different freshness — performance metrics are live but reviews refresh once nightly (3:00 AM UTC), so a review left during the day appears the following morning.
A 93-day cap on daily performance queries and a 1-year cap on weekly queries — wider ranges are truncated and data outside the window may not appear.
Live aggregate review metrics — average rating and total review count are read from the reviews API at query time (not from the review cache) and reflect the location’s lifetime totals, not the selected date range.
A cached review store of up to 50,000 rows per location — locations with more reviews than the cache limit may not surface every historical review.
Anonymous and reply fields may be empty — reviewer anonymity is recorded per review, and reply fields are empty when the owner has not responded.
One data source per location — reporting across multiple locations requires one data source per business.

API references

Business Profile Performance API (v1) — daily performance metrics
My Business API v4 — reviews — reviews and replies
My Business Account Management API (v1) — account listing
My Business Business Information API (v1) — location listing

​Introduction

​Data refresh strategy

​Architecture data

​Reports data

​Architecture levels

​Date range limits

​Metrics

​Google Business Profile fields

​Date Calculation

​Breakdowns

​Google Business Profile fields

​General

​Date

​Limitations

​API references

​See also

Introduction

Data refresh strategy

Architecture data

Reports data

Architecture levels

Date range limits

Metrics

Google Business Profile fields

Date Calculation

Breakdowns

Google Business Profile fields

General

Date

Limitations

API references

See also