How to connect AccuRanker data into DashThis with the CSV import?

By using the CSV automatic import, you can easily import your AccuRanker data into DashThis without any manual intervention.

AccuRanker is a well-known SEO platform allowing to track your keyword rankings and your organic visibility, along with your competitors'.

Unfortunately, AccuRanker is not a native integration in DashThis.  But by using the CSV import, and with little effort, you can access the same exact data and display it into your reports.

If you've never used the CSV import feature in DashThis, we recommend you to read this article to learn the basics.

 

1- Download your AccuRanker data

2- Create your CSV template

3- Add your AccuRanker data in your reports

 

1- Download your AccuRanker data

 

  • Download a CSV file from AccuRanker by creating a report and selecting the CSV as the report type.
, Importing Data from AccuRanker to DashThis
  • Get your file ready: simply insert a row with a Customer ID. This box is case sensitive, so be sure to write the name the same way every time.
    The Customer ID is the name of your file, and how it will appear in the system. This is equivalent to the source name in other integrations.
, Importing Data from AccuRanker to DashThis
 

2- Create your CSV template

 

  • Log in to DashThis and create a CSV template.
  • Select CSV files, add a new template. Then upload the CSV file from AccuRanker.
, Importing Data from AccuRanker to DashThis

  • Follow the simple steps in the screenshots below to set up the template.
    • Under the Header Lines – select 1. 
    • Make sure the Footer Lines stay at 0. 
    • Change the Column Separator to Semicolon.
       
      , Importing Data from AccuRanker to DashThis

    • In the Date section select the Column as a Type and choose Column 2. 
    • Change the date Format to yyyy-mm-dd.

      , Importing Data from AccuRanker to DashThis

    • Now it is time to locate the Customer ID. If you have followed the steps above, it should be in column 1, line 2.

      , Importing Data from AccuRanker to DashThis

  • Add Dimensions and Metrics.
    • In this example, we are adding the Keyword column as our Dimension.

      , Importing Data from AccuRanker to DashThis

    • You can add several metrics, in this case we have chosen Rank as our Metric.

      , Importing Data from AccuRanker to DashThis

  • Give the template a name and save it.

    , Importing Data from AccuRanker to DashThis
 
 

3- Add your AccuRanker data in your reports

 

Once your CSV template is saved, you can simply import your CSV file into one of your dashboards.

You can follow the detailed instructions in our other article.