Business Intelligence

Platform Manual

A/ EXECUTIVE DASHBOARD

B/ GENERAL LEVEL

1. General Insight

2. Performance Analysis

3. Hourly Visitor Statistics

4. Group Analysis

C/ STORE LEVEL

1. Store info

2. Visitor Analysis

3. Heatmap Analysis

4. Wifi Analysis

5. Queue

6. Categories

7. Demographics

8. MAG Demo

P.04

P.15

P.16

P.23

P.24

P.25

P.28

P.29

P.32

P.40

P.57

P.62

P.66

P.67

P.68

D/ STORE OPTIMIZER

E/ CAMPAIGNS

1. Campaign statistics

2. Campaign List

P.70

P.75

P.76

P.79

F/ REPORTS

1. Report Templates

2. Periodic Reports

G/ OPTIONS

1. Automated Reports

2. OHC Reports

3. Sales Integration

4. Traffic Integration

5. Groups

6. Store Info

7. Staff shifts

8. Import Goals

9. Staff MAC IDs

10.Categories

11.Queue PN Settings

12.Heatmap Threshold

13.DwellTime Regions

14.Visitor Flow Regions

15.Visitor Flow Relations

H/ PROFILE

I/ WHAT’S NEW

J/ API

P.82

P.83

P.89

P.90

P.91

P.92

P.93

P.94

P.95

P.96

P.97

P.100

P.101

P.102

P.106

P.107

P.108

P.109

P.110

P.111

P.113

P.116

EXECUTIVE DASHBOARD

SALES FUNNEL

Click on it

Preset interval can be

selected here

Calculation will change accordingly!

Today is compared with last week

Last 7 days is compared last month same week

Last 4 weeks is compared with same period last month

Whenever a widget seen, metric

customization is possible

Sales Funnel

Custom date can be

selected here

DRAW-IN RATE

Draw-In Rate: Incoming Traffic / Street Traffic

Note: Draw-In metric can be calculated with Wi-Fi Analytics as well as camera

Value in selected period

Difference with previous period

Street traffic can be captured with camera

Traffic sensor view

TRAFFIC

Value in selected period

Difference with previous period

Traffic: Number of visitors entering the location

Visitors

Imaginary entrance/exit lines

Incoming and exiting visitors

IN : Incoming

OUT: Outgoing

Sensor view

TRANSACTION

Value in selected period

Difference with previous period

Transaction: Number of invoices

In this example, number of

transaction is 4 for selected

time interval

CONVERSION RATE

Value in selected period

Difference with previous period

Conversion Rate: Transaction / Traffic

In other words it indicates how many of the

visitors has done purchase

AVERAGE TRANSACTION VALUE

Value in selected period

Difference with previous period

Average Transaction Value: Total Sales / Total Transaction

Total Transaction : 4

Total Sales : 200 USD

ATV: 200/4 = 50 USD

SALES

Value in selected period

Difference with previous period

Example

CONVERSION RATE VS TRAFFIC

Incoming Visitor AxisConversion Rate Axis

Dots represents stores

Clicking on dot forwards store section interface

Dialog box represents the traffic and

conversion rates as well as their difference

of selected store for previous period

Hovering on dot opens dialog box

CONVERSION RATE VS TRAFFIC

High Performance Area : This area can be used for

BenchmarkingMarketing Opportunity Area: Increasing traffic will

increase sales in this area

Sales Opportunity Area: Increasing conversion

will increase sales in this area

Check In-store operations!

Check marketing opportunities!

There would be a store closing decision!

Low Performance Area: This area should be

monitored for further analysis.

Examples: Sales/Sqm, Sales/Street Traffic

EXECUTIVE DASHBOARD

Any of the two

metrics below* can

be selected

Any of the three

metrics below*

can be selected

Stores can be

sorted by below

metrics*

Weekly cumulative

traffic distribution

can be seen*

Whenever this image

seen, export option is

available

GENERAL LEVEL

GENERAL INSIGHT

Metric Selection Option

Clicking on

store will

cancel

selection

Selected stores can be seen here

Stores can be selected here Custom date and date comparison

can be selected here

Excel overview can be exported

Clicking on it

will change

reporting to

excel format

Entrance/Exits can be seen

*Children traffic can be seen

Staff Exclusion solutions needs to be installed to obtain this metric

Calibration of sensors needs to be done accordingly. Children traffic option needs to be enabled on sensors.***

Weekly presentation can be seen here

**Staff entrance/exit can be seen

Additional store property

filters can be selected here

Daily presentation

Weekly presentation

GENERAL INSIGHT

Metrics shown can be selected here

Average Basket Size: Total units sold / Total number of invoices

Street: Street Traffic

Stock: Number of items in inventory

Sqm: Square meter

For presets like daily, weekly

and monthly, navigation arrows

appear for quick selection

GENERAL INSIGHT

Several locations can be selected

for reporting*

Reporting turn into excel view after 10 location selection to prevent skewing in reporting*

GENERAL INSIGHTFiltered store list can be seen here

Filter property can be selected here

Filter value can be selected here

Click here to add new store property

Custom date can be

typed here

Custom date can be selected here

1st date interval can be selected here

2nd date interval can be selected here

Date comparison can be enabled here*

First date

Last date

Selected interval for comparison should be equal*

GENERAL INSIGHT

Presets can be

selected here

Wi-Fi Analytics metrics can be selected here

Dwell time give you valuable insights on how long your customers stay

Retention gives you how frequent is your customer are visiting your stores

GENERAL INSIGHT

Weekday-Weekend breakdown can be

seen here for selected time interval

Daily breakdown can be seen here

for selected time interval

GENERAL INSIGHT

PERFORMANCE ANALYSIS

Metrics can be selected to

see performances of stores

Store breakdown for

selected metric can be

seen here

Conversion Rate vs Traffic

for selected stores can be

seen here

HOURLY VISITOR STATISTICS

Hourly Average or Hourly Sum for

selected interval can be selected here

GROUP ANALYSIS

Custom store groups can be

selected here

Metrics can

change here

There is no restriction on creating custom groups!

GROUP ANALYSIS

Performance of custom groups can be seen here

Hourly Average or Hourly Sum of custom groups can be seen here

GROUP ANALYSIS

Store Level

STORE INFO

Store can be selected here

Custom date can be selected here

Custom metric can be selected here

STORE INFO

Custom metric can be selected here

Remaining goal for selected metric

can be seen here

Quarterly Hit Rate for selected metric Yearly Hit Rate for selected metricMonthly Hit Rate for selected metric

Goals can be imported here

STORE INFO

Several custom metrics for store can

be selected and monitored here

Store information can be edited hereStore property and values for stores can be

added here

New York Store property added as High GDP

A new store property can be added here A new property value can be added hereClick here to filter store proprety

VISITOR ANALYSIS

Normalized Correlation = 1 means there is direct correlation between weather and other metric

Normalized Correlation = -1 means there is inverse correlation between weather and other metric

Normalized Correlation = 0 means there is no correlation between weather and other metric

Normalized Correlation for selected time interval

Other metrics can be selected here

Weather can be seen here

Weather data is taken from

www.openweathermap.org

VISITOR ANALYSIS

Conversion RateTraffic

Average Conversion Rate for selected time interval

Click on it to see details

Saturday data

VISITOR ANALYSIS

VISITOR ANALYSIS

Multiple Doors in same location

can be selected here

Clicking on it

will change

reporting to

excel format

In/Out toggle can be selected here

Custom date can be selected and

calculation will occur accordingly

VISITOR ANALYSIS

Average Draw-In Rate for selected time interval

Daily Average Draw-In Rate

VISITOR ANALYSIS

3 minutes interval can be seen here

Sensors needs to be setup for real time occupancy option

Occupancy = |IN-OUT|

Please note that if OUT > IN for definite time interval Occupancy will be 0

Custom time interval can be set. Please note that minimum value is 1 minute

VISITOR ANALYSIS

Historical Occupancy

VISITOR ANALYSIS

Time interval can be selected here

Data granularity can be selected here

HEATMAP ANALYSIS

If it is more than one day, daily calculation is being presented

Daily Heatmap

Camera Heatmap Output*Occupancy Percentage

Most

Occupant

Least

Occupant

Occupancy Percentage is calculated based on waiting time of people on related areas

Percentage is a numeric representation of color where Blue is 0% and Red is 100%

Real Camera Image

*

HEATMAP ANALYSIS

In daily selection, hourly calculation is being presented

Hourly Camera HeatmapHourly Slider Bar

MULTICAMERA HEATMAP

Store Heatmap is formed by several Heatmap Cameras installed in same store

Installed Camera

Heatmaps

Store Layout

GENERAL REPORTS

Daily Threshold: 60 seconds

If it is more than one day, daily

calculation is being presented

Daily Store Heatmap

Representation of waiting time can

chance according to above selection

Click Here

Red is most occupant area

Waiting time of people is

above 60 seconds

Blue is least occupant area

Waiting time of people is

below 60 seconds

Legend is showing total

Dwell time in seconds

Hourly Threshold: 60 seconds

If it is one day, hourly

calculation is being

presented

Hourly Store Heatmap

Click Here

GENERAL REPORTS

CUSTOM DATE REPORTS

Threshold 20 means normalization calculation is based on maximum waiting time (max = 20 seconds) of that

specific selected interval. Red is represented as above 20 seconds where as below waiting time is being

normalized by according to maximum threshold

Custom Date

Report menu can

be selected here

Threshold for waiting time can be selected

here Custom time period can be selected here

After clicking on it

please refresh the

page for new reportVisual report

can be seen

by clicking

here

Below is 21.03.2018 10:00 - 21.03.2018 11:00 Threshold :20 seconds

CUSTOM DATE REPORTS

Threshold 300 means normalization calculation is based on maximum waiting time (max = 300 seconds) of that

specific selected interval. Red is represented as above 300 seconds where as below waiting time is being

normalized by according to maximum threshold

CUSTOM DATE REPORTS

Below is 21.03.2018 10:00 - 21.03.2018 11:00 Threshold :300 seconds

CUSTOM DATE REPORTS

Threshold -1 means normalization calculation is based on maximum waiting time (max = red) of that specific

selected interval. Red is represented as max threshold, below waiting time threshold is being normalized by

according to maximum threshold

CUSTOM DATE REPORTS

Below is 21.03.2018 10:50 - 21.03.2018 11:00 Threshold : -1 (maximum waiting time)

CUSTOM DATE REPORTS

Max = 300 secondsMax = 20 seconds

*Same time interval different threshold comparison

CUSTOM DATE REPORTS

REGION STATS

Custom Region

Selected Time Interval

Click here for setup page

REGION STATS

Total average Dwell Time for location

Average Dwell Time for custom region

REGION STATS

Daily visitor count for custom region

VISITOR FLOW

42.17% of people in Zone 3 moved to Zone 4 during selected time interval

Entrance

Click here for setup page

HOURLY SELECTION

In case of daily selection, hourly reporting can be seen

WIFI ANALYSIS

Average Draw-In Rate for selected time interval

Daily Average Draw-In Rate

WIFI ANALYSIS

Store can be selected here

Custom time period can be selected here

Filtered data can be seen here

Daily breakdown of Dwell Time can be seen here

Average Dwell Time for 6 days

Daily average Dwell Time

Clicking on bar shows related daily breakdown

Filtered Data

Above 120 minute is filtered due to assumption of devices

detected is either display product or staff’s smart devices

Below 1 minute is filtered due to assumption of Wi-Fi

signal is lost and not an healthy data

WIFI ANALYSIS

WIFI ANALYSIS

Retention Rate calculation is calculated and presented monthly

Results for related month

Month can be selected hereStore can be selected here

12% of visitors visited

location again

Frequency of visit breakdown for visitors 33% of loyal customers (12% of total visitors in

May) visited New York store 3 times

WIFI ANALYSIS

Cross Shopper calculation is calculated and presented monthly

Results for related month

Month can be selected hereStore can be selected here

15.64% of visitors in Miami location also

visits New York location in May5.98% of visitors in Miami location also visits

New York location in May

In order to activate Cross Shopper couple please send an inquiry to help@v-count.com

Only two locations can be selected for each cross shopper calculation

QUEUE (REALTIME)

Checkout arrangement toggle option

Number of

individuals in

checkouts

Current time

Occupancy is

updated every

30 seconds

For push notification setup page please click here

Occupancy color

definition can be

changed here

Please Save

QUEUE (HOURLY STATISTICS)

Multiple Checkouts can be selected here

Custom date can

be selected and

calculation will

occur accordingly

Store can be selected here

Avg. number of

people waited for

specific hour can

be seen here

An excel output can be

taken here

Avg. waiting time

for specific hour

can be seen here

QUEUE (HOURLY STATISTICS)

Abandonment for

specific queue for

specific hour can be

seen here

Queue Entrance

If a person passes this edge and exit from

same it will be counted as abandonment

QUEUE (HOURLY STATISTICS)

CATEGORIES

Sample Category

Metrics can be selected here

Selected metric

Laptop Sales is outperforming in New York

store when its compared with average

Subcategories can be selected here

Sample

Subcategory

Categories can be selected here

MAG (MOOD/AGE/GENDER) ANALYSIS

Custom date can be selected and

calculation will occur accordingly

23.08% of visitors are

between 20-24 age group

7.69% of visitors are

female and between

20-24 age group

15.38% of visitors are male and

between 20-24 age groupMale & Female ratio for each

mood can be seen here

Male & Female ratio

for selected date can

be seen here

MAG(MOOD/AGE/GENDER) DEMO

Real time Output from camera view

Real time input from camera

This is an interactive Demo. Please request for a Demo!

Please note that V-Count do not store any image. After Gender, Age and Emotion

are determined, images are being discardedImages are being used with permission

MAG(MOOD/AGE/GENDER) DEMO

Store Optimizer

STORE OPTIMIZER

Week should be selected

here (Monday to Sunday)

1.01% of weekly traffic

belongs to Wednesday

19:00 – 20:00 cell

12.21% of weekly traffic belongs to

17:00 – 18:00 cell

13.77% of weekly traffic

belongs to Friday cell

Traffic in shifts can be

seen here

Metrics can be

selected here

CUSTOMER/STAFF(UNDERSTAFF/OVERSTAFF)

Friday 14:00 – 15:00 each staff

needs to attend 59.5 visitor

149 visitor needs to be attended by

staff in Sunday 13:00 - 17:00

SALES/TRAFFIC(LOST SALES OPPORTUNITY)

Sales/Traffic is 0.13 in

Sunday 19:00 – 20:00

shift

Sales/Traffic is 0.38 in Friday 9:00 – 13:00 shift

In this shift, there is a lost sales opportunity

In-Store Sales performance of staff in designated shifts can be monitored here

In this shift, there is a lost sales opportunity

(Sales (Cell) / Sales (Week)) /

((Traffic(Cell) / Traffic (Week))

SALES/TRAFFIC(LOST SALES OPPORTUNITY)

In here it is seen that Linette is trying

to handle sales operation alone in

Friday and Sunday shift

Interface automatically gives tip for

understaffed shifts (by comparing it to

traffic in same shifts) in order for user

to consider for next week’s schedule

In-Store Sales performance of staff in designated shifts can be monitored here

Staff becomes red whenever

weekly working hour is

exceeding legal upper limits

Shifts can be exported as

excel

Week of year can be seen

here

Campaigns

CAMPAIGNS

Multiple event can be

selected here

Clicking on event will exclude

them

Breakdown of events

can be seen here

Garage Sale Event generated 2.5 person for

each currency spent in marketing effort

Formula For Traffic Gain : ((Traffic During Campaign – Traffic Before Campaign) + (Traffic After Campaign – Traffic Before Campaign)) / Budget

Formula For Traffic Increase During Campaign: 100 * (Traffic During Campaign – Traffic Before Campaign) / Traffic Before Campaign

Formula For Traffic Increase / Budget – During Campaign: (Traffic During Campaign – Traffic Before Campaign) / Budget

CAMPAIGNS

Formula For Traffic Increase After Campaign: 100 * (Traffic After Campaign – Traffic During Campaign) / Traffic During Campaign

Formula For Traffic Increase / Budget – After Campaign: (Traffic After Campaign – Traffic During Campaign) / Budget

CAMPAIGNS

More events can be

added from here

Clicking on this icon shows

marketing effectiveness for this

event

CAMPAIGNS

Details for events

can be added here

CAMPAIGNS

Before Campaign After CampaignDuring Campaign

Store can be selected here

Metrics with variance before, during and after

campaign can be seen here

CAMPAIGNS

Reports

REPORT TEMPLATES

Click for new report template

Report templates that added before can be seen here

REPORT TEMPLATES

Report Type selection menu

REPORT TEMPLATES

Store selection menu

Multiple stores can be selected here

REPORT TEMPLATES

Data Period and Granularity selection menu

Period and Granularity can be

selected here

REPORT TEMPLATES

Metric selection menu

Metrics can be selected here

REPORT TEMPLATES

Visualization selection menu

Visualization type can be

selected here

Don’t forget to add Report Title before saving

PERIODIC REPORTS

Please note that, in order reports to be sent in correct

period, it needs to be same with templates

Options

AUTOMATED REPORTS

Sample Output for

Automated E-Mail

OHC REPORTS

Sample Output for Average Trigger

Sample Output for Online Health Check

SALES INTEGRATION

Sales, Transaction, Unit and Stocks

metrics can be added manually

Aim of this interface to aid users to manually add their metrics to our interface

There is an also called web service (API) method for automated integration.

Please check API Manual. Click here

TRAFFIC INTEGRATION

Traffic metric can be added manually

Aim of this interface to aid users to manually add their traffic metric to our

interface

There is an also called web service (API) method for automated integration.

Please check API Manual. Click here

Please note that this is a hidden menu. In order to activate it please contact

with help@v-count.com

GROUPS

Click here for reporting page

STORE INFOStore Tags can be

added here as

columnsValues can be

searched here

Values can be seen

here

STAFF SHIFTS

Staff and Shifts can be added and monitored from menu

Multiple Staff can be added from here

Staff ID needs to be filled in order to

prevent name confusion

Information can be edited

or deleted from here

Added Staff information can be seen here

Staff Shifts can be

added for multiple

staff with various time

intervals each day

Shifts can be edited here

Shift can be added and edited weekly

STAFF SHIFTS

Shifts can be seen

for selected week

Week can be

selected here

STAFF SHIFTS

IMPORT GOALS

Click here for reporting page

STAFF MAC IDS

Staff Exclusion solution is available with Staff Exclusion Tags that V-Count

distributes to stores.

Please note that V-Count do not contain any Staff personal information for

tracking

Each Tag has unique identifier that is hidden

CATEGORIES

Click here for reporting page

Sub categories can be branched in this menu

Custom categories can be formed in this menu

CATEGORIES

Categories can be grouped in custom fashion

CATEGORIES

Groups can be categorized

CATEGORIES

Groups can be assigned to stores

QUEUE PUSH NOTIFICATION SETTINGS

Queue threshold, above this limit notification is being sent to smart phones

Idling people in queue at the moment

Snooze option is available not to bother responsible

personnel for alarm that created frequently

This feature is available for iOS and Android

In order to have receive push notification please download V-Count in applications

Click here for reporting page

HEATMAP THRESHOLD

Click here for reporting page

Threshold means normalization calculation is based on selected maximum waiting time of that specific selected interval.

Red is represented as selected threshold where as below waiting time is being normalized by according to maximum threshold

DWELLTIME REGIONS

Click here for reporting page

Write a new Region Name, click Add

Select the Store

Select region, draw custom region and click Save

Active Region

VISITOR FLOW REGIONS

Write a new Region Name, click Add

Select the Store

Select region, draw custom region and click Save

Active Region

REGION FLOW RELATIONS

Zone 2 is bounded to Zone 3 & Zone 4

Zone 2, 3 and 4 relationship can be seen here

Click here for reporting page

Profile

PROFILE SETTINGS

Profile can be

selected here

Logo can be

changed from here

Temperature unit can be changed from here

Date format can be

changed from here

Language can be

changed from here

Password can be

changed from here

Hour format can be

changed from here

Default presentation of first 10

stores can be selected here

What’s New

WHAT’S NEW

What’s New page can be seen here

New feature explanations can be seen here

WHAT’S NEW

What’s New page can be seen here

Historic new feature explanations can be seen here

Whenever a new update is here,

pop up notification appears in any

page

Clicking on it opens new pop up

page

API

API

Sample output can be seen here

Sample input can be added here

Possible query topics can be seen here

Please request API Manual for more information!

The objective of this interactive interface is to help customer to understand how integration works

THANK YOU

v-count.com

linkedin.com/company/v-count

twitter.com/socialvcount

facebook.com/VCountsocial