> For the complete documentation index, see [llms.txt](https://docs.quanti.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.quanti.io/connectors/marketing-connectors/google-business-profile.md).
# Google Business Profile
Prebuilt reports and definition
***
## Prerequisites
To connect Google Business Profile to QUANTI, you need:
* A [Google Business Profile](https://business.google.com) account with at least one verified location
* A Google account with **Owner** or **Manager** access to the Business Profile
***
## Setup instructions
{% stepper %}
{% step %}
#### Authorize your Google account
* Click **Continue with Google**
* You will be redirected to Google's authorization page
* Log in with your Google account credentials
* Review and accept the requested permissions
* You will be redirected back to QUANTI automatically
{% endstep %}
{% step %}
#### Select your Business Account
Select the Business Account you want to sync. Each Business Account can contain multiple locations.
{% hint style="info" %}
Only one Business Account can be selected per connector. To sync multiple Business Accounts, create one connector per account.
{% endhint %}
{% endstep %}
{% step %}
#### Select prebuilt reports
Review the available prebuilt reports and select the ones you want to activate.
{% endstep %}
{% step %}
#### Connector information
* **Connector Name**: Name your connector. It must be unique.
* **Dataset ID**: Define the ID of the dataset. It must not exist yet, as it will be created and data will be sent there.
{% endstep %}
{% endstepper %}
***
## Prebuilt reports
**location**: Business location reference data — address (region, postal code, city, address lines), primary and additional categories, contact details (phone, website), opening hours (regular and special), GPS coordinates, open/closed status, profile description, labels, and service items. One row per location, updated at each sync.
**review**: Customer reviews submitted on Google Maps for each location — star rating (ONE to FIVE), comment text, creation and update timestamps, reviewer display name, anonymity flag, and merchant reply (comment and update time). A new row is inserted at each sync for each review, enabling review history tracking.
**location\_insight**: Daily performance metrics per location and metric type. Each row represents one metric for one location on one day. Dimensions: location\_id, date, daily\_metric. Metric: value.
Available `daily_metric` values include:
* `BUSINESS_IMPRESSIONS_DESKTOP_MAPS` — Impressions on Google Maps (desktop)
* `BUSINESS_IMPRESSIONS_DESKTOP_SEARCH` — Impressions on Google Search (desktop)
* `BUSINESS_IMPRESSIONS_MOBILE_MAPS` — Impressions on Google Maps (mobile)
* `BUSINESS_IMPRESSIONS_MOBILE_SEARCH` — Impressions on Google Search (mobile)
* `BUSINESS_DIRECTION_REQUESTS` — Clicks on "Get directions"
* `CALL_CLICKS` — Clicks on the phone number
* `WEBSITE_CLICKS` — Clicks on the website URL
* `BUSINESS_BOOKINGS` — Bookings made via the profile
* `BUSINESS_FOOD_ORDERS` — Food orders placed via the profile
* `BUSINESS_CONVERSATIONS` — Conversations initiated via the profile
```mermaid
erDiagram
location {
TIMESTAMP _quanti_loaded_at PK
STRING name PK
STRING language_code
STRING store_code
STRING title
STRING primary_phone
STRING primary_category_display_name
STRING storefront_address_region_code
STRING storefront_address_postal_code
STRING storefront_address_locality
STRING storefront_address_address_lines
STRING website_uri
STRING regular_hours
FLOAT latlng_latitude
FLOAT latlng_longitude
STRING open_info_status
STRING profile_description
}
review {
TIMESTAMP _quanti_loaded_at PK
STRING name PK
STRING review_id PK
STRING location_id
STRING star_rating
STRING comment
TIMESTAMP create_time
TIMESTAMP update_time
STRING reviewer_display_name
BOOLEAN reviewer_is_anonymous
STRING review_reply_comment
}
location_insight {
STRING _quanti_ad_account
DATE _quanti_date PK
STRING location_id PK
DATE date PK
STRING daily_metric PK
INTEGER value
}
location ||--o{ review : "name / location_id"
location ||--o{ location_insight : "name / location_id"
```
***
Prebuilt reports and definition
***
## Notes
* **Lookback window**: Default lookback is **7 days**. Metrics and reviews are re-synced over the lookback window to capture retroactive updates.
* **Historical data**: Up to **18 months** (540 days) of history can be loaded on initial setup.
* **`location_insight` granularity**: Metrics are stored in a narrow (unpivoted) format — one row per metric per day per location. Use a pivot in your BI tool or a SQL `CASE WHEN` to reshape the data by metric type.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.quanti.io/connectors/marketing-connectors/google-business-profile.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.