Google My Business Connector Reference
https://connectors.windsor.ai/google_my_business?api_key=<APIKEY>&date_preset=last_7d&fields=date,account_id,account_name,clicks,impressions
The Google My Business connector exposes 142 fields (22 metrics, 120 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available actions
Create Local Post Publish a standard "What's New" post on the connected Google Business Profile location. Provide the post text, an optional publicly accessible photo URL (JPG or PNG, at least 250x250 px and 10 KB) and an optional call-to-action button. Call-to-action types: BOOK, ORDER, SHOP, LEARN_MORE, SIGN_UP (each needs cta_url) or CALL (uses the listing's phone number, no cta_url). The post can be edited afterwards via update_local_post.
Publish a standard "What's New" post on the connected Google Business Profile location. Provide the post text, an optional publicly accessible photo URL (JPG or PNG, at least 250x250 px and 10 KB) and an optional call-to-action button. Call-to-action types: BOOK, ORDER, SHOP, LEARN_MORE, SIGN_UP (each needs cta_url) or CALL (uses the listing's phone number, no cta_url). The post can be edited afterwards via update_local_post.
Update Local Post Update the text, photo or call-to-action of an existing post on the connected Google Business Profile location. post_id is the trailing id from the post's resource name (the post_id field of the Local Posts table); full resource names are also accepted. Only the provided fields are changed. Call-to-action types: BOOK, ORDER, SHOP, LEARN_MORE, SIGN_UP (each needs cta_url) or CALL (uses the listing's phone number, no cta_url).
Update the text, photo or call-to-action of an existing post on the connected Google Business Profile location. post_id is the trailing id from the post's resource name (the post_id field of the Local Posts table); full resource names are also accepted. Only the provided fields are changed. Call-to-action types: BOOK, ORDER, SHOP, LEARN_MORE, SIGN_UP (each needs cta_url) or CALL (uses the listing's phone number, no cta_url).
Reply to Review Publish the owner's reply to a customer review on the connected Google Business Profile location, or replace the existing reply. review_id comes from the review_id field of the Reviews table; full resource names are also accepted. The reply is public; replying again replaces the existing reply.
Publish the owner's reply to a customer review on the connected Google Business Profile location, or replace the existing reply. review_id comes from the review_id field of the Reviews table; full resource names are also accepted. The reply is public; replying again replaces the existing reply.
Upload Photo Add a photo to the connected Google Business Profile location's gallery. Provide a publicly accessible photo URL (JPG or PNG, at least 250x250 px and 10 KB) and the gallery category it belongs to (default ADDITIONAL; COVER and PROFILE replace the current cover or profile photo).
Add a photo to the connected Google Business Profile location's gallery. Provide a publicly accessible photo URL (JPG or PNG, at least 250x250 px and 10 KB) and the gallery category it belongs to (default ADDITIONAL; COVER and PROFILE replace the current cover or profile photo).
Update Location Info Update the business description, website URL and/or primary phone number of the connected Google Business Profile location. Only the provided fields are changed. Edits may be reviewed by Google before they appear on the listing.
Update the business description, website URL and/or primary phone number of the connected Google Business Profile location. Only the provided fields are changed. Edits may be reviewed by Google before they appear on the listing.
Update Service Items Replace the full list of service items (services offered) on the connected Google Business Profile location. Each item is either structured — a Google-predefined service_type_id valid for one of the location's categories — or free-form — a category_id plus a custom display_name; both take an optional description and price. This replaces all existing service items: to keep current ones, read the location_service_items field first and resend them together with the changes. Google removes duplicate items automatically.
Replace the full list of service items (services offered) on the connected Google Business Profile location. Each item is either structured — a Google-predefined service_type_id valid for one of the location's categories — or free-form — a category_id plus a custom display_name; both take an optional description and price. This replaces all existing service items: to keep current ones, read the location_service_items field first and resend them together with the changes. Google removes duplicate items automatically.
Update Categories Set the primary category and the full list of additional categories of the connected Google Business Profile location. Category ids are stable Google ids like 'gcid:plumber' (accepted with or without the 'categories/' prefix); current values appear in the location_primary_category_id and location_additional_categories fields. Replaces all existing categories — omitting additional_category_ids removes every additional category. Category changes may be reviewed by Google and can in some cases trigger re-verification of the listing.
Set the primary category and the full list of additional categories of the connected Google Business Profile location. Category ids are stable Google ids like 'gcid:plumber' (accepted with or without the 'categories/' prefix); current values appear in the location_primary_category_id and location_additional_categories fields. Replaces all existing categories — omitting additional_category_ids removes every additional category. Category changes may be reviewed by Google and can in some cases trigger re-verification of the listing.
Update Service Area Replace the service area (the list of places the business serves) of the connected Google Business Profile location, and whether the business serves customers only at their locations or also at its own address. Replaces all existing places: to keep current ones, read the location_service_area field first and resend them together with the changes. Google caps the service area at 20 places.
Replace the service area (the list of places the business serves) of the connected Google Business Profile location, and whether the business serves customers only at their locations or also at its own address. Replaces all existing places: to keep current ones, read the location_service_area field first and resend them together with the changes. Google caps the service area at 20 places.
Update Attributes Update and/or remove individual attributes (e.g. amenities, payment options, appointment links) of the connected Google Business Profile location. Only the attributes named in the request are touched — unlike the other update actions, the rest of the set is left as is. Currently set attributes can be audited via the location_attributes field; Google rejects attributes that are not available for the location's categories.
Update and/or remove individual attributes (e.g. amenities, payment options, appointment links) of the connected Google Business Profile location. Only the attributes named in the request are touched — unlike the other update actions, the rest of the set is left as is. Currently set attributes can be audited via the location_attributes field; Google rejects attributes that are not available for the location's categories.
Update Address Replace the storefront address of the connected Google Business Profile location. WARNING: changing the address can put the listing back into Google's re-verification flow, which may unpublish it until the business verifies again — the action refuses to run unless acknowledge_reverification_risk is set to true, which requires the end user's explicit approval. The whole address is replaced: provide every part the listing should keep (current values are in the location_address_* fields).
Replace the storefront address of the connected Google Business Profile location. WARNING: changing the address can put the listing back into Google's re-verification flow, which may unpublish it until the business verifies again — the action refuses to run unless acknowledge_reverification_risk is set to true, which requires the end user's explicit approval. The whole address is replaced: provide every part the listing should keep (current values are in the location_address_* fields).
Set Regular Hours Set the weekly opening hours of the connected Google Business Profile location. Provide one period per continuous open span (a day may have several, e.g. before and after a lunch break; days with no period are shown as closed). For 24-hour opening use 00:00 to 24:00. Replaces all existing regular hours.
Set the weekly opening hours of the connected Google Business Profile location. Provide one period per continuous open span (a day may have several, e.g. before and after a lunch break; days with no period are shown as closed). For 24-hour opening use 00:00 to 24:00. Replaces all existing regular hours.
Set Special Hours Set exceptional opening hours of the connected Google Business Profile location for specific dates (holidays, events). Each period is a date that is either fully closed or open for the given time span. Replaces all existing special hours, so include every upcoming exceptional date in one call; regular hours are not affected.
Set exceptional opening hours of the connected Google Business Profile location for specific dates (holidays, events). Each period is a date that is either fully closed or open for the given time span. Replaces all existing special hours, so include every upcoming exceptional date in one call; regular hours are not affected.
Set Open Status Mark the connected Google Business Profile location as OPEN or CLOSED_TEMPORARILY (e.g. for renovations). A temporarily closed location stays on Google with a "Temporarily closed" label. Reversible by calling this action with the other status.
Mark the connected Google Business Profile location as OPEN or CLOSED_TEMPORARILY (e.g. for renovations). A temporarily closed location stays on Google with a "Temporarily closed" label. Reversible by calling this action with the other status.
Google My Business Fields
Google My Business LocalPosts fields
The LocalPosts report of the Google My Business connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| post_create_time | Post Create Time | Time of the creation of the local post. | |
| post_cta_action_type | TEXT | Post CTA Action Type | The type of action for the call-to-action button on the local post (e.g. LEARN_MORE, BOOK, ORDER, SHOP, SIGN_UP, CALL). |
| post_cta_url | TEXT | Post CTA URL | The URL that users are sent to when clicking through the local post call-to-action. |
| post_id | TEXT | Post ID | Google identifier for this local post in the form: accounts/{account_id}/locations/{location_id}/localPosts/{local_post_id}. |
| post_language_code | TEXT | Post Language Code | The language of the local post. |
| post_media_format | TEXT | Post Media Format | The format of the media item associated with the local post (e.g. PHOTO, VIDEO). |
| post_media_google_url | IMAGE_URL | Post Media Google URL | Google-hosted URL for the media item associated with the local post. |
| post_media_id | TEXT | Post Media ID | The resource name for the media item associated with the local post. In the form: accounts/{account_id}/locations/{location_id}/media/{media_key}. |
| post_scheduled_time | Post Scheduled Time | The scheduled publish time of the local post. | |
| post_search_url | TEXT | Post URL on Google Search | The link to the local post in Google search. This link can be used to share the post via social media, email, text, etc. |
| post_state | TEXT | Post State | The state of the post, indicating what part of its lifecycle it is in (e.g. LIVE, REJECTED, PROCESSING). |
| post_summary | TEXT | Post Summary | Description/body of the local post. |
| post_topic_type | TEXT | Post Topic Type | The topic type of the post (STANDARD, EVENT, OFFER, ALERT). |
| post_update_time | Post Update Time | Time of the last modification of the local post made by the user. |
Google My Business Media fields
The Media report of the Google My Business connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| media_category | TEXT | Media Category | The gallery category the media item is associated with (e.g. COVER, PROFILE, ADDITIONAL). |
| media_create_time | Media Create Time | Time of the creation of the media item. | |
| media_format | TEXT | Media Format | The format of the media item (e.g. PHOTO, VIDEO). |
| media_google_url | IMAGE_URL | Media Google URL | Google-hosted URL for the media item. |
| media_height_pixels | NUMERIC | Media Height Pixels | The height of the media item in pixels. |
| media_id | TEXT | Media ID | The resource name for the media item in the location's gallery in the form: accounts/{account_id}/locations/{location_id}/media/{media_key}. |
| media_thumbnail_url | IMAGE_URL | Media Thumbnail URL | Google-hosted URL for a thumbnail of the media item. |
| media_view_count | NUMERIC | Media View Count | The number of times the media item has been viewed. |
| media_width_pixels | NUMERIC | Media Width Pixels | The width of the media item in pixels. |
Google My Business Reviews fields
The Reviews report of the Google My Business connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| review_average_rating | NUMERIC | Review Average Rating | Average star rating within the selected time frame |
| review_average_rating_total | NUMERIC | Review Total Average Rating | Total average star rating |
| review_comment | TEXT | Review Comment | The body of the review as plain text with markups. |
| review_count | NUMERIC | Review Count | The number of reviews within the selected time frame |
| review_create_time | Review Create Time | The date for when the review was written. | |
| review_id | TEXT | Review ID | The encrypted unique identifier. |
| review_media_urls | TEXT | Review Media URLs | Comma-separated FIFE URLs of the photos (or video thumbnails) the reviewer attached to the review. |
| review_reply_comment | TEXT | Review Reply Comment | The body of the review reply as plain text with markups. |
| review_reply_update_time | Review Reply Update Time | The time of the review reply update. | |
| review_reviewer | TEXT | Reviewer | The author of the review. |
| review_reviewer_profile_photo | IMAGE_URL | Reviewer Profile Photo URL | The profile photo of the author of the review. |
| review_star_rating | TEXT | Review Star Rating | The star rating of the review. |
| review_total_count | NUMERIC | Review Total Count | The total number of reviews |
| review_update_time | Review Update Time | The date for when the review was last modified. |
Google My Business other fields
The Google My Business connector has 105 fields that do not belong to a named report, or belong to a report with only one or two fields.
Google My Business other fields (account_id to location_id)
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The ID that can be used for account selection. | |
| account_name | TEXT | Account Name | Business real-world name, as used consistently on storefront, website, and stationery, and as known to customers. | |
| account_number | TEXT | Account Number | Account reference number if provisioned. | |
| account_permission_level | TEXT | Account Permission Level | Specifies the permission level the user has for this account. | |
| account_role | TEXT | Account Role | Specifies the AccountRole of this account. | |
| account_type | TEXT | Account Type | Contains the type of account. Accounts of type PERSONAL and ORGANIZATION cannot be created using this API. | |
| account_verification_state | TEXT | Account Verification State | If verified, future locations that are created are automatically connected to Google Maps, and have Google+ pages created, without requiring moderation. | |
| account_vetted_state | TEXT | Account Vetted State | Indicates whether the account is vetted by Google. A vetted account is able to verify locations via the VETTED_PARTNER method. | |
| business_bookings | NUMERIC | Business Bookings | The number of bookings received from the business profile. | |
| business_food_menu_clicks | NUMERIC | Business Food Menu Clicks | The number of clicks to view or interact with the menu content on the business profile. Multiple clicks by a unique user within a single day are counted as 1. | |
| business_food_orders | NUMERIC | Business Food Orders | The number of food orders received from the business profile. | |
| call_clicks | NUMERIC | Call Clicks | The number of times the business profile call button was clicked. | |
| clicks | NUMERIC | Clicks | The Number of Clicks (call_clicks + website_clicks) | |
| conversations | NUMERIC | (Deprecated) Conversations | The number of message conversations received on the business profile. Deprecated due to the shutdown of the chat feature in Google Business Profile. | |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | The Date | |
| day_of_month | TEXT | Day of month | Day of the month | |
| direction_requests | NUMERIC | Direction Requests | The number of times a direction request was requested to the business location. | |
| google_account_id | TEXT | Google Account ID | The resource name, in the format accounts/{account_id}. | |
| impressions | NUMERIC | Impressions | The Number of Impressions (Maps + Search) (Desktop + Mobile) | |
| impressions_desktop_maps | NUMERIC | Impressions Desktop Maps | Business impressions on Google Maps on Desktop devices. Multiple impressions by a unique user within a single day are counted as a single impression. | |
| impressions_desktop_search | NUMERIC | Impressions Desktop Search | Business impressions on Google Search on Desktop devices. Multiple impressions by a unique user within a single day are counted as a single impression. | |
| impressions_mobile_maps | NUMERIC | Impressions Mobile Maps | Business impressions on Google Maps on Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression. | |
| impressions_mobile_search | NUMERIC | Impressions Mobile Search | Business impressions on Google Search on Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression. | |
| location_additional_categories | OBJECT | Location Additional Categories | Additional categories to describe your business. Categories help your customers find accurate, specific results for services they're interested in. | |
| location_additional_phones | OBJECT | Location Additional Phones | Up to two phone numbers (mobile or landline, no fax) at which your business can be called, in addition to your primary phone number. | |
| location_address_administrative_area | TEXT | Location Address Administrative Area | A precise, accurate address to describe your business location. Highest administrative subdivision which is used for postal addresses of a country or region. For example, this can be a state, a province, an oblast, or a prefecture. Specifically, for Spain this is the province and not the autonomous community (e.g. "Barcelona" and not "Catalonia"). Many countries don't use an administrative area in postal addresses. E.g. in Switzerland this should be left unpopulated. | |
| location_address_language_code | TEXT | Location Address Language Code | A precise, accurate address to describe your business location. BCP-47 language code of the contents of this address (if known). This is often the UI language of the input form or is expected to match one of the languages used in the address' country/region, or their transliterated equivalents. This can affect formatting in certain countries, but is not critical to the correctness of the data and will never affect any validation or other non-formatting related operations. Examples: "zh-Hant", "ja", "ja-Latn", "en". | |
| location_address_lines | OBJECT | Location Address Lines | A precise, accurate address to describe your business location. Unstructured address lines describing the lower levels of an address. | |
| location_address_locality | TEXT | Location Address Locality | A precise, accurate address to describe your business location. Generally refers to the city/town portion of the address. Examples: US city, IT comune, UK post town. In regions of the world where localities are not well defined or do not fit into this structure well, leave locality empty and use addressLines. | |
| location_address_organization | TEXT | Location Address Organization | A precise, accurate address to describe your business location. The name of the organization at the address. | |
| location_address_postal_code | TEXT | Location Address Postal Code | A precise, accurate address to describe your business location. Postal code of the address. Not all countries use or require postal codes to be present, but where they are used, they may trigger additional validation with other parts of the address (e.g. state/zip validation in the U.S.A.). | |
| location_address_recipients | OBJECT | Location Address Recipients | A precise, accurate address to describe your business location. The recipient at the address. This field may, under certain circumstances, contain multiline information. For example, it might contain "care of" information. | |
| location_address_region_code | REGION | Location Address Region Code | A precise, accurate address to describe your business location. CLDR region code of the country/region of the address. See https://cldr.unicode.org/ and https://www.unicode.org/cldr/charts/30/supplemental/territory_information.html for details. Example: "CH" for Switzerland. | |
| location_address_sorting_code | TEXT | Location Address Sorting Code | A precise, accurate address to describe your business location. Additional, country-specific, sorting code. This is not used in most regions. Where it is used, the value is either a string like "CEDEX", optionally followed by a number (e.g. "CEDEX 7"), or just a number alone, representing the "sector code" (Jamaica), "delivery area indicator" (Malawi) or "post office indicator" (e.g. Côte d'Ivoire). | |
| location_address_sublocality | TEXT | Location Address Sublocality | A precise, accurate address to describe your business location. Sublocality of the address. For example, this can be neighborhoods, boroughs, districts. | |
| location_adwords_ad_phone | TEXT | Location Adwords Ad Phone | Additional information that is surfaced in AdWords. An alternate phone number to display on AdWords location extensions instead of the location's primary phone number. | |
| location_attributes | OBJECT | Location Attributes | All attributes set on the location, e.g. amenities, payment options, accessibility, appointment links. Each entry carries the attribute resource name, value type and current values. | |
| location_id | TEXT | Location ID | Google identifier for this location in the form: locations/{locationId}. |
Google My Business other fields (location_label_1 to location_service_area)
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| location_label_1 | TEXT | Location Label 1 | Free-form string 1 to allow you to tag your business. | |
| location_label_10 | TEXT | Location Label 10 | Free-form string 10 to allow you to tag your business. | |
| location_label_2 | TEXT | Location Label 2 | Free-form string 2 to allow you to tag your business. | |
| location_label_3 | TEXT | Location Label 3 | Free-form string 3 to allow you to tag your business. | |
| location_label_4 | TEXT | Location Label 4 | Free-form string 4 to allow you to tag your business. | |
| location_label_5 | TEXT | Location Label 5 | Free-form string 5 to allow you to tag your business. | |
| location_label_6 | TEXT | Location Label 6 | Free-form string 6 to allow you to tag your business. | |
| location_label_7 | TEXT | Location Label 7 | Free-form string 7 to allow you to tag your business. | |
| location_label_8 | TEXT | Location Label 8 | Free-form string 8 to allow you to tag your business. | |
| location_label_9 | TEXT | Location Label 9 | Free-form string 9 to allow you to tag your business. | |
| location_labels | OBJECT | Location Labels | A collection of free-form strings to allow you to tag your business. These labels are NOT user facing; only you can see them. Must be between 1-255 characters per label. | |
| location_language_code | TEXT | Location Language Code | The language of the location. Set during creation and not updateable. | |
| location_latitude | TEXT | Location Latitude | The latitude in degrees. It must be in the range [-90.0, +90.0]. | |
| location_longitude | TEXT | Location Longitude | The longitude in degrees. It must be in the range [-180.0, +180.0]. | |
| location_metadata_can_delete | BOOLEAN | Location Metadata Can Delete | Additional non-user-editable information. Indicates whether the location can be deleted using the API. | |
| location_metadata_can_have_business_calls | BOOLEAN | Location Metadata Can Have Business Calls | Additional non-user-editable information. Indicates if the listing is eligible for business calls. | |
| location_metadata_can_have_food_menus | BOOLEAN | Location Metadata Can Have Food Menus | Additional non-user-editable information. Indicates if the listing is eligible for food menu. | |
| location_metadata_can_modify_service_list | BOOLEAN | Location Metadata Can Modify Service List | Additional non-user-editable information. Indicates if the listing can modify the service list. | |
| location_metadata_can_operate_health_data | BOOLEAN | Location Metadata Can Operate Health Data | Additional non-user-editable information. Indicates whether the location can operate on Health data. | |
| location_metadata_can_operate_local_post | BOOLEAN | Location Metadata Can Operate Local Post | Additional non-user-editable information. Indicates if the listing can manage local posts. | |
| location_metadata_can_operate_lodging_data | BOOLEAN | Location Metadata Can Operate Lodging Data | Additional non-user-editable information. Indicates whether the location can operate on Lodging data. | |
| location_metadata_duplicate_location | TEXT | Location Metadata Duplicate Location | Additional non-user-editable information. The location resource that this location duplicates. | |
| location_metadata_has_google_updated | BOOLEAN | Location Metadata Has Google Updated | Additional non-user-editable information. Indicates whether the place ID associated with this location has updates that need to be updated or rejected by the client. | |
| location_metadata_has_pending_edits | BOOLEAN | Location Metadata Has Pending Edits | Additional non-user-editable information. Indicates whether any of this Location's properties are in the edit pending state. | |
| location_metadata_has_voice_of_merchant | BOOLEAN | Location Metadata Has Voice Of Merchant | Additional non-user-editable information. Indicates if the listing has Voice of Merchant. If this boolean is false, you should call the locations.getVoiceOfMerchantState API to get details as to why they do not have Voice of Merchant. | |
| location_metadata_maps_uri | TEXT | Location Metadata Maps URI | Additional non-user-editable information. A link to the location on Maps. | |
| location_metadata_new_review_uri | TEXT | Location Metadata New Review URI | Additional non-user-editable information. A link to the page on Google Search where a customer can leave a review for the location. | |
| location_metadata_place_id | TEXT | Location Metadata Place ID | Additional non-user-editable information. If this location appears on Google Maps, this field is populated with the place ID for the location. This ID can be used in various Places APIs. | |
| location_more_hours | OBJECT | Location More Hours | More hours for a business's different departments or specific customers. | |
| location_open_info_can_reopen | TEXT | Location Open Info Can Reopen | A flag that indicates whether the location is currently open for business. Indicates whether this business is eligible for re-open. | |
| location_open_info_opening_date_day | TEXT | Location Open Info Opening Date Day | A flag that indicates whether the location is currently open for business. The date on which the location first opened. If the exact day is not known, month and year only can be provided. | |
| location_open_info_opening_date_month | TEXT | Location Open Info Opening Date Month | A flag that indicates whether the location is currently open for business. The date on which the location first opened. If the exact day is not known, month and year only can be provided. | |
| location_open_info_opening_date_year | TEXT | Location Open Info Opening Date Year | A flag that indicates whether the location is currently open for business. The date on which the location first opened. If the exact day is not known, month and year only can be provided. | |
| location_open_info_status | TEXT | Location Open Info Status | A flag that indicates whether the location is currently open for business. Indicates whether or not the Location is currently open for business. All locations are open by default, unless updated to be closed. | |
| location_primary_category_id | TEXT | Location Primary Category ID | Category that best describes the core business this location engages in. A stable ID (provided by Google) for this category. | |
| location_primary_category_name | TEXT | Location Primary Category Name | Category that best describes the core business this location engages in. The human-readable name of the category. | |
| location_primary_phone | TEXT | Location Primary Phone | A phone number that connects to your individual business location as directly as possible. Use a local phone number instead of a central, call center helpline number whenever possible. | |
| location_profile_description | TEXT | Location Profile Description | Describes your business in your own voice and shares with users the unique story of your business and offerings. Description of the location in your own voice, not editable by anyone else. | |
| location_regular_hours_periods | OBJECT | Location Regular Hours Periods | Operating hours for the business. | |
| location_service_area | OBJECT | Location Service Area | Service area businesses provide their service at the customer's location. If this business is a service area business, this field describes the area(s) serviced by the business. |
Google My Business other fields (location_service_items to year_week_iso)
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| location_service_items | OBJECT | Location Service Items | List of services supported by merchants. A service can be haircut, install water heater, etc. Duplicated service items will be removed automatically. | |
| location_special_hours_periods | OBJECT | Location Special Hours Periods | Special hours for the business. This typically includes holiday hours, and other times outside of regular operating hours. | |
| location_store_code | TEXT | Location Store Code | External identifier for this location, which must be unique within a given account. This is a means of associating the location with your own records. | |
| location_title | TEXT | Location Title | Location name should reflect your business's real-world name, as used consistently on your storefront, website, and stationery, and as known to customers. | |
| location_website_uri | TEXT | Location Website URI | A URL for this business. If possible, use a URL that represents this individual business location instead of a generic website/URL that represents all locations, or the brand. | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| parent_account_name | TEXT | Parent Account Name | The name of the account. For an account of type PERSONAL, this is the first and last name of the user account. | |
| search_keyword | TEXT | Search Keyword | The search keywords used to find a business in search or maps. The lower-cased string that the user entered. | |
| search_keyword_threshold | NUMERIC | Search Keyword Threshold | A threshold that indicates that the actual value is below this threshold. Either search_keyword_value or search_keyword_threshold is present. | |
| search_keyword_value | NUMERIC | Search Keyword Value | The sum of the number of unique users that used the keyword in a month, aggregated for each month requested. Either search_keyword_value or search_keyword_threshold is present. If search_keyword_value < search_keyword_threshold then API returns 0 for search_keyword_value. | |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| website_clicks | NUMERIC | Website Clicks | The number of times the business profile website was clicked. | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
