Brand Dominance
Use the Placer.ai Brand Dominance Data Feed to analyze Retail Chains dominance over specific regions (Zipcodes/States) over time.
The feed includes the data used to produce the Brand Dominance map, in digestible CSV files format.
https://www.placer.ai/the-square/brand-dominance-map/
How to get access?
Contact [email protected] or your account manager to enable the data-feed.
Files Delivery
Once enabled, files will be uploaded to your cloud bucket (AWS/GCS) or SFTP server (see Delivery Details for further details) once a month.
-
Files will be located under this path:
/export/analytics/brand_dominance/monthly//<region_resolution>
- upload date, example: 2020-01-11
<region_resolution> - Currently 3 regions are supported: nationwide, state, zipcode; Each delivery will include historical files for all 3 resolutions divided into these folders. -
Delivery is done until the 11th of each month, each delivery includes full data-history going back to 2017.
-
A unique CSV file will be produced per month, e.g. the file for October 2020 with a State level resolution will be named: "brand_dominance_state_2020-10-01_2020-11-01.csv"
-
Each file is GZip compressed
Data Retention and Usage
Placer's algorithms and data constantly improve, therefore we include all the history in every monthly export. We strongly suggest not to use data provided in old exports with new ones to avoid data anomalies.
Schema Overview - Nationwide
The Schema of the CSV files located under the nationwide folder. Each raw provides monthly chain Ranking and Foottraffic data.
| Column | Description | Type | Example |
|---|---|---|---|
| id | Placer's Chain ID | string | '59ae96a9173f562d3c355488' |
| name | Chain name | string | 'Dick's Sporting Goods' |
| category | Chain Category | string | 'Apparel' |
| sub_category | Chain Sub-category | string | 'Sporting Goods Shop' |
| brand_group | Used for comparison of chains ranking and visit share. Note: This field may change from time to time. | string | 'Sporting Goods' |
| time_frame | Data aggregation resolution. Supported values: 'monthly'. | string | 'monthly' |
| start_date | Data start date. | ISO-8601 | 2020-10-01 |
| end_date | Data end date (inclusive) | ISO-8601 | 2020-10-31 |
| chain_foottraffic | Estimated chain foot-traffic | number | 138489 |
| chain_rank | The chains rank (based on foot-traffic) - compared to other chains under the same brand_group | number | 1 |
| visit_share | The chains visit share percentage out of the total estimated foot-traffic per brand group | percent | 0.17 |
| region_brand_group_foottraffic | The total estimated foot-traffic per brand group | number | 825253 |
Schema Overview - State
The schema of the CSV files located under the state folder. Each raw provides monthly chain Ranking and Foottraffic data.
| Column | Description | Type | Example |
|---|---|---|---|
| id | Placer's Chain ID | string | '59ae96a9173f562d3c355488' |
| name | Chain name | string | 'Dick's Sporting Goods' |
| category | Chain Category | string | 'Apparel' |
| sub_category | Chain Sub-category | string | 'Sporting Goods Shop' |
| brand_group | Used for comparison of chains ranking and visit share. Note: This field may change from time to time. | string | 'Sporting Goods' |
| state | State name | string | 'Alabama' |
| time_frame | Data aggregation resolution. Supported values: 'monthly'. | string | 'monthly' |
| start_date | Data start date. | ISO-8601 | 2020-10-01 |
| end_date | Data end date (inclusive) | ISO-8601 | 2020-10-31 |
| chain_foottraffic | Estimated chain foot-traffic | number | 21856393 |
| chain_rank | The chains rank (based on foot-traffic) - compared to other chains under the same brand_group | number | 1 |
| visit_share | The chains visit share percentage out of the total estimated foot-traffic per brand group | percent | 0.31 |
| region_brand_group_foottraffic | The total estimated foot-traffic per brand group | number | 69868752 |
Schema Overview - Zipcode
The schema of the CSV files located under the zipcode folder. Each raw provides monthly chain Ranking and Foottraffic data.
| Column | Description | Type | Example |
|---|---|---|---|
| id | Placer's Chain ID | string | '59ae96a9173f562d3c355488' |
| name | Chain name | string | 'Dick's Sporting Goods' |
| category | Chain Category | string | 'Apparel' |
| sub_category | Chain Sub-category | string | 'Sporting Goods Shop' |
| brand_group | Used for comparison of chains ranking and visit share. Note: This field may change from time to time. | string | 'Sporting Goods' |
| state | State name | string | 'Alabama' |
| county | County name | string | 'Winston County' |
| city | City name | string | 'Addison' |
| zipcode | Zipcode number | number | 35540 |
| time_frame | Data aggregation resolution. Supported values: 'monthly'. | string | 'monthly' |
| start_date | Data start date. | ISO-8601 | 2020-10-01 |
| end_date | Data end date (inclusive) | ISO-8601 | 2020-10-31 |
| chain_foottraffic | Estimated chain foot-traffic | number | 456 |
| chain_rank | The chains rank (based on foot-traffic) - compared to other chains under the same brand_group | number | 1 |
| visit_share | The chains visit share percentage out of the total estimated foot-traffic per brand group | percent | 0.46 |
| region_brand_group_foottraffic | The total estimated foot-traffic per brand group | number | 984 |
Schema - Chain Coverage
Each export folder will include the current chain-coverage, i.e. Placer venue level coverage compare to the number of venues report by the chain's official website.
| Column | Description | Type | Example |
|---|---|---|---|
| id | Placer's Chain ID | string | '59ae96a9173f562d3c355488' |
| name | Chain name | string | 'Dick's Sporting Goods' |
| category | Chain Category | string | 'Apparel' |
| sub_category | Chain Sub-category | string | 'Sporting Goods Shop' |
| brand_group | Used for comparison of chains ranking and visit share. Note: This field may change from time to time. | string | 'Sporting Goods' |
| coverage | Placer's coverage compare to the official number of venues | percent | 0.9 |
Sample
Use the following files to review the delivery format structure.
The actual delivery will include more data (more history/chains/regions).
Link to Sample file
Updated 9 months ago