Note: This article contains references to Advanced Web Ranking Desktop, a version that is no longer under active development. 

Integrating a new software solution in big companies, with an already established business background, is always a challenge. There are lots of things to consider: compatibility with the existing solutions, impact on the workflow, new learning curve for users and so on.

Likewise, software integrators in SEO agencies and large brands, that have their own SEO teams, tend to overthink even the smallest change into their giant system’s equilibrium.

This happens especially with companies using in-house developed solutions, spread across all departments. Often, even if they really like the functionalities of a new SEO software they just learned about,  the decision is to sacrifice the benefits that tool would bring only to avoid rethinking their entire workflow.

But, what if they could just grab those benefits directly into their customized systems?

Get Google Location and Universal Search results into your own dashboards

Imagine that!

With Advanced Web Ranking 8.7, you can export rankings and enjoy the benefits of powerful SEO features within the familiar work frame of your own interface.

And the best thing about this is that, since AWR is a desktop based application, you get all the data whenever you need it, without depending on the update frequency of an external web service.

Let me give you some quick insights of the ranking data you can import from AWR:

  • Customized location narrowed down to city level

Gathering location based rankings is crucial in obtaining accurate reports for your websites’ positions in Google. However, the search engine’s IP detection system always influences the result lists. You can see this with a simple search in browser.

For example, if you search for Mambo from a USA location, and then repeat the search using a proxy server with an Italian IP address, the results are different. This can become problematic if you are monitoring rankings for customers that are based in other countries.

But, in Advanced Web Ranking, you can define your specific Google Locations according to the country, region or city you are targeting, and further retrieve rankings that are relevant for those locations.

  • Universal search results detailed by type

Another thing that influences the SERPs is Google’s way of blending different types of results in the same page. If you take a closer look at the results from the previous search in browser, you can see several Mambo Video, Images and News results mingled with the ordinary Web results.

This is part of the Google Universal Search strategy, which totally changes the positions web pages are assigned in the result lists.

To easily track down the effectiveness of different content types on your website, you need reports with results detailed by Organic, Image, Video, News or Shopping type. This is achieved in AWR with the Google Universal search engines, that you can add to your projects.

Now, all there’s left to do is to let AWR gather all this precious information for you and then automatically import it into your database.

1, 2, 3…Mambo!

Is it really that simple?

Yes!  And the best part is you can set the whole process on auto-pilot with a few easy steps.

Let me show you how this works:

  1. Create the Export Template

Once you’ve installed AWR and created a project with your websites and the targeted keywords and search engines, you need to create the Export template that the application will use to further generate the ranking data file.

To create the template, just go to  Data -> Export -> New Export. In the newly opened wizard, make sure you select the Website Rankings export type, and the CSV file format. Then just press the Create button and choose a name for your template.

By default, this export template will take into account the ranking data gathered during the last update, for all websites, keywords and search engines added in your project.

You can further customize your export template and choose the specific date range, websites, keywords and search engines for which you want to see the data. To do this, just open the Export template you created in Edit mode, and further make the changes you need in each section available.

To see how your export file will look like, all you need to do is to press on the Preview button from the top – left side of the window.

  1. Enter the command to be executed after the export

Once you are happy with the settings of your export, you need to enter the command that will be executed automatically after the export is generated.  This is where you create the actual bond between AWR and your in-house solution.

To enter the command, go to the “Output and Layout options” section of the Export template and check the “Execute command after report generation” check box. Then, just enter the command that ensures the content of the exported file will be imported into your database.

  1. Set up a scheduled update task in AWR

The next step in making the AWR export process automatic is to create the scheduled task that runs the project updates and gathers rankings automatically for your websites.

This is done in AWR using the Scheduler wizard, where you can set the start date, start time and frequency of your updates, according to your own needs.

Here is a short video tutorial that shows you exactly how to set up the scheduled task.

In the last step, you will need to choose the Export template you’ve just created from the Selected Reports drop down list. This will tell the application to generate your export after each scheduled project update.

While your scheduled project updates are running, you need to make sure that the machine where AWR is installed is turned on. The application does not need to be running at that time though.

Test the whole system and enjoy the freedom of automatic updates

Before going Live with the export – import process, it is recommended to run a quick test and check how the connection between AWR and your system works. This is the part where you get to see the AWR export capability in action.

To do this, you can create a test scheduled task that is set to run only one time, in the next five minutes. In the Scheduler wizard, make sure you select the Export template that you plan to further use during the automatic export – import process.

You can monitor the update in the application, from the Update progress screen.

Here, you get to see an estimated progress of your task, and also the status of completion.

Once the task is finished, check your database for the newly gathered rankings.


This is it! Now you can sit back and enjoy a good cup of coffee, while AWR gathers valuable ranking data and sends it automatically to your own in-house system.

Take advantage of the free 30 days trial version  and see for yourself the benefits that AWR can drive for your SEO teams, without affecting your departments’ workflow. Everything will be stored on your own network, so the integrity of your data and the updates frequency will be entirely in your own hands.

I hope you have enjoyed reading this article. I am looking forward to reading about your experiences shared in the comments section below.

  1. I like to gather the data with AWR and the export was not so a big problem. But an Import-Api for Keywords will be nice.
    One way can be, that i have an import-task in AWR, which request an xml or csv-file from a specific-url and import the keywords from this file to the current project.

Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like