Chain/Venue Multi-Metrics - V1.1.2

CUSTOMER_BUCKET/ SUB_FOLDER

Any valid string that represents a path

The bucket and the relative in the bucket as provided in the export settings (Output/Deliver To). SUB_FOLDER could be empty. E.g. if “Deliver To” is configured to be “my-customer-bucket/incoming-files/placer”, CUSTOMER_BUCKET = “my-customer-bucket” and SUB_FOLDER = “incoming-files/placer”.

SCHEMA

multi-metric, single-metric

The path will also include the export SCHEMA, currently supported only “multi-metric” (default for new exports) “single-metric” (deprecated, still used for existing exports).

EXPORT_TYPE

daily, weekly, monthly, weekly-daily, monthly-daily, monthly-weekly

Each export has an EXPORT_TYPE that is a combination of the frequency and the aggregation. If they are the same, the type is simply the frequency. For example, a weekly export (generated once a week) with a daily level aggregation (each line represents a single day), will be defined as “weekly-daily”. If that export would have had a weekly level aggregation (each line represent a single week’s aggregated metrics), the definition would be “weekly”.

DATE_STRING

Date in the format YYYY-MM-DD

Feed's generation date

ENTITY_TYPE

chain, venue, complex or billboard

Each exported file represents an entity. And that entity has an ENTITY_TYPE.

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. See Location Info for a full list of supported types.

string

'venue'

time_frame

Data aggregation resolution. Supported values: 'daily', 'weekly', 'monthly' and 'yearly'.

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' & 'cbsa' are supported.
Only available for entities of type 'chain.'
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'

foottraffic

Estimated foot-traffic in the location during the relevant time frame. Foot-traffic is extrapolated from the panel_visits.

integer

5000000

panel_visits

The actual number of visits generated by Placer's panel (observed visit).

integer

50000

home_distance

• estimated_foottraffic_X
  (multiple columns)

The accumulative foottraffic 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 foottraffic generated by customers who live within 50 miles of the property

integer

40000

home_distance

• percentage_X
  (multiple columns)

The percentage of foottraffic 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 foottraffic 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 foottraffic 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