When set, enables "filtered totals" mode for queries with no dimensions.
The query will:
Group by these dimensions in an inner subquery
Apply metricFilters via HAVING clause
Aggregate the filtered results in an outer query
Use this for totals that should respect metricFilters.
Example: Get total sessions where bounce_rate > 50%, grouped by landing_path.
Response
200 - application/json
The response is of type object.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Staminads Documentation","colors":{"primary":"#7763F1","light":"#8B63F1"},"logo":{"light":"https://mintcdn.com/staminads/xmodduBRIzsdtnFQ/logo/logo.svg?fit=max\u0026auto=format\u0026n=xmodduBRIzsdtnFQ\u0026q=85\u0026s=1be6fc9aece1f420d7d7106841235ca0","dark":"https://mintcdn.com/staminads/xmodduBRIzsdtnFQ/logo/logo.svg?fit=max\u0026auto=format\u0026n=xmodduBRIzsdtnFQ\u0026q=85\u0026s=1be6fc9aece1f420d7d7106841235ca0"},"favicon":"/favicon.svg","appearance":{"default":"light","strict":true},"navbar":{"links":[{"label":"Home","href":"https://www.staminads.com/"},{"label":"Support","href":"mailto:hello@staminads.com"},{"label":"Report issue","href":"https://github.com/staminads/staminads/issues"},{"label":"GitHub","href":"https://github.com/staminads/staminads"}]},"footer":{"socials":{}},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"staminads","hasAudioNarration":false,"actualSubdomain":"staminads","customDomains":["docs.staminads.com"],"gitSource":{"type":"github","owner":"pierre-b","repo":"staminads_docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6a20c5e0b7c442096901c48c","collectionId":"14b00cb4-04c0-47d2-9a7c-535f8000b256","schemaVersion":"v2"},"entitlements":{},"buildId":"6a20c5e0b7c442096901c48c:success","clientVersion":"0.0.3971","searchFilterCounts":[{"language":"default","tag":"API Reference","count":23},{"language":"default","tag":"Filters","count":12},{"language":"default","tag":"Documentation","count":10},{"language":"default","tag":"Get Started","count":10},{"language":"default","tag":"Analytics","count":5},{"language":"default","tag":"Workspaces","count":5},{"language":"default","tag":"Export","count":1}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","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":"editor-v7-file-tree","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":"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":"pause-universal-search-reconcile","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":"per-site-search-delta","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":"editor-private-page-search","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":"editor-nav-generations","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":"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":"byok-sep-25","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":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-agent-model-picker","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-updated-9-15","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":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"isAtlas":false,"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"api-reference/analytics/execute-an-analytics-query","slug":"/api-reference/analytics/execute-an-analytics-query","pageMetadata":{"title":"Execute an analytics query","description":null,"deprecated":null,"version":null,"openapi":"openapi.json post /api/analytics.query","href":"/api-reference/analytics/execute-an-analytics-query","autogeneratedByOpenApi":true,"hidden":false},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){return _jsx(_Fragment,{})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Execute an analytics query","description":null,"deprecated":null,"version":null,"openapi":"openapi.json post /api/analytics.query","href":"/api-reference/analytics/execute-an-analytics-query","autogeneratedByOpenApi":true,"hidden":false}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"openApiReferenceData":{"operation":{"operationId":"AnalyticsController_query","parameters":[],"requestBody":"97dbd00b-93e3-481d-88d2-4b44b135b32e","responses":{"200":"1947a91f-2487-47a6-ad87-91c046fd8e49"},"summary":"Execute an analytics query","tags":["analytics"],"method":"post","type":"path","servers":["f466ef73-8ecd-4c07-9329-05428f965a78"],"security":[],"path":"/api/analytics.query","baseUrlOptions":["https://your-instance.example.com"],"title":"Execute an analytics query","description":"","codeSamples":[],"requiredOnlyExamples":false,"requestExampleType":"generated","responseExampleType":"generated"},"dependencies":{"parameters":{},"requestBody":{"required":true,"content":{"application/json":{"schema":{"type":"object","properties":{"workspace_id":{"type":"string","isRequired":true,"uniqueKey":"workspace_id","typeLabel":"string"},"metrics":{"minItems":1,"type":"array","items":{"type":"string","uniqueKey":"metrics.items.[INDEX]","typeLabel":"string"},"isRequired":true,"uniqueKey":"metrics","typeLabel":"string[]"},"dateRange":{"type":"object","properties":{"start":{"type":"string","uniqueKey":"dateRange.start","typeLabel":"string"},"end":{"type":"string","uniqueKey":"dateRange.end","typeLabel":"string"},"preset":{"type":"string","enum":["previous_30_minutes","today","yesterday","previous_7_days","previous_14_days","previous_28_days","previous_30_days","previous_90_days","previous_91_days","this_week","previous_week","this_month","previous_month","this_quarter","previous_quarter","this_year","previous_year","previous_12_months","all_time"],"uniqueKey":"dateRange.preset","typeLabel":"enum\u003cstring>"},"granularity":{"type":"string","enum":["hour","day","week","month","year"],"uniqueKey":"dateRange.granularity","typeLabel":"enum\u003cstring>"}},"isRequired":true,"uniqueKey":"dateRange","typeLabel":"object"},"dimensions":{"type":"array","items":{"type":"string","uniqueKey":"dimensions.items.[INDEX]","typeLabel":"string"},"uniqueKey":"dimensions","typeLabel":"string[]"},"filters":{"type":"array","items":{"type":"object","properties":{"dimension":{"type":"string","isRequired":true,"uniqueKey":"filters.items.[INDEX].dimension","typeLabel":"string"},"operator":{"type":"string","enum":["equals","notEquals","in","notIn","contains","notContains","gt","gte","lt","lte","isNull","isNotNull","between","isEmpty","isNotEmpty"],"isRequired":true,"uniqueKey":"filters.items.[INDEX].operator","typeLabel":"enum\u003cstring>"},"values":{"type":"array","items":{"type":"object","uniqueKey":"filters.items.[INDEX].values.items.[INDEX]","typeLabel":"object"},"uniqueKey":"filters.items.[INDEX].values","typeLabel":"object[]"}},"required":["dimension","operator"],"uniqueKey":"filters.items.[INDEX]","typeLabel":"object"},"uniqueKey":"filters","typeLabel":"object[]"},"metricFilters":{"type":"array","items":{"type":"object","properties":{"metric":{"type":"string","isRequired":true,"uniqueKey":"metricFilters.items.[INDEX].metric","typeLabel":"string"},"operator":{"type":"string","enum":["gt","gte","lt","lte","between"],"isRequired":true,"uniqueKey":"metricFilters.items.[INDEX].operator","typeLabel":"enum\u003cstring>"},"values":{"type":"array","items":{"type":"object","uniqueKey":"metricFilters.items.[INDEX].values.items.[INDEX]","typeLabel":"object"},"isRequired":true,"uniqueKey":"metricFilters.items.[INDEX].values","typeLabel":"object[]"}},"required":["metric","operator","values"],"uniqueKey":"metricFilters.items.[INDEX]","typeLabel":"object"},"uniqueKey":"metricFilters","typeLabel":"object[]"},"compareDateRange":{"type":"object","properties":{"start":{"type":"string","uniqueKey":"compareDateRange.start","typeLabel":"string"},"end":{"type":"string","uniqueKey":"compareDateRange.end","typeLabel":"string"},"preset":{"type":"string","enum":["previous_30_minutes","today","yesterday","previous_7_days","previous_14_days","previous_28_days","previous_30_days","previous_90_days","previous_91_days","this_week","previous_week","this_month","previous_month","this_quarter","previous_quarter","this_year","previous_year","previous_12_months","all_time"],"uniqueKey":"compareDateRange.preset","typeLabel":"enum\u003cstring>"},"granularity":{"type":"string","enum":["hour","day","week","month","year"],"uniqueKey":"compareDateRange.granularity","typeLabel":"enum\u003cstring>"}},"uniqueKey":"compareDateRange","typeLabel":"object"},"timezone":{"type":"string","uniqueKey":"timezone","typeLabel":"string"},"order":{"type":"object","uniqueKey":"order","typeLabel":"object"},"limit":{"type":"number","minimum":1,"maximum":10000,"uniqueKey":"limit","typeLabel":"number"},"havingMinSessions":{"type":"number","minimum":1,"uniqueKey":"havingMinSessions","typeLabel":"number"},"table":{"type":"string","enum":["sessions","pages","goals"],"uniqueKey":"table","typeLabel":"enum\u003cstring>"},"totalsGroupBy":{"description":"When set, enables \"filtered totals\" mode for queries with no dimensions.\nThe query will:\n1. Group by these dimensions in an inner subquery\n2. Apply metricFilters via HAVING clause\n3. Aggregate the filtered results in an outer query\n\nUse this for totals that should respect metricFilters.\nExample: Get total sessions where bounce_rate > 50%, grouped by landing_path.","type":"array","items":{"type":"string","uniqueKey":"totalsGroupBy.items.[INDEX]","typeLabel":"string"},"uniqueKey":"totalsGroupBy","typeLabel":"string[]"}},"required":["workspace_id","metrics","dateRange"],"uniqueKey":"","typeLabel":"object"},"examples":{"Example":{"title":"Example","value":{"workspace_id":"\u003cstring>","metrics":["\u003cstring>"],"dateRange":{"start":"\u003cstring>","end":"\u003cstring>"},"dimensions":["\u003cstring>"],"filters":[{"dimension":"\u003cstring>","values":[{}]}],"metricFilters":[{"metric":"\u003cstring>","values":[{}]}],"compareDateRange":{"start":"\u003cstring>","end":"\u003cstring>"},"timezone":"\u003cstring>","order":{},"limit":5000.5,"havingMinSessions":2,"totalsGroupBy":["\u003cstring>"]}}},"exampleType":"generated"}},"exampleType":"generated"},"responses":{"1947a91f-2487-47a6-ad87-91c046fd8e49":{"description":"","content":{"application/json":{"schema":{"type":"object","uniqueKey":"","typeLabel":"object"},"examples":{"Example":{"title":"Example","value":{}}},"exampleType":"generated"}},"exampleType":"generated"}},"security":{},"servers":{"f466ef73-8ecd-4c07-9329-05428f965a78":{"url":"https://your-instance.example.com","description":"Your Staminads instance"}}},"originalFileLocation":"openapi.json"},"subdomain":"staminads","siteName":"Staminads Documentation","title":"Execute an analytics query - Staminads Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-01-25T18:56:25.606Z","originalFileLocation":"api-reference/analytics/execute-an-analytics-query.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=\"light\";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=\"application-name\" content=\"Staminads Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/staminads/-FNXJklUnV34uqRV/_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/staminads/-FNXJklUnV34uqRV/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/staminads/-FNXJklUnV34uqRV/_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/staminads/-FNXJklUnV34uqRV/_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/staminads/-FNXJklUnV34uqRV/_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/staminads/-FNXJklUnV34uqRV/_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/staminads/-FNXJklUnV34uqRV/_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/staminads/-FNXJklUnV34uqRV/_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/staminads/-FNXJklUnV34uqRV/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Execute an analytics query - Staminads Documentation\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Staminads Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.staminads.com/api-reference/analytics/execute-an-analytics-query\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://staminads.mintlify.app/_mintlify/api/og/v2?division=Analytics\u0026amp;title=Execute+an+analytics+query\u0026amp;theme=18e24c352bfd0d59ebadc206\u0026amp;signature=aca8a60494f7ee1c00516fb825c64c15f6d1c69bd83da300c83128d30f3fee54\">\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=\"Execute an analytics query - Staminads Documentation\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://staminads.mintlify.app/_mintlify/api/og/v2?division=Analytics\u0026amp;title=Execute+an+analytics+query\u0026amp;theme=18e24c352bfd0d59ebadc206\u0026amp;signature=aca8a60494f7ee1c00516fb825c64c15f6d1c69bd83da300c83128d30f3fee54\">\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/staminads/-FNXJklUnV34uqRV/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Staminads Documentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#7763F1\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.staminads.com/api-reference/analytics/execute-an-analytics-query\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/api-reference/analytics/execute-an-analytics-query.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.staminads.com/#organization\",\"name\":\"Staminads Documentation\",\"url\":\"https://docs.staminads.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/staminads/xmodduBRIzsdtnFQ/logo/logo.svg?fit=max\u0026auto=format\u0026n=xmodduBRIzsdtnFQ\u0026q=85\u0026s=1be6fc9aece1f420d7d7106841235ca0\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.staminads.com#website\",\"name\":\"Staminads Documentation\",\"url\":\"https://docs.staminads.com\",\"publisher\":{\"@id\":\"https://docs.staminads.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.staminads.com/api-reference/analytics/execute-an-analytics-query#webpage\",\"url\":\"https://docs.staminads.com/api-reference/analytics/execute-an-analytics-query\",\"name\":\"Execute an analytics query\",\"dateModified\":\"2026-01-25T18:56:25.606Z\",\"isPartOf\":{\"@id\":\"https://docs.staminads.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.staminads.com/api-reference/analytics/execute-an-analytics-query#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.staminads.com/api-reference/analytics/execute-an-analytics-query#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Staminads Documentation\",\"item\":\"https://docs.staminads.com\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Execute an analytics query\",\"item\":\"https://docs.staminads.com/api-reference/analytics/execute-an-analytics-query\"}]},{\"@type\":[\"TechArticle\",\"APIReference\"],\"@id\":\"https://docs.staminads.com/api-reference/analytics/execute-an-analytics-query#apireference\",\"headline\":\"Execute an analytics query\",\"name\":\"Execute an analytics query\",\"url\":\"https://docs.staminads.com/api-reference/analytics/execute-an-analytics-query\",\"mainEntityOfPage\":{\"@id\":\"https://docs.staminads.com/api-reference/analytics/execute-an-analytics-query#webpage\"},\"dateModified\":\"2026-01-25T18:56:25.606Z\",\"publisher\":{\"@id\":\"https://docs.staminads.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.staminads.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Staminads Documentation\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Staminads Documentation","nav":{"global":null,"tabs":[{"tab":"Documentation","pages":[{"title":"Documentation","href":"/introduction"}]},{"tab":"API Reference","groups":[{"group":"Workspaces","pages":[{"title":"List workspaces for current user","deprecated":null,"version":null,"openapi":"openapi.json get /api/workspaces.list","href":"/api-reference/workspaces/list-workspaces-for-current-user"},{"title":"Get workspace by ID","deprecated":null,"version":null,"openapi":"openapi.json get /api/workspaces.get","href":"/api-reference/workspaces/get-workspace-by-id"},{"title":"Create a new workspace","deprecated":null,"version":null,"openapi":"openapi.json post /api/workspaces.create","href":"/api-reference/workspaces/create-a-new-workspace"},{"title":"Update an existing workspace","deprecated":null,"version":null,"openapi":"openapi.json post /api/workspaces.update","href":"/api-reference/workspaces/update-an-existing-workspace"},{"title":"Delete a workspace","description":null,"deprecated":null,"version":null,"openapi":"openapi.json post /api/workspaces.delete","href":"/api-reference/workspaces/delete-a-workspace"}]},{"group":"Analytics","pages":[{"title":"Execute an analytics query","deprecated":null,"version":null,"openapi":"openapi.json post /api/analytics.query","href":"/api-reference/analytics/execute-an-analytics-query"},{"title":"Get min/max extremes of a metric across grouped data","description":null,"deprecated":null,"version":null,"openapi":"openapi.json post /api/analytics.extremes","href":"/api-reference/analytics/get-minmax-extremes-of-a-metric-across-grouped-data"},{"title":"Get available metrics","deprecated":null,"version":null,"openapi":"openapi.json get /api/analytics.metrics","href":"/api-reference/analytics/get-available-metrics"},{"title":"Get available dimensions","deprecated":null,"version":null,"openapi":"openapi.json get /api/analytics.dimensions","href":"/api-reference/analytics/get-available-dimensions"},{"title":"Get available analytics tables","deprecated":null,"version":null,"openapi":"openapi.json get /api/analytics.tables","href":"/api-reference/analytics/get-available-analytics-tables"}]},{"group":"Filters","pages":[{"title":"List filters for workspace","deprecated":null,"version":null,"openapi":"openapi.json get /api/filters.list","href":"/api-reference/filters/list-filters-for-workspace"},{"title":"Get filter by ID","deprecated":null,"version":null,"openapi":"openapi.json get /api/filters.get","href":"/api-reference/filters/get-filter-by-id"},{"title":"Create filter","deprecated":null,"version":null,"openapi":"openapi.json post /api/filters.create","href":"/api-reference/filters/create-filter"},{"title":"Update filter","deprecated":null,"version":null,"openapi":"openapi.json post /api/filters.update","href":"/api-reference/filters/update-filter"},{"title":"Delete filter","deprecated":null,"version":null,"openapi":"openapi.json post /api/filters.delete","href":"/api-reference/filters/delete-filter"},{"title":"Reorder filters","deprecated":null,"version":null,"openapi":"openapi.json post /api/filters.reorder","href":"/api-reference/filters/reorder-filters"},{"title":"List unique tags across all filters","deprecated":null,"version":null,"openapi":"openapi.json get /api/filters.listTags","href":"/api-reference/filters/list-unique-tags-across-all-filters"},{"title":"Start background backfill for all filters","deprecated":null,"version":null,"openapi":"openapi.json post /api/filters.backfillStart","href":"/api-reference/filters/start-background-backfill-for-all-filters"},{"title":"Get backfill task status","deprecated":null,"version":null,"openapi":"openapi.json get /api/filters.backfillStatus","href":"/api-reference/filters/get-backfill-task-status"},{"title":"Cancel running backfill task","deprecated":null,"version":null,"openapi":"openapi.json post /api/filters.backfillCancel","href":"/api-reference/filters/cancel-running-backfill-task"},{"title":"List backfill tasks for workspace","deprecated":null,"version":null,"openapi":"openapi.json get /api/filters.backfillList","href":"/api-reference/filters/list-backfill-tasks-for-workspace"},{"title":"Get backfill status summary for workspace","deprecated":null,"version":null,"openapi":"openapi.json get /api/filters.backfillSummary","href":"/api-reference/filters/get-backfill-status-summary-for-workspace"}]},{"group":"Export","pages":[{"title":"Export user events","deprecated":null,"version":null,"openapi":"openapi.json get /api/export.userEvents","href":"/api-reference/export/export-user-events"}]}]}]},"title":"Execute an analytics query - Staminads Documentation","buildId":"dpl_DFJrtvUi8HS5F9nkooKuDJsuD5BM","deploymentId":"dpl_DFJrtvUi8HS5F9nkooKuDJsuD5BM","dynamics":["c2aa737661","2b790eda92","b0f84f53ff","a9bb46feb3"],"chunks":["OpenApiReferenceProvider-rfhihCWU.js","utils-BmH1XFxk.js","cloneDeep-izs3Hzxb.js","_Uint8Array-BVIqJ90l.js","isObjectLike-C8vmzPEN.js","isArray-Dcu1dQ5t.js","utils-BcNsxPKB.js","toString-BX-iyh8G.js","isSymbol-CSH9U2Gm.js","addUniqueKeysToSchema-BAES3tkd.js","snippetPresets-DCMQBKLP.js","style-to-object-BY3JEAdk.js","v4-DIgz8zy6.js","ApiExamples-D6l_bzE9.js","isEqual-BfaiBbcl.js","usePlaygroundInputsStore-BOktbnNh.js","shallow-BCs8SgM7.js","getApiPlaygroundDisplay-DEmW5bJB.js","CodeSnippet-CpZOpB9C.js","CodeSnippets-BOBDqibl.js","Page-D5fEM6aW.js","getPastedJson-DH2JBvmr.js","icon-BBJH-kKh.js","MethodPill-D2Sd5NLC.js","DuplicateIcon-CGgfL2qN.js","createIcon-BKudBBzi.js","DynamicMarkdown-85clUA0i.js","SectionHeading-D0JiMgDx.js","axios-vUo_bRtp.js","Markdown-Cfiy0xZO.js","clsx-rL8ZCCw4.js","lib--scc4DXi.js","lib-B8HbPgcC.js","html-void-elements-mCSPHezU.js","dist-aeztFa9U.js","katex-YMM-FMeD.js","marked.esm-CZWythHk.js","AssistantPageLink-BywkCr5C.js"]}