💻Data Schema
echo_poi_id
A POI's unique and consistent Identification code created by Echo Analytics
string
echo_poi_id_v2
An improved version of our echo_poi_id. End of Q3/early Q4 this attribute will be rename as echo_poi_id and will replace the current version 1.
string
poi_name
Specific name of the physical place 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
tier1_category
Echo Analytics has its own taxonomy, which indicates which industry the POI falls under. Tier 1 indicates the least granular category, E.g Retail
string
tier2_category
Echo Analytics has its own taxonomy, which indicates which business the POI operates in. Tier 2 indicates the most granular category level, E.g. Clothing Stores
string
tier1_naics_code
The code that belongs to the highest level tier of the North American Industry Classification System
integer
tier1_naics_category
The category that belongs to the highest level tier of the North American Industry Classification System
string
tier2_naics_code
The code that belongs to the second highest level tier of the North American Industry Classification System
integer
tier2_naics_category
The category that belongs to the second highest level tier of the North American Industry Classification System
string
tier3_naics_code
The code that belongs to the third highest level tier of the North American Industry Classification System
integer
tier3_naics_category
The category that belongs to the third highest level tier of the North American Industry Classification System
string
tier4_naics_code
The code belongs to the second to last level tier of the North American Industry Classification System
integer
tier4_naics_category
The category that belongs to the second to last level tier of the North American Industry Classification System
string
tier5_naics_code
The code that belongs to the lowest level tier of the North American Industry Classification System
integer
tier5_naics_category
The category that belongs to the lowest level tier of the North American Industry Classification System
string
business_status
This indicates whether the POI is operational, temporarily closed, or permanently closed
string
full_address
Full address of the POI, it contains all available information about the address. (street name, street number, admin boundaries, zip code, etc.)
string
street_number
Street number, street name
string
zip_code
Zip code
string
admin_boundary_3
City, village, town
string
admin_boundary_2
Municipality, Suburb, County
string
admin_boundary_1
State, region
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 15 meters
string
parent_organization
A legal entity that runs the stated brand/franchise. This is the indicator of the business group that the company is listed under, Eg: Esso is owned by the Parent Organization Exxon Mobil Corporation
string
stock_ticker
The stock ticker symbol is a unique series of letters associated with publicly listed parent organisations E.g. McDonald's = MCD
string
opening_hours
Indicates the operating hours of the POI business (if applicable). Operating hours formatting can vary for each POI. E.g. (Mo-Fr 09:00-19:30; Sa 10:00-17:00)
string
phone_number
The phone number of the POI business (if applicable). E.g. +33673647563
string
website
URL of the official website tied to the POI business. Can sometimes be just the domain name of the company itself, can be a Facebook page associated to the business, or can be a detailed URL of the specific store of that chain
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
footfall_around_poi
The total count of all the unique individuals who were in the vicinity of the POI (400m radius) during the time aggregated. All people are considered, even the ones with a dwell time of 0 seconds.
integer
unique_visitors
The total count of unique individuals who visit a place during the aggregated time. To assign visitors to a POI, we consider all the signals found in the polygon of the POI as well as all signals found in a buffer of 30 meters around the POI. The buffer area is drawn from the edge of the polygon and not its centroid
integer
visits
The total number of times a place is visited during the aggregated time
integer
avg_visits_per_visitors
The average number of visits per visitor to a place during the time aggregated
float
median_dwell_time
The median dwell time of all visits to a place during the aggregated time. The median means that outliers’ values (very high dwell time of 10 days for example) are excluded so that the number calculated is not skewed by the outlier's values. The dwell time is give in seconds
integer
percent_shared_visitors
The top 10 brands or categories most visited by visitors to the POI during the aggregated time
float
before_event_percent_shared_visitors
The top 10 most visited brands or categories by visitors before visiting the selected place, during the aggregated time.
float
after_event_percent_shared_visitors
The top 10 most visited brands or categories by visitors after visiting the selected place, during the aggregated time.
float
home_location_h3_ids
The home location of all the visitors from a place, given in an h3 hexagon 7 (h7) We give the breakdown in %. We limit the results to the top 10 home locations. Beyond that number, the % tends to be very small and not meaningful.
string
work_location_h3_ids
The work location of all the visitors from a place, given in an h3 hexagon 7 (h7) We give the breakdown in %. We limit the results to the top 10 work locations. Beyond that number, the % tends to be very small and not meaningful.
string
catchment_area_polygon
The geometric shape that defines the catchment area of a given location. It is built using the home and work locations of its visitors. It helps businesses understand their customer base's geographical distribution.
geography
avg_brands_visited
The average number of brands visited by a visitors of a given location during the time aggregation of the analyse.
float
Last updated