Windsor brings all your Google My Business data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Google My Business Field Reference
Sample
https://connectors.windsor.ai/google_my_business?api_key=<APIKEY>&date_preset=last_7d&fields=date,account_id,account_name,clicks,impressions
Fields
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | The resource name, in the format accounts/{account_id}. |
| account_name | TEXT | Account Name | The name of the account. For an account of type PERSONAL, this is the first and last name of the user account. |
| 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 | Conversations | The number of message conversations received on the business profile. |
| 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. |
| 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_id | TEXT | Location ID | Google identifier for this location in the form: locations/{locationId}. |
| 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. |
| 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 |
| review_average_rating | NUMERIC | Review Average Rating | Average star rating within the selected time frame |
| review_comment | TEXT | Review Comment | The body of the review as plain text with markups. |
| 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_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 within the selected time frame |
| review_update_time | TIMESTAMP | Review Update Time | The date for when the review was last modified. |
| 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_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 |