Skip to main content
All CollectionsAdvanced Web Ranking Integrations
Streamline data sharing with third-party platforms using Google Drive integration
Streamline data sharing with third-party platforms using Google Drive integration

Link Advanced Web Ranking with Google Drive to streamline data access, backups, and sharing with third-party platforms like TapClicks.

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

By linking Advanced Web Ranking with Google Drive, you can export essential data either automatically or manually to your Drive. This integration not only facilitates easy access and backup of your AWR data but also streamlines sharing with third-party marketing platforms like TapClicks, enhancing your ability to manage and analyze SEO performance efficiently.

How to enable the Drive sync

  1. Go to the Connectors & API section in your AWR account.

  2. Locate the Google Drive panel and click on Sign in with Google.

  3. Follow the prompts to authorize AWR to access your Google account.

💡You can manage “Sign in with Google” permissions at any time by accessing the Third-party apps & services page while logged into your Google account.

How to upload AWR data to Drive

Once the connection between Advanced Web Ranking and Google Drive is established, you can choose from two upload methods: automatic or manual.

1. Automatic uploads

Setup of automatic uploads

In the Connectors & API section, select your preferred upload option (Upload exports after update or Override old exports), data types (Ranking, Visibility, Top Sites), and the projects for which you would like to upload the data for.

Click on Save Google Drive settings to enable automatic uploads.

The Upload exports after update option adds new data files to Drive after each ranking update, while the Override old exports option replaces previous exports with updated files.

Frequency of automatic uploads

Once the automatic uploads are enabled, AWR data will be uploaded to your Drive following the next ranking update which takes place for each of the selected projects. Further uploads will be performed based on the ranking update frequency chosen for each project. For instance, for daily scheduled projects the uploads will be performed daily, while for weekly scheduled projects the data will be uploaded once a week.

Uploaded data can be accessed from the My Drive > Recent section or the My Drive > Advanced Web Ranking folder, which is automatically created on your Drive with the first upload. Within the Advanced Web Ranking folder, separate folders will be created for each project, containing files for Ranking, Visibility, and/or Top Sites data.

2. Manual uploads

If you prefer not to enable automatic uploads or need to update data on Drive between scheduled exports, you can use the Export menu available in most AWR UI reports. This feature allows you to manually upload the desired data to Drive in either PDF format or as Sheets.

Datasets available for upload to Drive

When using automatic uploads the following datasets can be transferred to Google Drive:

Ranking: The uploaded file includes an array of metrics, such as Position, Best Position, Competition, Monthly Searches, Search Intent, and more, offering an in-depth view of your ranking performance.

Learn more about the Ranking dataset

The Ranking upload file includes the following metric columns:

  • Date: The specific date when the ranking update was completed.

  • Project: The name of the project to which the ranking data belongs. This helps to further identify and easily organize data from different projects.

  • Project Tag: The label assigned to the project for easier organization.

  • Unique: This column is used for the TapClicks integration with AWR. It contains unique keys that enable TapClicks's Smart Connector to accurately interpret and process AWR data while they are synced.

  • Search Engine: The specific search engine(s) from which the ranking data is obtained.

  • Keyword: The specific keyword or phrase for which the ranking position is recorded.

  • Website: The domain that ranks for each keyword.

  • URL: The specific URL on the website that was listed in SERP for each keyword.

  • Position: The ranking position of each keyword on the search results page.

  • Best Historical Position: The highest ranking position that each keyword has ever achieved since it was first updated.

  • Best Historical Date: The update date when each keyword reached its highest historical ranking position.

  • Page: The specific page number on which the keyword appears in the search results (eg. first page, second page, etc.)

  • Type: The specific category of search results (e.g., Organic, Local, Featured Snippets, etc.) for which each keyword appears on the SERP.

  • Search Intent: The primary purpose behind the user's search for the keyword, categorized into types such as Informational (seeking knowledge), Navigational (finding a specific website), Transactional (making a purchase), or Commercial (researching products or services). This helps in understanding what the user is aiming to achieve with their search.

  • Secondary Search Intent: Supplementary purposes related to the search, offering a deeper insight into the user's needs and motivations.

  • Previous Search Intent: The search intent recorded for the keyword during the previous update completed for the project. This helps in tracking changes in user intent between updates.

  • Previous Secondary Search Intent: The secondary search intent recorded during the previous update for the project. This provides context for how secondary search intents have shifted between updates.

  • Average Monthly Searches: The average search volume per month for the keyword.

  • Competition: The level of competition for each keyword, indicating how many other websites are trying to rank for the same keyword. A high competition level means many websites are targeting that keyword, making it harder to achieve a high ranking on the SERPs, while a low competition level means fewer websites are targeting the keyword, making it easier to rank higher.

  • CPC: The cost per click for the keyword in paid search advertising. This metric shows the amount advertisers are willing to pay for each click on ads associated with that keyword. It helps gauge the keyword's commercial value and competitiveness in the advertising market.

Visibility: The uploaded file provides a comprehensive snapshot of your website's performance, featuring a detailed set of Visibility Evolution, Ranking Distribution, and Ranking Comparison metrics. This enables you to see how your visibility is evolving, where your rankings currently stand, and how keyword positions shift between updates.

Learn more about the Visibility dataset

The Visibility upload file includes the following metric columns:

  • Date: The specific date when the ranking update was completed.

  • Project: The name of the project to which the Visibility data belongs. This helps easily organize data from different projects.

  • Project Tag: The label assigned to the project for easier organization.

  • Website: The domain for which the Visibility metrics were computed.

Visibility Evolution metrics:

  • Visibility Score: The website’s overall Visibility Score across all tracked keywords and search engines.

  • Visibility Percent: The website’s overall Visibility Percentage across all tracked keywords and search engines.

  • Average Rank: The average ranking position of the website on the SERP.

  • Market Share: The percentage of Estimated Visits from the total Estimated Visits that the top 20 ranking keywords can generate.

  • Click Share: The percentage of clicks the website could receive from its top 20 ranking keywords.

  • Total Click Share: The percentage of clicks the website could receive from organic search across the entire set of tracked keywords.

  • Estimated Visits: The aproximate number of visits the website may receive during a month, from its top 20 ranking keywords, based on their related Search Volume and Click Share.

  • Local Estimated Visits: The approximate number of visits the website may receive within a month from its keywords ranking locally within the top 20 positions.

  • Search Demand: The count of searches within the last 30 days for the tracked keyword set, as reported by Keyword Planner, across the selected search engine countries.

Ranking Distribution metrics

  • Ranked: The total count of keywords for which the website holds a position in the search results.

  • Not Ranked: The total count of keywords for which the website does not have a position in the search results.

  • First Place: The count of keywords for which the website appeared as the very first result on the SERP

  • Top 3: The count of keywords for which the website appeared in any of the top 3 positions on the SERP.

  • Top 5: The count of keywords for which the website appeared in any of the top 5 positions on the SERP.

  • Top 10: The count of keywords for which the website appeared in any of the top 10 positions on the SERP.

  • Top 20: The count of keywords for which the website appeared in any of the top 20 positions on the SERP.

  • Top 30: The count of keywords for which the website appeared in any of the top 30 positions on the SERP.

  • On First Page: The count of keywords for which the website appeared on the first page of search results.

  • Below First Page: The count of keywords for which the website appeared on pages beyond the first page of search results.

Ranking Comparison metrics:

  • Moved Up: The count of keywords that have improved their ranking position in the search results compared to the previous update.

  • Moved Down: The count of keywords that have declined in their ranking position in the search results compared to the previous update.

  • Added: The number of new keywords for which the website started ranking compared to the previous update.

  • Dropped: The number of keywords for which the website stopped ranking compared to the previous update.

  • Net Gain: The overall increase in keyword rankings compared to the previous update.

  • Net Loss: The overall decrease in keyword rankings compared to the previous update.

Top Sites: The upload file provides an overview of the top-ranking URLs, featuring key metrics to evaluate their performance. It helps you identify the URLs that excel in search results, providing insights into their ranking positions and result types for strategic analysis.

Learn more about the Top Sites dataset

The Top Sites upload file includes the following metric columns:

  • Date: The date when the Top Sites data was updated.

  • Keywords: The keyword or phrase for which the Top Sites data was retrieved.

  • Search Engine: The search engine(s) from which the Top Sites data was obtained.

  • URL: The URL of each Top Site listed in the search results.

  • Position: The ranking position of each Top Site on the search results page.

  • Page: The specific page number where the Top Site appeared in the search results (e.g., first page, second page).

  • Result Type: The category of search results (e.g., Organic, Local, Featured Snippets) where a Top Site appeared on the SERP.

Manual uploads allow you to import data from any report that supports the export to Drive feature. This includes all Ranking reports, Market Share, Difficulty, and other reports.

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


Did this answer your question?