Data and Files Help
Sample CSV File
Here is a sample CSV file displayed in Excel
Here is that same file as a CSV displayed in Notepad
Explanation of the Data type
In order for Viwedata to read you data and map it, it needs to be as a CSV file type. The reason for this is that a CSV file is simply each cell seperated by a comma, which is why it is called a CSV or Comma Seperated Value File. An Excel file can be configured in a multitude of ways making it very difficult for Viewdata or any software to interpret. Most Excel files can be saved as a CSV.
You can find an explanation of a CSV file type here https://en.wikipedia.org/wiki/Comma-separated_values
The CSV file type is a constant across many software applications such as your CRM and CMS systems and this makes it ideal to export data directly out of these systems and analyse it in Viewdata.
The other things that you will notice about the file itself are:
- One of the columns is a geographical attribute such as in this case a Postcode. Viewdata needs to have location in the file in order to understand where that customer resides and map the associated information.
- Each line is represented as an event or in this case an order and has a number of columns of information associated with it.
- The spreadsheet can contain thousands of rows of data and Viewdata is capable of processing this no problem
- You can also configure your csv file differently to contain different data or add columns to suit your business requirements.
Note: All data in the above spreadsheets is dummy data and has been created randomly to mimic a business that is selling cleaning products. Any similarities to actual people or events is purely coincidental.
What Geographical areas are supported
Viewdata will currently map the following geographical areas without any further input from a customer, simply by dropping the csv data file into the browser.
Suburbs, Postcodes, Local Government Areas, State Electoral Boundaries and the SA2 codes from the Australian Bureau of statistics.