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

Sample #3 - PARQUET 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.