We think Paolo Magrassi from Gartner said it best when he said “If you torture your data set enough, it will confess anything.” Like any large data sets, foot traffic data collected by a People Counting System over an entire year can be sizeable and intimidating. However, by using SenSource’s Vea Software, creating useful and impactful end of the year foot traffic reports has never been easier.
Here are three end of year foot traffic reports we think you will find useful, and how to quickly generate them:
2021 vs. 2020 Comparison Widget
One of Vea’s best features is the pre-configured widgets that give you crucial information that continues to update as data is collected. While very straightforward, a 2021 vs. 2020 comparison widget gives immediate insight to how you are performing compared to last year. Even though the Covid-19 pandemic has dramatically impacted us all the last two years, it helps normalize your data and gives a good outlook at how busy you have been.
This widget can be added by clicking the add widget button, selecting comparison, and then configuring the widget to compare year vs. year.
In the above example, a library has received 24.7% less traffic than last year. During the Covid-19 quarantine in 2020, the library saw a spike in traffic as patrons were entering the lobby to pick up materials. Even with 2020 as an outlier year for traffic, it’s still helpful to see exactly how many fewer patrons entered the library in 2021. This data is quickly available on the library’s Vea dashboard and can be used for completing government reports, requesting funds, justifying expansion or renovation needs and planning staff schedules.
Year-to-Date Average Max Occupancy Heatmap
Vea’s Heatmaps are a highly visual way to consume a large amount of data quickly. One ideal end of the year report is a Year-to-Date Average Max Occupancy by Hour Heatmap. This takes a measurement of every day’s high occupancy measurement by hour and averages it across the year. You can learn, on average, what your peak occupancy was by hour to help establish a solid foundation for scheduling for the coming year.
This report can be generated by navigating to Data Views then Heatmap. You can then input the selections shown in the image above (plus inputting your specific space).
Many inferences can be made from this sample Data Grid. As expected for a grocery store, the busiest days of the week are Saturday and Sunday, depicted by the longest stretch of red hours on the grid. Monday is the busiest weekday. Among all days of the week, 1:00 pm is the busiest single shopping hour, with heaviest traffic occurring between the hours of 11 am to 2 pm. The day-hour heatmap is an ideal report for planning staff schedules. It’s quickly evident that a schedule for Tuesdays, the slowest day of the week, should look different than a staff schedule for Monday. In addition, operational duties can be streamlined using the grid to find the slowest hours of the week to schedule deliveries, vendor meetings and store maintenance. As an end of year report, the grid may uncover big-picture items to consider such as adjusting open hours to reflect shopper habits or planning promotions to boost slower days.
Last-Year-by-Month Data Grid
While not as visually appealing, the data grid option in Vea is the ideal report format for those who enjoy working in Excel. Having the data in Columns and Rows lets users create their own reporting and charts in ways that make sense for them. A Last-Year-by-Month report in a data grid format gives insights to how busy you were by month and extrapolate that to compare against promotions you were running at that time. But again, in data grid format, you can manipulate the data as you see fit to help you learn and make conclusions about the previous year.
This report can be generated by navigating to Data Views then Data Grid. You can then input the selections shown in the image above (plus inputting your specific space).
Data reporting beauty is in the eye of the beholder. Vea remains flexible enough to allow the users to dictate what data they want to see and how they see it. Every organization can vary in how they use their foot traffic reports. But we recommend starting with these end of the year reports to set up your team for many successes in 2022!