Configuring Google Business Profile

Basic Settings

Configure the fundamental settings for your export:

• Export Name: A descriptive name to identify your export
• Date Range: Select how much historical data to include:
  • Last day
  • Last 7 days
  • Last 30 days
  • Last 90 days
  • Custom date range

Dimension Tabs

Business Profile exports are organized by dimensions, with each dimension creating a separate tab in your Google Sheet. The interface uses a tab-based layout where you can configure each dimension independently:

Available dimensions include:

• Daily Performance: Daily metrics including views, clicks, calls, direction requests, bookings, and more
• Reviews: Customer reviews with ratings, comments, reply information, and dates
• Customer Media: Customer-uploaded photos and media with attribution and metadata

For each dimension tab, you can:

• Enable/Disable: Choose whether to include this dimension in your export by selecting metrics
• Set Data Handling: Choose whether to append new data or replace existing data
• Select Metrics: Choose which metrics to include for this dimension

Daily Performance Metrics

For the Daily Performance dimension, you can select from the following metrics:

• Views on Maps (Desktop): Number of times your Business Profile appeared on Google Maps for desktop users
• Views on Search (Desktop): Number of times your Business Profile appeared in Google Search results for desktop users
• Views on Maps (Mobile): Number of times your Business Profile appeared on Google Maps for mobile users
• Views on Search (Mobile): Number of times your Business Profile appeared in Google Search results for mobile users
• Messages: Number of messages sent to your business
• Direction Requests: Number of requests for directions to your location
• Phone Calls: Number of phone calls made to your business
• Website Clicks: Number of clicks to your website
• Bookings: Number of bookings made through your Business Profile
• Food Orders: Number of food orders placed (restaurants only)
• Menu Clicks: Number of clicks on your menu (restaurants only)
• Date Exported: Timestamp of when the export was run

Review Metrics

For the Reviews dimension, you can export the following fields:

• Review ID: Unique identifier for each review
• Star Rating: Rating given by the reviewer (1-5 stars)
• Reviewer Name: Display name of the reviewer
• Review Comment: The review text/comment
• Review Reply: Your response to the review (if any)
• Review Creation Time: Full timestamp when the review was created
• Review Creation Date: Date when the review was created
• Review Modification Time: Full timestamp when the review was last modified
• Review Modification Date: Date when the review was last modified
• Review Reply Time: Full timestamp when you replied to the review
• Date Exported: Timestamp of when the export was run

Customer Media Metrics

For the Customer Media dimension, you can export the following fields:

• Media ID: Unique identifier for the media item
• Media Format: Type of media (photo, video, etc.)
• Customer Media URL: Direct URL to the media item
• Thumbnail URL: URL to the thumbnail version
• Width (px): Width of the media in pixels
• Height (px): Height of the media in pixels
• Contributor Name: Name of the customer who uploaded the media
• Contributor Photo URL: Profile photo URL of the contributor
• Upload Time: When the media was uploaded
• Date Exported: Timestamp of when the export was run

Data Handling

For each dimension tab, you can choose how to handle the exported data:

• Replace (default): Each export run will clear existing data and replace it with new data
• Append: Each export run will add new data rows without removing existing data

The append option is particularly useful for building historical datasets. When enabled, new data will be added to existing rows rather than replacing them, allowing you to track changes over time.