kapa.ai why my event queries only allow for 93 days data
The 93-day limit you're seeing is due to date range guardrails that Mixpanel applies to certain types of queries to ensure fast performance and a smooth experience. Specifically, two scenarios trigger this 93-day cap:
Reports using All Events — queries that use the "All Events" option are limited to a maximum date range of 93 days (approximately 3 months).
Reports using cohorts — these can include up to 93 time intervals (e.g., 93 days or 93 weeks). [Date Range Guardrails]
To query beyond 93 days, consider these workarounds:
Switch from "All Events" to a specific event — selecting a named event instead of "All Events" removes the 93-day restriction (daily granularity reports can go up to 12 months).
Change the granularity — for cohort-based reports, switching from daily to weekly or monthly intervals lets you cover a longer time span within the 93-interval limit.
Use a fixed or custom date range — if you're not using "All Events" or cohorts, you can select up to 12 months at daily granularity. [Date Range Guardrails]
In summary, the 93-day limit is most likely because your report is using All Events as the event selector. Switching to a specific event should allow you to extend your date range.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
