Weekly Patterns

Overview

Weekly Patterns data provides the same foot traffic data insights from Monthly Patterns on a
weekly basis, tracking data from Monday to the end of day on Sunday each week.

Data InformationValue
Refresh CadenceMonthly
Historical Coverage2018-Present
Geographic CoverageUnited States
Observation LevelVisits per week, by point of interest

Key Concepts

Visit Attribution

Advan Research computes the visits/visitors and other metrics inside a POI using the POI’s geometry. They do not apply any dwell time or any concept of “stops”; they rely on the polygon for accuracy. Advan Research has tested their data on 1,500 publicly traded tickers versus (a) top line revenue as reported from the companies and (b) credit card transaction counts on physical locations, and they have determined consistently that in the vast majority of cases filtering for dwell time reduces the signal and makes the correlation/forecasting worse.

Advan Research does not report data when less than 2 visitors are observed from that group. If there are
between 2 and 4 visitors this is reported as 4.

Determining Home Location

Advan Research computes a device’s home/work (night/day) location by computing the time a device spent in each building in the country; then taking the most frequented building.

Backfills

Backfill is when we take our most recent locations (i.e., addresses + geofences) and run our visit attribution algorithm backward in time to generate a new history of “backfilled” Patterns. Backfills are typically generated every time new Advan POIs are added (typically monthly, with the exception of August and December) on Advan POIs only. This means historical Patterns will only be present for all Advan POIs, including over 20,000 Industrial POIs, or any other POIs that were released on or before December 2022.

*These are the same concepts as Advan Research's Monthly Patterns dataset

Understanding Visitation and Trade Area Panels

For visitations Advan uses a panel which is consistent across time and can be normalized, in order to generate accurate year-over-year growth metrics. For trade areas visitor_home_cbgs, visitor_home_aggregation, visitor_daytime_cbgs, visitor_country_of_origin Advan uses all the panels they are receiving, for
which they have explicit permission to utilize for trade areas, as some panels prohibit Advan from computing where the cellphone spends its nights, i.e., the "home"; and its days, i.e., the "work" area.

This is a much larger panel, which intersects but does not fully contain the visitation panel, but it is more volatile month-over-month so therefore it should not be used for year-over-year comparisons (use the visitation metrics instead). Advan aligns the visitation & trade area fields by adjusting the trade area values as a percentage of the
visitations, as the sum of the trade area fields would not otherwise equal visits/visitors (Advan does not have a home census block group assigned for each visitor). Advan recommends that users interpret these trade area values as ratios or scaled indicators rather than absolute numbers due to the impact of adjustments (i.e., if one CBG has a value of 100 and another of 50, it means that the first one is about twice as large as the second one).

Updates to underlying Places data

SafeGraph made a disproportionately high number of changes to POIs in April - June 2023, this affected their usability for Advan given the history of millions of POIs were inconsistent with current data (Advan stopped taking the changes in June 2023). In particular, the ratio of shared polygons increased from ~20% to ~40% on the new POIs.

Panel

Along with the Weekly Patterns file, Advan Research also provides a Panel Overview Data to help you better understand the context of the data appearing in Weekly Patterns. They also provide a file containing information on the panel for each day of the week to help with normalization. This file will have rows for each region for each day of the week.

Home Location Distributions by State/Census Block Group ↗️

Number of Visits/Visitors by State ↗️

Normalization Stats ↗️

Schema

NameDescription
PLACEKEYUnique and persistent ID tied to this POI.
PARENT_PLACEKEYIf place is encompassed by a larger place (e.g., mall, airport), this lists the placekey of the parent place; otherwise null.
SAFEGRAPH_BRAND_IDSUnique and consistent ID that represents this specific brand.
LOCATION_NAMEThe name of the place of interest.
BRANDSIf this POI is an instance of a larger brand that we have explicitly identified, this column will contain that brand name.
STORE_IDThe unique ID associated with the store as provided and maintained by the store/brand itself.
TOP_CATEGORYThe label associated with the first 4 digits of the POI’s NAICS category.
SUB_CATEGORYThe label associated with all 6 digits of the POI’s NAICS category. For POIs with a 4-digit NAICS category, this column is null.
NAICS_CODE4-digit or 6-digit NAICS code describing the business.
LATITUDELatitude coordinate of the place of interest.
LONGITUDELongitude coordinate of the place of interest.
STREET_ADDRESSStreet address of the place of interest.
CITYThe city of the point of interest.
REGIONThe state, province, county, or equivalent of how "region" is understood in a given country for the place of interest.
POSTAL_CODEThe postal code of the place of interest.
OPEN_HOURSA JSON string with days as keys and opening & closing times (in the POI's local time) as values. See open_hours for more details.
CATEGORY_TAGSAn array of descriptive tags indicating higher-resolution category information.
OPENED_ONThe outside year and month this POI opened in yyyy-mm format. If null, then we do not have enough metadata to determine an open date.
CLOSED_ONThe outside year and month this POI closed in yyyy-mm format. If null, then this POI is open.
TRACKING_CLOSED_SINCEIndicates the year and month we started tracking "closed_on" for this POI.
WEBSITESThe web URL for the POI's publicly available website.
GEOMETRY_TYPEThe geometric shape associated with this POI. Possible values: POLYGON or POINT.
POLYGON_WKTThe shape of the place of interest, formatted as Well-Known Text (WKT).
POLYGON_CLASSClassification of the polygon: OWNED_POLYGON or SHARED_POLYGON.
ENCLOSEDIf true, the POI is completely enclosed indoors by its parent and is only accessible by entering the parent structure.
PHONE_NUMBERThe phone number of this POI.
IS_SYNTHETICIf true, this is not a precise POI footprint polygon but an inferred polygon.
INCLUDES_PARKING_LOTWhether or not the polygon includes the parking lot.
ISO_COUNTRY_CODEThe 2-letter ISO 3166-1 alpha-2 country code.
WKT_AREA_SQ_METERSThe calculated area of the polygon_wkt in square meters.
DATE_RANGE_STARTStart date of the date range.
DATE_RANGE_ENDEnd date of the date range.
RAW_VISIT_COUNTSNumber of visits in our panel to this POI during the date range.
RAW_VISITOR_COUNTSNumber of unique visitors from our panel to this POI during the date range.
VISITS_BY_DAYThe number of visits to the POI each day (local time) over the covered time period.
VISITS_BY_EACH_HOURThe number of visits to the POI (local time) over the covered time period.
POI_CBGThe census block group the POI is located within.
VISITOR_HOME_CBGSThe number of visitors to the POI from each census block group based on visitor's home location.
VISITOR_HOME_AGGREGATIONNumber of visitors from each census tract based on home location.
DISTANCE_FROM_HOMEMedian distance from home traveled by visitors in meters.
MEDIAN_DWELLMedian minimum dwell time in minutes.
RELATED_SAME_DAY_BRANDOther brands visited on the same day. Limited to top 20.
NORMALIZED_VISITS_BY_STATE_SCALINGVisits scaled using the mobile device sampling rate for the POI's state.
NORMALIZED_VISITS_BY_REGION_NAICS_VISITSraw_visit_counts divided by the sum(raw_visit_counts) to the naics_code in the same state or province during the same time period. This measures changes in the category-specific popularity of the POI over time.
NORMALIZED_VISITS_BY_REGION_NAICS_VISITORSraw_visit_counts divided by the sum(raw_visitor_counts) to the naics_code in the same state or province during the same time period. This measures changes in the visits per devices that visited the same category in Advan's panel to the POI over time.
NORMALIZED_VISITS_BY_TOTAL_VISITSraw_visit_counts divided by the total_visits in the same state or province during the same time period. This measures changes in the relative popularity of POI over time.
NORMALIZED_VISITS_BY_TOTAL_VISITORSraw_visit_counts divided by the total_devices_seen in the same state or province during the same time period. This measures changes in the visits per device in Advan's panel to the POI over time.