Analyzing Sentiment & Footfall in Post-COVID Berlin

Summary

Follow along as Data Appeal uses CARTO’s Location Intelligence platform to evaluate tourism in Berlin post-COVID.

This post may describe functionality for an old version of CARTO. Find out about the latest and cloud-native version here.
Analyzing Sentiment & Footfall in Post-COVID Berlin

The Data Appeal Company's Hannah Babineau - International Partnerships and Marketing Manager - guest blogs for CARTO!

With summer vacation season approaching  we’ve set out to determine if and how visitor hotspots have altered as a result of the COVID-19 pandemic. Are tourists avoiding historically crowded areas? Are travelers migrating into new neighborhoods and visiting lesser-known attractions?

By leveraging geospatial data  Sentiment Scores  the Footfall Index and our Location Intelligence partners at CARTO  Data Appeal has evaluated the city of Berlin to assess if and how the most popular points of interest have changed post-Covid.

You can explore the datasets used in this piece - as well as >10 000 others - on CARTO’s Data Observatory.

Let’s rewind to 2019

The year is 2019 and Berlin is once again a top European destination – ranked third after London and Paris in attracting travelers. The German city’s popularity continues to grow  attracting 34 million overnight stays by around 14 million visitors in just 2019 alone (Source: VisitBerlin). But how have things changed since the pandemic?

Let’s get started!

To support this analysis  we conducted a complete mapping of 946 971 points of interest across greater Berlin including all points of interest relating to retail  hospitality  food and beverage  transportation and attractions.

The interactive map below  designed by Data Appeal using CARTO’s Location Intelligence platform  is able to pinpoint the most popular places  based on customer satisfaction  footfall and by source market. Location Intelligence is one of the most advanced tools for performance evaluation  outdoor (OOH) marketing campaigns and strategic site selection.

For each point of interest  users can understand:  

     
  • Name  industry & category
  •  
  • Address
  •  
  • Sentiment Score (overall and by category)
  •  
  • Footfall Index (Popularity and foot traffic rating)
  •  
  • Service/product price range  facilities/amenities and more
  •  
  • Historic data from 2019 to present day


Open the map in a new window (ideal for mobile devices) here.

Throughout this analysis  we have uncovered four trends that are debunking what we thought we knew about post-COVID tourism.

Trend 1: Alexanderplatz records major increases in 2022

Despite the warnings to avoid large groups  travelers to Berlin can’t stay away from Alexanderpatz  the iconic public square in the city center. In fact  the Sentiment Score and Footfall Index have both increased from 79.42 to 86.99 and 60.15 to 109.05 respectively (January 2019 to 2022). When taking a deeper look  we found that this hotspot is most appreciated for its prime location  proximity to other attractions and services available in the nearby vicinity (public transportation  restrooms  etc.).

While these changes may appear minor at first  they are indeed significant. The 7 percentage point increase in Footfall is noteworthy  especially in a time where people are still cautious about gathering in large crowds. However  if there’s a silver lining to the pandemic  it’s that it has inspired travelers to get out and explore.

Trend 2: A need for green: Monbijou Park surpasses the Neptune Fountain as local hangout

While the Neptune Fountain  or Neptunbrunnen for the locals  has always been a must see  the impact of Covid has given both locals and tourists a new appreciation for green space and a moment to relax.

In fact  in January 2019  the Neptune Fountain was one of the top hangouts with a staggering Footfall Index of 99.9 and Sentiment of 84.4. However  the tables turned as a result of the pandemic  when people set out to escape the crowds and enjoy some fresh air. While people still passed by the Neptune Fountain  they continued their stroll to the Monbijou Park  a nearby public greenspace. Though Sentiment has improved thus far in 2022 (86.7)  the Neptune Fountain records a 4.2 percentage point decline with a Footfall Index of 95.7.

However the Monbijou Park reveals a different story. Whilst in January 2019 it had a high Footfall score of 95.19. Fast forward to January 2021 the Footfall increases to 97.6.  Spring forward to 2022 and the park is one of the hot-spots in Berlin  with a Footfall Index of 96.4. It seems that visitors have embraced the proverbial stop and smell the flowers.

Trend 3: Businesses Close and Sentiment Shifts

The third trend we detected was a shift in Sentiment across districts  especially Pankow to the north (+1 increase)  Mitte in the center (-1 decrease)  and Tempelhof and Schonberg to the south (-3.4 decrease).

Additionally  one staggering decrease is in the amount of active points of interest. Business across hospitality  food and beverage  retail and attractions have had to close down as a result of the pandemic as evidenced by the decrease in Points of Interest from 4 858 in Feb. 2019 to 3 793 in Feb. 2022.

2021
2021
2022
2022

Trend 4: Sentiment & Footfall hotspots

As part of the advanced functionality of CARTO’s Analytics Toolbox  we have access to the Getis-Ord spatial statistic tool. This tool allows for the identification of statistically significant hot and cold spots - i.e. areas where high and low values are clustered. This is a fantastic way of understanding and comparing spatial patterns within data.

In order to use Getis-Ord  the footfall and sentiment data for Berlin was aggregated by average to a H3 grid using CARTO’s enrich grid tool (find more about this here). H3 grids are a type of global hierarchical grid  a hexagonal zoning system which covers the entire world at multiple resolutions. These allow for incredibly fast and efficient analytics of big data. If this is the first you’re hearing about global hierarchical grids  read our blog post about them here - they’ll change the way you think about geography!

Explore the hotspot map below (mobile users may prefer to open full screen here) - pink values indicate presence of a hot spot whilst green indicate a low spot. Gray areas indicate there is no real clustering in either direction. The map on the left shows spatial clusters of footfall whilst the map on the right explores sentiment.


Open the map in a new window (ideal for mobile devices) here.

Predictably  high values of footfall cluster around Mitte and regional centers such as Güntzelkiez and Wrangelkiez. Conversely  green cold spots typically appear further from the city center. Spatial trends of sentiment are much more difficult to draw conclusions from. Whilst many clusters of high and low sentiment values do exist  these clusters are typically much smaller with trends much more localized. Areas without significant clustering are much more ubiquitous. It does not appear that there is any clear spatial relationship between footfall and sentiment. To further explore this  analysts could employ spatial statistics such as Geographically Weighted Regression which models the local variation between multiple variables.

CARTO & Data Appeal: The best of both worlds

In partnering with CARTO  Data Appeal’s datasets and proprietary KPIs can be accessed through CARTO’s user-friendly Location Intelligence platform  enabling organizations to use a range of data and bespoke spatial data science tools from CARTO’s Analytics Toolbox to undertake the following types of analysis:

     
  • Site & Distributor Selection: Strategize store or product placements
  •  
  • Market Expansion: Qualify ideal locations for their target audience
  •  
  • Competitive Intelligence: Perform accurate benchmarking and competitor analysis on points of interest and locations

Among the top KPIs used by some of the market’s biggest retail conglomerates and tourism destinations  are the Footfall Index and Sentiment Score.

The Footfall Index is an indicator - both available as ranked and absolute - calculated by online content  satellite data and aggregated mobility signals based on the selected time period. This KPI is provided both as an overall score and time of day breakdown to highlight peak and off-peak times. The Footfall Index is 100% GDPR compliant and can be applied to any Point of Interest or territory as granular as 500x500 meters.

Meanwhile  the Sentiment Score measures the level of satisfaction expressed by users online about a service  product  experience or territory. In detail  we semantically analyze geo-located online content from over 130 sources to accurately define the true customer perception and pinpoint what influences purchasing behaviors of current and future buyers to evaluate the value of any POI or territory.  

Ready to see our Location Intelligence platform in action? Get started by requesting a live demo today!