Skip to main content
All CollectionsAdvanced Web Ranking Integrations
How to configure AWR for seamless data exports to BigQuery
How to configure AWR for seamless data exports to BigQuery

Use AWR direct connector for automatic data exports to BigQuery. Learn the benefits, setup process, and tips for optimizing storage costs.

Larisa Rosu avatar
Written by Larisa Rosu
Updated over a week ago

Integrate Advanced Web Ranking with Google BigQuery to supercharge your SEO data management and analysis. Our direct connector allows you to automatically extract and upload your AWR data - including Ranking, Visibility, and/or Market Share - into a Google BigQuery data warehouse.

This integration streamlines your workflow by reducing reporting time, thanks to automatic daily bulk data exports.

By centralizing your AWR metrics in BigQuery, you gain an efficient way to access and manage large data sets. This setup not only minimizes the effort needed for data upload but also consolidates all your SEO data into a single location, enabling advanced analysis and comprehensive reporting.

Requirements

AWR subscription: To use this feature, you need an AWR subscription at the monthly Enterprise level or any yearly plan.

Familiarity with Google Cloud and BigQuery: Basic knowledge of the Google Cloud platform and the BigQuery service is necessary.

BigQuery storage and query costs

Using BigQuery may incur charges for storage and query operations. Each Google Cloud project is associated with a billing account that will be charged for BigQuery operations and storage.

BigQuery offers a free free usage tier and certain free operations. However, any usage beyond the free tier will be billed. You can monitor your usage and associated costs through the Billing reports in your Google Cloud Console.

Setting up the connection and enabling ongoing data exports

To connect AWR with BigQuery please follow these steps for both applications:

In Google Cloud Console (BigQuery)

Open your Google Cloud Console and select an existing project or create a new one where the AWR data will be exported.

From the sidebar menu, navigate to APIs & Services > Enabled APIs & Services.

Screenshot 2023-07-14 at 14

If BigQuery is not enabled for this project, click + ENABLE APIS AND SERVICES, search for BigQuery API, select it, and then click Enable BigQuery API.

Screenshot 2023-07-14 at 14

In Advanced Web Ranking

Only the superuser (subscription owner) or the Administrators can enable the BigQuery sync in AWR.

After setting up your project on Google Cloud navigate to the Settings > Connectors & API > Google BigQuery view in your AWR account.

Click the Sign in with Google button, then select the email address associated with the Google Cloud project.

Follow the prompts to allow AWR to access your Google account and manage data in your BigQuery.

Screenshot 2023-07-14 at 15

Configure the BigQuery automatic exports by selecting the type of data to be uploaded (Ranking, Visibility, and/or Market Share), the Google Cloud project for data export, and the AWR projects for which the exports should run. When done, click Save Google BigQuery settings.

After enabling the sync, the first batch of AWR data will be uploaded to the selected Cloud project within the next few hours. Subsequent data exports will occur daily until the sync is manually disabled from the Settings > Connectors & API > Google BigQuery section.

AWR data will accumulate in your Cloud project indefinitely. To effectively manage storage costs and avoid unnecessary expenses you can set appropriate partition expiration times in BigQuery.

If you have any further questions, please feel free to contact our support team.

Did this answer your question?