If you accept payment from your customers via paypal, then you can easily export and plot your sales and revenue data. This lesson is a step by step guide to exporting it and uploading it to 2map.co.uk.
A menu will drop down
This will take you to an options screen.
We only need a few fields.
Deselect all the fields.
Make sure 'Multi Column Postal Address is ticked'.
If you want 'postage amount' then that may be a useful field to map (if it differs by geography).
Scroll down to the bottom.
Click the 'Save' button.
Choose a large range, such as a year, to give enough data to plot.
Choose 'Comma Delimited' as the file type.
Click the 'Download History' button at the bottom.
Save the CSV file to your local disk.
Open the CSV file in a spreadsheet package such as Excel.
Remove any unnecessary fields.
The highlighted fields such as postcode and currency values are the only important ones. All other columns can be removed.
Save the file as CSV.
Under the 'Data' menu you will find an 'Upload' submenu.
Click 'Browse' and then select the CSV file that you just saved.
Give the dataset a unique name.
Click 'Upload' and you will be taken to the data conversion page.
The system will create a new dataset at the level you have chosen.
Record level rows will be grouped together based on the level you have selected. The values in this new dataset will be automatically calculated by adding up all record level values for the rows in each group.
As the CSV file has a row for each transaction you should select 'Sale'
Enter a name in the 'Dataset Name' text field.
Make sure this is a unique name. If you have already used this name for another dataset then you will be told to enter a different one.
Leave the defaults for the remaining options.
You are now on the last page of the map wizard.
Click on the field you wish to plot.
This can be changed or completely customised once on the map screen.