Migra tus queries del Data Warehouse legacy (client_analytics) al Analytics Warehouse.
Migrar desde el Data Warehouse legacy
El warehouse legacy (client_analytics) está deprecado. Sigue funcionando, sin cambios, durante el periodo de migración — migras a tu propio ritmo actualizando dos cosas en tus queries: el nombre de la base de datos y, donde cambiaron, los nombres de tablas y columnas. Tus credenciales y el host de conexión también pueden cambiar; tu Account Manager lo confirmará.
La base de datos legacy client_analytics será dada de baja después del periodo de migración. Toda integración nueva debe construirse únicamente contra treble_client_analytics.
Mapeo de tablas
Legacy (client_analytics)
Nueva (treble_client_analytics)
Notas
fact_sessions
fact_treble_sessions
Agrega trigger_keyword, last_node_id; inbound_outbound → direction
fact_inbound_messages
fact_treble_sessions filtrada por direction = 'INBOUND'
Absorbida — mismos datos, una sola tabla
fact_deployment_status
fact_campaign_sends
timestamps_eta → scheduled_at; timestamp_* → *_at
fact_deployment_daily
fact_campaign_daily
Mismas fórmulas, mismas columnas
fact_conversations
fact_agent_conversations
Historia completa (la legacy mantenía una ventana móvil de 3 meses); agrega transfer_count, campos de asignación y más
fact_agent_messages
fact_agent_conversation_messages
fact_redirections
fact_agent_conversation_transfers
fact_agent_status_changes
fact_agent_status_changes
Mismo nombre
fact_agent_daily
fact_agent_daily
Mismo nombre, mismas fórmulas
fact_hsm_responses
fact_hsm_responses
Mismo nombre
fact_target_events
fact_target_events
Mismo nombre
fact_whatsapp_links
fact_whatsapp_link_events
dim_agents, dim_tags, dim_teams, dim_agent_tags
Mismos nombres
dim_hsm
dim_hsms
Pluralizada
session_variables
fact_treble_session_variables
Ahora disponible de forma general
—
fact_treble_session_messages
Nueva — traza completa de la conversación
—
fact_treble_session_nodes
Nueva — recorrido nodo a nodo
—
fact_ad_sessions
Nueva — atribución Click-to-WhatsApp
—
dim_polls, dim_channels, dim_poll_nodes
Dimensiones nuevas
Renombres de columnas a tener en cuenta
Legacy
Nueva
Dónde
inbound_outbound
direction
sesiones
campaign_name
poll_name
conversaciones de agente (poll_name es el único nombre usado en todas partes ahora)
Historia completa. El warehouse legacy recortaba la mayoría de las tablas a una ventana móvil de 3 meses. El nuevo warehouse sirve todo. Si tus queries dependían de esa ventana como filtro implícito, agrega filtros de fecha explícitos (también es bueno para el rendimiento).
“Hoy” más fresco, consolidación declarada. Los datos aterrizan en minutos en lugar de horas, y las cifras de un día se consolidan por completo dentro de 48 horas (mira el contrato de datos). Durante una comparación de migración puedes ver el nuevo warehouse ligeramente adelantado respecto al legacy en el día más reciente — eso es rezago de actualización del legacy, no una discrepancia.
Los mensajes de conversaciones eliminadas se excluyen de fact_agent_conversation_messages por diseño (la conversación a la que pertenecen ya no existe).
El enriquecimiento de contacto en conversaciones antiguas se congela.helpdesk_contact_id y contact_wa_id en conversaciones de agente de más de 90 días conservan el valor que tenían — los cambios del CRM ya no se propagan hacia atrás en ellas.
Dos refinamientos de fórmula documentados en fact_agent_daily: el tiempo de primera respuesta ahora viene del cálculo propio de la plataforma, y los promedios de CSAT consideran solo conversaciones con calificación (rating != 0). Ambos son correcciones; la paridad histórica se verificó antes del lanzamiento.
Sin alias. Los nombres legacy no están espejados en la nueva base de datos — el mapeo de arriba se aplica una sola vez, en tus queries, y ambos sistemas coexisten mientras lo haces.
Ruta de migración sugerida
Apunta una copia de tu dashboard/reporte a treble_client_analytics usando el mapeo de arriba.
Ejecuta ambas versiones en paralelo durante unos días; espera coincidencias exactas en los días consolidados.
Haz el cambio definitivo, manteniendo filtros de fecha explícitos.
Avísale a tu Account Manager cuando ya no uses client_analytics — nos ayuda a programar la baja definitiva.
¿Esta página le ayudó?
{"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":"control","enabled":true,"payload":{"type":"string","value":"control"},"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":"es/docs/data-warehouse-v2/migration-guide","slug":"/es/docs/data-warehouse-v2/migration-guide","pageMetadata":{"title":"Guía de Migración","description":"Migra tus queries del Data Warehouse legacy (client_analytics) al Analytics Warehouse.","sidebarTitle":"Guía de Migración","href":"/es/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: \"Migra tus queries del Data Warehouse legacy (client_analytics) al 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:`migrar-desde-el-data-warehouse-legacy`,children:`Migrar desde el Data Warehouse legacy`}),`\n`,_jsxs(_components.p,{children:[`El warehouse legacy (`,_jsx(_components.code,{children:`client_analytics`}),`) está `,_jsx(_components.strong,{children:`deprecado`}),`. Sigue funcionando, sin cambios, durante el periodo de migración — migras a tu propio ritmo actualizando dos cosas en tus queries: el `,_jsx(_components.strong,{children:`nombre de la base de datos`}),` y, donde cambiaron, los `,_jsx(_components.strong,{children:`nombres de tablas y columnas`}),`. Tus credenciales y el host de conexión también pueden cambiar; tu Account Manager lo confirmará.`]}),`\n`,_jsx(Warning,{children:_jsxs(_components.p,{children:[`La base de datos legacy `,_jsx(_components.code,{children:`client_analytics`}),` será dada de baja después del periodo de migración. Toda integración nueva debe construirse únicamente contra `,_jsx(_components.code,{children:`treble_client_analytics`}),`.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`mapeo-de-tablas`,children:`Mapeo de tablas`}),`\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:[`Nueva (`,_jsx(_components.code,{children:`treble_client_analytics`}),`)`]}),_jsx(_components.th,{children:`Notas`})]})}),_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:[`Agrega `,_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`}),` filtrada por `,_jsx(_components.code,{children:`direction = 'INBOUND'`})]}),_jsx(_components.td,{children:`Absorbida — mismos datos, una sola tabla`})]}),_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:`Mismas fórmulas, mismas columnas`})]}),_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:`Historia completa (la legacy mantenía una ventana móvil de 3 meses); agrega transfer_count, campos de asignación y más`})]}),_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:`Mismo nombre`})]}),_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:`Mismo nombre, mismas fórmulas`})]}),_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:`Mismo nombre`})]}),_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:`Mismo nombre`})]}),_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:`Mismos nombres`}),_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:`Pluralizada`})]}),_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:`Ahora disponible de forma general`})]}),_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:`Nueva`}),` — traza completa de la conversación`]})]}),_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:`Nueva`}),` — recorrido nodo a nodo`]})]}),_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:`Nueva`}),` — atribución Click-to-WhatsApp`]})]}),_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:[`Dimensiones `,_jsx(_components.strong,{children:`nuevas`})]})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`renombres-de-columnas-a-tener-en-cuenta`,children:`Renombres de columnas a tener en cuenta`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Legacy`}),_jsx(_components.th,{children:`Nueva`}),_jsx(_components.th,{children:`Dónde`})]})}),_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:`sesiones`})]}),_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:[`conversaciones de agente (`,_jsx(_components.code,{children:`poll_name`}),` es el único nombre usado en todas partes ahora)`]})]}),_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:`envíos de campaña`})]}),_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:`envíos de campaña`})]}),_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:`nodos de flujo (identifica la opción elegida)`})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`diferencias-de-comportamiento-que-debes-conocer`,children:`Diferencias de comportamiento que debes conocer`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Historia completa.`}),` El warehouse legacy recortaba la mayoría de las tablas a una ventana móvil de 3 meses. El nuevo warehouse sirve todo. Si tus queries dependían de esa ventana como filtro implícito, agrega filtros de fecha explícitos (también es bueno para el rendimiento).`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`“Hoy” más fresco, consolidación declarada.`}),` Los datos aterrizan en minutos en lugar de horas, y las cifras de un día se consolidan por completo dentro de 48 horas (mira `,_jsx(_components.a,{href:`/es/docs/data-warehouse-v2/welcome#el-contrato-de-datos`,children:`el contrato de datos`}),`). Durante una comparación de migración puedes ver el nuevo warehouse ligeramente `,_jsx(_components.em,{children:`adelantado`}),` respecto al legacy en el día más reciente — eso es rezago de actualización del legacy, no una discrepancia.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Los mensajes de conversaciones eliminadas se excluyen`}),` de `,_jsx(_components.code,{children:`fact_agent_conversation_messages`}),` por diseño (la conversación a la que pertenecen ya no existe).`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`El enriquecimiento de contacto en conversaciones antiguas se congela.`}),` `,_jsx(_components.code,{children:`helpdesk_contact_id`}),` y `,_jsx(_components.code,{children:`contact_wa_id`}),` en conversaciones de agente de más de 90 días conservan el valor que tenían — los cambios del CRM ya no se propagan hacia atrás en ellas.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Dos refinamientos de fórmula documentados`}),` en `,_jsx(_components.code,{children:`fact_agent_daily`}),`: el tiempo de primera respuesta ahora viene del cálculo propio de la plataforma, y los promedios de CSAT consideran solo conversaciones con calificación (`,_jsx(_components.code,{children:`rating != 0`}),`). Ambos son correcciones; la paridad histórica se verificó antes del lanzamiento.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Sin alias.`}),` Los nombres legacy no están espejados en la nueva base de datos — el mapeo de arriba se aplica una sola vez, en tus queries, y ambos sistemas coexisten mientras lo haces.`]}),`\n`]}),`\n`,_jsx(Heading,{level:`2`,id:`ruta-de-migración-sugerida`,children:`Ruta de migración sugerida`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsxs(_components.li,{children:[`Apunta una copia de tu dashboard/reporte a `,_jsx(_components.code,{children:`treble_client_analytics`}),` usando el mapeo de arriba.`]}),`\n`,_jsx(_components.li,{children:`Ejecuta ambas versiones en paralelo durante unos días; espera coincidencias exactas en los días consolidados.`}),`\n`,_jsx(_components.li,{children:`Haz el cambio definitivo, manteniendo filtros de fecha explícitos.`}),`\n`,_jsxs(_components.li,{children:[`Avísale a tu Account Manager cuando ya no uses `,_jsx(_components.code,{children:`client_analytics`}),` — nos ayuda a programar la baja definitiva.`]}),`\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":"Guía de Migración","description":"Migra tus queries del Data Warehouse legacy (client_analytics) al Analytics Warehouse.","sidebarTitle":"Guía de Migración","href":"/es/docs/data-warehouse-v2/migration-guide"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Migrar desde el Data Warehouse legacy","slug":"migrar-desde-el-data-warehouse-legacy","depth":1,"children":[]},{"title":"Mapeo de tablas","slug":"mapeo-de-tablas","depth":2,"children":[]},{"title":"Renombres de columnas a tener en cuenta","slug":"renombres-de-columnas-a-tener-en-cuenta","depth":2,"children":[]},{"title":"Diferencias de comportamiento que debes conocer","slug":"diferencias-de-comportamiento-que-debes-conocer","depth":2,"children":[]},{"title":"Ruta de migración sugerida","slug":"ruta-de-migración-sugerida","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/_mintlify/custom/trebleai/e8b64c48fcecfaa0/script.js"],"subdomain":"trebleai","siteName":"Home","title":"Guía de Migración - Home","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"es":{"href":"/es/docs/data-warehouse-v2/migration-guide","matchLevel":0},"en":{"href":"/en/docs/data-warehouse-v2/migration-guide","matchLevel":1},"pt":{"href":"/pt/docs/data-warehouse-v2/migration-guide","matchLevel":1}}},"lastModified":"2026-11-12T17:19:31.387Z","originalFileLocation":"es/docs/data-warehouse-v2/migration-guide.mdx","locale":"es"},"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=\"Migra tus queries del Data Warehouse legacy (client_analytics) al 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=\"Guía de Migración - Home\">\u003cmeta data-mint-head property=\"og:description\" content=\"Migra tus queries del Data Warehouse legacy (client_analytics) al Analytics Warehouse.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Home\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://help.treble.ai/es/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=Uso+del+Warehouse\u0026amp;title=Gu%C3%ADa+de+Migraci%C3%B3n\u0026amp;description=Migra+tus+queries+del+Data+Warehouse+legacy+%28client_analytics%29+al+Analytics+Warehouse.\u0026amp;theme=6e15641089328b2149afcee8\u0026amp;signature=e16187850c3826dae9946192048d483f4f5c9f15e087408797ac3e6506204725\">\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=\"Guía de Migración - Home\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Migra tus queries del Data Warehouse legacy (client_analytics) al Analytics Warehouse.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://trebleai.mintlify.site/_mintlify/api/og/v2?division=Uso+del+Warehouse\u0026amp;title=Gu%C3%ADa+de+Migraci%C3%B3n\u0026amp;description=Migra+tus+queries+del+Data+Warehouse+legacy+%28client_analytics%29+al+Analytics+Warehouse.\u0026amp;theme=6e15641089328b2149afcee8\u0026amp;signature=e16187850c3826dae9946192048d483f4f5c9f15e087408797ac3e6506204725\">\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/es/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=\"/es/docs/data-warehouse-v2/migration-guide.md\">\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=\"en\" href=\"https://help.treble.ai/en/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/es/docs/data-warehouse-v2/migration-guide#webpage\",\"url\":\"https://help.treble.ai/es/docs/data-warehouse-v2/migration-guide\",\"name\":\"Guía de Migración\",\"description\":\"Migra tus queries del Data Warehouse legacy (client_analytics) al Analytics Warehouse.\",\"dateModified\":\"2026-11-12T17:19:31.387Z\",\"isPartOf\":{\"@id\":\"https://help.treble.ai#website\"},\"breadcrumb\":{\"@id\":\"https://help.treble.ai/es/docs/data-warehouse-v2/migration-guide#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://help.treble.ai/es/docs/data-warehouse-v2/migration-guide#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Analytics Warehouse\",\"item\":\"https://help.treble.ai/es/docs/data-warehouse-v2/welcome\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Guía de Migración\",\"item\":\"https://help.treble.ai/es/docs/data-warehouse-v2/migration-guide\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://help.treble.ai/es/docs/data-warehouse-v2/migration-guide#article\",\"headline\":\"Guía de Migración\",\"name\":\"Guía de Migración\",\"description\":\"Migra tus queries del Data Warehouse legacy (client_analytics) al Analytics Warehouse.\",\"url\":\"https://help.treble.ai/es/docs/data-warehouse-v2/migration-guide\",\"mainEntityOfPage\":{\"@id\":\"https://help.treble.ai/es/docs/data-warehouse-v2/migration-guide#webpage\"},\"dateModified\":\"2026-11-12T17:19:31.387Z\",\"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":"/es/docs/data-warehouse-v2/migration-guide.md","siteName":"Home","nav":{"global":null,"languages":[{"language":"es","default":true,"anchors":[{"anchor":"Documentación","icon":"book-open","tabs":[{"tab":"Bienvenido","pages":[{"title":"Bienvenido","href":"/es/home"}]},{"tab":"Guía de usuario","groups":[{"group":"Empezar","pages":[{"title":"Bienvenido a Treble","sidebarTitle":"Descripción General","href":"/es/docs/welcome"},{"title":"Conceptos Clave","href":"/es/docs/key-concepts"},{"group":"Introducción a Treble","pages":[{"title":"Empezar","href":"/es/docs/intro-to-treble/welcome"},{"title":"Conversación Outbound","href":"/es/docs/intro-to-treble/outbound-convo"},{"title":"Conversación Inbound","href":"/es/docs/intro-to-treble/inbound-convo"},{"title":"Tutorial: Primera Conversación Transferida a un Agente","href":"/es/docs/intro-to-treble/first-agent-convo"}]}]},{"group":"Meta","pages":[{"title":"Meta y Treble","href":"/es/docs/meta/overview"},{"title":"WhatsApp, WhatsApp Business y WhatsApp Business API","href":"/es/docs/meta/wa-wabiz-api"},{"group":"Conectar línea de WhatsApp","pages":[{"title":"Conectar Linea de WhatsApp","sidebarTitle":"Empezar","href":"/es/docs/meta/guide/welcome"},{"title":"Preparar tu sitio web","href":"/es/docs/meta/guide/preparing-website"},{"title":"Portafolio comercial de Meta","href":"/es/docs/meta/guide/business-manager"},{"title":"Verificación de Meta","href":"/es/docs/meta/guide/meta-verification"},{"title":"Número de WhatsApp","href":"/es/docs/meta/guide/whatsapp-number"}]},{"group":"Plantillas de mensajes","pages":[{"title":"Plantillas","href":"/es/docs/meta/hsm-templates/intro"},{"title":"Plantillas de utilidad","href":"/es/docs/meta/hsm-templates/utility"},{"title":"Plantillas de Carrusel","href":"/es/docs/meta/hsm-templates/carousel"}]},{"title":"Green Check Linea de WhatsApp","href":"/es/docs/meta/green-check"},{"title":"Salud de la Línea de WhatsApp","href":"/es/docs/meta/whatsapp-line-health"},{"title":"Políticas de la Plataforma de WhatsApp Business","href":"/es/docs/meta/waba-policies"},{"title":"Nombres de usuario de WhatsApp y BSUID (Business-Scoped User ID)","href":"/es/docs/meta/usernames-and-bsuid"},{"group":"Errores de WhatsApp","pages":[{"title":"Failure by unable to contact en WhatsApp","href":"/es/docs/meta/error-descriptions/failure-by-unable-to-contact"},{"title":"Failure by payment issue en WhatsApp","href":"/es/docs/meta/error-descriptions/failure-by-payment-issue"}]}]},{"group":"Construye con Treble","pages":[{"title":"Objetivo de tu Campaña","href":"/es/docs/build-with-treble/welcome"},{"group":"Funcionalidades","pages":[{"title":"Variables","href":"/es/docs/build-with-treble/features/variables"},{"title":"Variables Nativas","href":"/es/docs/build-with-treble/features/native-variables"},{"title":"Flujo Alterno","href":"/es/docs/build-with-treble/features/alternate-flow"},{"title":"Segunda plantilla","href":"/es/docs/build-with-treble/features/second-hsm"},{"title":"Bloque de Objetivo","href":"/es/docs/build-with-treble/features/goal-block"},{"title":"Imágenes, documentos y videos en tus bloques de mensaje","href":"/es/docs/build-with-treble/features/media"}]},{"group":"Bloques","pages":[{"title":"Pruebas A/B","href":"/es/docs/build-with-treble/blocks/ab-test"},{"group":"Métodos de transferencia","pages":[{"title":"Métodos de transferencia","href":"/es/docs/build-with-treble/blocks/transfer-methods/overview"},{"title":"Métodos de Treble","href":"/es/docs/build-with-treble/blocks/transfer-methods/treble"},{"title":"Métodos de HubSpot","href":"/es/docs/build-with-treble/blocks/transfer-methods/hubspot"},{"title":"Asignación por API","href":"/es/docs/build-with-treble/blocks/transfer-methods/api"}]},{"title":"Transferencia a agente","href":"/es/docs/build-with-treble/blocks/agent"},{"title":"WhatsApp Flows","href":"/es/docs/build-with-treble/blocks/whatsapp-flows"},{"title":"📣 Eventos de Meta — Mide lo que realmente importa","sidebarTitle":"Eventos de Meta","href":"/es/docs/build-with-treble/blocks/meta-events"},{"title":"Bloques de mensaje - Botones, Lista Interactiva, Simple y con Opciones","href":"/es/docs/build-with-treble/blocks/message-blocks"},{"title":"Bloque Condicional","href":"/es/docs/build-with-treble/blocks/conditional"},{"title":"Bloque Enlace a Conversación","href":"/es/docs/build-with-treble/blocks/jump-to-conversation"}]},{"group":"Guías","pages":[{"title":"Configuración de horarios y condiciones de tiempo","href":"/es/docs/build-with-treble/guides/schedules-and-time-configuration"},{"title":"Cómo medir el rendimiento de tus enlaces","href":"/es/docs/build-with-treble/guides/measure-links"}]}]},{"group":"Plataforma Principal","pages":[{"title":"Entendiendo la plataforma principal","sidebarTitle":"Descripción General","href":"/es/docs/main-platform/welcome"},{"title":"Editor de Flujos de Conversación","href":"/es/docs/main-platform/conversation-editor"},{"title":"Enviar Conversación Outbound","href":"/es/docs/main-platform/send-convo"},{"title":"Contactos","href":"/es/docs/main-platform/contacts"},{"title":"Acortador de links de Treble","href":"/es/docs/main-platform/link-shortener"},{"group":"Agentes de IA","pages":[{"title":"Introducción","href":"/es/docs/main-platform/ai-center/overview"},{"title":"Crea un agente","href":"/es/docs/main-platform/ai-center/create-agent"},{"title":"Configura tu agente","href":"/es/docs/main-platform/ai-center/configure-agent"},{"title":"Prueba tu agente","href":"/es/docs/main-platform/ai-center/playground"},{"title":"Base de conocimientos","href":"/es/docs/main-platform/ai-center/knowledge-base"},{"group":"Agentes","pages":[{"group":"Agente de IA","pages":[{"title":"Introducción","href":"/es/docs/main-platform/ai-center/agents/ai-agent/overview"},{"title":"Herramienta de llamada a API","href":"/es/docs/main-platform/ai-center/agents/ai-agent/api-tool"},{"title":"Integración con Google Calendar","href":"/es/docs/main-platform/ai-center/agents/ai-agent/google-calendar"},{"title":"Configurar la integración con Shopify","href":"/es/docs/main-platform/ai-center/agents/ai-agent/shopify-install"},{"title":"Cómo usar Shopify en tus conversaciones","href":"/es/docs/main-platform/ai-center/agents/ai-agent/shopify-usage"}]},{"group":"Agentes heredados","pages":[{"title":"Logra un objetivo concreto","href":"/es/docs/main-platform/ai-center/agents/objective-ai"},{"title":"Califica clientes potenciales","href":"/es/docs/main-platform/ai-center/agents/lead-qualification"}]}]}]},{"group":"Métricas","pages":[{"title":"Métricas","sidebarTitle":"Introducción","href":"/es/docs/main-platform/metrics/overview"},{"title":"Salientes","href":"/es/docs/main-platform/metrics/outbound"},{"title":"Entrantes","href":"/es/docs/main-platform/metrics/inbound"},{"title":"Agentes","href":"/es/docs/main-platform/metrics/agents"}]},{"title":"Métricas de conversación","href":"/es/docs/main-platform/conversation-metrics"},{"title":"Links de WhatsApp","href":"/es/docs/main-platform/whatsapp-links"},{"title":"Centro de métricas","sidebarTitle":"Centro de métricas","href":"/es/docs/main-platform/analytics-center"},{"title":"Sección de Configuración","href":"/es/docs/main-platform/settings"},{"title":"Base de conocimiento","href":"/es/docs/main-platform/knowledge-base"}]},{"group":"Plataforma de Agentes","pages":[{"title":"Entendiendo la plataforma de Agentes","sidebarTitle":"Descripción General","href":"/es/docs/agent-platform/welcome"},{"title":"Vista Principal","href":"/es/docs/agent-platform/main-platform"},{"title":"Sección de contactos","href":"/es/docs/agent-platform/contacts"},{"group":"Administrador","pages":[{"title":"Sección de Administrador","href":"/es/docs/agent-platform/admin/admin-section"},{"title":"Métricas","href":"/es/docs/agent-platform/admin/metrics"},{"title":"Agentes","href":"/es/docs/agent-platform/admin/agents"},{"title":"Equipos de Agentes","href":"/es/docs/agent-platform/admin/tags-teams"},{"title":"Plantillas de Respuestas Rápidas","href":"/es/docs/agent-platform/admin/quick-responses"},{"title":"IA - Asistentes Inteligentes","href":"/es/docs/agent-platform/admin/treble-boost"},{"title":"Configuración","href":"/es/docs/agent-platform/admin/configuration"},{"title":"Recomendaciones y preguntas frecuentes","href":"/es/docs/agent-platform/admin/tips-and-questions"}]},{"title":"Aplicación Móvil para Agentes","href":"/es/docs/agent-platform/mobile-app"},{"title":"Cómo ordenar y filtrar conversaciones","href":"/es/docs/agent-platform/filters"},{"title":"Configuración de Notificaciones Push","href":"/es/docs/agent-platform/notifications"},{"title":"Detección automática de inactividad","href":"/es/docs/agent-platform/inactivity"},{"title":"Automatizaciones de SLA","href":"/es/docs/agent-platform/sla-automations"}]},{"group":"Integraciones","pages":[{"title":"Integraciones","href":"/es/docs/integrations/welcome"},{"group":"HubSpot","pages":[{"title":"Integración con HubSpot","href":"/es/docs/integrations/hubspot/welcome"},{"title":"Instalar Treble en HubSpot","href":"/es/docs/integrations/hubspot/install"},{"title":"Instalar la Extensión de Chrome","href":"/es/docs/integrations/hubspot/chrome-extension"},{"title":"Primeros Pasos","href":"/es/docs/integrations/hubspot/getting-started"},{"group":"Funcionalidades","pages":[{"title":"Workflows","href":"/es/docs/integrations/hubspot/features/workflows"},{"title":"Variables","href":"/es/docs/integrations/hubspot/features/variables"},{"title":"Propiedades de HubSpot en Treble","href":"/es/docs/integrations/hubspot/features/properties"},{"title":"Desplegar Conversación desde Perfil de Contacto","href":"/es/docs/integrations/hubspot/features/deploy"},{"title":"Historial de Chat en HubSpot como Notas","href":"/es/docs/integrations/hubspot/features/chat-history"},{"title":"Actividades de HubSpot","href":"/es/docs/integrations/hubspot/features/activities"}]},{"group":"Bloques","pages":[{"title":"Bloque de Acción en CRM","href":"/es/docs/integrations/hubspot/blocks/crm-action"},{"title":"Bloque Objeto CRM","href":"/es/docs/integrations/hubspot/blocks/crm-variable-assignment"},{"title":"Bloque de Ticket","href":"/es/docs/integrations/hubspot/blocks/ticket"},{"title":"Bloque Condicional","href":"/es/docs/integrations/hubspot/blocks/conditional"}]},{"group":"HubSpot + AI","pages":[{"title":"Integración de HubSpot con IA","href":"/es/docs/integrations/hubspot/hubspot-ai/welcome"},{"title":"Instalación de la integración de HubSpot con IA","href":"/es/docs/integrations/hubspot/hubspot-ai/installation"},{"title":"Funcionalidades de la integración de HubSpot con IA","href":"/es/docs/integrations/hubspot/hubspot-ai/features"},{"title":"Ejemplos de uso de la integración de HubSpot con IA","href":"/es/docs/integrations/hubspot/hubspot-ai/examples"}]}]},{"group":"Salesforce","pages":[{"title":"Integración con Salesforce","href":"/es/docs/integrations/salesforce/welcome"},{"title":"Instalar Treble en Salesforce","href":"/es/docs/integrations/salesforce/install"},{"title":"Sincronizar objetos de Salesforce","href":"/es/docs/integrations/salesforce/object-sync"},{"group":"Bloques","pages":[{"title":"Bloque de Acción en CRM","href":"/es/docs/integrations/salesforce/blocks/crm-action"},{"title":"Bloque de lectura de Salesforce","href":"/es/docs/integrations/salesforce/blocks/crm-variable-assignment"},{"title":"Transferir a un asesor desde Salesforce","href":"/es/docs/integrations/salesforce/blocks/human-transfer"}]},{"group":"Funcionalidades","pages":[{"title":"Historial de conversación en el CRM","href":"/es/docs/integrations/salesforce/features/activities"},{"title":"Objeto personalizado de conversaciones","href":"/es/docs/integrations/salesforce/features/custom-object"},{"title":"Tipos de registro (Record Types)","href":"/es/docs/integrations/salesforce/features/record-types"},{"title":"Person Accounts","href":"/es/docs/integrations/salesforce/features/person-accounts"},{"title":"Contactos de Salesforce en Sales","href":"/es/docs/integrations/salesforce/features/sales-view"},{"title":"Configuraciones avanzadas","href":"/es/docs/integrations/salesforce/features/advanced-settings"}]},{"group":"Treble dentro de Salesforce","pages":[{"title":"WhatsApp dentro de Salesforce","href":"/es/docs/integrations/salesforce/embed/custom-tab"},{"title":"Lanzar conversaciones desde un Flow","href":"/es/docs/integrations/salesforce/embed/automation-flow-package"},{"title":"Marketing Cloud","href":"/es/docs/integrations/salesforce/embed/marketing-cloud"}]},{"group":"Salesforce AI","pages":[{"title":"Integración con Salesforce AI","href":"/es/docs/integrations/salesforce/salesforce-ai/welcome"},{"title":"Instalación de la integración con Salesforce AI","href":"/es/docs/integrations/salesforce/salesforce-ai/installation"},{"title":"Funcionalidades de la integración con Salesforce AI","href":"/es/docs/integrations/salesforce/salesforce-ai/features"},{"title":"Ejemplos de uso de la integración con Salesforce AI","href":"/es/docs/integrations/salesforce/salesforce-ai/examples"}]}]},{"group":"Sheets","pages":[{"title":"Integración de Treble.ai con Google Sheets","href":"/es/docs/integrations/sheets/welcome"},{"title":"Preguntas Frecuentes","href":"/es/docs/integrations/sheets/faq"}]},{"group":"Zoho","pages":[{"title":"Integración con Zoho","href":"/es/docs/integrations/zoho/welcome"},{"title":"Instalación de la integración con Zoho","href":"/es/docs/integrations/zoho/installation"},{"title":"Funcionalidades de la integración con Zoho","href":"/es/docs/integrations/zoho/features"},{"title":"Ejemplos de uso de la integración con Zoho","href":"/es/docs/integrations/zoho/examples"}]},{"group":"Pipedrive","pages":[{"title":"Integración con Pipedrive","href":"/es/docs/integrations/pipedrive/welcome"},{"title":"Instalación de la integración con Pipedrive","href":"/es/docs/integrations/pipedrive/installation"},{"title":"Funcionalidades de la integración con Pipedrive","href":"/es/docs/integrations/pipedrive/features"},{"title":"Ejemplos de uso de la integración con Pipedrive","href":"/es/docs/integrations/pipedrive/examples"}]},{"group":"Active Campaign","pages":[{"title":"Integración con Active Campaign","href":"/es/docs/integrations/activecampaign/welcome"},{"title":"Instalación de la integración con Active Campaign","href":"/es/docs/integrations/activecampaign/installation"},{"title":"Funcionalidades de la integración con Active Campaign","href":"/es/docs/integrations/activecampaign/features"},{"title":"Ejemplos de uso de la integración con Active Campaign","href":"/es/docs/integrations/activecampaign/examples"}]}]},{"group":"Analytics Warehouse","pages":[{"title":"Analytics Warehouse","description":"Consulta tus datos de Treble casi en tiempo real con SQL — historia completa, mayor detalle y un contrato de nombres estable.","sidebarTitle":"Introducción","href":"/es/docs/data-warehouse-v2/welcome"},{"group":"Uso del Warehouse","pages":[{"title":"Guía de Migración","sidebarTitle":"Guía de Migración","href":"/es/docs/data-warehouse-v2/migration-guide"},{"title":"Sincronización Incremental","description":"Mantén una copia de tus datos de Treble en tus propios sistemas, de forma confiable, usando el watermark synced_at.","sidebarTitle":"Sincronización Incremental","href":"/es/docs/data-warehouse-v2/incremental-sync"},{"title":"Optimización de Consultas","sidebarTitle":"Optimización","href":"/es/docs/data-warehouse-v2/query-optimization"}]},{"group":"Flujos de Conversación","pages":[{"title":"fact_treble_sessions","sidebarTitle":"Sesiones","href":"/es/docs/data-warehouse-v2/fact-treble-sessions"},{"title":"fact_treble_session_messages","sidebarTitle":"Mensajes","href":"/es/docs/data-warehouse-v2/fact-treble-session-messages"},{"title":"fact_treble_session_nodes","sidebarTitle":"Recorridos","href":"/es/docs/data-warehouse-v2/fact-treble-session-nodes"},{"title":"fact_treble_session_variables","sidebarTitle":"Variables","href":"/es/docs/data-warehouse-v2/fact-treble-session-variables"}]},{"group":"Campañas","pages":[{"title":"fact_campaign_sends","sidebarTitle":"Envíos","href":"/es/docs/data-warehouse-v2/fact-campaign-sends"},{"title":"fact_campaign_daily","sidebarTitle":"Resumen Diario","href":"/es/docs/data-warehouse-v2/fact-campaign-daily"},{"title":"fact_hsm_responses","sidebarTitle":"Respuestas a Plantillas","href":"/es/docs/data-warehouse-v2/fact-hsm-responses"}]},{"group":"Espacio de Agentes","pages":[{"title":"fact_agent_conversations","sidebarTitle":"Conversaciones","href":"/es/docs/data-warehouse-v2/fact-agent-conversations"},{"title":"fact_agent_conversation_messages","sidebarTitle":"Mensajes","href":"/es/docs/data-warehouse-v2/fact-agent-conversation-messages"},{"title":"fact_agent_conversation_transfers","sidebarTitle":"Transferencias","href":"/es/docs/data-warehouse-v2/fact-agent-conversation-transfers"},{"title":"fact_agent_status_changes","sidebarTitle":"Disponibilidad","href":"/es/docs/data-warehouse-v2/fact-agent-status-changes"},{"title":"fact_agent_daily","sidebarTitle":"Resumen Diario","href":"/es/docs/data-warehouse-v2/fact-agent-daily"}]},{"group":"Conversiones y Atribución","pages":[{"title":"fact_target_events","sidebarTitle":"Eventos Objetivo","href":"/es/docs/data-warehouse-v2/fact-target-events"},{"title":"fact_ad_sessions","sidebarTitle":"Meta Ads (CTWA)","href":"/es/docs/data-warehouse-v2/fact-ad-sessions"},{"title":"fact_whatsapp_link_events","sidebarTitle":"Links de WhatsApp","href":"/es/docs/data-warehouse-v2/fact-whatsapp-link-events"}]},{"title":"Dimensiones","sidebarTitle":"Dimensiones","href":"/es/docs/data-warehouse-v2/dimensions"}]},{"group":"Data Warehouse (Legacy)","pages":[{"title":"Data Warehouse (Legacy)","sidebarTitle":"Introducción","href":"/es/docs/data-warehouse/welcome"},{"title":"fact_conversations","sidebarTitle":"Conversaciones","href":"/es/docs/data-warehouse/fact-conversations"},{"title":"fact_agent_messages","sidebarTitle":"Mensajes","href":"/es/docs/data-warehouse/fact-agent-messages"},{"title":"fact_redirections","sidebarTitle":"Transferencias","href":"/es/docs/data-warehouse/fact-redirections"},{"title":"fact_agent_status_changes","sidebarTitle":"Disponibilidad de Agentes","href":"/es/docs/data-warehouse/fact-agent-status-changes"},{"title":"fact_agent_daily","sidebarTitle":"Productividad por Agente","href":"/es/docs/data-warehouse/fact-agent-daily"},{"title":"fact_sessions","sidebarTitle":"Flujos de Conversación","href":"/es/docs/data-warehouse/fact-sessions"},{"title":"fact_deployment_status","sidebarTitle":"Detalle de Envíos","href":"/es/docs/data-warehouse/fact-deployment-status"},{"title":"fact_deployment_daily","sidebarTitle":"Métricas de Envíos","href":"/es/docs/data-warehouse/fact-deployment-daily"},{"title":"fact_hsm_responses","sidebarTitle":"Respuestas a plantillas","href":"/es/docs/data-warehouse/fact-hsm-responses"},{"title":"Tablas de Dimensiones","sidebarTitle":"Dimensiones","href":"/es/docs/data-warehouse/dimensions"},{"title":"Optimización de Consultas","sidebarTitle":"Optimización","href":"/es/docs/data-warehouse/query-optimization"}]}]},{"tab":"Referencia de API","pages":[{"title":"Referencia de API","href":"/es/api-reference/intro/intro"}]}]},{"anchor":"Comunidad","icon":"slack","href":"https://trebleai.slack.com"},{"anchor":"Blog","icon":"newspaper","href":"https://blog.treble.ai"}]},{"language":"en","pages":[{"title":"en","href":"/en/docs/data-warehouse-v2/migration-guide"}]},{"language":"pt","pages":[{"title":"pt","href":"/pt/docs/data-warehouse-v2/migration-guide"}]}]},"basePath":"","title":"Guía de Migración - Home","deploymentId":"dpl_vSEmv961Ncyvz1psVwgUnTXQMSYk","buildId":"dpl_vSEmv961Ncyvz1psVwgUnTXQMSYk","dynamics":[],"chunks":[]}