Chain/Venue Multi-Metrics
Overview
Placer will upload your feeds to your bucket in the schema detailed below on a daily/weekly basis.
Configuration
| Configuration aspect | Available options descriptions |
|---|---|
| Data granularity | Daily, Weekly (supporting custom weeks aggregation), and Monthly |
| File formats | CSV and PARQUET |
| Regions | The following regions can be selected for the different regional chains: - Nationwide - State - DMA - CBSA |
| Feeds time frame | The feed can be set to start at any desired start date (most earlier can be set to 1.1.2017) till the latest data date. |
| Delivery methods | Please refer to the following Delivery Details for all supported delivery options for this feed. |
| Delivery Schedule | Here is the delivery scheduling for each of the available feeds: Daily: Every day at 7 am EST Weekly: Delivered each Wednesday Monthly: Delivered on the 6th of each month |
| Control files | Supported |
| Success file | Supported |
| Amazon SNS notification | Supported |
Deliverables and Schemas
Chain/venue multi-metrics
Please refer to the definition and structure of the metrics file:
| Column | Description | Type | Example |
|---|---|---|---|
| publication_date | Data publication date | ISO-8601 | 2020-08-01 |
| version_code | Calibration version code | string | 1.0.0 |
| id | Placer's entity ID | string | '5965fca0173f564b883c222e' |
| name | Entity name | string | 'Mcdonald's' |
| type | Entity type. Supported entity types: venue, complex, chain, and billboard. | string | 'venue' |
| time_frame | Data aggregation resolution. Supported values: 'daily', 'weekly', and 'monthly'. | string | 'daily' |
| start_date | Data start date. | ISO-8601 | 2018-04-15 |
| end_date | Data end date (inclusive) | ISO-8601 | 2018-04-15 |
| region_type | 'nationwide', 'state', 'dma' and 'cbsa' are supported. Note: CBSA is the union of MSAs & micro-MSAs | string | 'nationwide' |
| region_name | Region's name | string | 'California' |
| region_code | Region's code | string | 'CA' |
| lat | The entity's latitude. Only available for entities of type 'venue' or 'complex | double | 37.786099 |
| lng | The entity's longitude. Only available for entities of type 'venue' or 'complex | double | -121.46352 |
| ticker_symbol | The stock exchange ticker symbol | string | 'MCD' |
| company_name | If available, the parent company chain name. | string | 'Mcdonald's' |
| New! DV 2.0 visit_duration_segmentation | This column displays the default segmentation of visit duration set for the analyzed Point of Interest (POI). The values within this column may fall into one of the following categories: - 'under_10_min' - '10_min_or_longer' - 'all_visits' These values will be populated by March 31st. Until then, this column will remain empty. | string | 'under_10_min' |
| foottraffic | Estimated foot-traffic in the location during the relevant time frame. Foot-traffic is extrapolated from the panel_visits. | long | 5000000 |
| home_distance _estimated_foottraffic_X (multiple columns) | The accumulative foot traffic generated by customer who live within 'X' miles of the property. Includes a column per distance(mi) as follows: 0.3, 0.5, 0.7, 1, 2, 3, 5, 7, 10, 30, 50, 100, 250, 250+ Example: 'home_distance _estimated_foottraffic_50' means the sum of foot traffic generated by customers who live within 50 miles of the property | integer | 40000 |
| home_distance _percentage_X (multiple columns) | The percentage of foot traffic generated by customer who live within 'X' miles of the property. Includes a column per distance(mi) as follows: 0.3, 0.5, 0.7, 1, 2, 3, 5, 7, 10, 30, 50, 100, 250, 250+ | double | 25.485 |
| work_distance _estimated_foottraffic_X (multiple columns) | The accumulative foot traffic generated by customer who work within 'X' miles of the property. Includes a column per distance(mi) as follows: 0.3, 0.5, 0.7, 1, 2, 3, 5, 7, 10, 30, 50, 100, 250, 250+ | integer | 4000 |
| work_distance _percentage_X (multiple columns) | The percentage of foot traffic generated by customer who work within 'X' miles of the property. Includes a column per distance(mi) as follows: 0.3, 0.5, 0.7, 1, 2, 3, 5, 7, 10, 30, 50, 100, 250, 250+ | double | 13.35 |
| foottraffic_per_sqft | The number of visits at the property during the relevant time frame by its size (square footage) | double | 10.91 |
POI Metadata
Please refer to the following page for the POI metadata schema.
Sample files
Sample #1 - Daily Chain-level data for Walmart Supercenter, Only January 2017 - CSV formatted
Sample #2 - Weekly Venue-level data for a selected Applebee's store in Q1/Q2 2017 - CSV formatted
Privacy comes first
Placer is a privacy-first company, and like all our products this feed conforms to our privacy policy as is described in our Trust Center. In situations where the content of this feed conflicts with our privacy policy, the conflicting data points will be redacted from the files.
Updated 4 months ago