How to Export CSV Data from Google Business Profile and Import It into clariBI

Google Business Profile (formerly Google My Business) provides valuable insights into how customers find and interact with your local business listing on Google Search and Maps. Exporting this data into clariBI enables AI analysis of visibility trends, customer actions, and local search performance.

What You Can Export from Google Business Profile

• Search query data showing how customers find your listing
• Total searches, views, and impressions over time
• Customer actions (website clicks, direction requests, phone calls)
• Photo views and photo quantity comparisons
• Business profile views on Search vs. Maps
• Review count and rating data
• Popular times and visit duration estimates
• Messaging and booking interaction metrics

Export CSV Data from Google Business Profile

Method 1: Performance Insights Download

1. Go to business.google.com and sign in with your Google account
2. In Business Profile Manager, select the checkbox next to the business profile(s) you want to export data for
3. Click Actions Insights in the top right area of the page
4. Select your desired timeframe (options include 7, 30, or 90 days, or a custom date range)
5. Click Download Report to export your performance data as a CSV file
6. The file will include metrics such as searches, views, and customer actions for the selected period

Method 2: Bulk Export (Multiple Locations)

1. Go to business.google.com
2. In Business Profile Manager, select the checkboxes next to multiple business profiles
3. Click Actions Insights in the top right area
4. Select the timeframe (7, 30, or 90 days, or a custom date range)
5. Click Download Report to export a CSV covering all selected locations

Tips for Clean Exports

• Export data regularly to track trends over time — available date ranges include 7, 30, 90 days, or custom ranges
• Download data for all metrics at once rather than exporting individual metrics separately, so clariBI can correlate actions with visibility
• For multi-location businesses, bulk exports are far more efficient and let clariBI compare performance across locations

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "Google Business Profile - Performance 2024")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "How have search impressions and direction requests trended month over month?"
- "Which customer actions are growing the fastest — calls, website clicks, or directions?"
- "Compare performance across all my business locations and identify the top performers"

clariBI's AI will automatically analyze your data and suggest relevant insights.