Analytics FAQs
Frequently asked questions about Airshot Analytics.
Last updated
Frequently asked questions about Airshot Analytics.
Last updated
If graphs have not been enabled, they will display in grey. To activate agraph, use the toggle button (to the top right of the graph). You can also access the section ordering icon (in the top icon menu) to re-order and activate/deactivate graphs.
When you deactivate a graph it will be moved to the bottom of the page.
To see goal rings, you need to add in a goal value. Select a category and then adjust the zero value to reflect the target you are aiming for. If you want to track leads, you will select "Leads" as your category (provided that this is a column in your performance data), and then you will adjust the goal value to a target number, for example, 50.
After uploading performance data, you can use the goal rings graph to set performance targets. This allows both you (the Broadcaster) and the participant to see when goals are being reached.
Have a look at the example analytics in this section to see how it's done.
Yes. As a Broadcaster, you can switch from Analytics to Participant view.
The Broadcaster app allows Broadcasters to view stats, discussions, leaderboards and analytics on-the-go. Heavy lifting such as global analytics, performance data uploads and other admin tasks are reserved as backend-only features.
Sign into the Airshot app, go to the Account and select either "Analytics" to see the analytics that you have set up, or select "Participant View" to see what the participant can see.
Yes. As a Broadcaster, you can switch from Analytics to Participant View.
The Participant View gives you a glimpse of what the participant is seeing on their app. As a Broadcaster, your app contains different content, i.e. Analytics.
To switch between seeing the Broadcaster or the Participant app, go to the Account and select either "Analytics" to see the analytics that you have set up, or select "Participant view" to see what the participant can see.
You'll see that your Analytics section has been split into three categories: Insight, Analysis & Focus. So, what's the difference?
Insight provides behavioural-type data (you can add analytics including sentiment, pulse, demographic, series graph and pie graph). Interaction rates (from pulse) and the AI-driven glimpse at participant emotions/reactions (sentiment) are best coupled with custom graphs (pie or series).
Analysis shows you how the Broadcast is doing in terms of engagement. You can add the following analytics: engagement, frequency, responsiveness, series graph, pie graph and rank list.
Focus is reserved for what you want to focus on seeing during the Broadcast. Here you can build the analytics you want to look at on a daily basis, including: leaderboard, performance, participation, audience map, goal rings, series graph, pie graph and rank list.
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 format).
Because it is possible to upload multiple performance data files, each file will be added as a new sheet (similar to Excel). Look at the bottom of your screen and find the upload you are looking for.
Leaderboards viewed by country take the location added in the user's profile (the locatino they enter manually when activating their account or the location they share when activating their account).
Custom graphs (such as map graph, rank list and pie graphs) are populated using location data that originates from the performance data upload.
Note: It is likely that the user location in their profile is not always the same as the location in the performance data. Leaderboards reflect profile-based location, and custom graphs reflect data upload location. Use custom graphs to get consistent and accurate locations based on the data you rely on. The person with the highest sales average is likely to rank the highest for performance.
Performance average (expressed as a percentage) is calculated by comparing the individual participant's aggregate to the highest performance value.
For example: Based on data, Frank has x3 records of sales, e.g. March (500), April (250), May (350). To calculate his aggregate, we need to first work out his average sales: (500 + 250 + 450) / 3 = 400.
We then compare that to the highest overall sale record (of any user). Let's say the highest sales achieved by a user was 600. To calculate Frank's average sales performance, the following formula is applied: (Frank's average sales / highest sale). In this example, that translates into: 400 / 600 * 100 = 66.6%.
Frank's average performance score is therefore 66.6%.
In a nutshell: The percentage of a performance key value, for example user's sales / best sales giving them a score of a / b. This would mean the user with the highest score (e.g. sales) would likely be in the first position in a performance context.
The percentage of participation in a Broadcast is calculated by counting the amount of activities that a participant has completed during a Broadcast.
For example, if a user participated in 9/10 activities, they would earn a score of 90%.
If your excel sheet is not uploading or is loading incorrectly, please ensure that the formatting is correct (as per requirements). You can also follow the troubleshooting steps below:
Excel file must be in .xls or .csv format (no .xlsx permitted)
The Excel file must contain no hidden rows
The file should only have one sheet (only the first sheet will be uploaded)
The file must follow the same structure as previously uploaded performance data
Cell styling/formatting should be removed
Ensure that the correct date format is being used
Ensure that the correct location format is being used (as specified here)
Check that the first row of data contains column names/headers and remove any rows that are not relevant to the data structure (e.g. a row with a title)
Airshot will accept the following formats as "date" values in an upload:
d/m/Y e.g. 31/03/2019
m/d/Y e.g. 03/31/2019
Y-m-d e.g. 2019-03-31
d/m/y e.g 31/03/19
m/d/y e.g 03/31/19
y-m-d e.g 19-03-31
Note: Dates detected will automatically convert to "Y-M-D" format once uploaded, as this is the preferred universal format in software.