Google My Business Connector Reference

22 metrics120 dimensions

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.

Parameters
summarystringRequiredphoto_urlstringcta_typestringcta_urlstringlanguage_codestring
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).

Parameters
post_idstringRequiredsummarystringphoto_urlstringcta_typestringcta_urlstring
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.

Parameters
review_idstringRequiredcommentstringRequired
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).

Parameters
photo_urlstringRequiredcategorystring
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.

Parameters
descriptionstringwebsite_urlstringprimary_phonestring
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.

Parameters
service_itemsarrayRequired
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.

Parameters
primary_category_idstringRequiredadditional_category_idsarray
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.

Parameters
business_typestringRequiredplacesarrayRequired
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.

Parameters
attributesarrayunset_attribute_idsarray
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).

Parameters
region_codestringRequiredaddress_linesarrayRequiredlocalitystringpostal_codestringadministrative_areastringacknowledge_reverification_riskboolean
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.

Parameters
periodsarrayRequired
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.

Parameters
periodsarrayRequired
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.

Parameters
statusstringRequired

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 TIMESTAMP 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 TIMESTAMP 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 TIMESTAMP 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 TIMESTAMP 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 TIMESTAMP 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 TIMESTAMP 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 TIMESTAMP 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 TIMESTAMP 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.
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.
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 TIMESTAMP 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