Discussions

Ask a Question
Back to All

Duplicate Visit Counts Across Different Placekeys in Foot Traffic Data

Using the Weekly Patterns - Foot Traffic - Full Historical Data, I noticed that several rows have identical values for raw_visit_count, raw_visitor_count, and origin_home_cbg, as well as the visitor count within origin_home_cbg, even though these locations have different placekey values. I checked their parent_placekey, and while some of them share the same parent, others do not. Additionally, I examined whether all child_placekey values under the same parent_placekey had matching raw_visit_count, raw_visitor_count, and origin_home_cbg, but that wasn't always the case.