Venue-Info Metadata

Used alongside the Chain/Venue Metrics data-feed, the 'Venue Info Feed', provides additional static metadata, such as an address, category, store ID, etc for every Venue/Complex that is included in your feed.

🚧

Note

This feed is usually used for use cases such as:

  1. Mapping Placer's venues/complex to your own venues using store ID, address, etc
  2. Decide on which IDs to include in advanced aggregations based on the provided meta-data

This feed should not be used for building your own Venue database or for any usage that is not (or loosely) related to Placer's data. Any caching of the venue's info data requires written confirmation from Placer.ai.

Files Delivery

  • Once enabled, Venue Info metadata files*CSV/PARQUET) will be added to your Chain/Venue Metrics data-feed under the metadata subfolder. Example path: '/export/analytics/multi_metrics/weekly/2020-01-30/chains/metadata/'

  • Files are created per chain. Examples:
    Walmart_Supercenter_2020-07-27.csv.gz - The Venue Info for all Walmart properties that were included in the Data-Feed file of July 27, 2020.

  • The files can be generated as either CSV or PARQUET formatted

  • Each file is a GZip compressed file

🚧

Data Retention and Usage

Placer's algorithms and data constantly improve. Therefore, Venue Info may change occasionally, and new venues may be added. We strongly suggest not using data provided in old exports with new ones to avoid data anomalies.

Schema Overview

Each file will have the following columns:

Column

Description

Type

Example

id

Placer's entity ID

string

'59ae96a9173f562d3c355488'

type

Entity type. See Location Info for a full list of supported types.

string

'venue'

name

Entity's Name (in many cases will be the same as the chain's name)

string

'Dick's Sporting Goods'

chain_id

Parent Chain ID

string

588795f54c0da83f6d1c1414

chain_name

Parent Chain Name

string

'Dick's Sporting Goods'

lat

The entity's latitude.

double

37.786099

lng

The entity's longitude.

double

-121.46352

category

Entity's Category

string

'Apparel'

sub_category

Entity's Sub-category.

string

'Recreational & Sporting Goods'

store_id

If available, the official store ID as defined by the parent chain.

string

'82358'

address

Entity's address (Street + number)

string

700-706 Mission St

city

Entity's city name

string

San Francisco

state_name

Entity's state name

string

California

state_code

Entity's state code

string

CA

country

Entity's country name

string

United States

country_code

Entity's country code

string

US

zipcode

Entity's zipcode

string

94103

dma_name

The DMA's name

string

"Albany, GA"

dma_code

The DMA's code

number

525

cbsa_name

The MSAs or micro-MSAs name

string

"San Luis Obispo-Paso Robles, CA Metro Area"

cbsa_code

The MSAs or micro-MSAs number

number

42020

opening_date

The first known date a certain venue was publicly opened

ISO-8601 date

2020-08-01

closing_date

The last known date a certain venue was closed

ISO-8601 date

2020-09-01

enclosing_shopping_center_id

The POI ID of the enclosing shopping center for the requested

string

'5f1da6d1e7e43b78baea93df'

enclosing_shopping_center_name

The POI name of the enclosing shopping center for the requested

string

'Long Beach Towne Center111'

category_group

Business domains.

string

'Apparel'

publication_date

Data publication date

ISO-8601

2020-08-01