Examples
Examples
Try the starting example
- JSON Members [member ID,join date YYYY-MM-DD]
- [["A","2026-01-01"],["B","2026-01-15"],["C","2026-02-01"]]
- JSON Visits [member ID,date YYYY-MM-DD]
- [["A","2026-02-02"],["A","2026-02-10"],["C","2026-02-12"]]
- Reporting start date
- 2026-02-01
- Reporting end date
- 2026-02-28
- Inactivity threshold (days without visit)
- 20
- Join cohorts [YYYY-MM,members,window visits,visits/member]
- [["2026-01",2,2,1],["2026-02",1,1,1]]
- Member visit frequency and recency [ID,window visits,days since last visit or join]
- [["A",2,18],["B",0,44],["C",1,16]]
- Inactive member IDs
- ["B"]
Try another scenario
- JSON Members [member ID,join date YYYY-MM-DD]
- [["A","2026-01-01"],["B","2026-01-15"],["C","2026-02-01"]]
- JSON Visits [member ID,date YYYY-MM-DD]
- [["A","2026-02-02"],["A","2026-02-10"],["C","2026-02-12"]]
- Reporting start date
- 2026-02-01
- Reporting end date
- 2026-02-28
- Inactivity threshold (days without visit)
- 17
- Join cohorts [YYYY-MM,members,window visits,visits/member]
- [["2026-01",2,2,1],["2026-02",1,1,1]]
- Member visit frequency and recency [ID,window visits,days since last visit or join]
- [["A",2,18],["B",0,44],["C",1,16]]
- Inactive member IDs
- ["A","B"]
Calculation method
Calculation method
Join cohorts [YYYY-MM,members,window visits,visits/member]
Group members joined by report end by join month; count visits in inclusive reporting window.
Member visit frequency and recency [ID,window visits,days since last visit or join]
Last valid visit before report end; use join date if never visited.
Inactive member IDs
Recency≥supplied inactivity threshold.
Symbols and units
- a
- JSON Members [member ID,join date YYYY-MM-DD]
- b
- JSON Visits [member ID,date YYYY-MM-DD]
- c
- Reporting start date
- d
- Reporting end date
- e
- Inactivity threshold (days without visit)
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- Actual civil-date cohorts and inactivity. Duplicate same-day visits count separately; visits must reference known members and not precede joining. Supported limits: Up to 1000 members and 10000 visits.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.