Data Upload
Performance data upload guidelines.
Last updated
Performance data upload guidelines.
Last updated
Import performance data if you are tracking performance and would like to visualise your data using the many graphs and analytical tools available on the Airshot platform.
Once uploaded performance graph is automatically plotted and a performance aggregate is included on the leaderboard in order to rank participants.
It is essential that your import (.csv or .xls) is formatted as per the requirements below. You will not be able to upload an excel sheet in .xlsx format. A .xlsx file must be converted to .csv or .xls.
Important: If you are including locations in you performance upload, the data must be added in the following format: "City, Country Code". This allows us to accurately look up locations and plot them on maps. The country code follows the ISO Alpha-2 format (which is a standard).
Please check this list before uploading:
Data
Requirements/Parameters
E-mail Addresses
Your import should contain an email address in each row.
Date
Less than 10 columns
Your import data should not have more than 10 columns.
Less than 1000 rows
Your import data should not have more than 1000 rows. If you have more than 1000 rows, consider importing in batches.
Matches previous structure
You can upload multiple files, but each import must match previously added columns. You can append more columns, as long as the previous columns are maintained.
Once performance data has been uploaded, you can specify the key indicator column, e.g. Sales.
A common structure in the context of Airshot is simply data that follows the same common structure as the initial upload.
To illustrate common structures, let's take a look at examples. Our first example is the data that we first upload to a Broadcast.
This will create the common structure for our performance uploads which is "Date", "E-mail","Sales". Our subsequent uploads must at least have this structure, however, we are still allowed to append more columns.
For example, your next upload can be:
But your next upload can't be:
The reason the above bad example won't be accepted, is because it does not contain the common structure "Date","E-mail","Sales".
If you would like to see a sample of a performance data upload, please download the .csv file below.
This sample data was created for a scenario in which call centre agents' performance is tracked to extract top performing individuals, teams, locations, and overall sales, leads & rating.
Each Broadcast can contain up to 10,000 rows of data (including headers).
For Excel upload troubleshooting and further information, please refer to the FAQs and troubleshooting section here.
Your import should contain a date in each row. For more info on date formatting, .