Outlet name & Identifier
Column name(s):
Indicator values:
Outlet address - Fields contain both version of the outlet address 1. address string and address separated into separate columns (Street, Number, District, Region, Country).
Address includes specific GPS coordinates for further use in client tools.
Column name(s):
outlet_address
street
house_number
land_registry_number
locality
region_1
region_2
region_3
postcode
country
GPS_latitude
GPS_longitude
Indicator values:
How long has the outlet been active in this specific location.
Column name(s):
Indicator values:
Official name of the outlet parent company.
Column name(s):
Indicator values:
Official ID of the outlet parent company in the government registry.
Column name(s):
Indicator values:
Primary top level category for the outlet (HoReCa / On-Trade, Accommodation, Retail or Other)
Column name(s):
Indicator values:
HoReCa / On-Trade
Accommodation
Retail
Other
Secondary top level category for the outlet (HoReCa / On-Trade, Accommodation, Retail or Other)
Column name(s):
Indicator values:
HoReCa / On-Trade
Accommodation
Retail
Other
Primary business outlet segmentation based on SharpGrid's taxonomy. It allows you to filter and select outlets that fit your target criteria.
Column name(s):
Indicator values:
Restaurant
Fastfood
Coffee & tea room
Sweet & baked
Bar & wine room
Pub
Club
Event (hall)
Hospitality only
Catering
Some outlets fit more than one segment in SharpGrid's outlet segmentation. Outlets have the option to have secondary segment which helps user to select with higher granularity.
Column name(s):
Indicator values:
Restaurant
Fastfood
Coffee & tea room
Sweet & baked
Bar & wine room
Pub
Club
Event (hall)
Hospitality only
Catering
Public e-mail contact of the outlet or its operator.
Column name(s):
Indicator values:
Public phone contact of the outlet or its operator.
Column name(s):
Indicator values:
Public website of the outlet.
Column name(s):
Indicator values:
Shows outlet's opening hours divided into SharpGrid's segmentation of opening hours. Can be used for filtering specific market segments e.g. for spirits outlets need to be opened evenings / nights.
Column name(s):
week_opening_hours_segment
weekdays_opened
Indicator values:
Morning & lunch
Lunch & evening
Evening only
Non-stop
Lunch only
Morning till evening
Other
Identified cuisine type. Only applies to restaurant or other types of outlets where Sharpgrid is able to identify specific meals typical for each cuisine.
Column name(s):
Indicator values:
Asian
Czech
Fish
French
Indian
Italian (without pizza)
Meat
Mexican
Middle Eastern
Mixed
Pizza
Sushi
Vegetarian
Describes whether the outlet offers full–size meals (typically dinner or lunch). This indicator can be used to identify all outlets offering food.
Column name(s):
Indicator values:
Yes / No
Identification (based on proprietary data model) of whether alcohol is offered in the outlet or not. Can be used for estimation of total market potential, marketing and sales targeting.
Column name(s):
Indicator values:
Yes / No
Attribute shows availability of delivery services. Attribute marks positive if delivery is either managed by outlet or by food delivery services.
Column name(s):
Indicator values:
Yes / No
Aggregate rating score from user generated content gathered from outlet's digital signature. The range of the value is between 1 - 5, 5 (1 worst, 5 best) Can be used to determine outlet quality and consumer experience with regards to the outlet. Aggregate rating score from user generated reviews & ratings compared to outlets within the region and segment. Indicator value represents outlet rating position. Value TOP represents top 25% of best ranked outlets within the area.
Column name(s):
consumer_rating_score
consumer_rating_rank
Indicator values:
Top
Good
Fair
Low
Engagement represents sum of all interactions (text reviews, numercial ratings) generated by outlets visitors.
In output dataset it is present in two forms:
Score - total numerical count of all reviews
Rank - All outlets divided into 4 equally sized segments (each segment represents a quarter of the market).
E.g. Top segment represents the 25% of most rated outlets in the market.
Column name(s):
consumer_engagement_score
consumer_engagement_rank
consumer_engagement_rank_reg
Indicator values:
Top
Good
Fair
Low
Local market rank responds to the question - is this the most popular outlet within this area?
We measure the engagement generated by visitors in 1,000m radius around the outlet. For each outlet we analyze the local area around the outlet and create a ranked order of all outlets in near distance (1,000m) by their engagement of their visitors.
Based on the position in this list, the outlet gets a value ranging from Low to Top. How to interpret values:
For an outlet to score in Top segment there are also additional requirements which needs to be fulfilled:
Column name(s):
Indicator values:
Top
Fair
Low
Growth measures outlet's dynamic in engagement over time.
There are two dimensions to growth – one is initial engagement. High engagememt indicates "well-established" outlet. The second dimension is the change over time (growth in engagement). This is measured as quarterly change in reviews.
Based on this two dimension we indentify 3 key segments:
Column name(s):
Indicator values:
Champion
Steady
Opportunity
Food & beverage rank estimates total outlet revenue generated by volume of sold food and drinks. Each value of output represent one quarter of the market. Top represents 25% of outlets with highest revenue from food and beverages.
Drivers that influence estimated performance of an outlet are following:
Column name(s):
Indicator values:
Top
Good
Fair
Low
Seasonality helps uncover outlets that benefit from seasonal visits (e.g. summer holidays, winter ski holidays etc.). This indicator marks outlets located in summer or winter seasonal localities. Outlets either have summer, winter or mixed seasonality type which marks the peak season for their revenue. You can use this indicator to determine what kind of products will be best suitable for the outlet's customers.
Column name(s):
Indicator values:
Summer
Winter
Mixed
Shows what makes the outlet popular with its customers or what is the main reason for their visit. This indicator will help you create the best product mix for maximum effectiveness at this location.
Column name(s):
active_night_entertainment
adult_entertainment
active_allday_entertainment
enjoying_sweet_baked
enjoying_coffee
enjoying_tea
enjoying_cocktails_spirits
enjoying_wine
enjoying_beer
general_food
small_refreshment
Indicator values:
Yes / No