Visits Data Schema

Standard Visits Feeds

Visits

ColumnTypeDescriptionExample
MAID or hashed_maidstringMAIDs (Plain Text IDs). Please note that hashed MAIDs (mandatory when utilizing S3) via SHA-256 hashing3aa3fb9018197e28bf81d197405ea30986ade37349e1ad2812ae4c0177cad965
venue_idstringFSQ unique identifier of venues (individual store). Available if approved to receive store-level data4ba12857f964a520469d37e3
chain_idstringFSQ unique identifier of chains4b6f6361f964a52067ee2ce3
chain_namestringName of chainThe Home Depot
DMA (US only) or zipstringDMA (US only) or zip of chain user visitedLos Angeles, CA /90120
protected_timestamp*date timeDate and timestamp when user visited, +/- 2 hours; ISO 86012019-07-24 09:15:03
dwellNumberNumber of minutes a phone is in a venue (difference between start and end time)7
source_indicatorstringIndicates whether the visit is from a 1P (O&O, SDK) or 3P source1P or 3P
home_zip (US only)numberHome zip code of user, for zips with >1k in population This data point can be optional10016
confidence_scorestringFilter visits based on high/medium/low confidence score depending on your use case. Identify high confidence visits for modeling, or include medium and low confidence visits to increase scale for audience activationMedium
home_CBG*stringIndicates the census block group in which the visitor lives482012231001
work_CBG*stringIndicates the census block group in which the visitor works482012231001

Places Mapping File

ColumnTypeDescriptionExample
venueIDstringFoursquare’s unique identifier for a particular venue/location; displayed as a 24-character string5c6b234e037be1002ce54dda
venue_namestringName of the venueOld Navy
addressnumberAddress of the venue1217 Rockville Pike
citystringCity the venue is located inRockville
dma (US only)numberDMA the venue is located inWashington, DC
zipstringZip code the venue is located in20852
statestringState the venue is located inMD
countrynumberCountry the venue is located inUS
geo_latnumberLatitude coordinates of the venue39.054581
geo_longnumberLongitude coordinates of the venue-77.11638
level_1_catstringPrimary category of the venueShops & services
level_2_catstringSecondary category of the venueClothing stores
level_3_catstringTertiary category of the venueWomen’s stores
chain_idstringFoursquare’s unique identifier for a particular chain; displayed as a 24-character string556d1d36aceaff43eb0a9e60
chain_namestringName of the chainOld Navy
parent_venue_idnumberThe ID of the parent venue if this venue is located in an airport, shopping centre, etc.4eb0307f6c250ddebea09895

Research Data Feeds

Visits

ColumnTypeDescriptionExample
venueIDstringFoursquare’s unique identifier for a particular venue/location; displayed as a 24-character string5c6b234e037be1002ce54dda
utc_datedateDate of the visit in UTC time2019-07-24
utc_hournumberHour of the visit in UTC time10
local_datenumberDate of the visit in local time2019-07-24
local_hournumberHour of the visit in local hour11
genderstringModeled gender of the visitorMale or female
agestringModeled age cohort of the visitor20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84
Full_Panel_Reweighted_sag_scorenumberNormalization score assigned to visit, based on the user's state, age & gender (e.g. this 1 visit should be weighted as 87.6813336 visits, to derive insights representative of the overall US population)87.6813336
dwell_timenumberNumber of seconds a phone is in a venue (difference between start and end time)193
Home zipnumberHome zip code of user, for zips with >1k in population This data point can be optional and available in early 202110016
home_CBG*stringIndicates the census block group in which the visitor lives482012231001
work_CBG*stringIndicates the census block group in which the visitor works482012231001

Places Mapping File

ColumnTypeDescriptionExample
venueIDstringFoursquare’s unique identifier for a particular venue/location; displayed as a 24-character string5c6b234e037be1002ce54dda
venue_namestringName of the venueOld Navy
addressnumberAddress of the venue1217 Rockville Pike
citystringCity the venue is located inRockville
dmanumberDMA the venue is located inWashington, DC
zipstringZip code the venue is located in20852
statestringState the venue is located inMD
countrynumberCountry the venue is located inUS
geo_latnumberLatitude coordinates of the venue39.054581
geo_longnumberLongitude coordinates of the venue-77.11638
level_1_catstringPrimary category of the venueShops & services
level_2_catstringSecondary category of the venueClothing stores
level_3_catstringTertiary category of the venueWomen’s stores
chain_idstringFoursquare’s unique identifier for a particular chain; displayed as a 24-character string556d1d36aceaff43eb0a9e60
chain_namestringName of the chainOld Navy
parent_venue_idnumberThe ID of the parent venue if this venue is located in an airport, shopping centre, etc.4eb0307f6c250ddebea09895

Did this page help you?