💻Data Schema
Visits
echo_poi_id
A POI's unique and consistent identification code created by Echo Analytics
string
poi_name
Specific name of the point of interest
string
brand
A label indicating which chain/franchise the entity is operated by, if any. At Echo, an entity is only considered a brand if it has more than 3 physical locations and has a proprietary website
string
country_code
The country where the POI is located in a 2-letter ISO code format
string
latitude
The standard latitude in decimal degrees, truncated to 5 digits (approx. 1.11 meter accuracy)
float
longitude
The standard longitude in decimal degrees, truncated to 5 digits (approx. 1.11 meter accuracy)
float
geo_h3_id_level_10
A unique identifier for each H3 area (H3 = Uber's Hexagonal Hierarchical Spatial Index, a grid system with different granularity levels). At Echo, we use Level 10, which has an area of approximately 0,015 squared km
string
date_range_start
The start date of data collection for data delivered
date
date_range_end
The end date of data collection for data delivered
date
Num_of_ unique_visitors_per_1M_observed_users
Unique devices visiting the analyzed POI, expressed per one million devices observed across the country. A nationally normalized count
integer
Num_of_visits_per_1M_observed_users
Visits to the analyzed POI, expressed per one million devices observed across the country. A nationally normalized count
integer
Vists Heatmap
geo_h3_id_level_9
A unique identifier for each H3 area level 9 (H3 = Uber's Hexagonal Hierarchical Spatial Index, a grid system with different granularity levels). Level 9 has an area of approximately 0,10 squared km
string
latitude
The standard latitude in decimal degrees, truncated to 5 digits (approx. 1.11 meter accuracy)
float
longitude
The standard longitude in decimal degrees, truncated to 5 digits (approx. 1.11 meter accuracy)
float
date_range_start
The start date of data collection for data delivered
date
date_range_end
The end date of data collection for data delivered
date
Num_of_visits_per_1M_observed_users
Visits to the analyzed POI, expressed per one million devices observed across the country. A nationally normalized count
integer
Catchment Area (Hexagon, Zipcodes, IRIS (France only)
echo_poi_id
A POI's unique and consistent identification code created by Echo Analytics
string
poi_name
Specific name of the point of interest
string
brand
A label indicating which chain/franchise the entity is operated by, if any. At Echo, an entity is only considered a brand if it has more than 3 physical locations and has a proprietary website
string
country_code
The country where the POI is located in a 2-letter ISO code format
string
latitude
The standard latitude in decimal degrees, truncated to 5 digits (approx. 1.11 meter accuracy)
float
longitude
The standard longitude in decimal degrees, truncated to 5 digits (approx. 1.11 meter accuracy)
float
geo_h3_id_level_10
A unique identifier for each H3 area (H3 = Uber's Hexagonal Hierarchical Spatial Index, a grid system with different granularity levels). At Echo, we use Level 10, which has an area of approximately 0,015 squared km
string
date_range_start
The start date of data collection for data delivered
date
date_range_end
The end date of data collection for data delivered
date
home_hex_id/home_zip_code/home_iris_code
The top 10 hexagons level 10/zip codes/IRIS containing the POI visitors' home locations. Insights at IRIS code level are available only in France
integer
home_percent
The percentage of visitors with home locations in a given hexagon / zip code / IRIS
float
work_hex_id
The top 10 hexagons level 10/zip codes/IRIS containing the POI visitors' work locations
string
work_percent
The percentage of visitors with work locations in a given hexagon / zip code / IRIS
float
catchment_area_polygon
The geometric shape built using the Top 10 home & work hexagons / zip codes / IRIS of visitors of a given POI
geography
Dwell Time
echo_poi_id
A POI's unique and consistent identification code created by Echo Analytics
string
poi_name
Specific name of the point of interest
string
brand
A label indicating which chain/franchise the entity is operated by, if any. At Echo, an entity is only considered a brand if it has more than 3 physical locations and has a proprietary website
string
country_code
The country where the POI is located in a 2-letter ISO code format
string
latitude
The standard latitude in decimal degrees, truncated to 5 digits (approx. 1.11 meter accuracy)
float
longitude
The standard longitude in decimal degrees, truncated to 5 digits (approx. 1.11 meter accuracy)
float
geo_h3_id_level_10
A unique identifier for each H3 area (H3 = Uber's Hexagonal Hierarchical Spatial Index, a grid system with different granularity levels). At Echo, we use Level 10, which has an area of approximately 0,015 squared km
string
date_range_start
The start date of data collection for data delivered
date
date_range_end
The end date of data collection for data delivered
date
avgDuration (s)
Average dwell time in seconds
integer
distribution
Statistical distribution of dwell times in pre defined buckets (range 1 : from 0 to 15 minutes, range 2: from 15 minutes to 30 minutes, range 3: from 30 minutes to 45 minutes, range 4: from 45 minutes to 60 minutes, range 5: more than 60 minutes)
float
*Dwell time can also be aggregated at a brand level, available on a custom basis. Please reach out to Echo for more information.
Cross Visits
brand
Main Brand of the analysis
string
country_code
The country where the POI is located in a 2-letter ISO code format
string
date_range_start
The start date of data collection for data delivered
date
date_range_end
The end date of data collection for data delivered
date
percent_shared_visitors
Percentage of shared visitors with selected target brands
float
percent_exclusive_visitors
The percentage of visitors who were observed exclusively at the selected brand and did not appear at the target brands during the observation period. This metric reflects the level of visit exclusivity
float
*Echo can provide this analysis at a POI level (comparing POIs versus POIs). Moreover, cross-visits can be assessed not only with individual brands or POIs but also with broader POI categories (such as fast food, clothing, and other retail segments). Please reach out to Echo for more information.
Last updated
Was this helpful?