Google BigQuery is a cloud-based data warehouse that uses SQL-like queries to pull insights from data stored in the cloud. After you connect Google BigQuery, you can query your database directly from widgets on your AgencyAnalytics dashboards and reports.

We strongly recommend having a technical resource available to set up your BigQuery integration. The AgencyAnalytics Support Team cannot assist with your setup or with writing queries.

To avoid a failed connection or an error when integrating Google BigQuery to a Client, the person connecting must have:

If you meet the permission requirements above, follow these steps to connect Google BigQuery to a Client.

Step 1: Open the Client where you'd like to connect Google BigQuery, then click the Data Sources tab at the top.

Step 2: Click the blue Connect Data Source button in the upper-right corner of the page.

Step 3: Search for Google BigQuery in the upper-right search box, then click the Google BigQuery card.

Step 4: Click the Connect New Account button in the bottom left.

Step 5: In the pop-up window, log in to the Google account associated with the BigQuery database you'd like to connect to, then follow the prompts in the connection window.

After authorizing the connection, you'll be brought back to the connection page. Select the correct account from those now available.

Once saved, Google BigQuery will be successfully connected! You can start adding BigQuery widgets to your reporting and query data right away.

No, our BigQuery integration is strictly for reading data already stored in BigQuery, so you can visualize it in your AgencyAnalytics reports and dashboards.

If you have any questions, please contact our friendly support team by following these instructions! We're available 24/5 to help 😄