Skip to main content

Data Manager — editing and importing sensor data

How to view, edit, import, and export raw sensor counting data in the Vemcount Data Manager — including bulk corrections and audit trail.

V
Written by Vemco Group

The Data Manager is where admins view, correct, import and export raw counting and sales data. Use it when a sensor was offline and data must be entered by hand, or when historical figures need correcting.

Path: Settings (cogwheel) > Data Manager

The three parts of the Data Manager

  • Footfall Data Manager: view, edit, import and export visitor counts, and generate average values. Every change is logged.

  • Sales Data Manager: view and manage POS and turnover data.

  • Simple Footfall Data Manager: a simpler screen for quick corrections and for locations that count by hand (for example paper tally sheets). Use the import template to upload counts without exact timestamps.

View raw data

  1. Select the location and date range.

  2. The table shows hourly data: time, count in and count out.

  3. Zero values and sudden spikes are highlighted. Check them before you export or report.

Edit data

  1. Click the cell you want to correct.

  2. Enter the correct value.

  3. Add a comment with the reason. It is saved in the Activity Log.

  4. Click Save Changes.

Import data (CSV/Excel)

  1. Click Import.

  2. Upload a CSV or Excel file with historical counts.

  3. Map the columns to the right fields: timestamp, count in, count out.

  4. Run the preview to check the values.

  5. Click Confirm import.

For file preparation and date format codes, see How to manually import footfall data.

Export data

Select a location and date range, click Export and choose CSV or Excel. All raw hourly data for the period is downloaded.

Warning: corrections change all dashboards, reports and KPIs for that period. Check values carefully before you save bulk edits. Every edit is logged with the user's name, the time and the comment. If a sensor is counting wrong, fixing or recalibrating the sensor is better than correcting the data by hand.

When to contact support

  • You are missing data because of an outage and are not sure how to fill the gap.

  • An import or a bulk correction gave unexpected numbers.

  • You do not have access to the Data Manager and need a correction made.

Email support@vemcogroup.com with the location, the dates and what should be corrected.

Did this answer your question?