We've expanded our Analytics Module with the addition of the Query Builder interface. It’s an intuitive, natural language way to get an answer to simple or complex queries. Like "How many devices did we see on site over the duration of our event?" or "What was the average dwell time at each of the three headline sponsor's activation's on Day 2 of our event, for attendees who weren't there on Day 1".
You can combine these queries with AND and OR logic, building up complex ‘where and when’ questions that define particular customer behaviours.
The interface will be immediately familiar to users of our Engage message segment builder, as it’s built on just the same principles. Using Query Builder, operations, commercial and marketing teams can get the answers they need about visitor behaviour without needing analysts, or knowledge of BI tools.
To access the Query Builder, head to the Analytics Module and in the top right hand corner, click on the "Queries" button:
Creating a query is straightforward:
- Click on the "Creatre new query" button (there's also an option to reload a previous query and amend it).
- Use the dropdown boxes to select your query metric: Number of Devices, Number of People (NB only available where scaling has been applied), Number of Visits, Average Dwell Time or Average Visit Time. (Note that the Average Dwell time is the average of the total amount of time each device spent matching the segment while the Average Visit Time is the average length of a visit.)
- Then choose from a second drop-down as to whether your query should match all or any of the rules you will now define.
- Use "Add filter" if your query is simple - for example "Devices Present at Region A". Use "Add Segment" when you want to run a more complex Query. You can combine any number of Filters and/or Segments - we've given some example queries here.
- The minus sign on the right hand of the screen enables you to quickly delete a Filter or Segment.
- Give your query a name and then click "Submit Query".
Each query name and number returned will then be stored on the Query Builder for future reference (unless you choose to delete it). There is no limit to the number of queries you can to ask the system.
Queries can be reloaded for quickly amending and rerunning (e.g. for mutiple different times), and they can also be deleted. Just use the drop down menu to the right of each count figure:
Note that Weighting is applied to Query Builder outputs.