Foursquare Interview Questions
The questions to prepare for Foursquare interviews, across all roles. Questions from real interview reports rank first. Updated weekly.
Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
FoursquareAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreRank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.
WaymoFind the longest substring with all unique characters using a sliding window.
FoursquareSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Explain how you used a KPI and supporting metrics to diagnose a product issue and make a concrete product decision.
FoursquareDescribe how you executed an important project under tight resource constraints, balancing scope, risks, and stakeholder expectations.
FoursquareApproach for maintaining data quality and integrity across ETL pipelines.
FoursquareExplain how supervised and unsupervised learning differ, and ground the distinction in a practical ML example.
FoursquareA structured approach to planning and running a user research project that identifies user needs and drives product decisions.
FoursquareIdentify major online experiment pitfalls and explain how they can bias results in a streaming product A/B test.
Foursquare