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.

Did this answer your question?