Daily Visit Count

PlaceIQ is a data and technology company that provides accurate and actionable foot traffic data to drive strategic business decisions and power location-intelligent marketing and advertising.

The Daily Visit Count product provides normalized foot traffic for individual locations belonging to over 700 brands across the United States. The data can be used to understand store-by-store trends, compare visitation between competitors, and understand share within categories.

The dataset includes three tables:

FACT_NUM_VISIT_V2_SHARED contains the time series data by LOCATION_KEY. VISITS_NORM provides normalized visit counts by LOCAL_DATE for each location. NUM_STANDARD_VISITS provides the raw observations to the location, however it is recommended to use VISITS_NORM for any analysis.

DIM_LOCATION_TAXONOMY_SHARED contains metadata to understand what brand is associated with a given LOCATION_KEY. LOCATION_FACET can be used to identify specific brands, while LOCATION_VERTICAL, LOCATION_CATEGORY, and LOCATION_SUB_CATEGORY can be used to understand a set of brands. It is recommended to use LOCATION_FACETs beginning with 'Places->SYN->ANA' for trend analysis.

DIM_LOCATION_SHARED contains a given location's metadata in geographic terms, including the latitude & longitude of the polygon's centroid (LOCATION_CENTROID_LATITUDE & LOCATION_CENTROID_LONGITUDE), Census Block Group (CENSUS_BLOCK_GROUP), Zip Code (LOCATION_ZIPCODE_5), DMA (LOCATION_DMA_CODE), and State (LOCATION_STATE_ABBR).

搜集汇总

背景与挑战

背景概述

Daily Visit Count数据集提供美国700多个品牌门店的标准化客流量数据，包含时间序列、品牌分类和地理位置三个维度的信息表，适用于门店趋势分析和市场竞争对比。建议使用VISITS_NORM标准化数据和特定LOCATION_FACET进行趋势分析。