{"id":8426,"date":"2022-01-05T18:31:48","date_gmt":"2022-01-05T18:31:48","guid":{"rendered":"https:\/\/help.fromdoppler.com\/es\/?p=8426"},"modified":"2024-06-13T14:57:10","modified_gmt":"2024-06-13T14:57:10","slug":"integracion-doppler-bigquery-tabla-campaign-detail","status":"publish","type":"post","link":"https:\/\/help.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-detail\/","title":{"rendered":"Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Detail?"},"content":{"rendered":"<p>\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery para generar <a href=\"https:\/\/help.fromdoppler.com\/es\/integrar-doppler-bigquery#data-studio\" target=\"_blank\" rel=\"noopener\">reportes personalizados<\/a>? En este art\u00edculo encontrar\u00e1s el <strong>significado de cada Campo de informaci\u00f3n<\/strong> <strong>de la tabla Campaign Detail <\/strong>de BigQuery. Esto te ayudar\u00e1 a <strong>comprender mejor los datos y resultados<\/strong> de tus reportes.<\/p>\n<h2>Integraci\u00f3n Doppler y BigQuery: consideraciones sobre las tablas de datos<\/h2>\n<p>Actualmente el <a href=\"https:\/\/console.cloud.google.com\/bigquery?project=doppler-291113\" target=\"_blank\" rel=\"noopener\">proyecto Doppler en BigQuery<\/a> tiene tres tablas de las cuales se puede consumir informaci\u00f3n para generar reportes:<\/p>\n<ul>\n<li>La tabla<strong> Campaign Detail <\/strong>contiene datos relativos a la actividad de los <strong>Suscriptores que recibieron tus Campa\u00f1as.<\/strong><\/li>\n<li>La tabla <strong><a href=\"https:\/\/help.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\" target=\"_blank\" rel=\"noopener\">Campaign Summary<\/a><\/strong> trae la informaci\u00f3n relativa a las<strong> Campa\u00f1as enviadas.<\/strong><\/li>\n<li>La tabla <strong>Subscriber<\/strong> tiene informaci\u00f3n relativa a <strong>cada Suscriptor.<\/strong><\/li>\n<\/ul>\n<p><img class=\"aligncenter wp-image-8437\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_31-300x212.png\" alt=\"Big Query tabla Campaign Detail\" width=\"600\" height=\"424\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_31-300x212.png 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_31-768x543.png 768w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_31.png 840w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/p>\n<blockquote><p>Una aclaraci\u00f3n importante: la tabla <strong>Campaign Detail<\/strong> contiene grandes vol\u00famenes de informaci\u00f3n, lo que la vuelve <strong>m\u00e1s pesada.<\/strong> En comparaci\u00f3n, los datos de la tabla <strong>Campaign Summary<\/strong> son menores, por lo que es <strong>m\u00e1s liviana.<\/strong><\/p><\/blockquote>\n<p>Ahora veamos los Campos de informaci\u00f3n de la tabla Campaign Detail y qu\u00e9 significan cada uno.<\/p>\n<h3>Significado de los Campos de la tabla Campaign Detail<\/h3>\n<h4>Informaci\u00f3n relativa a Usuarios de Doppler<\/h4>\n<table style=\"border: 1px solid black; border-collapse: collapse; height: 162px;\" width=\"973\">\n<tbody>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><b>Campo en BigQuery<\/b><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><b>Tipo de Campo<\/b><\/td>\n<td style=\"text-align: center; border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px 5px;\"><b>Qu\u00e9 significa<\/b><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">IdUser<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">N\u00famerico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">UserId del usuario de Doppler. <strong><em>I<\/em><\/strong><\/span><em><span style=\"font-weight: 400;\"><strong>dentificador \u00fanico<\/strong> que<\/span><span style=\"font-weight: 400;\"> sirve para hacer consultas cruzadas entre tablas.\u00a0<\/span><\/em><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">User<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Texto<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Nombre de usuario de la cuenta de Doppler (Email)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Informaci\u00f3n relativa a Campa\u00f1as<\/h4>\n<table style=\"border: 1px solid black; border-collapse: collapse; height: 590px;\" width=\"970\">\n<tbody>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><b>Campo en BigQuery<\/b><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><b>Tipo de Campo<\/b><\/td>\n<td style=\"text-align: center; border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px 5px;\"><b>Qu\u00e9 significa<\/b><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">IdCampaign<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\"><strong>Identificador \u00fanico<\/strong> de la Campa\u00f1a<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Campaign<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Texto<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Nombre de la Campa\u00f1a<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Subject<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Texto<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Asunto de la Campa\u00f1a<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Header<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Texto<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Pre-encabezado de la Campa\u00f1a<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">FromEmail<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Texto\u00a0<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Remitente de la Campa\u00f1a (Email)<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">UTCSentDate<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Fecha y hora<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Fecha de env\u00edo de la Campa\u00f1a<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">IdAutomation*<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\"><strong>Identificador \u00fanico<\/strong> que agrupa las Campa\u00f1as dentro de un Flujo de Automation\u00a0<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">AutomationName<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Texto<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\">Tipo de Flujo de Automation<\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">IdParentCampaign<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\"><strong>Identificador \u00fanico<\/strong> que indica de qu\u00e9 Campa\u00f1a es r\u00e9plica. <\/span><i><span style=\"font-weight: 400;\">Si es NULL no hay r\u00e9plica.<\/span><\/i><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">IdTestAB<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\"><strong>Identificador \u00fanico<\/strong> que agrupa las Campa\u00f1as Test A\/B: Env\u00edo A, Env\u00edo B y Env\u00edo Ganador\u00a0<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">CampaignType<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Texto<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Campa\u00f1a Cl\u00e1sica o Social<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">CampaignSubType<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Texto<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Campa\u00f1a Cl\u00e1sica, Automation, Env\u00edo Inteligente, Test A\/B<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">ViewOnlineURL<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Texto<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Link a versi\u00f3n online de la Campa\u00f1a<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><em>*Si anteriormente utilizabas el campo IdScheduledTask en tus reportes, deber\u00e1s actualizarlo.<\/em><\/p>\n<h4>Informaci\u00f3n relativa a Suscriptores<\/h4>\n<table style=\"border: 1px solid black; border-collapse: collapse; height: 120px;\" width=\"630\">\n<tbody>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><b>Campo en BigQuery<\/b><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><b>Tipo de Campo<\/b><\/td>\n<td style=\"text-align: center; border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px 5px;\"><b>Qu\u00e9 significa<\/b><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">IdSubscriber<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\"><strong>Identificador \u00fanico<\/strong> del Suscriptor\u00a0<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Email<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Texto<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Email del Contacto (Suscriptor)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Informaci\u00f3n relativa a M\u00e9tricas de Campa\u00f1as<\/h4>\n<table style=\"border: 1px solid black; border-collapse: collapse; height: 465px;\" width=\"841\">\n<tbody>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><b>Campo en BigQuery<\/b><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><b>Tipo de Campo<\/b><\/td>\n<td style=\"text-align: center; border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px 5px;\"><b>Qu\u00e9 significa<\/b><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">sent<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Cantidad de Contactos (Suscriptores) a los que se envi\u00f3 la Campa\u00f1a<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">delivered<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Cantidad de Contactos (Suscriptores) a los que se entreg\u00f3 la Campa\u00f1a<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">total_opens<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Cantidad Total de Aperturas<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">unique_opens<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Cantidad de Aperturas \u00fanicas\u00a0<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">unopened<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Cantidad de No Abiertos<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">total_clicks<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Cantidad Total de Clics<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">unique_clicks<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Cantidad de Clics \u00fanicos<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">unsubscriptions<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Cantidad de desuscripciones<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">hard_bounces<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Cantidad de Rebotes Hard<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">soft_bounces<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Cantidad de Rebotes Soft<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">total_bounces<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Num\u00e9rico<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Cantidad Total de Rebotes<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">last_click<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Fecha y hora<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Fecha \u00faltimo clic registrado en la Campa\u00f1a<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Otra informaci\u00f3n<\/h4>\n<table style=\"border: 1px solid black; border-collapse: collapse; height: 71px;\" width=\"717\">\n<tbody>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><b>Campo en BigQuery<\/b><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><b>Tipo de Campo<\/b><\/td>\n<td style=\"text-align: center; border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px 5px;\"><b>Qu\u00e9 significa<\/b><\/td>\n<\/tr>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">last_modified_time<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Fecha y hora<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px; text-align: center;\"><span style=\"font-weight: 400;\">Fecha \u00faltima sincronizaci\u00f3n entre Doppler y BigQuery<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>IMPORTANTE<\/strong>: Luego de realizar la conexi\u00f3n entre Doppler y BigQuery debes esperar al menos 24 horas para que la informaci\u00f3n de la tabla est\u00e9 disponible.<\/p>\n<p>Esperamos que esta informaci\u00f3n te resulte \u00fatil para interpretar mejor las m\u00e9tricas de tus reportes.<\/p>\n<p><strong>Eso fue todo. \u00a1Que disfrutes la integraci\u00f3n de Doppler y BigQuery!<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery para generar reportes personalizados en Google Data Studio? En este art\u00edculo encontrar\u00e1s el significado de cada Campo de informaci\u00f3n de la tabla Campaign Detail de BigQuery.<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[583,585,486,11],"tags":[793,789,795,794],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Detail? - Doppler Help Center<\/title>\n<meta name=\"description\" content=\"\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery? Descubre el significado de cada Campo de la tabla Campaign Detail.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Detail? - Doppler Help Center\" \/>\n<meta property=\"og:description\" content=\"\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery? Descubre el significado de cada Campo de la tabla Campaign Detail.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/help.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-detail\/\" \/>\n<meta property=\"og:site_name\" content=\"Doppler Help Center\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-05T18:31:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-13T14:57:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_31-300x212.png\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Noelia Rosemberg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#website\",\"url\":\"https:\/\/help.fromdoppler.com\/es\/\",\"name\":\"Doppler Help Center\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/help.fromdoppler.com\/es\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"es\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8426#primaryimage\",\"url\":\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_31.png\",\"contentUrl\":\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_31.png\",\"width\":840,\"height\":594,\"caption\":\"Big Query tabla Campaign Detail\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8426#webpage\",\"url\":\"https:\/\/help.fromdoppler.com\/es\/?p=8426\",\"name\":\"[:es]Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Detail?[:] - Doppler Help Center\",\"isPartOf\":{\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8426#primaryimage\"},\"datePublished\":\"2022-01-05T18:31:48+00:00\",\"dateModified\":\"2024-06-13T14:57:10+00:00\",\"author\":{\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/f559471be2364aba583598a0be7fef89\"},\"description\":\"\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery? Descubre el significado de cada Campo de la tabla Campaign Detail.\",\"breadcrumb\":{\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8426#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/help.fromdoppler.com\/es\/?p=8426\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8426#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/help.fromdoppler.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Detail?\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/f559471be2364aba583598a0be7fef89\",\"name\":\"Noelia Rosemberg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f2e376ea187567ba08f332dd83b76c47?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f2e376ea187567ba08f332dd83b76c47?s=96&d=mm&r=g\",\"caption\":\"Noelia Rosemberg\"},\"sameAs\":[\"http:\/\/www.fromdoppler.com\"],\"url\":\"https:\/\/help.fromdoppler.com\/es\/author\/nrosemberg\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Detail? - Doppler Help Center","description":"\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery? Descubre el significado de cada Campo de la tabla Campaign Detail.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"es_ES","og_type":"article","og_title":"Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Detail? - Doppler Help Center","og_description":"\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery? Descubre el significado de cada Campo de la tabla Campaign Detail.","og_url":"https:\/\/help.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-detail\/","og_site_name":"Doppler Help Center","article_published_time":"2022-01-05T18:31:48+00:00","article_modified_time":"2024-06-13T14:57:10+00:00","og_image":[{"url":"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_31-300x212.png"}],"twitter_card":"summary","twitter_misc":{"Escrito por":"Noelia Rosemberg","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/help.fromdoppler.com\/es\/#website","url":"https:\/\/help.fromdoppler.com\/es\/","name":"Doppler Help Center","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/help.fromdoppler.com\/es\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"es"},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/help.fromdoppler.com\/es\/?p=8426#primaryimage","url":"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_31.png","contentUrl":"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_31.png","width":840,"height":594,"caption":"Big Query tabla Campaign Detail"},{"@type":"WebPage","@id":"https:\/\/help.fromdoppler.com\/es\/?p=8426#webpage","url":"https:\/\/help.fromdoppler.com\/es\/?p=8426","name":"[:es]Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Detail?[:] - Doppler Help Center","isPartOf":{"@id":"https:\/\/help.fromdoppler.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/help.fromdoppler.com\/es\/?p=8426#primaryimage"},"datePublished":"2022-01-05T18:31:48+00:00","dateModified":"2024-06-13T14:57:10+00:00","author":{"@id":"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/f559471be2364aba583598a0be7fef89"},"description":"\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery? Descubre el significado de cada Campo de la tabla Campaign Detail.","breadcrumb":{"@id":"https:\/\/help.fromdoppler.com\/es\/?p=8426#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/help.fromdoppler.com\/es\/?p=8426"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/help.fromdoppler.com\/es\/?p=8426#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/help.fromdoppler.com\/es\/"},{"@type":"ListItem","position":2,"name":"Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Detail?"}]},{"@type":"Person","@id":"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/f559471be2364aba583598a0be7fef89","name":"Noelia Rosemberg","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f2e376ea187567ba08f332dd83b76c47?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f2e376ea187567ba08f332dd83b76c47?s=96&d=mm&r=g","caption":"Noelia Rosemberg"},"sameAs":["http:\/\/www.fromdoppler.com"],"url":"https:\/\/help.fromdoppler.com\/es\/author\/nrosemberg\/"}]}},"_links":{"self":[{"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/posts\/8426"}],"collection":[{"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/comments?post=8426"}],"version-history":[{"count":18,"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/posts\/8426\/revisions"}],"predecessor-version":[{"id":9010,"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/posts\/8426\/revisions\/9010"}],"wp:attachment":[{"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/media?parent=8426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/categories?post=8426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/tags?post=8426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}