SharpGrid output documentation

Basic data

Outlet Name

Outlet name & Identifier

Column name(s):


Indicator values: 

Outlet Address

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: 

Age

How long has the outlet been active in this specific location.

Column name(s):


Indicator values: 

Company name

Official name of the outlet parent company.

Column name(s):


Indicator values: 

Company ID

Official ID of the outlet parent company in the government registry.

Column name(s):


Indicator values: 

Contacts

E-mail

Public e-mail contact of the outlet or its operator.

Column name(s):


Indicator values: 

Phone number

Public phone contact of the outlet or its operator.

Column name(s):


Indicator values: 

Web

Public website of the outlet.

Column name(s):


Indicator values: 

Outlet Attributes

Opening hours

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

Cuisine(s)

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

Serve meal

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

Any alcohol

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

Delivery

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

Consumer Insights

Consumer rating

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):

Outlet_rating_score

outlet_rating_score_segment


Indicator values: 

Top

Good

Fair

Low

Consumer engagement

Total count of all interactions consumers has made with current outlet. Every rating, review and other kind of interaction. For the purpose of better selection and analytical work segmenatation buckets are also included (engagement segments). All outlets are divided into 4 segments (Top, Good, Fair, Low) each representing 25% of the market. Equally regional segmentation divides market into 4 segments where each represents 25% of regional market. This allows for discovering well engaging outlets in areas with lower user engagement.

Column name(s):

outlet_popularity_score

outlet_popularity_score_segment

outlet_popularity_score_reg_segment


Indicator values: 

Top

Good

Fair

Low

Local market rank

Local market position measures outlet position in hyperlocal environment of 1.000m radius. Attributes shows the outlet's position with regards to competition in outlet's segment. Outlets marked as Top are in top 25% of the local competition.

Column name(s):


Indicator values: 

Top

Fair

Low

Business potential

F&B Revenue rank

Estimated total business potential of an oultet. Shows the total costs of food and drinks prepared by outlet. Attribute divides market into 4 buckets (Top, Good, Fair, Low) by their spend size.

Column name(s):


Indicator values: 

Top

Good

Fair

Low

Seasonality

Seasonality helps to uncover outlets which benefit from seasonal visits (e.g. summer holidays, winter ski holidays etc.). Indicator marks outlets which are in summer or winter seasonal localities. Outlets either have summer, winter or mixed seasonality type which marks the peak season for their revenue.

Column name(s):


Indicator values: 

Summer

Winter

Mixed

Growth

Determines the outlet's business potential based on the change of the user engagement over time. There are 4 different patterns which SharpGrid identifies:

  1. Champions - Best performing outlets. Champion type outlets are well-established outlets with high growth dynamic.
  2. Steady - Well performinig outlets, Steady type of outlets are well-established but are growing at steady pace over time. Outlet of this type most likely has reached their peak in the market and their audience and further high grow should not be expected.
  3. Opportunity - Small & growing outlets. Outlets that are yet to be established, often opened recently and finding their way to the consumers. Over time they either fade out, grow to champions or reach their peak and become steady.

Column name(s):


Indicator values: 

Champion

Steady

Opportunity

Core consumer proposition(s)

Determines what makes the outlet popular with its customers or what is the main reason for consumer visit. This indicator serve to determine which products mix work the best here.

  • Active night entertainment - Outlets where people come to dance and have fun at night - all discos, clubs, dance clubs and places with regular live music belong here.
  • Adult Entertainment - Adult entertainment reserved for erotic clubs and similar outlets.
  • Active all day entertainment - Outlets where people come because there is some activity to do all day long apart from eating, drinking or snacking. People come primarily for the "activity" and they eat or drink to refresh themselves. 
  • Small Refreshment - Outlets where people come to have just one quick thing - drink, ice-cream, snack. Customers typically do not spend much time here and often consume what they bought on the go.
  • General eating out - Outlets where eating breakfast/lunch/dinner are the key reason to come. Many ordinary restaurants belong to this occasion. If such outlets offer something distinctive beyond food it gets more labels (e.g. enjoying beer, enjoying wine)
  • Sweet & baked - Outlets with a wide offering of sweets and baked products and these are an important part of a visit. Typical representatives are sweetshops, ice-cream shops, bakeries and similar outlets.
  • Coffee - Outlets with clear primary focus on selling coffee or outlets where coffee is an important part of why you visit. 
  • Tea - Mainly tea rooms and exceptionally some other places with explicit mentions of a wide variety of tea. 
  • Cocktails & spirits - Outlets which mainly offers cocktails and spirits -  bars or clubs and sometimes pubs. 
  • Wine - Primarily wine bars but also restaurants, bistros and bars with confirmed wide selection of wine. 
  • Beer - Outlets where people would go for a few beers with a group of friends. Most pubs and many restaurants esp. those serving Czech cuisine will fit here.

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