Get cohort analysis.If you specify neither an interval nor a unit, the interval is 1 day. This means that each user gets 24 hours in each interval to do the specified event.An example response with a born_event of ‘event integration’ and event of ‘viewed report’ might look like this:
These results indicate that on 2012-01-02, 10 users did the born_event (“event integration”), as indicated by the first field. If the retention_type=compounded, then first will instead indicate the number of users who did event (“viewed report”) on the specified date. 9 of those users did event (“viewed report”) within 24 hours (the “0th” interval) of doing the born_event. Seven of those did event between 24 and 48 hours (interval 1) of the born_event. These 7 are a subset of the initial 10, but not necessarily a subset of the 9 (retention is not a funnel; see the number increase between 72 and 96 hours). And finally, 6 users did event between 48 and 72 hours (interval 2) after the born_event.In the Mixpanel retention UI, “First time” corresponds to retention_type=birth, and “Recurring” corresponds to retention_type=compounded.The Query API has a rate limit of 60 queries per hour and a maximum of 5 concurrent queries.
Must be either "birth" or "compounded". Defaults to "birth". The “birth” retention type corresponds to first time retention. The “compounded” retention type corresponds to recurring retention. See the Types of Retention article for more information.
The number of units (can be specified in either days, weeks, or months) that you want per individual bucketed interval. May not be greater than 90 days if days is the specified unit. The default value is 1.
The number of individual buckets, or intervals, that are returned; defaults to 1. Note that we include a "0th" interval for events that take place less than one interval after the initial event.
A counting method for retention queries where retention values accumulate from right to left, i.e. day N is equal to users who retained on day N and any day after. The default value of false does not perform this accumulation. Learn more about Counting Method.
{"docsConfig":{"theme":"sequoia","$schema":"https://mintlify.com/docs.json","name":"Mixpanel","colors":{"primary":"#7856ff","light":"#7856ff","dark":"#1b0b3a"},"logo":{"light":"https://mintcdn.com/mixpanel-edb78807/DbK2t9axJQF3qO_F/logo/light.svg?fit=max\u0026auto=format\u0026n=DbK2t9axJQF3qO_F\u0026q=85\u0026s=6197d81a55ffdba599db8650555eb912","dark":"https://mintcdn.com/mixpanel-edb78807/DbK2t9axJQF3qO_F/logo/dark.svg?fit=max\u0026auto=format\u0026n=DbK2t9axJQF3qO_F\u0026q=85\u0026s=84d73a51982dfb741e7b218aa5800da1","href":"https://mixpanel.com/home/"},"favicon":"https://mintcdn.com/mixpanel-edb78807/GuD3mcBg6zjCWsvh/favicon.png?fit=max\u0026auto=format\u0026n=GuD3mcBg6zjCWsvh\u0026q=85\u0026s=62e7fd3264b57e48f4366724ac591cc3","appearance":{"default":"light"},"background":{"color":{"dark":"#242133"}},"navbar":{"links":[{"href":"https://mixpanel.com/login","label":"Login"},{"href":"https://mixpanel.com/contact-us/sales","label":"Contact Sales"}],"primary":{"type":"button","label":"Get Started Free","href":"https://mixpanel.com/register"}},"footer":{"socials":{"x":"https://x.com/mixpanel","github":"https://github.com/mixpanel","linkedin":"https://www.linkedin.com/company/mixpanel-inc-"}},"seo":{"metatags":{"canonical":"https://docs.mixpanel.com"}},"fonts":{"heading":{"family":"Garnett Medium","source":"https://cdn.mxpnl.com/static/marketing/fonts/garnett/garnett-medium.woff2","format":"woff2"},"body":{"family":"Garnett","source":"https://cdn.mxpnl.com/static/marketing/fonts/garnett/garnett-regular.woff2","format":"woff2"}},"styling":{"codeblocks":"system","latex":true},"integrations":{"gtm":{"tagId":"GTM-MRDR9SP"},"mixpanel":{"projectToken":"metrics-1"}},"contextual":{"options":["copy","view","chatgpt","claude","perplexity","grok","mcp","cursor","vscode"],"display":"header"},"navigation":{"global":{"anchors":[{"anchor":"About Us","icon":"circle-question","href":"https://mixpanel.com/about"},{"anchor":"Community","icon":"users","href":"https://community.mixpanel.com/"},{"anchor":"Blog","icon":"newspaper","href":"https://mixpanel.com/blog"}]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"mixpanel-edb78807","hasAudioNarration":false,"actualSubdomain":"mixpanel-edb78807","customDomains":["docs.mixpanel.com"],"gitSource":{"type":"github","owner":"mixpanel","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":false,"mountPath":"","label":""},"feedback":{"thumbs":true,"contextualFeedback":{"allowEmail":false},"edits":true,"issues":true,"agentFeedback":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"REMOVE_BRANDING":{"status":"ENABLED"},"CONTEXTUAL_FEEDBACK":{"status":"ENABLED"},"CODE_SNIPPET_FEEDBACK":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6af3b57c4c06ccda963787a7","clientVersion":"0.0.4111","searchFilterCounts":[{"language":"default","tag":"Docs","count":224},{"language":"default","tag":"API Docs","count":163},{"language":"default","tag":"DATA IN","count":89},{"language":"default","tag":"Tracking Methods","count":62},{"language":"default","tag":"DATA OUT","count":51},{"language":"default","tag":"Guides","count":49},{"language":"default","tag":"ANALYSIS","count":37},{"language":"default","tag":"Integrations","count":37},{"language":"default","tag":"SDKs","count":29},{"language":"default","tag":"ADMIN","count":28}],"searchSettings":{"maxResults":20}},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":true,"enableContextualStarterQuestions":true,"enableAskAiSearchBar":true,"deflection":{"enabled":true,"email":"support@mixpanel.com","showHelpButton":true}},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"starterQuestions":[{"_id":"69b359f377281040f2f1a46e","deploymentId":"69b350f33e949c7a5a4dbb8c","questionText":"What value can I get from using Mixpanel?","status":"active","generatedBy":"manual","createdAt":"2026-03-13T00:27:31.956Z","updatedAt":"2026-03-13T00:27:31.956Z","__v":0},{"_id":"69b359e977281040f2f1a41d","deploymentId":"69b350f33e949c7a5a4dbb8c","questionText":"How do I send my first event?","status":"active","generatedBy":"manual","createdAt":"2026-03-13T00:27:21.832Z","updatedAt":"2026-03-13T00:27:21.832Z","__v":0},{"_id":"69b359e277281040f2f1a3f7","deploymentId":"69b350f33e949c7a5a4dbb8c","questionText":"What events should I track?","status":"active","generatedBy":"manual","createdAt":"2026-03-13T00:27:14.345Z","updatedAt":"2026-03-13T00:27:14.345Z","__v":0}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":".dark li[id=\"topbar-cta-button\"]>a>span{background-color:#8363fe!important}h5,h6{font-weight:bold}.create-service-account{display:flex;margin:18px 0}.create-service-account img{width:80%}@media (max-width: 1400px){.create-service-account img{width:100%}}.mixpanel-custom-two-column{display:flex;margin:18px 0}.mixpanel-custom-two-column div{width:100%;margin:15px 0}.mixpanel-custom-two-column .image-container{display:flex}.mixpanel-custom-two-column .image-container img{height:300px}#navbar>div.z-0.absolute.inset-0.bg-background-light.dark\\:bg-background-dark,#navbar>div.z-10.relative>div.hidden.lg\\:block.bg-gray-50.dark\\:bg-gray-900{background-color:#f5f2f2!important}.dark #navbar>div.z-0.absolute.inset-0.bg-background-light.dark\\:bg-background-dark,.dark #navbar>div.z-10.relative>div.hidden.lg\\:block.bg-gray-50.dark\\:bg-gray-900{background-color:#2b273f!important}ul.contains-task-list,ul.contains-task-list>li.task-list-item{padding-left:0!important}ul.contains-task-list>li.task-list-item:before{width:0;height:0}.dark #content{color:#e2e1e6}.mxp-cookie-preferences-link{display:inline-block;margin-left:1rem;font-size:0.875rem;color:inherit;opacity:0.7;text-decoration:none}.mxp-cookie-preferences-link:hover{opacity:1}.mxp-subscribe-button{background-image:linear-gradient(to top, #7856ff, #9075ff);box-shadow:0 1px 2px 0 rgb(0 0 0 / 0.05)}.mxp-subscribe-button:disabled{opacity:0.5;cursor:not-allowed}.mxp-subscribe-dialog{margin:auto}.mxp-subscribe-dialog::backdrop{background-color:rgb(0 0 0 / 0.8)}.mxp-subscribe-modal{background-color:#fbf9f9}.dark .mxp-subscribe-modal{background-color:#201f24}.mxp-subscribe-error{color:#cc332b}.mxp-extended-button{padding-top:0.625rem;padding-bottom:0.625rem;background-image:linear-gradient(to bottom, #9b7eff, #7856ff)}.mxp-extended-button:hover{box-shadow:0 4px 6px -1px rgb(0 0 0 / 0.1), 0 2px 4px -2px rgb(0 0 0 / 0.1)}.mxp-extended-button:active{background-image:linear-gradient(to bottom, #9b7eff, #5028c0)}"}],"page":{"pagePath":"reference/retention-query","slug":"/reference/retention-query","pageMetadata":{"openapi":"openapi/query.openapi.yaml GET /retention","title":"Query Retention Report","description":"Query retention (cohort analysis) data for users who did a born event and then a return event, with interval and unit options","href":"/reference/retention-query"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Query retention (cohort analysis) data for users who did a born event and then a return event, with interval and unit options\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,p:`p`,pre:`pre`,span:`span`,..._provideComponents(),...props.components},{CodeBlock}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`Get cohort analysis.`}),`\n`,_jsxs(_components.p,{children:[`If you specify neither an `,_jsx(_components.code,{children:`interval`}),` nor a `,_jsx(_components.code,{children:`unit`}),`, the `,_jsx(_components.code,{children:`interval`}),` is 1 day. This means that each user gets 24 hours in each interval to do the specified event.`]}),`\n`,_jsxs(_components.p,{children:[`An example response with a `,_jsx(_components.code,{children:`born_event`}),` of ‘event integration’ and `,_jsx(_components.code,{children:`event`}),` of ‘viewed report’ might look like this:`]}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`14`,language:`json`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`json`,children:_jsxs(_components.code,{language:`json`,numberOfLines:`14`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`{`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"2012-01-01\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: {`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"counts\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: [`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`2`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`2`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`],`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"first\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`2`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` },`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"2012-01-02\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: {`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"counts\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: [`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`9`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`7`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`6`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`],`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"first\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`10`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` },`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"2012-01-03\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: {`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"counts\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: [`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`9`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`6`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`4`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`],`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#116329`,\"--shiki-dark\":`#9CDCFE`},children:` \"first\"`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`: `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`10`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` }`})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`}`})}),`\n`]})})}),`\n`,_jsxs(_components.p,{children:[`These results indicate that on 2012-01-02, 10 users did the `,_jsx(_components.code,{children:`born_event`}),` (“event integration”), as indicated by the first field. If the `,_jsx(_components.code,{children:`retention_type=compounded`}),`, then first will instead indicate the number of users who did `,_jsx(_components.code,{children:`event`}),` (“viewed report”) on the specified date. 9 of those users did `,_jsx(_components.code,{children:`event`}),` (“viewed report”) within 24 hours (the “0th” interval) of doing the `,_jsx(_components.code,{children:`born_event`}),`. Seven of those did `,_jsx(_components.code,{children:`event`}),` between 24 and 48 hours (interval 1) of the `,_jsx(_components.code,{children:`born_event`}),`. These 7 are a subset of the initial 10, but not necessarily a subset of the 9 (retention is not a funnel; see the number increase between 72 and 96 hours). And finally, 6 users did `,_jsx(_components.code,{children:`event`}),` between 48 and 72 hours (interval 2) after the `,_jsx(_components.code,{children:`born_event`}),`.`]}),`\n`,_jsxs(_components.p,{children:[`In the Mixpanel retention UI, “First time” corresponds to `,_jsx(_components.code,{children:`retention_type=birth`}),`, and “Recurring” corresponds to `,_jsx(_components.code,{children:`retention_type=compounded`}),`.`]}),`\n`,_jsx(_components.p,{children:`The Query API has a rate limit of 60 queries per hour and a maximum of 5 concurrent queries.`})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"codeStyling":"system","config":{},"pageMetadata":{"openapi":"openapi/query.openapi.yaml GET /retention","title":"Query Retention Report","description":"Query retention (cohort analysis) data for users who did a born event and then a return event, with interval and unit options","href":"/reference/retention-query"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":["/_mintlify/custom/mixpanel-edb78807/d49abd19d2d5d678/scripts/sentry.js","/_mintlify/custom/mixpanel-edb78807/c8ec676755c57705/scripts/trustarc.js"],"openApiReferenceData":{"operation":{"operationId":"retention-query","summary":"Query Retention Report","tags":["Retention"],"description":"Query retention (cohort analysis) data for users who did a born event and then a return event, with interval and unit options","parameters":["b59a710d-6c28-457a-ae09-afa74170c810","63786d8d-9d8c-4118-b34e-15b593e1dac0","f1847844-3e25-4176-b96f-77abba1fe92e","06a205cd-b8f7-4516-b7fb-43770b2b28e5","5e1c678b-be19-446a-b188-00f4bce84e20","20e2ff41-c4de-4127-ba46-2965ad2fd12b","af2d96cb-93df-49be-b6b6-db0a3337699f","56a13e5b-253c-4ac0-a0cf-f3ba3bf51271","ddf64b1a-7be9-4ba4-86d9-45ca04fade05","a13f1cc7-5429-4819-9f1e-517eea688e69","3fd99982-e903-4306-abd5-a4af363e87e0","28b08179-74a4-4ae5-9dbf-8cd2138a1ddc","7e0e5135-1d6c-423d-b877-b72a3bb48d38","f70366c0-01cf-4ac4-a08b-9d78cea338e4","66a2e652-8577-4674-9d80-772c955cbdda"],"responses":{"200":"33e4809d-5135-44c5-a0cc-40aa62bfe22e"},"method":"get","type":"path","servers":["40a76f4a-2435-48b0-a5da-46d99b75dd04"],"security":["848fa3ad-9051-479a-bd28-36747af9b5a7","e01d7dc4-85e8-4dc3-a579-ce0fea51556f"],"path":"/retention","baseUrlOptions":["https://{regionAndDomain}.com/api/query"],"title":"Query Retention Report","codeSamples":[],"requiredOnlyExamples":false,"requestExampleType":"generated","responseExampleType":"generated"},"dependencies":{"parameters":{"b59a710d-6c28-457a-ae09-afa74170c810":{"in":"query","name":"project_id","schema":{"type":"integer","isRequired":true,"description":"Required if using service account to authenticate request.","uniqueKey":"","typeLabel":"integer"},"description":"Required if using service account to authenticate request.","required":true},"63786d8d-9d8c-4118-b34e-15b593e1dac0":{"in":"query","name":"workspace_id","schema":{"type":"integer","description":"The id of the workspace if applicable.","uniqueKey":"","typeLabel":"integer"},"description":"The id of the workspace if applicable."},"f1847844-3e25-4176-b96f-77abba1fe92e":{"in":"query","name":"from_date","schema":{"type":"string","isRequired":true,"description":"The date in yyyy-mm-dd format to begin querying from. This date is inclusive.","uniqueKey":"","typeLabel":"string"},"description":"The date in yyyy-mm-dd format to begin querying from. This date is inclusive.","required":true},"06a205cd-b8f7-4516-b7fb-43770b2b28e5":{"in":"query","name":"to_date","schema":{"type":"string","isRequired":true,"description":"The date in yyyy-mm-dd format to query to. This date is inclusive.","uniqueKey":"","typeLabel":"string"},"description":"The date in yyyy-mm-dd format to query to. This date is inclusive.","required":true},"5e1c678b-be19-446a-b188-00f4bce84e20":{"in":"query","name":"retention_type","schema":{"type":"string","enum":["birth","compounded"],"example":"birth","description":"Must be either \"birth\" or \"compounded\". Defaults to \"birth\". The “birth” retention type corresponds to first time retention. The “compounded” retention type corresponds to recurring retention. See the [Types of Retention](https://help.mixpanel.com/hc/en-us/articles/360001370146) article for more information.","uniqueKey":"","typeLabel":"enum\u003cstring>"},"description":"Must be either \"birth\" or \"compounded\". Defaults to \"birth\". The “birth” retention type corresponds to first time retention. The “compounded” retention type corresponds to recurring retention. See the [Types of Retention](https://help.mixpanel.com/hc/en-us/articles/360001370146) article for more information."},"20e2ff41-c4de-4127-ba46-2965ad2fd12b":{"in":"query","name":"born_event","schema":{"type":"string","example":"Added to cart","description":"The first event a user must do to be counted in a birth retention cohort. Required when retention_type is \"birth\"; ignored otherwise.","uniqueKey":"","typeLabel":"string"},"description":"The first event a user must do to be counted in a birth retention cohort. Required when retention_type is \"birth\"; ignored otherwise."},"af2d96cb-93df-49be-b6b6-db0a3337699f":{"in":"query","name":"event","schema":{"type":"string","example":"Viewed report","description":"The event to generate returning counts for. Applies to both birth and compounded retention. If not specified, we look across all events.","uniqueKey":"","typeLabel":"string"},"description":"The event to generate returning counts for. Applies to both birth and compounded retention. If not specified, we look across all events."},"56a13e5b-253c-4ac0-a0cf-f3ba3bf51271":{"in":"query","name":"born_where","schema":{"type":"string","example":"properties[\"$os\"]==\"Linux\"","description":"An expression to filter born_events by. See the [expressions section](/reference/segmentation-expressions) above.","uniqueKey":"","typeLabel":"string"},"description":"An expression to filter born_events by. See the [expressions section](/reference/segmentation-expressions) above."},"ddf64b1a-7be9-4ba4-86d9-45ca04fade05":{"in":"query","name":"where","schema":{"type":"string","example":"properties[\"$os\"]==\"Linux\"","description":"An expression to filter born_events by. See the [expressions section](/reference/segmentation-expressions) above.","uniqueKey":"","typeLabel":"string"},"description":"An expression to filter born_events by. See the [expressions section](/reference/segmentation-expressions) above."},"a13f1cc7-5429-4819-9f1e-517eea688e69":{"in":"query","name":"interval","schema":{"type":"integer","example":1,"description":"The number of units (can be specified in either days, weeks, or months) that you want per individual bucketed interval. May not be greater than 90 days if days is the specified unit. The default value is 1.","uniqueKey":"","typeLabel":"integer"},"description":"The number of units (can be specified in either days, weeks, or months) that you want per individual bucketed interval. May not be greater than 90 days if days is the specified unit. The default value is 1."},"3fd99982-e903-4306-abd5-a4af363e87e0":{"in":"query","name":"interval_count","schema":{"type":"integer","example":1,"description":"The number of individual buckets, or intervals, that are returned; defaults to 1. Note that we include a \"0th\" interval for events that take place less than one interval after the initial event.","uniqueKey":"","typeLabel":"integer"},"description":"The number of individual buckets, or intervals, that are returned; defaults to 1. Note that we include a \"0th\" interval for events that take place less than one interval after the initial event."},"28b08179-74a4-4ae5-9dbf-8cd2138a1ddc":{"in":"query","name":"unit","schema":{"type":"string","enum":["day","week","month"],"example":"day","description":"The interval unit. It can be \"day\", \"week\", or \"month\". Default is \"day\".","uniqueKey":"","typeLabel":"enum\u003cstring>"},"description":"The interval unit. It can be \"day\", \"week\", or \"month\". Default is \"day\"."},"7e0e5135-1d6c-423d-b877-b72a3bb48d38":{"in":"query","name":"unbounded_retention","schema":{"type":"boolean","default":false,"example":false,"description":"A counting method for retention queries where retention values accumulate from right to left, i.e. day N is equal to users who retained on day N and any day after. The default value of false does not perform this accumulation. [Learn more about Counting Method](https://help.mixpanel.com/hc/en-us/articles/360045484191).","uniqueKey":"","typeLabel":"boolean"},"description":"A counting method for retention queries where retention values accumulate from right to left, i.e. day N is equal to users who retained on day N and any day after. The default value of false does not perform this accumulation. [Learn more about Counting Method](https://help.mixpanel.com/hc/en-us/articles/360045484191)."},"f70366c0-01cf-4ac4-a08b-9d78cea338e4":{"in":"query","name":"on","schema":{"type":"string","description":"The property expression to segment the second event on. See the [expressions section](/reference/segmentation-expressions) above.","uniqueKey":"","typeLabel":"string"},"description":"The property expression to segment the second event on. See the [expressions section](/reference/segmentation-expressions) above."},"66a2e652-8577-4674-9d80-772c955cbdda":{"in":"query","name":"limit","schema":{"type":"integer","description":"Return the top limit segmentation values. This parameter does nothing if \"on\" is not specified.","uniqueKey":"","typeLabel":"integer"},"description":"Return the top limit segmentation values. This parameter does nothing if \"on\" is not specified."}},"responses":{"33e4809d-5135-44c5-a0cc-40aa62bfe22e":{"description":"Success.","content":{"application/json":{"examples":{"example":{"title":"example","value":{"2012-01-01":{"counts":[2,1,2],"first":2},"2012-01-02":{"counts":[9,7,6],"first":10},"2012-01-03":{"counts":[9,6,4],"first":10}}}},"schema":{"type":"object","additionalProperties":{"type":"object","properties":{"counts":{"type":"array","items":{"type":"integer","uniqueKey":"additionalProperties.counts.items.[INDEX]","typeLabel":"integer"},"uniqueKey":"additionalProperties.counts","typeLabel":"integer[]"},"first":{"type":"integer","uniqueKey":"additionalProperties.first","typeLabel":"integer"}},"uniqueKey":"additionalProperties","typeLabel":"object"},"uniqueKey":"","typeLabel":"object"},"exampleType":"examples"}},"exampleType":"examples"}},"security":{"848fa3ad-9051-479a-bd28-36747af9b5a7":{"ServiceAccount":{"type":"http","scheme":"basic","description":"Service Account","scopes":[],"schemeName":"ServiceAccount"}},"e01d7dc4-85e8-4dc3-a579-ce0fea51556f":{"ProjectSecret":{"type":"http","scheme":"basic","description":"Project Secret","scopes":[],"schemeName":"ProjectSecret"}}},"servers":{"40a76f4a-2435-48b0-a5da-46d99b75dd04":{"url":"https://{regionAndDomain}.com/api/query","description":"Mixpanel's calculated data API","variables":{"regionAndDomain":{"default":"mixpanel","enum":["mixpanel","eu.mixpanel","in.mixpanel"],"description":"The server location to be used:\n * `mixpanel` - The default (US) servers used for most projects\n * `eu.mixpanel` - EU servers if you are enrolled in EU Data Residency\n * `in.mixpanel` - India servers if you are enrolled in India Data Residency\n"}}}},"processedSecurityOptions":[{"schemes":[{"scheme":{"type":"http","scheme":"basic","description":"Service Account","scopes":[],"schemeName":"ServiceAccount"},"schema":{"title":"Basic Auth","type":"object","description":"Service Account","isRequired":true,"properties":{"username":{"type":"string","uniqueKey":"username","isRequired":true,"typeLabel":"string","deprecated":false},"password":{"type":"string","uniqueKey":"password","isRequired":true,"typeLabel":"string","deprecated":false}},"additionalProperties":false,"deprecated":false},"schemeName":"ServiceAccount","name":"Authorization"}],"title":"ServiceAccount"},{"schemes":[{"scheme":{"type":"http","scheme":"basic","description":"Project Secret","scopes":[],"schemeName":"ProjectSecret"},"schema":{"title":"Basic Auth","type":"object","description":"Project Secret","isRequired":true,"properties":{"username":{"type":"string","uniqueKey":"username","isRequired":true,"typeLabel":"string","deprecated":false},"password":{"type":"string","uniqueKey":"password","isRequired":true,"typeLabel":"string","deprecated":false}},"additionalProperties":false,"deprecated":false},"schemeName":"ProjectSecret","name":"Authorization"}],"title":"ProjectSecret"}]},"originalFileLocation":"openapi/query.openapi.yaml"},"subdomain":"mixpanel-edb78807","siteName":"Mixpanel","title":"Query Retention Report - Mixpanel","relatedPagesConfig":{"enabled":true,"limit":5,"mode":"manual"},"contextualStarterQuestions":[{"_id":"6ae240de5679fd8985f47562","deploymentId":"69b350f33e949c7a5a4dbb8c","questionText":"What does the counts array mean?","status":"active","generatedBy":"contextual","path":"reference/retention-query","createdAt":"2026-10-28T18:37:18.463Z","updatedAt":"2026-10-28T18:37:18.463Z","__v":0},{"_id":"6ae240de5679fd8985f47561","deploymentId":"69b350f33e949c7a5a4dbb8c","questionText":"How do I set up cohort analysis?","status":"active","generatedBy":"contextual","path":"reference/retention-query","createdAt":"2026-10-28T18:37:18.463Z","updatedAt":"2026-10-28T18:37:18.463Z","__v":0},{"_id":"6ae240de5679fd8985f47563","deploymentId":"69b350f33e949c7a5a4dbb8c","questionText":"How are retention intervals calculated?","status":"active","generatedBy":"contextual","path":"reference/retention-query","createdAt":"2026-10-28T18:37:18.463Z","updatedAt":"2026-10-28T18:37:18.463Z","__v":0}],"navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-10-28T18:37:02.768Z","originalFileLocation":"reference/retention-query.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"light\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Query retention (cohort analysis) data for users who did a born event and then a return event, with interval and unit options\">\u003cmeta data-mint-head name=\"application-name\" content=\"Mixpanel\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/mixpanel-edb78807/CduMXmQIBqqE7wqB/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/mixpanel-edb78807/CduMXmQIBqqE7wqB/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/mixpanel-edb78807/CduMXmQIBqqE7wqB/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/mixpanel-edb78807/CduMXmQIBqqE7wqB/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/mixpanel-edb78807/CduMXmQIBqqE7wqB/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/mixpanel-edb78807/CduMXmQIBqqE7wqB/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/mixpanel-edb78807/CduMXmQIBqqE7wqB/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/mixpanel-edb78807/CduMXmQIBqqE7wqB/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/mixpanel-edb78807/CduMXmQIBqqE7wqB/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Query Retention Report - Mixpanel\">\u003cmeta data-mint-head property=\"og:description\" content=\"Query retention (cohort analysis) data for users who did a born event and then a return event, with interval and unit options\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Mixpanel\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.mixpanel.com/reference/retention-query\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://mixpanel-edb78807.mintlify.site/_mintlify/api/og/v2?division=Retention\u0026amp;title=Query+Retention+Report\u0026amp;description=Query+retention+%28cohort+analysis%29+data+for+users+who+did+a+born+event+and+then+a+return+event%2C+with+interval+and+unit+options\u0026amp;theme=624105f698bb0a7f71b3897f\u0026amp;signature=52a033c29e60a8fcb22d65ba6759e1d68a2d21a41d799dc8d76dc8fcb7248c36\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Query Retention Report - Mixpanel\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Query retention (cohort analysis) data for users who did a born event and then a return event, with interval and unit options\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://mixpanel-edb78807.mintlify.site/_mintlify/api/og/v2?division=Retention\u0026amp;title=Query+Retention+Report\u0026amp;description=Query+retention+%28cohort+analysis%29+data+for+users+who+did+a+born+event+and+then+a+return+event%2C+with+interval+and+unit+options\u0026amp;theme=624105f698bb0a7f71b3897f\u0026amp;signature=52a033c29e60a8fcb22d65ba6759e1d68a2d21a41d799dc8d76dc8fcb7248c36\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/mixpanel-edb78807/CduMXmQIBqqE7wqB/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Mixpanel\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#7856ff\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.mixpanel.com/reference/retention-query\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/reference/retention-query.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.mixpanel.com/#organization\",\"name\":\"Mixpanel\",\"url\":\"https://docs.mixpanel.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/mixpanel-edb78807/DbK2t9axJQF3qO_F/logo/light.svg?fit=max\u0026auto=format\u0026n=DbK2t9axJQF3qO_F\u0026q=85\u0026s=6197d81a55ffdba599db8650555eb912\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.mixpanel.com#website\",\"name\":\"Mixpanel\",\"url\":\"https://docs.mixpanel.com\",\"publisher\":{\"@id\":\"https://docs.mixpanel.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.mixpanel.com/reference/retention-query#webpage\",\"url\":\"https://docs.mixpanel.com/reference/retention-query\",\"name\":\"Query Retention Report\",\"description\":\"Query retention (cohort analysis) data for users who did a born event and then a return event, with interval and unit options\",\"dateModified\":\"2026-10-28T18:37:02.768Z\",\"isPartOf\":{\"@id\":\"https://docs.mixpanel.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.mixpanel.com/reference/retention-query#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.mixpanel.com/reference/retention-query#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"QUERY API\",\"item\":\"https://docs.mixpanel.com/reference/query-api\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Query Retention Report\",\"item\":\"https://docs.mixpanel.com/reference/retention-query\"}]},{\"@type\":[\"TechArticle\",\"APIReference\"],\"@id\":\"https://docs.mixpanel.com/reference/retention-query#apireference\",\"headline\":\"Query Retention Report\",\"name\":\"Query Retention Report\",\"description\":\"Query retention (cohort analysis) data for users who did a born event and then a return event, with interval and unit options\",\"url\":\"https://docs.mixpanel.com/reference/retention-query\",\"mainEntityOfPage\":{\"@id\":\"https://docs.mixpanel.com/reference/retention-query#webpage\"},\"dateModified\":\"2026-10-28T18:37:02.768Z\",\"publisher\":{\"@id\":\"https://docs.mixpanel.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.mixpanel.com#website\"}}]}\u003c/script>","agentPointerHref":"/reference/retention-query.md","siteName":"Mixpanel","nav":{"global":{"anchors":[{"anchor":"About Us","icon":"circle-question","href":"https://mixpanel.com/about"},{"anchor":"Community","icon":"users","href":"https://community.mixpanel.com/"},{"anchor":"Blog","icon":"newspaper","href":"https://mixpanel.com/blog"}]},"tabs":[{"tab":"Docs","pages":[{"title":"Docs","href":"/docs/what-is-mixpanel"}]},{"tab":"Guides","pages":[{"title":"Guides","href":"/guides/mixpanel-introduction"}]},{"tab":"Changelogs","pages":[{"title":"Changelogs","href":"/changelogs"}]},{"tab":"FAQs","pages":[{"title":"FAQs","href":"/troubleshooting/faqs"}]},{"tab":"API Docs","groups":[{"group":"MIXPANEL APIs","pages":[{"title":"Overview","href":"/reference/overview"},{"group":"Authentication Methods","root":{"title":"Authentication Methods","href":"/reference/authentication"},"pages":[{"title":"Service Accounts","href":"/reference/service-accounts"},{"title":"Project Token","href":"/reference/project-token"},{"title":"Project Secret [Deprecated]","href":"/reference/project-secret"},{"title":"Request Signature [Deprecated]","href":"/reference/request-signature"}]},{"title":"Segmentation Expressions","href":"/reference/segmentation-expressions"},{"title":"Rate Limits","href":"/reference/rate-limits"}]},{"group":"INGESTION API","pages":[{"group":"Events","root":{"title":"Import Events","openapi":"openapi/ingestion.openapi.yaml POST /import","href":"/reference/import-events"},"pages":[{"title":"Import Events","openapi":"openapi/ingestion.openapi.yaml POST /import","href":"/reference/import-events"},{"openapi":"openapi/ingestion.openapi.yaml POST /track","title":"Track Events","href":"/reference/track-event"},{"title":"Event Deduplication","href":"/reference/event-deduplication"}]},{"title":"Overview","href":"/reference/ingestion-api"},{"title":"Authentication","href":"/reference/ingestion-api-authentication"},{"group":"Group Profiles","root":{"openapi":"openapi/ingestion.openapi.yaml POST /groups#group-set","title":"Update Group Profile Property","href":"/reference/group-set-property"},"pages":[{"openapi":"openapi/ingestion.openapi.yaml POST /groups#group-set","title":"Update Group Profile Property","href":"/reference/group-set-property"},{"openapi":"openapi/ingestion.openapi.yaml POST /groups#group-set-once","title":"Set Group Profile Property Once","href":"/reference/group-set-property-once"},{"openapi":"openapi/ingestion.openapi.yaml POST /groups#group-unset","title":"Delete Group Profile Property","href":"/reference/group-delete-property"},{"openapi":"openapi/ingestion.openapi.yaml POST /groups#group-remove-from-list","title":"Remove from Group Profile List Property","href":"/reference/group-remove-from-list-property"},{"openapi":"openapi/ingestion.openapi.yaml POST /groups#group-union","title":"Union to Group Profile List Property","href":"/reference/group-union"},{"openapi":"openapi/ingestion.openapi.yaml POST /groups#group-batch-update","title":"Batch Update Group Profiles","href":"/reference/group-batch-update"},{"openapi":"openapi/ingestion.openapi.yaml POST /groups#group-delete","title":"Delete Group","href":"/reference/delete-group"},{"title":"Limits","href":"/reference/limits-1"}]},{"group":"Lookup Tables","root":{"title":"Lookup Tables","href":"/reference/lookup-tables"},"pages":[{"openapi":"openapi/ingestion.openapi.yaml GET /lookup-tables","title":"List Lookup Tables","href":"/reference/list-lookup-tables"},{"openapi":"openapi/ingestion.openapi.yaml PUT /lookup-tables/{id}","title":"Replace a Lookup Table","href":"/reference/replace-lookup-table"}]},{"group":"User Profiles","root":{"openapi":"openapi/ingestion.openapi.yaml POST /engage#profile-set","title":"Set User Profile Property","href":"/reference/profile-set"},"pages":[{"openapi":"openapi/ingestion.openapi.yaml POST /engage#profile-set","title":"Set User Profile Property","href":"/reference/profile-set"},{"openapi":"openapi/ingestion.openapi.yaml POST /engage#profile-set-once","title":"Set User Profile Property Once","href":"/reference/profile-set-property-once"},{"openapi":"openapi/ingestion.openapi.yaml POST /engage#profile-numerical-add","title":"Increment Numerical Property","href":"/reference/profile-numerical-add"},{"openapi":"openapi/ingestion.openapi.yaml POST /engage#profile-union","title":"Union to User Profile List Property","href":"/reference/user-profile-union"},{"openapi":"openapi/ingestion.openapi.yaml POST /engage#profile-list-append","title":"Append to List Property","href":"/reference/profile-append-to-list-property"},{"openapi":"openapi/ingestion.openapi.yaml POST /engage#profile-list-remove","title":"Remove from User Profile List Property","href":"/reference/profile-remove-from-list-property"},{"openapi":"openapi/ingestion.openapi.yaml POST /engage#profile-unset","title":"Delete User Profile Property","href":"/reference/profile-delete-property"},{"openapi":"openapi/ingestion.openapi.yaml POST /engage#profile-batch-update","title":"Update Multiple Profiles","href":"/reference/profile-batch-update"},{"openapi":"openapi/ingestion.openapi.yaml POST /engage#profile-delete","title":"Delete User Profile","href":"/reference/delete-profile"},{"title":"Limits","href":"/reference/user-profile-limits"}]}]},{"group":"IDENTITY API","pages":[{"group":"Identities","root":{"openapi":"openapi/identity.openapi.yaml POST /track#create-identity","title":"Create Identity","href":"/reference/create-identity"},"pages":[{"openapi":"openapi/identity.openapi.yaml POST /track#create-identity","title":"Create Identity","href":"/reference/create-identity"},{"openapi":"openapi/identity.openapi.yaml POST /track#identity-create-alias","title":"Create Alias","href":"/reference/identity-create-alias"},{"openapi":"openapi/identity.openapi.yaml POST /import","title":"Merge Identities","href":"/reference/identity-merge"}]}]},{"group":"QUERY API","pages":[{"title":"Overview","href":"/reference/query-api"},{"group":"Cohorts","root":{"openapi":"openapi/query.openapi.yaml POST /cohorts/list","title":"List Saved Cohorts","href":"/reference/cohorts-list"},"pages":[{"openapi":"openapi/query.openapi.yaml POST /cohorts/list","title":"List Saved Cohorts","href":"/reference/cohorts-list"}]},{"group":"Engage","root":{"openapi":"openapi/query.openapi.yaml POST /engage","title":"Query Profiles","href":"/reference/engage-query"},"pages":[{"openapi":"openapi/query.openapi.yaml POST /engage","title":"Query Profiles","href":"/reference/engage-query"}]},{"title":"Authentication","href":"/reference/query-api-authentication"},{"group":"Funnels","root":{"openapi":"openapi/query.openapi.yaml GET /funnels","title":"Query Saved Report","href":"/reference/funnels-query"},"pages":[{"openapi":"openapi/query.openapi.yaml GET /funnels","title":"Query Saved Report","href":"/reference/funnels-query"},{"openapi":"openapi/query.openapi.yaml GET /funnels/list","title":"List Saved Funnels","href":"/reference/funnels-list-saved"}]},{"group":"Insights","root":{"openapi":"openapi/query.openapi.yaml GET /insights","title":"Query Saved Report","href":"/reference/insights-query"},"pages":[{"openapi":"openapi/query.openapi.yaml GET /insights","title":"Query Saved Report","href":"/reference/insights-query"},{"openapi":"openapi/insights.openapi.json POST /insights/query","title":"Custom Insights Query","tag":"BETA","href":"/reference/insights-run-query"}]},{"group":"JQL","root":{"openapi":"openapi/query.openapi.yaml POST /jql","title":"Custom JQL Query","href":"/reference/query-jql"},"pages":[{"openapi":"openapi/query.openapi.yaml POST /jql","title":"Custom JQL Query","href":"/reference/query-jql"},{"title":"Additional Information","url":"/docs/reports/apps/jql","description":"Additional JQL reference material, linking to the JQL overview in the Mixpanel documentation","href":"/links/jql"}]},{"group":"Retention","root":{"openapi":"openapi/query.openapi.yaml GET /retention","title":"Query Retention Report","description":"Query retention (cohort analysis) data for users who did a born event and then a return event, with interval and unit options","href":"/reference/retention-query"},"pages":[{"openapi":"openapi/query.openapi.yaml GET /retention","title":"Query Retention Report","description":"Query retention (cohort analysis) data for users who did a born event and then a return event, with interval and unit options","href":"/reference/retention-query"},{"openapi":"openapi/query.openapi.yaml GET /retention/addiction","title":"Query Frequency Report","description":"Get data about how frequently users are performing events","href":"/reference/retention-frequency-query"}]},{"group":"Segmentation","root":{"openapi":"openapi/query.openapi.yaml GET /segmentation","title":"Query Segmentation Report","href":"/reference/segmentation-query"},"pages":[{"openapi":"openapi/query.openapi.yaml GET /segmentation","title":"Query Segmentation Report","href":"/reference/segmentation-query"},{"openapi":"openapi/query.openapi.yaml GET /segmentation/numeric","title":"Numerically Bucket","href":"/reference/segmentation-numeric-query"},{"openapi":"openapi/query.openapi.yaml GET /segmentation/sum","title":"Numerically Sum","href":"/reference/segmentation-sum-query"},{"openapi":"openapi/query.openapi.yaml GET /segmentation/average","title":"Numerically Average","href":"/reference/segmentation-query-average"}]},{"group":"Activity Feed","root":{"openapi":"openapi/query.openapi.yaml GET /stream/query","title":"Profile Event Activity","href":"/reference/activity-stream-query"},"pages":[{"openapi":"openapi/query.openapi.yaml GET /stream/query","title":"Profile Event Activity","href":"/reference/activity-stream-query"}]},{"group":"Event Breakdown","root":{"openapi":"openapi/query.openapi.yaml GET /events","title":"Aggregate Event Counts","href":"/reference/list-recent-events"},"pages":[{"openapi":"openapi/query.openapi.yaml GET /events","title":"Aggregate Event Counts","href":"/reference/list-recent-events"},{"openapi":"openapi/query.openapi.yaml GET /events/top","title":"Today's Top Events","href":"/reference/query-top-events"},{"openapi":"openapi/query.openapi.yaml GET /events/names","title":"Top Events","href":"/reference/query-months-top-event-names"},{"openapi":"openapi/query.openapi.yaml GET /events/properties","title":"Aggregrated Event Property Values","href":"/reference/query-event-properties"},{"openapi":"openapi/query.openapi.yaml GET /events/properties/top","title":"Top Event Properties","href":"/reference/query-events-top-properties"},{"openapi":"openapi/query.openapi.yaml GET /events/properties/values","title":"Top Event Property Values","href":"/reference/query-events-top-property-values"}]}]},{"group":"EVENT EXPORT API","pages":[{"group":"Export","root":{"openapi":"openapi/export.openapi.yaml GET /export","title":"Download Data","href":"/reference/raw-event-export"},"pages":[{"openapi":"openapi/export.openapi.yaml GET /export","title":"Download Data","href":"/reference/raw-event-export"}]},{"title":"Overview","href":"/reference/raw-data-export-api"},{"title":"Authentication","href":"/reference/raw-data-export-api-authentication"}]},{"group":"LEXICON SCHEMAS API","pages":[{"title":"Overview","href":"/reference/lexicon-schemas-api"},{"title":"Authentication","href":"/reference/lexicon-schemas-api-authentication"},{"group":"Create Schemas","root":{"openapi":"openapi/lexicon-schemas.openapi.yaml POST /projects/{projectId}/schemas","title":"Create/Replace Multiple","href":"/reference/upload-schemas-for-project"},"pages":[{"openapi":"openapi/lexicon-schemas.openapi.yaml POST /projects/{projectId}/schemas","title":"Create/Replace Multiple","href":"/reference/upload-schemas-for-project"},{"openapi":"openapi/lexicon-schemas.openapi.yaml POST /projects/{projectId}/schemas/{entityType}/{name}","title":"Create/Replace One","href":"/reference/upload-schema-by-entity-and-name"}]},{"group":"Delete Schemas","root":{"openapi":"openapi/lexicon-schemas.openapi.yaml DELETE /projects/{projectId}/schemas","title":"Delete all Schemas","href":"/reference/delete-all-schemas-in-project"},"pages":[{"openapi":"openapi/lexicon-schemas.openapi.yaml DELETE /projects/{projectId}/schemas","title":"Delete all Schemas","href":"/reference/delete-all-schemas-in-project"},{"openapi":"openapi/lexicon-schemas.openapi.yaml DELETE /projects/{projectId}/schemas/{entityType}","title":"Delete for Entity","href":"/reference/delete-schemas-for-entity"},{"openapi":"openapi/lexicon-schemas.openapi.yaml DELETE /projects/{projectId}/schemas/{entityType}/{name}","title":"Delete for Entity and Name","href":"/reference/delete-schema-by-entity-and-name"}]},{"group":"Retrieve Schemas","root":{"openapi":"openapi/lexicon-schemas.openapi.yaml GET /projects/{projectId}/schemas","title":"List Schemas","href":"/reference/list-all-schemas-for-project"},"pages":[{"openapi":"openapi/lexicon-schemas.openapi.yaml GET /projects/{projectId}/schemas","title":"List Schemas","href":"/reference/list-all-schemas-for-project"},{"openapi":"openapi/lexicon-schemas.openapi.yaml GET /projects/{projectId}/schemas/{entityType}","title":"List for Entity","href":"/reference/list-schemas-for-entity"},{"openapi":"openapi/lexicon-schemas.openapi.yaml GET /projects/{projectId}/schemas/{entityType}/{name}","title":"List for Entity and Name","href":"/reference/list-schemas-by-entity-and-name"}]},{"title":"Limits","href":"/reference/limits"}]},{"group":"DATA PIPELINES API","pages":[{"title":"Overview","href":"/reference/overview-2"},{"title":"Authentication","href":"/reference/authentication-2"},{"group":"Create Pipelines","root":{"openapi":"openapi/data-pipelines.openapi.yaml POST /nessie/pipeline/create","title":"Create Pipeline","href":"/reference/create-warehouse-pipeline"},"pages":[{"openapi":"openapi/data-pipelines.openapi.yaml POST /nessie/pipeline/create","title":"Create Pipeline","href":"/reference/create-warehouse-pipeline"}]},{"group":"Delete Pipelines","root":{"openapi":"openapi/data-pipelines.openapi.yaml POST /nessie/pipeline/cancel","title":"Delete Pipeline","href":"/reference/cancel-warehouse-pipeline"},"pages":[{"openapi":"openapi/data-pipelines.openapi.yaml POST /nessie/pipeline/cancel","title":"Delete Pipeline","href":"/reference/cancel-warehouse-pipeline"}]},{"group":"Edit Pipelines","root":{"openapi":"openapi/data-pipelines.openapi.yaml POST /nessie/pipeline/edit","title":"Edit Pipeline","href":"/reference/edit-warehouse-pipeline"},"pages":[{"openapi":"openapi/data-pipelines.openapi.yaml POST /nessie/pipeline/edit","title":"Edit Pipeline","href":"/reference/edit-warehouse-pipeline"}]},{"group":"Pause Pipelines","root":{"openapi":"openapi/data-pipelines.openapi.yaml POST /nessie/pipeline/pause","title":"Pause Pipeline","href":"/reference/pause-warehouse-pipeline"},"pages":[{"openapi":"openapi/data-pipelines.openapi.yaml POST /nessie/pipeline/pause","title":"Pause Pipeline","href":"/reference/pause-warehouse-pipeline"}]},{"group":"Resume Pipelines","root":{"openapi":"openapi/data-pipelines.openapi.yaml POST /nessie/pipeline/resume","title":"Resume Pipeline","href":"/reference/resume-warehouse-pipeline"},"pages":[{"openapi":"openapi/data-pipelines.openapi.yaml POST /nessie/pipeline/resume","title":"Resume Pipeline","href":"/reference/resume-warehouse-pipeline"}]},{"group":"Retrieve Pipelines","root":{"openapi":"openapi/data-pipelines.openapi.yaml GET /nessie/pipeline/jobs","title":"List Pipelines","href":"/reference/list-warehouse-pipeline-jobs"},"pages":[{"openapi":"openapi/data-pipelines.openapi.yaml GET /nessie/pipeline/jobs","title":"List Pipelines","href":"/reference/list-warehouse-pipeline-jobs"},{"openapi":"openapi/data-pipelines.openapi.yaml GET /nessie/pipeline/status","title":"Get Pipeline","href":"/reference/get-warehouse-pipeline-status"},{"openapi":"openapi/data-pipelines.openapi.yaml GET /nessie/pipeline/timeline","title":"List Pipeline Logs","href":"/reference/list-warehouse-pipeline-sync-dates"}]}]},{"group":"SERVICE ACCOUNTS API","pages":[{"title":"Overview","href":"/reference/service-accounts-api"},{"title":"Authentication","href":"/reference/service-accounts-api-authentication"},{"group":"Create Service Accounts","root":{"openapi":"openapi/service-accounts.openapi.yaml POST /organizations/{organizationId}/service-accounts","title":"Create Service Account","href":"/reference/create-service-account"},"pages":[{"openapi":"openapi/service-accounts.openapi.yaml POST /organizations/{organizationId}/service-accounts","title":"Create Service Account","href":"/reference/create-service-account"}]},{"group":"Delete Service Accounts","root":{"openapi":"openapi/service-accounts.openapi.yaml DELETE /organizations/{organizationId}/service-accounts/{serviceAccountId}","title":"Delete Service Account","href":"/reference/delete-service-account"},"pages":[{"openapi":"openapi/service-accounts.openapi.yaml DELETE /organizations/{organizationId}/service-accounts/{serviceAccountId}","title":"Delete Service Account","href":"/reference/delete-service-account"}]},{"group":"Project Membership","root":{"openapi":"openapi/service-accounts.openapi.yaml GET /projects/{projectId}/service-accounts","title":"List Service Accounts For Project","href":"/reference/list-project-service-accounts"},"pages":[{"openapi":"openapi/service-accounts.openapi.yaml GET /projects/{projectId}/service-accounts","title":"List Service Accounts For Project","href":"/reference/list-project-service-accounts"},{"openapi":"openapi/service-accounts.openapi.yaml POST /organizations/{organizationId}/service-accounts/add-to-project","title":"Add Service Accounts To Projects","href":"/reference/add-service-accounts-to-projects"},{"openapi":"openapi/service-accounts.openapi.yaml POST /organizations/{organizationId}/service-accounts/remove-from-project","title":"Remove Service Accounts From Projects","href":"/reference/remove-service-accounts-from-projects"}]},{"group":"Retrieve Service Accounts","root":{"openapi":"openapi/service-accounts.openapi.yaml GET /organizations/{organizationId}/service-accounts","title":"List Service Accounts","href":"/reference/list-service-accounts"},"pages":[{"openapi":"openapi/service-accounts.openapi.yaml GET /organizations/{organizationId}/service-accounts","title":"List Service Accounts","href":"/reference/list-service-accounts"},{"openapi":"openapi/service-accounts.openapi.yaml GET /organizations/{organizationId}/service-accounts/{serviceAccountId}","title":"Get Service Account","href":"/reference/get-service-account"}]}]},{"group":"ANNOTATIONS API","pages":[{"title":"Overview","href":"/reference/overview-1"},{"group":"Delete Annotation","root":{"openapi":"openapi/annotations.openapi.yaml DELETE /projects/{projectId}/annotations/{annotationId}","title":"Delete Annotation","href":"/reference/delete-annotation-1"},"pages":[{"openapi":"openapi/annotations.openapi.yaml DELETE /projects/{projectId}/annotations/{annotationId}","title":"Delete Annotation","href":"/reference/delete-annotation-1"}]},{"group":"Retrieve Annotations","root":{"openapi":"openapi/annotations.openapi.yaml GET /projects/{projectId}/annotations","title":"List Annotations","href":"/reference/list-all-annotations-for-project"},"pages":[{"openapi":"openapi/annotations.openapi.yaml GET /projects/{projectId}/annotations","title":"List Annotations","href":"/reference/list-all-annotations-for-project"},{"openapi":"openapi/annotations.openapi.yaml GET /projects/{projectId}/annotations/{annotationId}","title":"Get Annotation","href":"/reference/get-annotation-1"}]},{"group":"Create Annotations","root":{"openapi":"openapi/annotations.openapi.yaml POST /projects/{projectId}/annotations","title":"Create Annotations","href":"/reference/create-annotation"},"pages":[{"openapi":"openapi/annotations.openapi.yaml POST /projects/{projectId}/annotations","title":"Create Annotations","href":"/reference/create-annotation"}]},{"group":"Patch Annotation","root":{"openapi":"openapi/annotations.openapi.yaml PATCH /projects/{projectId}/annotations/{annotationId}","title":"Patch Annotation","href":"/reference/patch-annotation-1"},"pages":[{"openapi":"openapi/annotations.openapi.yaml PATCH /projects/{projectId}/annotations/{annotationId}","title":"Patch Annotation","href":"/reference/patch-annotation-1"}]},{"group":"Get Annotation tags","root":{"openapi":"openapi/annotations.openapi.yaml GET /projects/{projectId}/annotations/tags","title":"Get Annotation Tags","href":"/reference/get-annotation-tags-1"},"pages":[{"openapi":"openapi/annotations.openapi.yaml GET /projects/{projectId}/annotations/tags","title":"Get Annotation Tags","href":"/reference/get-annotation-tags-1"}]},{"group":"Create Annotation tag","root":{"openapi":"openapi/annotations.openapi.yaml POST /projects/{projectId}/annotations/tags","title":"Create Annotation Tag","href":"/reference/create-annotation-tag-1"},"pages":[{"openapi":"openapi/annotations.openapi.yaml POST /projects/{projectId}/annotations/tags","title":"Create Annotation Tag","href":"/reference/create-annotation-tag-1"}]}]},{"group":"GDPR API","pages":[{"title":"Overview","href":"/reference/gdpr-api"},{"group":"Create a Retrieval","root":{"openapi":"openapi/gdpr.openapi.yaml POST /data-retrievals/v3.0","title":"Create a Retrieval","href":"/reference/create-retrieval-1"},"pages":[{"openapi":"openapi/gdpr.openapi.yaml POST /data-retrievals/v3.0","title":"Create a Retrieval","href":"/reference/create-retrieval-1"}]},{"group":"Check Status of Retrieval","root":{"openapi":"openapi/gdpr.openapi.yaml GET /data-retrievals/v3.0/{tracking_id}","title":"Check Status of Retrieval","href":"/reference/get-retrieval"},"pages":[{"openapi":"openapi/gdpr.openapi.yaml GET /data-retrievals/v3.0/{tracking_id}","title":"Check Status of Retrieval","href":"/reference/get-retrieval"}]},{"group":"Create a Deletion","root":{"openapi":"openapi/gdpr.openapi.yaml POST /data-deletions/v3.0","title":"Create a Deletion","href":"/reference/create-deletion"},"pages":[{"openapi":"openapi/gdpr.openapi.yaml POST /data-deletions/v3.0","title":"Create a Deletion","href":"/reference/create-deletion"}]},{"group":"Check Status of Deletion","root":{"openapi":"openapi/gdpr.openapi.yaml GET /data-deletions/v3.0/{tracking_id}","title":"Check Status of Deletion","href":"/reference/get-deletion"},"pages":[{"openapi":"openapi/gdpr.openapi.yaml GET /data-deletions/v3.0/{tracking_id}","title":"Check Status of Deletion","href":"/reference/get-deletion"}]},{"group":"Cancel a Deletion","root":{"openapi":"openapi/gdpr.openapi.yaml DELETE /data-deletions/v3.0/{tracking_id}","title":"Cancel a Deletion","href":"/reference/delete-deletion"},"pages":[{"openapi":"openapi/gdpr.openapi.yaml DELETE /data-deletions/v3.0/{tracking_id}","title":"Cancel a Deletion","href":"/reference/delete-deletion"}]}]},{"group":"WAREHOUSE CONNECTORS API","pages":[{"title":"Overview","href":"/reference/warehouse-connectors-api"},{"title":"Authentication","href":"/reference/warehouse-connectors-api-authentication"},{"group":"Warehouse Imports","root":{"openapi":"openapi/warehouse-connectors.openapi.yaml PUT /projects/{projectId}/warehouse-sources/imports/{importId}/manual-sync","title":"Run an import","href":"/reference/run-an-import-1"},"pages":[{"openapi":"openapi/warehouse-connectors.openapi.yaml PUT /projects/{projectId}/warehouse-sources/imports/{importId}/manual-sync","title":"Run an import","href":"/reference/run-an-import-1"},{"openapi":"openapi/warehouse-connectors.openapi.yaml GET /projects/{projectId}/warehouse-sources/imports","title":"List Warehouse Imports","href":"/reference/list-warehouse-imports"},{"openapi":"openapi/warehouse-connectors.openapi.yaml GET /projects/{projectId}/warehouse-sources/imports/{importId}","title":"Get Warehouse Import","href":"/reference/get-warehouse-import"},{"openapi":"openapi/warehouse-connectors.openapi.yaml PATCH /projects/{projectId}/warehouse-sources/imports/{importId}","title":"Update Warehouse Import","href":"/reference/update-warehouse-import"},{"openapi":"openapi/warehouse-connectors.openapi.yaml DELETE /projects/{projectId}/warehouse-sources/imports/{importId}","title":"Delete Warehouse Import","href":"/reference/delete-warehouse-import"},{"openapi":"openapi/warehouse-connectors.openapi.yaml POST /projects/{projectId}/warehouse-sources/imports/event-stream","title":"Create Event Stream Import","href":"/reference/create-event-stream-import"},{"openapi":"openapi/warehouse-connectors.openapi.yaml POST /projects/{projectId}/warehouse-sources/imports/people","title":"Create People Import","href":"/reference/create-people-import"},{"openapi":"openapi/warehouse-connectors.openapi.yaml POST /projects/{projectId}/warehouse-sources/imports/groups","title":"Create Groups Import","href":"/reference/create-groups-import"},{"openapi":"openapi/warehouse-connectors.openapi.yaml POST /projects/{projectId}/warehouse-sources/imports/lookup-table","title":"Create Lookup Table Import","href":"/reference/create-lookup-table-import"},{"openapi":"openapi/warehouse-connectors.openapi.yaml GET /projects/{projectId}/warehouse-sources/imports/{importId}/history","title":"Get Import History","href":"/reference/get-import-history"}]},{"title":"Run an Import","href":"/reference/run-an-import"}]},{"group":"FEATURE FLAGS API","pages":[{"title":"Overview","href":"/reference/feature-flags-api"},{"group":"Get Flag Definitions","root":{"openapi":"openapi/feature-flags.openapi.yaml GET /flags/definitions","title":"Get Flag Definitions","href":"/reference/get-flag-definitions"},"pages":[{"openapi":"openapi/feature-flags.openapi.yaml GET /flags/definitions","title":"Get Flag Definitions","href":"/reference/get-flag-definitions"}]},{"group":"Get Variant Assignments","root":{"openapi":"openapi/feature-flags.openapi.yaml GET /flags","title":"Get Variant Assignments","href":"/reference/get-variant-assignments"},"pages":[{"openapi":"openapi/feature-flags.openapi.yaml GET /flags","title":"Get Variant Assignments","href":"/reference/get-variant-assignments"}]}]},{"group":"FEATURE FLAGS MANAGEMENT API","pages":[{"title":"Overview","href":"/reference/feature-flags-management-api"},{"group":"Flag Management","root":{"openapi":"openapi/feature-flags-management.openapi.yaml GET /projects/{project_id}/workspaces/{workspace_id}/feature-flags","title":"List Feature Flags","href":"/reference/list-feature-flags-1"},"pages":[{"openapi":"openapi/feature-flags-management.openapi.yaml GET /projects/{project_id}/workspaces/{workspace_id}/feature-flags","title":"List Feature Flags","href":"/reference/list-feature-flags-1"},{"openapi":"openapi/feature-flags-management.openapi.yaml POST /projects/{project_id}/workspaces/{workspace_id}/feature-flags","title":"Create Feature Flag","href":"/reference/create-feature-flag-1"},{"openapi":"openapi/feature-flags-management.openapi.yaml GET /projects/{project_id}/workspaces/{workspace_id}/feature-flags/{flag_id}","title":"Get Feature Flag","href":"/reference/get-feature-flag-1"},{"openapi":"openapi/feature-flags-management.openapi.yaml DELETE /projects/{project_id}/workspaces/{workspace_id}/feature-flags/{flag_id}","title":"Delete Feature Flag","href":"/reference/delete-feature-flag-1"},{"openapi":"openapi/feature-flags-management.openapi.yaml PUT /projects/{project_id}/workspaces/{workspace_id}/feature-flags/{flag_id}","title":"Update Feature Flag","href":"/reference/update-feature-flag-1"}]}]},{"group":"EXPERIMENTS API","pages":[{"group":"Experiment Management","root":{"openapi":"openapi/experiments.openapi.yaml GET /workspaces/{workspace_id}/experiments","title":"List Experiments","href":"/reference/list-experiments"},"pages":[{"openapi":"openapi/experiments.openapi.yaml GET /workspaces/{workspace_id}/experiments","title":"List Experiments","href":"/reference/list-experiments"},{"openapi":"openapi/experiments.openapi.yaml POST /workspaces/{workspace_id}/experiments","title":"Create Experiment","href":"/reference/create-experiment"},{"openapi":"openapi/experiments.openapi.yaml GET /workspaces/{workspace_id}/experiments/{experiment_id}","title":"Get Experiment","href":"/reference/get-experiment"},{"openapi":"openapi/experiments.openapi.yaml PATCH /workspaces/{workspace_id}/experiments/{experiment_id}","title":"Update Experiment","href":"/reference/update-experiment"},{"openapi":"openapi/experiments.openapi.yaml DELETE /workspaces/{workspace_id}/experiments/{experiment_id}","title":"Delete Experiment","href":"/reference/delete-experiment"}]},{"group":"Experiment Actions","root":{"openapi":"openapi/experiments.openapi.yaml POST /workspaces/{workspace_id}/experiments/{experiment_id}/archive","title":"Archive Experiment","href":"/reference/archive-experiment"},"pages":[{"openapi":"openapi/experiments.openapi.yaml POST /workspaces/{workspace_id}/experiments/{experiment_id}/archive","title":"Archive Experiment","href":"/reference/archive-experiment"},{"openapi":"openapi/experiments.openapi.yaml DELETE /workspaces/{workspace_id}/experiments/{experiment_id}/archive","title":"Unarchive Experiment","href":"/reference/unarchive-experiment"},{"openapi":"openapi/experiments.openapi.yaml PATCH /workspaces/{workspace_id}/experiments/{experiment_id}/decide","title":"Decide Experiment","href":"/reference/decide-experiment"},{"openapi":"openapi/experiments.openapi.yaml PUT /workspaces/{workspace_id}/experiments/{experiment_id}/force_conclude","title":"Force Conclude Experiment","href":"/reference/force-conclude-experiment"},{"openapi":"openapi/experiments.openapi.yaml PUT /workspaces/{workspace_id}/experiments/{experiment_id}/launch","title":"Launch Experiment","href":"/reference/launch-experiment"}]}]},{"group":"PLATFORM API","pages":[{"group":"Overview","root":{"title":"Overview","href":"/reference/platform-api"},"pages":[{"title":"Permissions Reference","href":"/reference/permissions"}]},{"group":"Projects","pages":[{"title":"List Project Data Definitions","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json get /v1/projects/{project_id}/data-definitions","href":"/api-reference/projects/list-project-data-definitions"},{"title":"Create Project Data Definition","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json post /v1/projects/{project_id}/data-definitions","href":"/api-reference/projects/create-project-data-definition"},{"title":"Merge Project Data Definition","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json post /v1/projects/{project_id}/data-definitions/merge","href":"/api-reference/projects/merge-project-data-definition"},{"title":"Unmerge Project Data Definition","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json post /v1/projects/{project_id}/data-definitions/unmerge","href":"/api-reference/projects/unmerge-project-data-definition"},{"title":"Get Project Data Definition","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json get /v1/projects/{project_id}/data-definitions/{definition_id}","href":"/api-reference/projects/get-project-data-definition"},{"title":"Delete Project Data Definition","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json delete /v1/projects/{project_id}/data-definitions/{definition_id}","href":"/api-reference/projects/delete-project-data-definition"},{"title":"Patch Project Data Definition","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json patch /v1/projects/{project_id}/data-definitions/{definition_id}","href":"/api-reference/projects/patch-project-data-definition"},{"title":"List Project Data Definition Tags","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json get /v1/projects/{project_id}/data-definition-tags","href":"/api-reference/projects/list-project-data-definition-tags"},{"title":"Create Project Data Definition Tag","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json post /v1/projects/{project_id}/data-definition-tags","href":"/api-reference/projects/create-project-data-definition-tag"},{"title":"Get Project Data Definition Tag","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json get /v1/projects/{project_id}/data-definition-tags/{tag_id}","href":"/api-reference/projects/get-project-data-definition-tag"},{"title":"Delete Project Data Definition Tag","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json delete /v1/projects/{project_id}/data-definition-tags/{tag_id}","href":"/api-reference/projects/delete-project-data-definition-tag"},{"title":"Rename Project Data Definition Tag","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json patch /v1/projects/{project_id}/data-definition-tags/{tag_id}","href":"/api-reference/projects/rename-project-data-definition-tag"}]},{"group":"Workspaces","pages":[{"title":"List Workspace Data Definitions","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json get /v1/workspaces/{workspace_id}/data-definitions","href":"/api-reference/workspaces/list-workspace-data-definitions"},{"title":"Create Workspace Data Definition","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json post /v1/workspaces/{workspace_id}/data-definitions","href":"/api-reference/workspaces/create-workspace-data-definition"},{"title":"Merge Workspace Data Definition","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json post /v1/workspaces/{workspace_id}/data-definitions/merge","href":"/api-reference/workspaces/merge-workspace-data-definition"},{"title":"Unmerge Workspace Data Definition","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json post /v1/workspaces/{workspace_id}/data-definitions/unmerge","href":"/api-reference/workspaces/unmerge-workspace-data-definition"},{"title":"Get Workspace Data Definition","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json get /v1/workspaces/{workspace_id}/data-definitions/{definition_id}","href":"/api-reference/workspaces/get-workspace-data-definition"},{"title":"Delete Workspace Data Definition","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json delete /v1/workspaces/{workspace_id}/data-definitions/{definition_id}","href":"/api-reference/workspaces/delete-workspace-data-definition"},{"title":"Patch Workspace Data Definition","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json patch /v1/workspaces/{workspace_id}/data-definitions/{definition_id}","href":"/api-reference/workspaces/patch-workspace-data-definition"},{"title":"List Workspace Data Definition Tags","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json get /v1/workspaces/{workspace_id}/data-definition-tags","href":"/api-reference/workspaces/list-workspace-data-definition-tags"},{"title":"Create Workspace Data Definition Tag","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json post /v1/workspaces/{workspace_id}/data-definition-tags","href":"/api-reference/workspaces/create-workspace-data-definition-tag"},{"title":"Get Workspace Data Definition Tag","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json get /v1/workspaces/{workspace_id}/data-definition-tags/{tag_id}","href":"/api-reference/workspaces/get-workspace-data-definition-tag"},{"title":"Delete Workspace Data Definition Tag","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json delete /v1/workspaces/{workspace_id}/data-definition-tags/{tag_id}","href":"/api-reference/workspaces/delete-workspace-data-definition-tag"},{"title":"Rename Workspace Data Definition Tag","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json patch /v1/workspaces/{workspace_id}/data-definition-tags/{tag_id}","href":"/api-reference/workspaces/rename-workspace-data-definition-tag"}]},{"group":"Organizations","pages":[{"title":"Query Organization Audit Logs","deprecated":null,"version":null,"openapi":"/openapi/platform.openapi.json post /v1/organizations/{organization_id}/audit-logs/query","href":"/api-reference/organizations/query-organization-audit-logs"}]}]}]}]},"basePath":"","title":"Query Retention Report - Mixpanel","buildId":"dpl_DqYu5MPb49gWBBbUGgpHQUmCHY3P","deploymentId":"dpl_DqYu5MPb49gWBBbUGgpHQUmCHY3P","dynamics":["c2aa737661","b0f84f53ff","a9bb46feb3","2b790eda92"],"chunks":["OpenApiReferenceProvider-CybtLBIt.js","utils-BMLj2fvV.js","cloneDeep-izs3Hzxb.js","_Uint8Array-BVIqJ90l.js","isObjectLike-C8vmzPEN.js","isArray-Dcu1dQ5t.js","utils-B6In562Y.js","toString-BX-iyh8G.js","isSymbol-CSH9U2Gm.js","addUniqueKeysToSchema-Dr8Mfhp9.js","snippetPresets-2rmQvMVl.js","style-to-object-BY3JEAdk.js","v4-DIgz8zy6.js","conditional-requirements-CFM0id0Q.js","Page-C4GwDT3_.js","ApiExamples-WMqJYdZj.js","isEqual-BfaiBbcl.js","usePlaygroundInputsStore-CJ-MlPHu.js","shallow-dY3TMRCk.js","getApiPlaygroundDisplay-v-1B2bKm.js","CodeSnippet-BDhiTB7U.js","CodeSnippets-D9hnzQcS.js","getPastedJson-Th2V45jI.js","icon-BQXch1W9.js","MethodPill-BCqUneP3.js","DuplicateIcon-Q_-bhurZ.js","createIcon-DUjLHRqp.js","DynamicMarkdown-B-f2cqXQ.js","SectionHeading-Da5NsV4v.js","axios-vUo_bRtp.js","Markdown-D13FWkIM.js","clsx-D3Isdib3.js","lib-DuNMoZ05.js","lib-B8HbPgcC.js","html-void-elements-mCSPHezU.js","dist-C-XZBk9h.js","katex-YMM-FMeD.js","marked.esm-CZWythHk.js","AssistantPageLink--qIqmmVG.js"]}