Weld logo
UnknownAugust 21, 20242 min read

New Connector Alert - Google My Business Profile

Author image
by Pedro Prazeres
Sync your Google My Business Profile data directly to your data warehouse

New Connector Alert 🚨

Looking to optimize your Google My Business Profile reporting? With our new ETL connector, you can effortlessly integrate your Google My Business Profile data with all your other data sources. Create a comprehensive view of your business metrics, enhance your analytics, and make more informed decisions with ease!

What data can I get from Google My Business Profile?

  • account
  • account_location
  • account_location_regular_hour_period
  • account_location_primary_category_more_hour_type
  • account_location_primary_category_service_type
  • local_post
  • local_post_media
  • location_admin
  • review
  • media

How can I set up the Google My Business Profile connector in Weld?

  1. Authorize the Connector

    • Click on 'New Connector' and select 'Google My Business Profile' from the list.
    • Allow access to your Google account.
  2. Select the desired tables

    • Choose the tables you would like to sync with Weld.
    • Alternatively, click 'select all tables' to include them all.
  3. Set Sync Schedule

    • Set the frequency at which new data should be synced from Google My Business Profile to your destination.
Google My Business reverse-etl setup

How does Weld work?

After setting up the Google My Business Profile connector, Weld extracts data from Google on a set schedule and then syncs it directly into your data warehouse.

What Metrics can I create from my Google My Business Data?

  • Profile Views per Location
  • Review count per Location
  • Average Review Rating per Location
  • Review Response Rate
  • Post Engagement
  • Total Number of Posts/Locations/Reviews
  • Service Availability per Location
  • Media Views per Location
  • Business Hours Completion
  • Admin Response Time
Google My Business reverse-etl setup

What can I do with my Google My Business Profile Data?

  • Get insights into customer behavior and business performance using Ed, our AI SQL assistant.
  • Combine with your other data sources in our SQL Editor.
  • Visualize in any BI Tool for actionable insights.

Sign up to Weld

Ready to start transforming your data into insights? Get started with Weld for free today.

Continue reading

Weld Product Updates – November 2025 image

November 28, 2025

Weld Product Updates – November 2025

This month at Weld, we launched new connectors for Notion, LinkedIn Company Pages, and LaunchDarkly, introduced BigQuery partitioning and clustering, and delivered improvements acr…

Discrepancies in Microsoft Ads image

November 25, 2025

Discrepancies in Microsoft Ads

Microsoft Ads dashboards and your reporting tools can tell different stories. Learn why data discrepancies happen, what causes mismatched metrics, and how to troubleshoot them effe…

Loved by data teams from around the world

Get started with Weld

Spend less time managing data and more time getting real insights.