Discussions

Hi team,

Hello, I was following the instructions of using DuckDB to download foot traffic/ weekly patterns from the Avdan Research. I was able to get the file list and define the date partition range. However, I kept getting the following error message when generating a data preview and querying relevant data for downloading:

I had a few questions about the new Advan Weekly Patterns Plus data.

Hi. I have noticed that in the Advan monthly patterns data, November has only 29 entries per POI. I know that this is due to day light savings. My question is that if the missing entry (date) corresponds to the same day when day light saving ends (i.e. first Sunday of November)?

Hello, I am trying to download the Foot Traffic / Weekly Patterns dataset of Advan until the most recent date, which I expected to be maximum one week ago. However, when I check the metadata it says "Data max available date: 2025-06-23". Has this dataset not been updated since June? Why and when will it be updated with the remaining months?

I am wondering how the "MEDIAN_DWELL" variable is calculated in the Advan Neighborhood Patterns dataset. The variable description is somewhat vague:

Hi, I'm running a comparison of the Advan raw daily visits to the Veraset daily visitors for a specific location for a set of dates. I'm finding that the counts are inconsistent with each other. Is Advan not using Veraset for their underlying data? Thanks! Below are the pulls I'm looking at:

Hello Dewey team,

Hello,