Unfortunately this website is not compatible with Internet Explorer versions before 11.
Please upgrade to IE 11, or use another browser.

Blog

Analytics Queries: Colocator’s new spatial query builder

01 Apr 2019 | Written by Mark Maydon

Announcing Colocator’s new Query Builder

At Crowd Connected we’ve always provided multiple ways to turn underlying location data into insight. For some use cases our interactive charting provides a quick way to explore customer behaviour. Companies with in house BI teams can export visit-based summaries in csv format for use in BI tools. And operations teams can have daily reports generated.

But sometimes if you have a custom query you need answering, then the standard reports and the standard charts won’t work. If it’s a business critical question, you may have to look to an in house or external analyst. If you’re just curious, the question may well go unanswered.

Building a new query

Conventional wisdom is that when it comes to analytics, tools can be quick and intuitive, or they can be powerful. At Crowd Connected, we want our location data tools to be both. And so we created a new query builder for location data. It’s an intuitive, natural language spatial query builder - running on top of our Segmentation Engine. The same engine is used across much of our platform, but hidden from view. The query builder exposes this powerful segmentation engine to our users, with an intuitive front end.

You can find out how many app users were ‘Present, in an area, between two times, for at least a minimum dwell’, just by making selections in a series of drop downs.

History of previously run queries

The new interface is completely self-service, so operations, commercial and marketing teams can get the answers they need about visitor behaviour without needing analysts, or knowledge of BI tools. It will be immediately familiar to users of our Engage message segment builder, as it’s built on just the same principles.

The new feature has been in beta testing with some of our key clients during Q1 2019, and is released to all customers in Q2.

Sign up to our mailing list for more content from Crowd Connected

How location and beacon data analysis can mislead

Location and beacon data gathered from mobile phones is affected by sampling rate variation. Without correction, business analysis can be flawed. Here's what you need to know.

The Need For Speed – How to Tackle The Challenge of Delivering Real-Time Data Fast

When it comes to data visualisation solutions, speed of rendering is business critical. The ability of any data visualisation system to work in real time is becoming increasingly a must-have for brands, events & operational teams.

Mobile Developments

The Colocator mobile library is in continuous development and improvement for both iOS and Android. From feature improvements to battery optimisation and smart ways to collect data, we are always keeping an eye on new mobile OS versions and technologies that would enable us to provide more insight.