Data Import Tool: Bring all your data into Raven Reports

Written by and published



You asked for it, and we listened!

Here at Raven we pride ourselves on listening to you and giving you the tools you need to give your clients the best possible reports. As Jon said in his Status Report, we spent a significant portion of the last couple of months gauging our customers’ needs through data analysis and direct feedback. One of the most exciting results of this has been a simple but powerful tool: the Data Import Tool.

The Problem

I have client-specific reporting that I need to integrate, but Raven doesn’t have a way for me to include this. What if I want to import my own data or analysis?

The Solution

A Data Import tool that allows you to bring your own data into Raven via a CSV file and seamlessly integrate it as a table into your automated reports! So many problems solved! Here are the most-requested types of data you can now include in Reports because of the Data Import tool:

  • A keyword’s rank movement each month
  • Third-party rankings data
  • Facebook Ads
  • Amazon Seller Marketplace
  • Etsy shops
  • Client-specific analysis
  • Anything you can import from a CSV file

The Example

Ever wanted to show your clients a specific keyword’s ranking over time? Well, this isn’t a capability we can currently give you in Raven, but if you’re doing this keyword research anyway, why not transfer that data to a CSV and upload it through the Data Import tool?

Here’s my data in a Google Sheet:

rankings data in spreadsheet

And here’s the same data in my Raven Report:

Data import in Raven

The Evolution

The Data Import tool currently supports creating tables from CSV files. We hope to add KPIs, line graphs, bar graphs and pie charts in the future.

There’s no firm ETA on when these additional view options will become available, but you can offer suggestions and vote up the ideas you most like within our Ideas Portal. Just log in or sign up for Raven and click Help > Request New Features to offer feedback.

The Steps

What data have you been itching to include in Raven Reports? Here’s the CSV file I used if you want a template. When adding a section to a Raven report, click Data Import.

Import Data into Raven Report

After uploading your CSV file, choose how you’d like the data to be displayed.

Raven Data Import Tool settings

Here are the full steps for using the Data Import tool. Enjoy!

  • Awesome news!!!

    In the past we would export the reports, then modify in Adobe Editor to import additional sheets. Love being able to keep it all in one report!

    • Thanks Conor! And please submit any feature requests you have for. We want to keep making this better.

      • Matteo

        Is there a way to import in your reports the Google Analytics reports that are not still included in yours or even our GA custom reports?
        Besides, what about allowing the insertion if images directly in your reports (not through links to images as I have to do to date)?
        Thanks

        • Seth Kuhn

          Agreed on the Images! Adding screenshots could be A LOT simpler.

          I’d be fine if you only stored the image for a month, or even a couple weeks, just enough time to generate the report. Or have a storage quota, so that people have to delete images from last month to add new screenshots this month…or there could be a fee to upgrade storage space.

  • Pingback: New: Import AuthorityLabs Rankings into Raven Reports()

  • Hi, have there been any updates on this? Is there any thoughts for automating imports? I.e. data from Adobe Analtyics