> ## Documentation Index
> Fetch the complete documentation index at: https://docs.adriel.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Data reference

> Metrics, breakdowns, refresh cadence, and limits for the Google Business Profile data source in Adriel.

## 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-sources/g-n/google-business-profile/how-to-connect).

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

<Note>
  **How to read the columns**

  Code style like `CALL_CLICKS` is the literal platform API key. *Italic text* describes how a value is produced when it doesn't map cleanly to a single platform field or when it's computed by Adriel.

  **Data type vocabulary**: Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean.
</Note>

### Visibility & impressions

| Metric                       | Description                                                          | Data type | API Key                               |
| ---------------------------- | -------------------------------------------------------------------- | --------- | ------------------------------------- |
| Impressions – Desktop Maps   | Times the business was shown on Google Maps from a desktop device.   | Number    | `BUSINESS_IMPRESSIONS_DESKTOP_MAPS`   |
| Impressions – Desktop Search | Times the business was shown on Google Search from a desktop device. | Number    | `BUSINESS_IMPRESSIONS_DESKTOP_SEARCH` |
| Impressions – Mobile Maps    | Times the business was shown on Google Maps from a mobile device.    | Number    | `BUSINESS_IMPRESSIONS_MOBILE_MAPS`    |
| Impressions – Mobile Search  | Times the business was shown on Google Search from a mobile device.  | Number    | `BUSINESS_IMPRESSIONS_MOBILE_SEARCH`  |

### Actions & conversions

| Metric             | Description                                                               | Data type | API Key                       |
| ------------------ | ------------------------------------------------------------------------- | --------- | ----------------------------- |
| Call clicks        | Times customers clicked to call the business from the listing.            | Number    | `CALL_CLICKS`                 |
| Website clicks     | Times customers clicked through to the business website from the listing. | Number    | `WEBSITE_CLICKS`              |
| Direction requests | Times customers requested directions to the business.                     | Number    | `BUSINESS_DIRECTION_REQUESTS` |
| Bookings           | Bookings made through the business listing.                               | Number    | `BUSINESS_BOOKINGS`           |
| Food orders        | Food orders placed through the business listing.                          | Number    | `BUSINESS_FOOD_ORDERS`        |
| Food menu clicks   | Times customers clicked to view the food menu.                            | Number    | `BUSINESS_FOOD_MENU_CLICKS`   |
| Conversations      | Messages started with the business from the listing.                      | Number    | `BUSINESS_CONVERSATIONS`      |

### Reviews & ratings

| Metric                     | Description                                                                       | Data type | API Key                    |
| -------------------------- | --------------------------------------------------------------------------------- | --------- | -------------------------- |
| Average rating             | Lifetime average star rating for the location (served live from the reviews API). | Ratio     | `averageRating`            |
| Total review count         | Lifetime count of all reviews for the location.                                   | Number    | `totalReviewCount`         |
| Rating                     | Star rating on an individual review (1–5).                                        | Number    | `starRating`               |
| Review comment             | Text of the review left by the customer.                                          | Text      | `comment`                  |
| Reviewer name              | Display name of the reviewer.                                                     | Text      | `reviewer.displayName`     |
| Is reviewer anonymous      | Whether the reviewer is anonymous.                                                | Boolean   | `reviewer.isAnonymous`     |
| Reviewer profile photo URL | URL of the reviewer's profile photo.                                              | URL       | `reviewer.profilePhotoUrl` |
| Review reply comment       | Text of the business owner's reply, if any.                                       | Text      | `reviewReply.comment`      |
| Review reply update time   | When the owner's reply was last updated.                                          | Date      | `reviewReply.updateTime`   |
| Review create time         | When the review was first submitted.                                              | Date      | `createTime`               |
| Review update time         | When the review was last updated.                                                 | Date      | `updateTime`               |
| Review name                | Google's internal resource path for the review.                                   | Text      | `name`                     |

## Breakdowns

<Note>
  **How to read the columns**

  Code style like `reviewId` is the literal platform API key. Breakdowns without an API key are produced by Adriel.
</Note>

### Reviews & ratings

| Breakdown          | Description                                                              | API Key            |
| ------------------ | ------------------------------------------------------------------------ | ------------------ |
| Review             | One row per individual review, keyed on the review ID.                   | `reviewId`         |
| Review star rating | One row per star-rating value (1–5), aggregating reviews at that rating. | `reviewStarRating` |

### Business

<Note>
  Adriel collapses all rows into a single business-level total and labels the row with the business name.
</Note>

| Breakdown | Description                                        |
| --------- | -------------------------------------------------- |
| Business  | Aggregates all data into one row for the location. |

### Time & date grouping

<Note>
  Adriel groups the connector's daily-granularity performance results into these standard views for reporting alongside other connectors.
</Note>

| Breakdown           | Description                                                  |
| ------------------- | ------------------------------------------------------------ |
| No Grouping         | Returns a single total with no time split.                   |
| Auto Time Breakdown | Automatically picks the best granularity for the date range. |
| Daily               | Split reports by day.                                        |
| Weekly (Start: Mon) | Split reports by ISO week, starting Monday.                  |
| Monthly             | Split reports by calendar month.                             |
| Quarterly           | Split reports by calendar quarter.                           |
| Yearly              | Split reports by calendar year.                              |

## 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)](https://developers.google.com/my-business/reference/performance/rest) — daily performance metrics
* [My Business API v4 — reviews](https://developers.google.com/my-business/reference/rest/v4/accounts.locations.reviews) — reviews and replies
* [My Business Account Management API (v1)](https://developers.google.com/my-business/reference/accountmanagement/rest) — account listing
* [My Business Business Information API (v1)](https://developers.google.com/my-business/reference/businessinformation/rest) — location listing

## See also

* [How to connect Google Business Profile](/data-sources/g-n/google-business-profile/how-to-connect) (paired how-to)
* [Google Analytics 4 data reference](/data-sources/g-n/google-analytics-4/data-reference) — for the web and app analytics counterpart
* [Google Search Console data reference](/data-sources/g-n/google-search-console/data-reference) — for organic search performance