Move your queries from the legacy Data Warehouse (client_analytics) to the Analytics Warehouse.
Migrating from the legacy Data Warehouse
The legacy warehouse (client_analytics) is deprecated. It keeps working, untouched, during the migration period — you migrate at your own pace by updating two things in your queries: the database name and, where they changed, table and column names. Your credentials and connection host may also change; your Account Manager will confirm.
The legacy client_analytics database will be decommissioned after the migration period. All new integrations should be built against treble_client_analytics only.
Table mapping
Legacy (client_analytics)
New (treble_client_analytics)
Notes
fact_sessions
fact_treble_sessions
Adds trigger_keyword, last_node_id; inbound_outbound → direction
fact_inbound_messages
fact_treble_sessions filtered by direction = 'INBOUND'
Absorbed — same data, one table
fact_deployment_status
fact_campaign_sends
timestamps_eta → scheduled_at; timestamp_* → *_at
fact_deployment_daily
fact_campaign_daily
Same formulas, same columns
fact_conversations
fact_agent_conversations
Full history (legacy kept a rolling 3 months); adds transfer_count, assignment fields, and more
fact_agent_messages
fact_agent_conversation_messages
fact_redirections
fact_agent_conversation_transfers
fact_agent_status_changes
fact_agent_status_changes
Same name
fact_agent_daily
fact_agent_daily
Same name, same formulas
fact_hsm_responses
fact_hsm_responses
Same name
fact_target_events
fact_target_events
Same name
fact_whatsapp_links
fact_whatsapp_link_events
dim_agents, dim_tags, dim_teams, dim_agent_tags
Same names
dim_hsm
dim_hsms
Pluralized
session_variables
fact_treble_session_variables
Now generally available
—
fact_treble_session_messages
New — full conversation trace
—
fact_treble_session_nodes
New — node-by-node journey
—
fact_ad_sessions
New — Click-to-WhatsApp attribution
—
dim_polls, dim_channels, dim_poll_nodes
New dimensions
Column renames to watch for
Legacy
New
Where
inbound_outbound
direction
sessions
campaign_name
poll_name
agent conversations (poll_name is the one name used everywhere now)
Full history. The legacy warehouse trimmed most tables to a rolling 3 months. The new warehouse serves everything. If your queries relied on the window as an implicit filter, add explicit date filters (also good for performance).
Fresher “today”, stated consolidation. Data lands in minutes instead of hours, and figures for a day consolidate fully within 48 hours (see the data contract). During a migration comparison you may see the new warehouse slightly ahead of the legacy on the most recent day — that is legacy refresh lag, not a discrepancy.
Messages of deleted conversations are excluded from fact_agent_conversation_messages by design (the conversation they belong to no longer exists).
Contact enrichment on old conversations freezes.helpdesk_contact_id and contact_wa_id on agent conversations older than 90 days keep the value they had — CRM changes no longer propagate backwards to them.
Two documented formula refinements in fact_agent_daily: first-response time now comes from the platform’s own computation, and CSAT averages consider only conversations with a rating (rating != 0). Both are corrections; historical parity was verified before release.
No aliases. Legacy names are not mirrored in the new database — the mapping above is applied once, in your queries, and both systems coexist while you do it.
Suggested migration path
Point a copy of your dashboard/report at treble_client_analytics using the mapping above.
Run both versions side by side for a few days; expect exact matches on consolidated days.
Switch over, keeping explicit date filters.
Tell your Account Manager when you no longer use client_analytics — it helps us schedule the decommission.
Was this page helpful?
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Home","colors":{"primary":"#6464FF","light":"#F7F8FF","dark":"#6464FF"},"logo":{"light":"https://mintcdn.com/trebleai/5XNOo1Uq3QVPV6lD/logo/treble-light.svg?fit=max\u0026auto=format\u0026n=5XNOo1Uq3QVPV6lD\u0026q=85\u0026s=0f7f2dba2b6ef63a34fe90483601df50","dark":"https://mintcdn.com/trebleai/5XNOo1Uq3QVPV6lD/logo/dark.svg?fit=max\u0026auto=format\u0026n=5XNOo1Uq3QVPV6lD\u0026q=85\u0026s=fe4efb4ec225da5a3af57d9b539341c2"},"favicon":"https://mintcdn.com/trebleai/N7qFKPzh9cWmkY9Y/favicon-treble.svg?fit=max\u0026auto=format\u0026n=N7qFKPzh9cWmkY9Y\u0026q=85\u0026s=97fb999775e0a3d4632062af00a6dd3f","appearance":{"default":"light","strict":true},"navbar":{"links":[{"href":"https://wa.me/12058834230","label":"Support"}],"primary":{"type":"button","label":"Dashboard","href":"https://app.treble.ai"}},"footer":{"socials":{"linkedin":"https://www.linkedin.com/company/treble-ai"}},"integrations":{"amplitude":{"apiKey":"73db3d1720f71527cf6882e5063e25b6"},"intercom":{"appId":"uye4idh4"}},"styling":{"latex":true},"navigation":{"languages":[{"language":"es","default":true,"href":"es/home"},{"language":"en","href":"en/home"},{"language":"pt","href":"pt/home"}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"trebleai","hasAudioNarration":false,"actualSubdomain":"trebleai","customDomains":["help.treble.ai"],"gitSource":{"type":"github","owner":"treble-ai","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"feedback":{"thumbs":true,"edits":false},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6af7179e3522466a5b817c0e","clientVersion":"0.0.4227","searchFilterCounts":[{"language":"en","tag":"Documentation","count":200},{"language":"es","tag":"Documentación","count":200},{"language":"pt","tag":"Documentação","count":200},{"language":"en","tag":"User Guide","count":168},{"language":"es","tag":"Guía de usuario","count":168},{"language":"pt","tag":"Guia do usuário","count":168},{"language":"en","tag":"Integrations","count":52},{"language":"es","tag":"Integraciones","count":52},{"language":"pt","tag":"Integrações","count":52},{"language":"en","tag":"API Reference","count":31},{"language":"es","tag":"Referencia de API","count":31},{"language":"pt","tag":"Referência da API","count":31},{"language":"en","tag":"Main Platform","count":26},{"language":"es","tag":"Plataforma Principal","count":26},{"language":"pt","tag":"Plataforma Principal","count":26},{"language":"en","tag":"Build with Treble","count":20},{"language":"en","tag":"Analytics Warehouse","count":20},{"language":"es","tag":"Construye con Treble","count":20},{"language":"es","tag":"Analytics Warehouse","count":20},{"language":"pt","tag":"Construa com o Treble","count":20},{"language":"pt","tag":"Analytics Warehouse","count":20},{"language":"en","tag":"Salesforce","count":19},{"language":"es","tag":"Salesforce","count":19},{"language":"pt","tag":"Salesforce","count":19},{"language":"en","tag":"Webhooks","count":18},{"language":"en","tag":"Blocks","count":18},{"language":"es","tag":"Webhooks","count":18},{"language":"es","tag":"Bloques","count":18},{"language":"pt","tag":"Webhooks","count":18},{"language":"pt","tag":"Blocos","count":18}]},"assistantConfig":{},"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":"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},{"name":"starter-pricing","enabled":true,"variant":{"name":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":":root{--font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, Cantarell, 'Open Sans', 'Helvetica Neue', sans-serif}.hero-container{text-align:center;padding:4rem 1rem;background-color:#fafafa}.hero-title{font-size:3rem;font-weight:600;margin-bottom:1rem;color:#111827}.hero-description{font-size:1.125rem;color:#4b5563;margin-bottom:2rem;max-width:600px;margin-left:auto;margin-right:auto}.search-input{width:100%;max-width:500px;padding:0.75rem 1rem;border:1px solid #e5e7eb;border-radius:0.5rem;font-size:1rem;margin-bottom:2rem;cursor:pointer;background-color:white;transition:all 0.2s ease}.search-input:hover{border-color:#d1d5db;background-color:#f9fafb;box-shadow:0 1px 3px rgba(0, 0, 0, 0.1)}.search-input:focus{outline:none;border-color:#d1d5db;box-shadow:0 1px 3px rgba(0, 0, 0, 0.1)}.explore-link{color:#111827;text-decoration:none;font-weight:500}.explore-link:hover{text-decoration:underline}.section-title{text-align:center;font-size:2rem;font-weight:600;color:#111827;margin:4rem 0 2rem}.tools-guides-container{margin:6rem auto 8rem;max-width:70rem;padding-left:1.25rem;padding-right:1.25rem}.tools-guides-header{text-align:center;margin-bottom:3rem}.tools-guides-grid{width:100%}.hr{border-color:rgb(var(--gray-100));border-top-width:1px;margin-top:3em;margin-bottom:3em}.loom-video{position:relative;padding-bottom:62.5%;height:0}.loom-video iframe{position:absolute;top:0;left:0;width:100%;height:100%}a.article-link{color:var(--tw-prose-links);text-decoration:none;font-weight:600;border-bottom:2px solid rgb(var(--primary-dark));transition:border-color 0.2s ease;position:relative;display:inline-flex;align-items:center}a.article-link p{margin:0}a.article-link svg{width:14px!important;height:14px!important;margin-left:4px}a.article-link:hover{color:rgb(var(--primary-dark));border-color:transparent;background-color:rgba(var(--primary-dark), 0.1);transition:color 0.3s ease, border-color 0.3s ease, background-color 0.3s ease}.interactive-guide .step-container{margin-bottom:2rem;padding:1.5rem;border:1px solid #e5e7eb;border-radius:0.5rem;display:none;opacity:0;transform:translateY(10px);transition:opacity 0.3s ease, transform 0.3s ease}.interactive-guide .step-container h3{margin-top:0}.interactive-guide .step-container.active{display:block}.interactive-guide .step-container.current{opacity:1;transform:translateY(0)}.interactive-guide .step-container.completed{border-color:#10B981}.interactive-guide .step-navigation{display:flex;justify-content:flex-start;margin-bottom:2rem;gap:0.5rem}.interactive-guide .step-indicator{width:2rem;height:2rem;border-radius:50%;background-color:#f3f4f6;border:2px solid #e5e7eb;display:flex;align-items:center;justify-content:center;font-size:0.875rem;font-weight:500;color:#6b7280;cursor:pointer;transition:all 0.2s ease}.interactive-guide .step-indicator:hover{border-color:#d1d5db;background-color:#e5e7eb}.interactive-guide .step-indicator.current{background-color:#10B981;border-color:#059669;color:white}.interactive-guide .step-indicator.completed{background-color:#D1FAE5;border-color:#10B981;color:#059669}.interactive-guide .step-indicator.completed:hover{background-color:#A7F3D0}.interactive-guide .choice-buttons{display:flex;gap:1rem;margin-top:1rem}.interactive-guide .choice-button{padding:0.5rem 1rem;border:1px solid #e5e7eb;border-radius:0.25rem;background-color:white;cursor:pointer;transition:all 0.2s}.interactive-guide .choice-button:hover{background-color:#f9fafb;border-color:#d1d5db}.interactive-guide .choice-button.yes{background-color:#10B981;color:white;border-color:#059669}.interactive-guide .choice-button.no{background-color:#EF4444;color:white;border-color:#DC2626}.interactive-guide .choice-button.yes:hover{background-color:#059669}.interactive-guide .choice-button.no:hover{background-color:#DC2626}.interactive-guide .result-message{margin-top:1rem;padding:1rem;border-radius:0.25rem;display:none}.interactive-guide .result-message.success{background-color:#D1FAE5;color:#065F46;display:block}.interactive-guide .result-message.error{background-color:#FEE2E2;color:#991B1B;display:block}.interactive-guide .sub-steps{margin-top:1rem;display:none}.interactive-guide .sub-steps.active{display:block}.interactive-guide .checkbox-item{display:flex;flex-direction:column;margin-bottom:1rem;padding:0.75rem;border-radius:0.25rem;border:1px solid #e5e7eb;transition:all 0.2s}.interactive-guide .checkbox-item:hover{border-color:#d1d5db}.interactive-guide .checkbox-row{display:flex;align-items:center;justify-content:space-between}.interactive-guide .checkbox-label{display:flex;align-items:center;gap:0.75rem}.interactive-guide .toggle-buttons{display:flex;gap:0.5rem}.interactive-guide .toggle-button{padding:0.25rem 0.75rem;border:1px solid #e5e7eb;border-radius:0.25rem;background-color:white;font-size:0.875rem;cursor:pointer;transition:all 0.2s}.interactive-guide .toggle-button.selected{background-color:#10B981;color:white;border-color:#059669}.interactive-guide .toggle-button.selected.no{background-color:#EF4444;border-color:#DC2626}.interactive-guide .sub-step-help{display:none;margin-top:0.5rem;padding:0.75rem;background-color:#FEF3C7;border-radius:0.25rem;color:#92400E}.interactive-guide .sub-step-help.active{display:block}.interactive-guide .sub-step-help a{color:#92400E}.interactive-guide .sub-step-help a:hover{color:#78350F}.interactive-guide .progress-indicator{margin-top:1rem;height:0.5rem;background-color:#e5e7eb;border-radius:0.25rem;overflow:hidden}.interactive-guide .progress-bar{height:100%;background-color:#10B981;transition:width 0.3s ease;width:0%}.interactive-guide .sub-steps-summary{margin-top:1rem;padding:0.75rem;border-radius:0.25rem;background-color:#f9fafb;display:none}.interactive-guide .sub-steps-summary.complete{display:block;background-color:#D1FAE5;color:#065F46}"}]}
{"page":{"pagePath":"en/docs/data-warehouse-v2/migration-guide","slug":"/en/docs/data-warehouse-v2/migration-guide","pageMetadata":{"title":"Migration Guide","description":"Move your queries from the legacy Data Warehouse (client_analytics) to the Analytics Warehouse.","sidebarTitle":"Migration Guide","href":"/en/docs/data-warehouse-v2/migration-guide"},"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: \"Move your queries from the legacy Data Warehouse (client_analytics) to the Analytics Warehouse.\"\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={a:`a`,code:`code`,em:`em`,li:`li`,ol:`ol`,p:`p`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{Heading,Table,Warning}=_components;if(!Heading)_missingMdxReference(`Heading`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`1`,id:`migrating-from-the-legacy-data-warehouse`,children:`Migrating from the legacy Data Warehouse`}),`\n`,_jsxs(_components.p,{children:[`The legacy warehouse (`,_jsx(_components.code,{children:`client_analytics`}),`) is `,_jsx(_components.strong,{children:`deprecated`}),`. It keeps working, untouched, during the migration period — you migrate at your own pace by updating two things in your queries: the `,_jsx(_components.strong,{children:`database name`}),` and, where they changed, `,_jsx(_components.strong,{children:`table and column names`}),`. Your credentials and connection host may also change; your Account Manager will confirm.`]}),`\n`,_jsx(Warning,{children:_jsxs(_components.p,{children:[`The legacy `,_jsx(_components.code,{children:`client_analytics`}),` database will be decommissioned after the migration period. All new integrations should be built against `,_jsx(_components.code,{children:`treble_client_analytics`}),` only.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`table-mapping`,children:`Table mapping`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsxs(_components.th,{children:[`Legacy (`,_jsx(_components.code,{children:`client_analytics`}),`)`]}),_jsxs(_components.th,{children:[`New (`,_jsx(_components.code,{children:`treble_client_analytics`}),`)`]}),_jsx(_components.th,{children:`Notes`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_sessions`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_treble_sessions`})}),_jsxs(_components.td,{children:[`Adds `,_jsx(_components.code,{children:`trigger_keyword`}),`, `,_jsx(_components.code,{children:`last_node_id`}),`; `,_jsx(_components.code,{children:`inbound_outbound`}),` → `,_jsx(_components.code,{children:`direction`})]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_inbound_messages`})}),_jsxs(_components.td,{children:[_jsx(_components.code,{children:`fact_treble_sessions`}),` filtered by `,_jsx(_components.code,{children:`direction = 'INBOUND'`})]}),_jsx(_components.td,{children:`Absorbed — same data, one table`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_deployment_status`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_campaign_sends`})}),_jsxs(_components.td,{children:[_jsx(_components.code,{children:`timestamps_eta`}),` → `,_jsx(_components.code,{children:`scheduled_at`}),`; `,_jsx(_components.code,{children:`timestamp_*`}),` → `,_jsx(_components.code,{children:`*_at`})]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_deployment_daily`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_campaign_daily`})}),_jsx(_components.td,{children:`Same formulas, same columns`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_conversations`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_agent_conversations`})}),_jsx(_components.td,{children:`Full history (legacy kept a rolling 3 months); adds transfer_count, assignment fields, and more`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_agent_messages`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_agent_conversation_messages`})}),_jsx(_components.td,{})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_redirections`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_agent_conversation_transfers`})}),_jsx(_components.td,{})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_agent_status_changes`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_agent_status_changes`})}),_jsx(_components.td,{children:`Same name`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_agent_daily`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_agent_daily`})}),_jsx(_components.td,{children:`Same name, same formulas`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_hsm_responses`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_hsm_responses`})}),_jsx(_components.td,{children:`Same name`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_target_events`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_target_events`})}),_jsx(_components.td,{children:`Same name`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_whatsapp_links`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_whatsapp_link_events`})}),_jsx(_components.td,{})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[_jsx(_components.code,{children:`dim_agents`}),`, `,_jsx(_components.code,{children:`dim_tags`}),`, `,_jsx(_components.code,{children:`dim_teams`}),`, `,_jsx(_components.code,{children:`dim_agent_tags`})]}),_jsx(_components.td,{children:`Same names`}),_jsx(_components.td,{})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`dim_hsm`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`dim_hsms`})}),_jsx(_components.td,{children:`Pluralized`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`session_variables`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_treble_session_variables`})}),_jsx(_components.td,{children:`Now generally available`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_treble_session_messages`})}),_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`New`}),` — full conversation trace`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_treble_session_nodes`})}),_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`New`}),` — node-by-node journey`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`—`}),_jsx(_components.td,{children:_jsx(_components.code,{children:`fact_ad_sessions`})}),_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`New`}),` — Click-to-WhatsApp attribution`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`—`}),_jsxs(_components.td,{children:[_jsx(_components.code,{children:`dim_polls`}),`, `,_jsx(_components.code,{children:`dim_channels`}),`, `,_jsx(_components.code,{children:`dim_poll_nodes`})]}),_jsxs(_components.td,{children:[_jsx(_components.strong,{children:`New`}),` dimensions`]})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`column-renames-to-watch-for`,children:`Column renames to watch for`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Legacy`}),_jsx(_components.th,{children:`New`}),_jsx(_components.th,{children:`Where`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`inbound_outbound`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`direction`})}),_jsx(_components.td,{children:`sessions`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`campaign_name`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`poll_name`})}),_jsxs(_components.td,{children:[`agent conversations (`,_jsx(_components.code,{children:`poll_name`}),` is the one name used everywhere now)`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`timestamps_eta`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`scheduled_at`})}),_jsx(_components.td,{children:`campaign sends`})]}),_jsxs(_components.tr,{children:[_jsxs(_components.td,{children:[_jsx(_components.code,{children:`timestamp_delivered`}),` / `,_jsx(_components.code,{children:`_responded`}),` / `,_jsx(_components.code,{children:`_failure`}),` / `,_jsx(_components.code,{children:`_success`})]}),_jsxs(_components.td,{children:[_jsx(_components.code,{children:`delivered_at`}),` / `,_jsx(_components.code,{children:`responded_at`}),` / `,_jsx(_components.code,{children:`failed_at`}),` / `,_jsx(_components.code,{children:`succeeded_at`})]}),_jsx(_components.td,{children:`campaign sends`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`answer_id`})}),_jsx(_components.td,{children:_jsx(_components.code,{children:`answer_option_id`})}),_jsx(_components.td,{children:`flow nodes (it identifies the chosen option)`})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`behavior-differences-you-should-know`,children:`Behavior differences you should know`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Full history.`}),` The legacy warehouse trimmed most tables to a rolling 3 months. The new warehouse serves everything. If your queries relied on the window as an implicit filter, add explicit date filters (also good for performance).`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Fresher “today”, stated consolidation.`}),` Data lands in minutes instead of hours, and figures for a day consolidate fully within 48 hours (see `,_jsx(_components.a,{href:`/en/docs/data-warehouse-v2/welcome#the-data-contract`,children:`the data contract`}),`). During a migration comparison you may see the new warehouse slightly `,_jsx(_components.em,{children:`ahead`}),` of the legacy on the most recent day — that is legacy refresh lag, not a discrepancy.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Messages of deleted conversations are excluded`}),` from `,_jsx(_components.code,{children:`fact_agent_conversation_messages`}),` by design (the conversation they belong to no longer exists).`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Contact enrichment on old conversations freezes.`}),` `,_jsx(_components.code,{children:`helpdesk_contact_id`}),` and `,_jsx(_components.code,{children:`contact_wa_id`}),` on agent conversations older than 90 days keep the value they had — CRM changes no longer propagate backwards to them.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Two documented formula refinements`}),` in `,_jsx(_components.code,{children:`fact_agent_daily`}),`: first-response time now comes from the platform’s own computation, and CSAT averages consider only conversations with a rating (`,_jsx(_components.code,{children:`rating != 0`}),`). Both are corrections; historical parity was verified before release.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`No aliases.`}),` Legacy names are not mirrored in the new database — the mapping above is applied once, in your queries, and both systems coexist while you do it.`]}),`\n`]}),`\n`,_jsx(Heading,{level:`2`,id:`suggested-migration-path`,children:`Suggested migration path`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsxs(_components.li,{children:[`Point a copy of your dashboard/report at `,_jsx(_components.code,{children:`treble_client_analytics`}),` using the mapping above.`]}),`\n`,_jsx(_components.li,{children:`Run both versions side by side for a few days; expect exact matches on consolidated days.`}),`\n`,_jsx(_components.li,{children:`Switch over, keeping explicit date filters.`}),`\n`,_jsxs(_components.li,{children:[`Tell your Account Manager when you no longer use `,_jsx(_components.code,{children:`client_analytics`}),` — it helps us schedule the decommission.`]}),`\n`]})]})}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":{"config":{},"pageMetadata":{"title":"Migration Guide","description":"Move your queries from the legacy Data Warehouse (client_analytics) to the Analytics Warehouse.","sidebarTitle":"Migration Guide","href":"/en/docs/data-warehouse-v2/migration-guide"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Migrating from the legacy Data Warehouse","slug":"migrating-from-the-legacy-data-warehouse","depth":1,"children":[]},{"title":"Table mapping","slug":"table-mapping","depth":2,"children":[]},{"title":"Column renames to watch for","slug":"column-renames-to-watch-for","depth":2,"children":[]},{"title":"Behavior differences you should know","slug":"behavior-differences-you-should-know","depth":2,"children":[]},{"title":"Suggested migration path","slug":"suggested-migration-path","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/_mintlify/custom/trebleai/e8b64c48fcecfaa0/script.js"],"subdomain":"trebleai","siteName":"Home","title":"Migration Guide - Home","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"es":{"href":"/es/docs/data-warehouse-v2/migration-guide","matchLevel":1},"en":{"href":"/en/docs/data-warehouse-v2/migration-guide","matchLevel":0},"pt":{"href":"/pt/docs/data-warehouse-v2/migration-guide","matchLevel":1}}},"lastModified":"2026-11-12T17:19:40.149Z","originalFileLocation":"en/docs/data-warehouse-v2/migration-guide.mdx","locale":"en"},"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=\"description\" content=\"Move your queries from the legacy Data Warehouse (client_analytics) to the Analytics Warehouse.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Home\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/trebleai/HNsHU13Wcqq09jY3/_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/trebleai/HNsHU13Wcqq09jY3/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/trebleai/HNsHU13Wcqq09jY3/_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/trebleai/HNsHU13Wcqq09jY3/_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/trebleai/HNsHU13Wcqq09jY3/_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/trebleai/HNsHU13Wcqq09jY3/_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/trebleai/HNsHU13Wcqq09jY3/_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/trebleai/HNsHU13Wcqq09jY3/_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/trebleai/HNsHU13Wcqq09jY3/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Migration Guide - Home\">\u003cmeta data-mint-head property=\"og:description\" content=\"Move your queries from the legacy Data Warehouse (client_analytics) to the Analytics Warehouse.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Home\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://help.treble.ai/en/docs/data-warehouse-v2/migration-guide\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://trebleai.mintlify.site/_mintlify/api/og/v2?division=Using+the+Warehouse\u0026amp;title=Migration+Guide\u0026amp;description=Move+your+queries+from+the+legacy+Data+Warehouse+%28client_analytics%29+to+the+Analytics+Warehouse.\u0026amp;theme=6e15641089328b2149afcee8\u0026amp;signature=fe9d8646fd9d497a9853fbea5d67342c2c7a0f6ce079b13305235bcb3e3dab18\">\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=\"Migration Guide - Home\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Move your queries from the legacy Data Warehouse (client_analytics) to the Analytics Warehouse.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://trebleai.mintlify.site/_mintlify/api/og/v2?division=Using+the+Warehouse\u0026amp;title=Migration+Guide\u0026amp;description=Move+your+queries+from+the+legacy+Data+Warehouse+%28client_analytics%29+to+the+Analytics+Warehouse.\u0026amp;theme=6e15641089328b2149afcee8\u0026amp;signature=fe9d8646fd9d497a9853fbea5d67342c2c7a0f6ce079b13305235bcb3e3dab18\">\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/trebleai/HNsHU13Wcqq09jY3/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Home\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#6464FF\">\u003clink data-mint-head rel=\"canonical\" href=\"https://help.treble.ai/en/docs/data-warehouse-v2/migration-guide\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/en/docs/data-warehouse-v2/migration-guide.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://help.treble.ai/en/docs/data-warehouse-v2/migration-guide\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"es\" href=\"https://help.treble.ai/es/docs/data-warehouse-v2/migration-guide\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"pt\" href=\"https://help.treble.ai/pt/docs/data-warehouse-v2/migration-guide\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://help.treble.ai/es/docs/data-warehouse-v2/migration-guide\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://help.treble.ai/#organization\",\"name\":\"Home\",\"url\":\"https://help.treble.ai\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/trebleai/5XNOo1Uq3QVPV6lD/logo/treble-light.svg?fit=max\u0026auto=format\u0026n=5XNOo1Uq3QVPV6lD\u0026q=85\u0026s=0f7f2dba2b6ef63a34fe90483601df50\"}},{\"@type\":\"WebSite\",\"@id\":\"https://help.treble.ai#website\",\"name\":\"Home\",\"url\":\"https://help.treble.ai\",\"publisher\":{\"@id\":\"https://help.treble.ai/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://help.treble.ai/en/docs/data-warehouse-v2/migration-guide#webpage\",\"url\":\"https://help.treble.ai/en/docs/data-warehouse-v2/migration-guide\",\"name\":\"Migration Guide\",\"description\":\"Move your queries from the legacy Data Warehouse (client_analytics) to the Analytics Warehouse.\",\"dateModified\":\"2026-11-12T17:19:40.149Z\",\"isPartOf\":{\"@id\":\"https://help.treble.ai#website\"},\"breadcrumb\":{\"@id\":\"https://help.treble.ai/en/docs/data-warehouse-v2/migration-guide#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://help.treble.ai/en/docs/data-warehouse-v2/migration-guide#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Analytics Warehouse\",\"item\":\"https://help.treble.ai/en/docs/data-warehouse-v2/welcome\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migration Guide\",\"item\":\"https://help.treble.ai/en/docs/data-warehouse-v2/migration-guide\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://help.treble.ai/en/docs/data-warehouse-v2/migration-guide#article\",\"headline\":\"Migration Guide\",\"name\":\"Migration Guide\",\"description\":\"Move your queries from the legacy Data Warehouse (client_analytics) to the Analytics Warehouse.\",\"url\":\"https://help.treble.ai/en/docs/data-warehouse-v2/migration-guide\",\"mainEntityOfPage\":{\"@id\":\"https://help.treble.ai/en/docs/data-warehouse-v2/migration-guide#webpage\"},\"dateModified\":\"2026-11-12T17:19:40.149Z\",\"publisher\":{\"@id\":\"https://help.treble.ai/#organization\"},\"isPartOf\":{\"@id\":\"https://help.treble.ai#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Home\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Home\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/en/docs/data-warehouse-v2/migration-guide.md","siteName":"Home","nav":{"global":null,"languages":[{"language":"es","default":true,"pages":[{"title":"es","href":"/es/docs/data-warehouse-v2/migration-guide"}]},{"language":"en","anchors":[{"anchor":"Documentation","icon":"book-open","tabs":[{"tab":"Welcome","pages":[{"title":"Welcome","href":"/en/home"}]},{"tab":"User Guide","groups":[{"group":"Get Started","pages":[{"title":"Welcome to Treble","sidebarTitle":"Overview","href":"/en/docs/welcome"},{"title":"Key Concepts","href":"/en/docs/key-concepts"},{"group":"Introduction to Treble","pages":[{"title":"Getting Started","href":"/en/docs/intro-to-treble/welcome"},{"title":"Outbound Conversation","href":"/en/docs/intro-to-treble/outbound-convo"},{"title":"Inbound Conversation","href":"/en/docs/intro-to-treble/inbound-convo"},{"title":"Tutorial: First Conversation Transferred to an Agent","href":"/en/docs/intro-to-treble/first-agent-convo"}]}]},{"group":"Meta","pages":[{"title":"Meta and Treble","href":"/en/docs/meta/overview"},{"title":"WhatsApp, WhatsApp Business, and WhatsApp Business API","href":"/en/docs/meta/wa-wabiz-api"},{"group":"Connect WhatsApp Line","pages":[{"title":"Connect WhatsApp Line","sidebarTitle":"Getting Started","href":"/en/docs/meta/guide/welcome"},{"title":"Prepare your website","href":"/en/docs/meta/guide/preparing-website"},{"title":"Meta Business Portfolio","href":"/en/docs/meta/guide/business-manager"},{"title":"Meta Verification","href":"/en/docs/meta/guide/meta-verification"},{"title":"WhatsApp Number","href":"/en/docs/meta/guide/whatsapp-number"}]},{"group":"Message Templates","pages":[{"title":"Templates","href":"/en/docs/meta/hsm-templates/intro"},{"title":"Utility Templates","href":"/en/docs/meta/hsm-templates/utility"},{"title":"Carousel Templates","href":"/en/docs/meta/hsm-templates/carousel"}]},{"title":"Green Check WhatsApp Line","href":"/en/docs/meta/green-check"},{"title":"WhatsApp Line Health","href":"/en/docs/meta/whatsapp-line-health"},{"title":"WhatsApp Business Platform Policies","href":"/en/docs/meta/waba-policies"},{"title":"WhatsApp Usernames \u0026 Business-Scoped User IDs (BSUID)","href":"/en/docs/meta/usernames-and-bsuid"},{"group":"WhatsApp Errors","pages":[{"title":"Failure by unable to contact in WhatsApp","href":"/en/docs/meta/error-descriptions/failure-by-unable-to-contact"},{"title":"Failure by payment issue in WhatsApp","href":"/en/docs/meta/error-descriptions/failure-by-payment-issue"}]}]},{"group":"Build with Treble","pages":[{"title":"Campaign Objective","href":"/en/docs/build-with-treble/welcome"},{"group":"Features","pages":[{"title":"Variables","href":"/en/docs/build-with-treble/features/variables"},{"title":"Native Variables","href":"/en/docs/build-with-treble/features/native-variables"},{"title":"Alternate Flow","href":"/en/docs/build-with-treble/features/alternate-flow"},{"title":"Second template","href":"/en/docs/build-with-treble/features/second-hsm"},{"title":"Goal Block","href":"/en/docs/build-with-treble/features/goal-block"},{"title":"Images, documents and videos in your message blocks","href":"/en/docs/build-with-treble/features/media"}]},{"group":"Blocks","pages":[{"title":"A/B Testing","href":"/en/docs/build-with-treble/blocks/ab-test"},{"group":"Transfer Methods","pages":[{"title":"Transfer Methods","href":"/en/docs/build-with-treble/blocks/transfer-methods/overview"},{"title":"Treble Methods","href":"/en/docs/build-with-treble/blocks/transfer-methods/treble"},{"title":"HubSpot Methods","href":"/en/docs/build-with-treble/blocks/transfer-methods/hubspot"},{"title":"API Assignment","href":"/en/docs/build-with-treble/blocks/transfer-methods/api"}]},{"title":"Transfer to Agent","href":"/en/docs/build-with-treble/blocks/agent"},{"title":"WhatsApp Flows","href":"/en/docs/build-with-treble/blocks/whatsapp-flows"},{"title":"📣 Meta Events — Measure What Matters","sidebarTitle":"Meta Events","href":"/en/docs/build-with-treble/blocks/meta-events"},{"title":"Message Blocks - Buttons, Interactive List, Simple and with Options","href":"/en/docs/build-with-treble/blocks/message-blocks"},{"title":"Conditional Block","href":"/en/docs/build-with-treble/blocks/conditional"},{"title":"Jump to Conversation Block","href":"/en/docs/build-with-treble/blocks/jump-to-conversation"}]},{"group":"Guides","pages":[{"title":"Schedule and Time Configuration","href":"/en/docs/build-with-treble/guides/schedules-and-time-configuration"},{"title":"How to Measure Your Link Performance","href":"/en/docs/build-with-treble/guides/measure-links"}]}]},{"group":"Main Platform","pages":[{"title":"Understanding the Main Platform","sidebarTitle":"Overview","href":"/en/docs/main-platform/welcome"},{"title":"Conversation Flow Editor","href":"/en/docs/main-platform/conversation-editor"},{"title":"Send Outbound Conversation","href":"/en/docs/main-platform/send-convo"},{"title":"Contacts","href":"/en/docs/main-platform/contacts"},{"title":"Treble Link Shortener","href":"/en/docs/main-platform/link-shortener"},{"group":"AI Agents","pages":[{"title":"Introduction","href":"/en/docs/main-platform/ai-center/overview"},{"title":"Create an agent","href":"/en/docs/main-platform/ai-center/create-agent"},{"title":"Configure your agent","href":"/en/docs/main-platform/ai-center/configure-agent"},{"title":"Test your agent","href":"/en/docs/main-platform/ai-center/playground"},{"title":"Knowledge Base","href":"/en/docs/main-platform/ai-center/knowledge-base"},{"group":"Agents","pages":[{"group":"AI Agent","pages":[{"title":"Introduction","href":"/en/docs/main-platform/ai-center/agents/ai-agent/overview"},{"title":"API Call Tool","href":"/en/docs/main-platform/ai-center/agents/ai-agent/api-tool"},{"title":"Google Calendar Integration","href":"/en/docs/main-platform/ai-center/agents/ai-agent/google-calendar"},{"title":"Setting up Shopify Integration","href":"/en/docs/main-platform/ai-center/agents/ai-agent/shopify-install"},{"title":"How to use Shopify in your conversations","href":"/en/docs/main-platform/ai-center/agents/ai-agent/shopify-usage"}]},{"group":"Legacy agents","pages":[{"title":"Take your customers to a goal","href":"/en/docs/main-platform/ai-center/agents/objective-ai"},{"title":"Lead Qualification","href":"/en/docs/main-platform/ai-center/agents/lead-qualification"}]}]}]},{"group":"Metrics","pages":[{"title":"Metrics","sidebarTitle":"Introduction","href":"/en/docs/main-platform/metrics/overview"},{"title":"Outbound","href":"/en/docs/main-platform/metrics/outbound"},{"title":"Inbound","href":"/en/docs/main-platform/metrics/inbound"},{"title":"Agents","href":"/en/docs/main-platform/metrics/agents"}]},{"title":"Conversation Metrics","href":"/en/docs/main-platform/conversation-metrics"},{"title":"WhatsApp Links","href":"/en/docs/main-platform/whatsapp-links"},{"title":"Analytics Center","sidebarTitle":"Analytics Center","href":"/en/docs/main-platform/analytics-center"},{"title":"Settings Section","href":"/en/docs/main-platform/settings"},{"title":"Knowledge Base","href":"/en/docs/main-platform/knowledge-base"}]},{"group":"Agent Platform","pages":[{"title":"Understanding the Agent Platform","sidebarTitle":"General Overview","href":"/en/docs/agent-platform/welcome"},{"title":"Main View","href":"/en/docs/agent-platform/main-platform"},{"title":"Contacts Section","href":"/en/docs/agent-platform/contacts"},{"group":"Admin","pages":[{"title":"Administrator Section","href":"/en/docs/agent-platform/admin/admin-section"},{"title":"Metrics","href":"/en/docs/agent-platform/admin/metrics"},{"title":"Agents","href":"/en/docs/agent-platform/admin/agents"},{"title":"Agent Teams","href":"/en/docs/agent-platform/admin/tags-teams"},{"title":"Quick Response Templates","href":"/en/docs/agent-platform/admin/quick-responses"},{"title":"AI - Intelligent Assistants","href":"/en/docs/agent-platform/admin/treble-boost"},{"title":"Configuration","href":"/en/docs/agent-platform/admin/configuration"},{"title":"Recommendations and FAQs","href":"/en/docs/agent-platform/admin/tips-and-questions"}]},{"title":"Mobile App for Agents","href":"/en/docs/agent-platform/mobile-app"},{"title":"How to Sort and Filter Conversations","href":"/en/docs/agent-platform/filters"},{"title":"Push Notifications Setup","href":"/en/docs/agent-platform/notifications"},{"title":"Automatic Inactivity Detection","href":"/en/docs/agent-platform/inactivity"},{"title":"SLA Automations","href":"/en/docs/agent-platform/sla-automations"}]},{"group":"Integrations","pages":[{"title":"Integrations","href":"/en/docs/integrations/welcome"},{"group":"HubSpot","pages":[{"title":"HubSpot Integration","href":"/en/docs/integrations/hubspot/welcome"},{"title":"Install Treble in HubSpot","href":"/en/docs/integrations/hubspot/install"},{"title":"Install the Chrome Extension","href":"/en/docs/integrations/hubspot/chrome-extension"},{"title":"Getting Started","href":"/en/docs/integrations/hubspot/getting-started"},{"group":"Features","pages":[{"title":"Workflows","href":"/en/docs/integrations/hubspot/features/workflows"},{"title":"Variables","href":"/en/docs/integrations/hubspot/features/variables"},{"title":"HubSpot properties in Treble","href":"/en/docs/integrations/hubspot/features/properties"},{"title":"Deploy Conversation from Contact Profile","href":"/en/docs/integrations/hubspot/features/deploy"},{"title":"Chat History in HubSpot as Notes","href":"/en/docs/integrations/hubspot/features/chat-history"},{"title":"HubSpot Activities","href":"/en/docs/integrations/hubspot/features/activities"}]},{"group":"Blocks","pages":[{"title":"CRM Action Block","href":"/en/docs/integrations/hubspot/blocks/crm-action"},{"title":"CRM Object Block","href":"/en/docs/integrations/hubspot/blocks/crm-variable-assignment"},{"title":"Ticket Block","href":"/en/docs/integrations/hubspot/blocks/ticket"},{"title":"Conditional Block","href":"/en/docs/integrations/hubspot/blocks/conditional"}]},{"group":"HubSpot + AI","pages":[{"title":"HubSpot AI Integration","href":"/en/docs/integrations/hubspot/hubspot-ai/welcome"},{"title":"Installing the HubSpot AI Integration","href":"/en/docs/integrations/hubspot/hubspot-ai/installation"},{"title":"HubSpot AI Integration Features","href":"/en/docs/integrations/hubspot/hubspot-ai/features"},{"title":"HubSpot AI integration use case examples","href":"/en/docs/integrations/hubspot/hubspot-ai/examples"}]}]},{"group":"Salesforce","pages":[{"title":"Salesforce Integration","href":"/en/docs/integrations/salesforce/welcome"},{"title":"Install Treble in Salesforce","href":"/en/docs/integrations/salesforce/install"},{"title":"Sync Salesforce objects","href":"/en/docs/integrations/salesforce/object-sync"},{"group":"Blocks","pages":[{"title":"CRM Action Block","href":"/en/docs/integrations/salesforce/blocks/crm-action"},{"title":"Salesforce read block","href":"/en/docs/integrations/salesforce/blocks/crm-variable-assignment"},{"title":"Transfer to an advisor from Salesforce","href":"/en/docs/integrations/salesforce/blocks/human-transfer"}]},{"group":"Features","pages":[{"title":"Conversation history in the CRM","href":"/en/docs/integrations/salesforce/features/activities"},{"title":"Conversations custom object","href":"/en/docs/integrations/salesforce/features/custom-object"},{"title":"Record Types","href":"/en/docs/integrations/salesforce/features/record-types"},{"title":"Person Accounts","href":"/en/docs/integrations/salesforce/features/person-accounts"},{"title":"Salesforce contacts in Sales","href":"/en/docs/integrations/salesforce/features/sales-view"},{"title":"Advanced settings","href":"/en/docs/integrations/salesforce/features/advanced-settings"}]},{"group":"Treble inside Salesforce","pages":[{"title":"WhatsApp inside Salesforce","href":"/en/docs/integrations/salesforce/embed/custom-tab"},{"title":"Launch conversations from a Flow","href":"/en/docs/integrations/salesforce/embed/automation-flow-package"},{"title":"Marketing Cloud","href":"/en/docs/integrations/salesforce/embed/marketing-cloud"}]},{"group":"Salesforce AI","pages":[{"title":"Salesforce AI Integration","href":"/en/docs/integrations/salesforce/salesforce-ai/welcome"},{"title":"Installing the Salesforce AI Integration","href":"/en/docs/integrations/salesforce/salesforce-ai/installation"},{"title":"Salesforce AI Integration Features","href":"/en/docs/integrations/salesforce/salesforce-ai/features"},{"title":"Salesforce AI integration use case examples","href":"/en/docs/integrations/salesforce/salesforce-ai/examples"}]}]},{"group":"Sheets","pages":[{"title":"Treble.ai Integration with Google Sheets","href":"/en/docs/integrations/sheets/welcome"},{"title":"Frequently Asked Questions","href":"/en/docs/integrations/sheets/faq"}]},{"group":"Zoho","pages":[{"title":"Zoho Integration","href":"/en/docs/integrations/zoho/welcome"},{"title":"Installing the Zoho Integration","href":"/en/docs/integrations/zoho/installation"},{"title":"Zoho Integration Features","href":"/en/docs/integrations/zoho/features"},{"title":"Zoho integration use case examples","href":"/en/docs/integrations/zoho/examples"}]},{"group":"Pipedrive","pages":[{"title":"Pipedrive Integration","href":"/en/docs/integrations/pipedrive/welcome"},{"title":"Installing the Pipedrive Integration","href":"/en/docs/integrations/pipedrive/installation"},{"title":"Pipedrive Integration Features","href":"/en/docs/integrations/pipedrive/features"},{"title":"Pipedrive integration use case examples","href":"/en/docs/integrations/pipedrive/examples"}]},{"group":"Active Campaign","pages":[{"title":"Active Campaign Integration","href":"/en/docs/integrations/activecampaign/welcome"},{"title":"Installing the Active Campaign Integration","href":"/en/docs/integrations/activecampaign/installation"},{"title":"Active Campaign Integration Features","href":"/en/docs/integrations/activecampaign/features"},{"title":"Active Campaign integration use case examples","href":"/en/docs/integrations/activecampaign/examples"}]}]},{"group":"Analytics Warehouse","pages":[{"title":"Analytics Warehouse","description":"Query your Treble data in near real time with SQL — full history, richer detail, and a stable naming contract.","sidebarTitle":"Introduction","href":"/en/docs/data-warehouse-v2/welcome"},{"group":"Using the Warehouse","pages":[{"title":"Migration Guide","sidebarTitle":"Migration Guide","href":"/en/docs/data-warehouse-v2/migration-guide"},{"title":"Incremental Sync","description":"Keep a copy of your Treble data in your own systems, reliably, using the synced_at watermark.","sidebarTitle":"Incremental Sync","href":"/en/docs/data-warehouse-v2/incremental-sync"},{"title":"Query Optimization","sidebarTitle":"Optimization","href":"/en/docs/data-warehouse-v2/query-optimization"}]},{"group":"Conversation Flows","pages":[{"title":"fact_treble_sessions","sidebarTitle":"Sessions","href":"/en/docs/data-warehouse-v2/fact-treble-sessions"},{"title":"fact_treble_session_messages","sidebarTitle":"Messages","href":"/en/docs/data-warehouse-v2/fact-treble-session-messages"},{"title":"fact_treble_session_nodes","sidebarTitle":"Journeys","href":"/en/docs/data-warehouse-v2/fact-treble-session-nodes"},{"title":"fact_treble_session_variables","sidebarTitle":"Variables","href":"/en/docs/data-warehouse-v2/fact-treble-session-variables"}]},{"group":"Campaigns","pages":[{"title":"fact_campaign_sends","sidebarTitle":"Sends","href":"/en/docs/data-warehouse-v2/fact-campaign-sends"},{"title":"fact_campaign_daily","sidebarTitle":"Daily Summary","href":"/en/docs/data-warehouse-v2/fact-campaign-daily"},{"title":"fact_hsm_responses","sidebarTitle":"Template Responses","href":"/en/docs/data-warehouse-v2/fact-hsm-responses"}]},{"group":"Agent Workspace","pages":[{"title":"fact_agent_conversations","sidebarTitle":"Conversations","href":"/en/docs/data-warehouse-v2/fact-agent-conversations"},{"title":"fact_agent_conversation_messages","sidebarTitle":"Messages","href":"/en/docs/data-warehouse-v2/fact-agent-conversation-messages"},{"title":"fact_agent_conversation_transfers","sidebarTitle":"Transfers","href":"/en/docs/data-warehouse-v2/fact-agent-conversation-transfers"},{"title":"fact_agent_status_changes","sidebarTitle":"Availability","href":"/en/docs/data-warehouse-v2/fact-agent-status-changes"},{"title":"fact_agent_daily","sidebarTitle":"Daily Summary","href":"/en/docs/data-warehouse-v2/fact-agent-daily"}]},{"group":"Conversions \u0026 Attribution","pages":[{"title":"fact_target_events","sidebarTitle":"Target Events","href":"/en/docs/data-warehouse-v2/fact-target-events"},{"title":"fact_ad_sessions","sidebarTitle":"Meta Ads (CTWA)","href":"/en/docs/data-warehouse-v2/fact-ad-sessions"},{"title":"fact_whatsapp_link_events","sidebarTitle":"WhatsApp Links","href":"/en/docs/data-warehouse-v2/fact-whatsapp-link-events"}]},{"title":"Dimensions","sidebarTitle":"Dimensions","href":"/en/docs/data-warehouse-v2/dimensions"}]},{"group":"Data Warehouse (Legacy)","pages":[{"title":"Data Warehouse (Legacy)","sidebarTitle":"Introduction","href":"/en/docs/data-warehouse/welcome"},{"title":"fact_conversations","sidebarTitle":"Conversations","href":"/en/docs/data-warehouse/fact-conversations"},{"title":"fact_agent_messages","sidebarTitle":"Messages","href":"/en/docs/data-warehouse/fact-agent-messages"},{"title":"fact_redirections","sidebarTitle":"Transfers","href":"/en/docs/data-warehouse/fact-redirections"},{"title":"fact_agent_status_changes","sidebarTitle":"Agent Availability","href":"/en/docs/data-warehouse/fact-agent-status-changes"},{"title":"fact_agent_daily","sidebarTitle":"Agent Productivity","href":"/en/docs/data-warehouse/fact-agent-daily"},{"title":"fact_sessions","sidebarTitle":"Conversation Flows","href":"/en/docs/data-warehouse/fact-sessions"},{"title":"fact_deployment_status","sidebarTitle":"Delivery Detail","href":"/en/docs/data-warehouse/fact-deployment-status"},{"title":"fact_deployment_daily","sidebarTitle":"Delivery Metrics","href":"/en/docs/data-warehouse/fact-deployment-daily"},{"title":"fact_hsm_responses","sidebarTitle":"Template Responses","href":"/en/docs/data-warehouse/fact-hsm-responses"},{"title":"Dimension Tables","sidebarTitle":"Dimensions","href":"/en/docs/data-warehouse/dimensions"},{"title":"Query Optimization","sidebarTitle":"Optimization","href":"/en/docs/data-warehouse/query-optimization"}]}]},{"tab":"API Reference","pages":[{"title":"API Reference","href":"/en/api-reference/intro/intro"}]}]},{"anchor":"Community","icon":"slack","href":"https://trebleai.slack.com"},{"anchor":"Blog","icon":"newspaper","href":"https://blog.treble.ai"}]},{"language":"pt","pages":[{"title":"pt","href":"/pt/docs/data-warehouse-v2/migration-guide"}]}]},"basePath":"","title":"Migration Guide - Home","deploymentId":"dpl_vSEmv961Ncyvz1psVwgUnTXQMSYk","buildId":"dpl_vSEmv961Ncyvz1psVwgUnTXQMSYk","dynamics":[],"chunks":[]}