Skip to content

Points Of Interest - Sentiment and Footfall

This CSV file relates to POI_Main_Listing file through the poi_id key field.

Field Description Type
poi_id primary key Unique POI identifier. STRING
date primary key The date of the analysis, based on the aggregated period chosen:
  • DAILY: the single day (ex. 2022-01-13).
  • WEEKLY: the first day of the week, starting from Monday (ex. 2022-01-10).
  • MONTHLY: the first day of the month (ex. 2022-01-01).
  • QUARTERLY: the first day of the quarter (ex. 2022-01-01).
 DATE
reviews Total number of online reviews retrieved during the period of analysis. INTEGER
sentiment Overall sentiment calculated over online content retrieved during the period of analysis.
Valid ranges: 0 (minimum) to 100 (maximum).		 DOUBLE
footfall The footfall score is a proprietary, absolute and uncapped index that measures the foot traffic and popularity of a POI over time. This indicator takes into account various factors, such as the number of geo-localised reviews and social media content and others when available.
Footfall can be compared among POIs/tiles of the same industry.		 DOUBLE

*The above fields in bold are considered the primary keys of the csv file.