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 you 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 in 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 to 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.
  • 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. 

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.
  • 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.

    • In the Date section select the Column as a Type and choose Column 2. 
    • Change the date format to yyyy-mm-dd.
    • Now it is time to locate the Customer ID. If you have followed the steps above, it should be in column 1, line 2.

  • Add Dimensions and Metrics.
    • In this example, we are adding the Keyword column as our Dimension.
    • You can add several metrics, in this case, we have chosen Rank as our Metric.

  • Give the template a name and save it.

3- Add your AccuRanker data to 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.