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.

IDTypeNameDescription
post_create_timeTIMESTAMPPost Create TimeTime of the creation of the local post.
post_cta_action_typeTEXTPost CTA Action TypeThe 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_urlTEXTPost CTA URLThe URL that users are sent to when clicking through the local post call-to-action.
post_idTEXTPost IDGoogle identifier for this local post in the form: accounts/{account_id}/locations/{location_id}/localPosts/{local_post_id}.
post_language_codeTEXTPost Language CodeThe language of the local post.
post_media_formatTEXTPost Media FormatThe format of the media item associated with the local post (e.g. PHOTO, VIDEO).
post_media_google_urlIMAGE_URLPost Media Google URLGoogle-hosted URL for the media item associated with the local post.
post_media_idTEXTPost Media IDThe 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_timeTIMESTAMPPost Scheduled TimeThe scheduled publish time of the local post.
post_search_urlTEXTPost URL on Google SearchThe link to the local post in Google search. This link can be used to share the post via social media, email, text, etc.
post_stateTEXTPost StateThe state of the post, indicating what part of its lifecycle it is in (e.g. LIVE, REJECTED, PROCESSING).
post_summaryTEXTPost SummaryDescription/body of the local post.
post_topic_typeTEXTPost Topic TypeThe topic type of the post (STANDARD, EVENT, OFFER, ALERT).
post_update_timeTIMESTAMPPost Update TimeTime 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.

IDTypeNameDescription
media_categoryTEXTMedia CategoryThe gallery category the media item is associated with (e.g. COVER, PROFILE, ADDITIONAL).
media_create_timeTIMESTAMPMedia Create TimeTime of the creation of the media item.
media_formatTEXTMedia FormatThe format of the media item (e.g. PHOTO, VIDEO).
media_google_urlIMAGE_URLMedia Google URLGoogle-hosted URL for the media item.
media_height_pixelsNUMERICMedia Height PixelsThe height of the media item in pixels.
media_idTEXTMedia IDThe 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_urlIMAGE_URLMedia Thumbnail URLGoogle-hosted URL for a thumbnail of the media item.
media_view_countNUMERICMedia View CountThe number of times the media item has been viewed.
media_width_pixelsNUMERICMedia Width PixelsThe width of the media item in pixels.

Google My Business Reviews fields

The Reviews report of the Google My Business connector includes 14 fields.

IDTypeNameDescription
review_average_ratingNUMERICReview Average RatingAverage star rating within the selected time frame
review_average_rating_totalNUMERICReview Total Average RatingTotal average star rating
review_commentTEXTReview CommentThe body of the review as plain text with markups.
review_countNUMERICReview CountThe number of reviews within the selected time frame
review_create_timeTIMESTAMPReview Create TimeThe date for when the review was written.
review_idTEXTReview IDThe encrypted unique identifier.
review_media_urlsTEXTReview Media URLsComma-separated FIFE URLs of the photos (or video thumbnails) the reviewer attached to the review.
review_reply_commentTEXTReview Reply CommentThe body of the review reply as plain text with markups.
review_reply_update_timeTIMESTAMPReview Reply Update TimeThe time of the review reply update.
review_reviewerTEXTReviewerThe author of the review.
review_reviewer_profile_photoIMAGE_URLReviewer Profile Photo URLThe profile photo of the author of the review.
review_star_ratingTEXTReview Star RatingThe star rating of the review.
review_total_countNUMERICReview Total CountThe total number of reviews
review_update_timeTIMESTAMPReview Update TimeThe 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)

IDTypeNameDescriptionReport
account_idTEXTAccount IDThe ID that can be used for account selection.
account_nameTEXTAccount NameBusiness real-world name, as used consistently on storefront, website, and stationery, and as known to customers.
account_numberTEXTAccount NumberAccount reference number if provisioned.
account_permission_levelTEXTAccount Permission LevelSpecifies the permission level the user has for this account.
account_roleTEXTAccount RoleSpecifies the AccountRole of this account.
account_typeTEXTAccount TypeContains the type of account. Accounts of type PERSONAL and ORGANIZATION cannot be created using this API.
account_verification_stateTEXTAccount Verification StateIf verified, future locations that are created are automatically connected to Google Maps, and have Google+ pages created, without requiring moderation.
account_vetted_stateTEXTAccount Vetted StateIndicates whether the account is vetted by Google. A vetted account is able to verify locations via the VETTED_PARTNER method.
business_bookingsNUMERICBusiness BookingsThe number of bookings received from the business profile.
business_food_menu_clicksNUMERICBusiness Food Menu ClicksThe 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_ordersNUMERICBusiness Food OrdersThe number of food orders received from the business profile.
call_clicksNUMERICCall ClicksThe number of times the business profile call button was clicked.
clicksNUMERICClicksThe Number of Clicks (call_clicks + website_clicks)
conversationsNUMERIC(Deprecated) ConversationsThe number of message conversations received on the business profile. Deprecated due to the shutdown of the chat feature in Google Business Profile.
data_fetched_atTIMESTAMPData fetched atUTC 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.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateThe Date
day_of_monthTEXTDay of monthDay of the month
direction_requestsNUMERICDirection RequestsThe number of times a direction request was requested to the business location.
google_account_idTEXTGoogle Account IDThe resource name, in the format accounts/{account_id}.
impressionsNUMERICImpressionsThe Number of Impressions (Maps + Search) (Desktop + Mobile)
impressions_desktop_mapsNUMERICImpressions Desktop MapsBusiness impressions on Google Maps on Desktop devices. Multiple impressions by a unique user within a single day are counted as a single impression.
NUMERICImpressions Desktop SearchBusiness 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_mapsNUMERICImpressions Mobile MapsBusiness impressions on Google Maps on Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression.
NUMERICImpressions Mobile SearchBusiness 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_categoriesOBJECTLocation Additional CategoriesAdditional categories to describe your business. Categories help your customers find accurate, specific results for services they're interested in.
location_additional_phonesOBJECTLocation Additional PhonesUp 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_areaTEXTLocation Address Administrative AreaA 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_codeTEXTLocation Address Language CodeA 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_linesOBJECTLocation Address LinesA precise, accurate address to describe your business location. Unstructured address lines describing the lower levels of an address.
location_address_localityTEXTLocation Address LocalityA 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_organizationTEXTLocation Address OrganizationA precise, accurate address to describe your business location. The name of the organization at the address.
location_address_postal_codeTEXTLocation Address Postal CodeA 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_recipientsOBJECTLocation Address RecipientsA 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_codeREGIONLocation Address Region CodeA 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_codeTEXTLocation Address Sorting CodeA 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_sublocalityTEXTLocation Address SublocalityA precise, accurate address to describe your business location. Sublocality of the address. For example, this can be neighborhoods, boroughs, districts.
location_adwords_ad_phoneTEXTLocation Adwords Ad PhoneAdditional 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_attributesOBJECTLocation AttributesAll 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_idTEXTLocation IDGoogle identifier for this location in the form: locations/{locationId}.

Google My Business other fields (location_label_1 to location_service_area)

IDTypeNameDescriptionReport
location_label_1TEXTLocation Label 1Free-form string 1 to allow you to tag your business.
location_label_10TEXTLocation Label 10Free-form string 10 to allow you to tag your business.
location_label_2TEXTLocation Label 2Free-form string 2 to allow you to tag your business.
location_label_3TEXTLocation Label 3Free-form string 3 to allow you to tag your business.
location_label_4TEXTLocation Label 4Free-form string 4 to allow you to tag your business.
location_label_5TEXTLocation Label 5Free-form string 5 to allow you to tag your business.
location_label_6TEXTLocation Label 6Free-form string 6 to allow you to tag your business.
location_label_7TEXTLocation Label 7Free-form string 7 to allow you to tag your business.
location_label_8TEXTLocation Label 8Free-form string 8 to allow you to tag your business.
location_label_9TEXTLocation Label 9Free-form string 9 to allow you to tag your business.
location_labelsOBJECTLocation LabelsA 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_codeTEXTLocation Language CodeThe language of the location. Set during creation and not updateable.
location_latitudeTEXTLocation LatitudeThe latitude in degrees. It must be in the range [-90.0, +90.0].
location_longitudeTEXTLocation LongitudeThe longitude in degrees. It must be in the range [-180.0, +180.0].
location_metadata_can_deleteBOOLEANLocation Metadata Can DeleteAdditional non-user-editable information. Indicates whether the location can be deleted using the API.
location_metadata_can_have_business_callsBOOLEANLocation Metadata Can Have Business CallsAdditional non-user-editable information. Indicates if the listing is eligible for business calls.
location_metadata_can_have_food_menusBOOLEANLocation Metadata Can Have Food MenusAdditional non-user-editable information. Indicates if the listing is eligible for food menu.
location_metadata_can_modify_service_listBOOLEANLocation Metadata Can Modify Service ListAdditional non-user-editable information. Indicates if the listing can modify the service list.
location_metadata_can_operate_health_dataBOOLEANLocation Metadata Can Operate Health DataAdditional non-user-editable information. Indicates whether the location can operate on Health data.
location_metadata_can_operate_local_postBOOLEANLocation Metadata Can Operate Local PostAdditional non-user-editable information. Indicates if the listing can manage local posts.
location_metadata_can_operate_lodging_dataBOOLEANLocation Metadata Can Operate Lodging DataAdditional non-user-editable information. Indicates whether the location can operate on Lodging data.
location_metadata_duplicate_locationTEXTLocation Metadata Duplicate LocationAdditional non-user-editable information. The location resource that this location duplicates.
location_metadata_has_google_updatedBOOLEANLocation Metadata Has Google UpdatedAdditional 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_editsBOOLEANLocation Metadata Has Pending EditsAdditional non-user-editable information. Indicates whether any of this Location's properties are in the edit pending state.
location_metadata_has_voice_of_merchantBOOLEANLocation Metadata Has Voice Of MerchantAdditional 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_uriTEXTLocation Metadata Maps URIAdditional non-user-editable information. A link to the location on Maps.
location_metadata_new_review_uriTEXTLocation Metadata New Review URIAdditional 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_idTEXTLocation Metadata Place IDAdditional 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_hoursOBJECTLocation More HoursMore hours for a business's different departments or specific customers.
location_open_info_can_reopenTEXTLocation Open Info Can ReopenA 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_dayTEXTLocation Open Info Opening Date DayA 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_monthTEXTLocation Open Info Opening Date MonthA 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_yearTEXTLocation Open Info Opening Date YearA 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_statusTEXTLocation Open Info StatusA 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_idTEXTLocation Primary Category IDCategory that best describes the core business this location engages in. A stable ID (provided by Google) for this category.
location_primary_category_nameTEXTLocation Primary Category NameCategory that best describes the core business this location engages in. The human-readable name of the category.
location_primary_phoneTEXTLocation Primary PhoneA 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_descriptionTEXTLocation Profile DescriptionDescribes 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_periodsOBJECTLocation Regular Hours PeriodsOperating hours for the business.
location_service_areaOBJECTLocation Service AreaService 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)

IDTypeNameDescriptionReport
location_service_itemsOBJECTLocation Service ItemsList of services supported by merchants. A service can be haircut, install water heater, etc. Duplicated service items will be removed automatically.
location_special_hours_periodsOBJECTLocation Special Hours PeriodsSpecial hours for the business. This typically includes holiday hours, and other times outside of regular operating hours.
location_store_codeTEXTLocation Store CodeExternal 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_titleTEXTLocation TitleLocation 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_uriTEXTLocation Website URIA 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.
monthTEXTMonthNumber of the month
nowTIMESTAMPNowCurrent timestamp
parent_account_nameTEXTParent Account NameThe name of the account. For an account of type PERSONAL, this is the first and last name of the user account.
search_keywordTEXTSearch KeywordThe search keywords used to find a business in search or maps. The lower-cased string that the user entered.
search_keyword_thresholdNUMERICSearch Keyword ThresholdA threshold that indicates that the actual value is below this threshold. Either search_keyword_value or search_keyword_threshold is present.
search_keyword_valueNUMERICSearch Keyword ValueThe 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.
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
website_clicksNUMERICWebsite ClicksThe number of times the business profile website was clicked.
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_month_nameTEXTYear month nameYear and month with the month name written out, e.g. "Jan 2025".
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20