Integrating GMBapi.com local data with BigQuery opens powerful new capabilities, enabling advanced data analysis, custom reporting, and seamless integration with your existing tools. This guide walks you step-by-step through setting up the BigQuery integration and maximising its potential for your business.
What You Get with Our BigQuery Integration
With this integration, you can:
- Access organised and structured
- BigQuery tables (no raw data dumps).
- The tables are updated daily with the most recent data from your GBPs.
- Generate your customised Google
- Business Profile reports and insights.
- Integrate our actionable insights directly into your own platform, software, or website.
- Utilise the provided code to replicate the visualisations seen on our website on your reports or on your website!
BigQuery and GMBapi.com Integration Requirements
Before setting up your BigQuery integration, ensure the following:
- You have an active GMBapi.com account with all your locations synced!
- You have an active billing account associated with your Google Cloud Project.
- You have created a service account with the following roles:
- BigQuery Data Editor is Necessary to create/edit a table within your GCP
- BigQuery Job User- Necessary to schedule and execute queries
- Share the service account email and the name(s) of the accounts in app.gmbapi.com that should receive access.
- Once access to the tables is shared, you can schedule queries using the created service account in your own BigQuery project.
Step-by-Step Guide to Set Up BigQuery Integration
*If you have already created a Google Cloud Platform account with billing set up, you can skip to Step 3
Step 1: Create a Google Cloud Project
- Navigate to Google Cloud Platform.
- Create a new project or select an existing one.
Step 2: Set up the Billing Details
- Go to the Google Cloud Console.
- From the left-hand menu, select “Billing” → then click “Manage Billing Accounts”.
- Choose the appropriate organisation (if applicable) and click “Create Account”.
- Enter a name for your billing account, select your country, and connect it to the correct organisation.
- Add a valid payment method and submit to enable billing.
Step 2.1. Link Your Billing Account to the Project
- In the Cloud Console, select the project you want to connect.
- Navigate to the “Billing” section.
- If prompted, select the billing account to link to this project.
- To switch billing accounts later, click “Manage Billing Accounts” and choose the appropriate option.
⚠️ Note: : Without billing enabled, scheduled queries and other BigQuery operations will not run.
Step 3: Create and Configure a Service Account
- In your Google Cloud project, go to IAM & Admin > Service Accounts.
- Click on Create Service Account.
- Name your service account (e.g.,
- “BigQuery Integration“).
Assign the following roles to ensure that the service account has access to schedule queries and create tables within the GCP:- BigQuery Data Editor
- BigQuery Job User
- Complete the service account creation and copy the generated email address.
Step 4: Share the Service Account Email
- Share the service account email with our support team or via your integration management portal.
- In addition, please confirm the GMBapi.com account (GBP location group) you want the service account to access.
- Data is stored per GBP account, and explicit access is required for each one.
Note: If you need access to additional GBP accounts in the future, simply repeat Step 3 onward for each new account.
Step 5: Set Up BigQuery
- Navigate to BigQuery within your Google Cloud Console.
- Create a new dataset or select an existing one.
- Important: Set the dataset region to europe-west4 (Netherlands).
- This is required for transferring data using a scheduled query; the source and destination regions must match. Since GMBapi.com stores data in the Netherlands, your dataset must also be in that region to enable the transfer.
Note: If needed, you can later replicate or migrate your data to another region. Learn more 👉 BigQuery Data Replication
Step 6: Access and Utilise Your Data
Once access is granted, you have two main ways to work with your data:
- Scheduled Queries (Recommended)
Use scheduled queries in your BigQuery project to copy the organised data from GMBapi.com into your own dataset. This ensures long-term access and ownership of the data.
Use the service account credentials when setting up scheduled queries.
- Direct Access via BigQuery API
Alternatively, you can use the service account credentials to access the data directly via the BigQuery API within your code.
✅ Recommendation: For better control, portability, and future-proofing, we recommend creating a copy of the tables within your own GCP project either via scheduled queries or programmatically using the BigQuery API.
Our team will provide ready-to-use SQL templates and visual code snippets to help you get started quickly.
Example Use Cases for BigQuery Integration
Custom Reports
Generate tailored reports specific to your business needs, drilling down into local SEO performance metrics.
Platform Integration
Integrate our insights seamlessly into your CRM, website dashboard, or any analytics platform your business uses.
Advanced Analysis
Leverage BigQuery’s powerful analytical capabilities to spot trends, opportunities, and actionable insights faster than ever.
Getting Help
If you get stuck at any point in the process, our team is here to assist you. Don’t hesitate to reach out if you’re unsure about setting permissions, creating service accounts, or scheduling queries. We’re committed to making your integration process smooth and successful.
Request access to a location group and start a free trial. Then:
- Contact our support team.
- Set up your BigQuery project.
- Ensure your billing account is active.
- Create a service account with the correct roles.
- Share the service account email and relevant app.gmbapi.com account names.
- Begin scheduling queries to retrieve structured data tables.
For detailed assistance, access our comprehensive documentation or contact our support team directly to streamline your BigQuery integration experience.
Embrace the full potential of your local SEO data with our robust BigQuery integration, making smarter, data-driven decisions easier than ever.
FAQs Abour GMBapi.com and BigQuery Intergration
What do I need to set up the BigQuery integration for Google Business Profile data?
To set up the integration, you need an active GMBapi.com account with your locations synced, a Google Cloud Project with billing enabled, and a service account with the correct BigQuery roles. Once these are in place, our team can grant access to structured BigQuery tables that update daily with your Google Business Profile data.
Which roles should I assign to the service account?
The service account must have the BigQuery Data Editor and BigQuery Job User roles. The Data Editor role allows the account to create and edit tables within your project, while the Job User role makes it possible to schedule and execute queries. Without these roles, your integration and data transfers will not function correctly.
Why must my dataset be in europe-west4?
Your dataset must be located in europe-west4 because GMBapi.com stores its data in the Netherlands. Google requires the source and destination regions to match for data transfers to work. If the regions are not aligned, your scheduled queries and data pipelines will fail. If necessary, you can later replicate or migrate the data to a different region, but the initial dataset must be in europe-west4.
How often is my data updated?
The BigQuery tables are updated daily with the most recent data from your Google Business Profiles. This ensures that your analysis, dashboards, and reports always reflect the latest local SEO performance metrics without the need for manual updates.
How can I access my data?
You can access your data in two main ways. The recommended method is to use scheduled queries, which copy the structured tables from GMBapi.com into your own BigQuery project so you maintain long-term control and ownership. Alternatively, you can use the BigQuery API to query the data directly with your service account credentials. Most businesses choose scheduled queries since they provide more flexibility and portability.
Can I integrate the data into my own platform or CRM?
Yes, the integration is designed to work seamlessly with your existing tools. Once your data is available in BigQuery, you can connect it directly to your dashboards, CRM systems, websites, or analytics platforms. Many businesses use this capability to build custom dashboards or integrate insights into their existing workflows.
Who do I contact if I get stuck?
If you encounter any issues, whether with setting up the service account, enabling billing, or scheduling queries, you can contact the GMBapi.com support team. Our team is available to walk you through the process and make sure your integration is running smoothly from start to finish.
