Skip to content

Location - Sentiment and Footfall by Customer Type

Field Description Type
geometry_id primary key Geometry unique identifier. STRING
geometry WKT format. 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
customer_type primary key Customer’s type: business, couple, family, groups, solo. STRING
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

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