The Query Builder interface in our Analytics Module enables you to get answer to simple or complex queries. Here are some examples.
1 How many devices saw every act on the main stage?
Use multiple filters for mutiple times at a single Region
<Number of devices that> match <All> of the following:
- Present at Main Stage between Time A and Time B
- Present at Main Stage between Time C and Time D
- etc.
2 How many devices visited every stage?
Use multiple filters for mutiple Regions and mutiple times
<Number of devices that> match <All> of the following:
- Present at Main Stage between Time A and Time B
- Present at Second Stage between Time A and Time B
- etc.
3 How many people only visited the main stage?
Use multiple filters combining 'Present' and 'Not Present' for mutiple Regions and mutiple times
<Number of devices that> match <All> of the following:
- Present at Main Stage between Time A and Time B
- Not Present at Second Stage between Time A and Time B
- Not Present at Third Stage between Time A and Time B
- etc.
4 How many devices went to both the north and south sponsor areas?
Use two segments with multiple filters in eachÂ
<Number of devices that> match <All> of the following:
- Any
- Present at North Sponsor A between Time A and Time B
- Present at North Sponsor B between Time A and Time B
andÂ
- Any
- Present at South Sponsor A between Time A and Time B
- Present at South Sponsor B between Time A and Time B
5 How long did devices spend in the sponsor areas?
Use Average Dwell for the Regions and time periods
<Average Dwell time of devices that> match <Any> of the following:
- Present at Sponsor X between Time A and Time B
- Present at Sponsor Y between Time A and Time B
- Present at Sponsor Z between Time A and Time B
6 How many people never visited our headline sponsor?
Use a combination of People (assumes Scaling has been applied) for the entire venue Region and Not Present for the duration of the event in the Headline Sponsor Region
<Number of people that> match <All> of the following:
- Present at Venue between Time A and Time B
- Not Present at Headline Sponsor between Time A and Time B
7 How long did a visit to the bar on average take?
Use Average Visit Dwell across all of the bar regions
< Average Visit Dwell time of devices that> match <Any> of the following:
- Present at Bar A between Time A and Time B
- Present at Bar B between Time A and Time B
- etc (for each of the different bars and/or time periods you want to include)
8 What was the average number of visits to the bar?
Run two separate queries and then combine the results
<Number of devices that> match <Any> of the following:
- Present at Bar A between Time A and Time B
- Present at Bar B between Time A and Time B
- etc (for each of the different bars and/or time periods you want to include)
<Number of Visits that> match <Any> of the following:
- Present at Bar A between Time A and Time B
- Present at Bar B between Time A and Time B
- etc (for each of the different bars and/or time periods you want to include, matching identically to the previous query)
Then divide the Visits figure by the Devices figure.