{"id":8413,"date":"2022-01-05T18:30:34","date_gmt":"2022-01-05T18:30:34","guid":{"rendered":"https:\/\/help.fromdoppler.com\/es\/?p=8413"},"modified":"2024-06-13T14:57:32","modified_gmt":"2024-06-13T14:57:32","slug":"integracion-doppler-bigquery-tabla-campaign-summary","status":"publish","type":"post","link":"https:\/\/help.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/","title":{"rendered":"Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Summary?"},"content":{"rendered":"<p>\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery para generar <a href=\"https:\/\/help.fromdoppler.com\/es\/integrar-doppler-bigquery\" 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 Summary<\/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 Summary <\/strong>trae la informaci\u00f3n relativa a las<strong> Campa\u00f1as enviadas.<\/strong><\/li>\n<li>La tabla <strong><a href=\"https:\/\/help.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-detail\" target=\"_blank\" rel=\"noopener\">Campaign Detail<\/a><\/strong> contiene datos relativos a la actividad de los <strong>Suscriptores con tus Campa\u00f1as.<\/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-8442\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33-300x240.png\" alt=\"BigQuery tabla Campaign Summary\" width=\"601\" height=\"481\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33-300x240.png 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33-768x615.png 768w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33.png 804w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/p>\n<blockquote><p>En comparaci\u00f3n con la tabla Campaign Detail, 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 Summary qu\u00e9 significan cada uno.<\/p>\n<h3>Significado de los Campos de la tabla Campaign Summary<\/h3>\n<h4>Informaci\u00f3n relativa a Usuarios de Doppler<\/h4>\n<table style=\"border: 1px solid black; border-collapse: collapse;\">\n<tbody>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px;\">\n<p style=\"text-align: center;\"><b>Campo en BigQuery<\/b><\/p>\n<\/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=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px;\">\n<p style=\"text-align: center;\"><b>Qu\u00e9 significa<\/b><\/p>\n<\/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><i><span style=\"font-weight: 400;\"><strong><em>dentificador \u00fanico<\/em><\/strong> que sirve para hacer consultas cruzadas entre tablas.\u00a0<\/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;\">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;\">\n<tbody>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px;\">\n<p style=\"text-align: center;\"><b>Campo en BigQuery<\/b><\/p>\n<\/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=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px;\">\n<p style=\"text-align: center;\"><b>Qu\u00e9 significa<\/b><\/p>\n<\/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 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 el resultado es\u00a0 NULL significa que 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 M\u00e9tricas de Campa\u00f1as<\/h4>\n<table style=\"border: 1px solid black; border-collapse: collapse;\">\n<tbody>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px;\">\n<p style=\"text-align: center;\"><b>Campo en BigQuery<\/b><\/p>\n<\/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=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px;\">\n<p style=\"text-align: center;\"><b>Qu\u00e9 significa<\/b><\/p>\n<\/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;\">open_rate_total<\/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;\">Porcentaje<\/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 dividido Cantidad de Contactos \/ Suscriptores a los que se envi\u00f3 la Campa\u00f1a\u00a0 (total_opens\/sent)<\/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;\">open_rate_unique<\/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;\">Porcentaje<\/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 dividido Cantidad de Contactos \/ Suscriptores a los que se envi\u00f3 la Campa\u00f1a<\/span><\/p>\n<p><span style=\"font-weight: 400;\">(unique_opens\/sent)<\/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;\">click_thru_rate<\/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;\">Porcentaje<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px;\">\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">Cantidad Total de Clics dividido Cantidad de Contactos \/ Suscriptores a los que se envi\u00f3 la Campa\u00f1a<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">(total_clicks\/sent)<\/span><\/p>\n<\/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;\">click_thru_open_rate<\/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;\">Porcentaje<\/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 dividido Cantidad total de Aperturas<\/span><\/p>\n<p><span style=\"font-weight: 400;\">(total_clicks\/total_opens)<\/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;\">bounce_rate<\/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;\">Porcentaje<\/span><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px;\">\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\"> Cantidad total de Rebotes dividido Cantidad de Contactos \/ Suscriptores a los que se envi\u00f3 la Campa\u00f1a<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\">(total_bounces\/sent)<\/span><\/p>\n<\/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;\">\n<tbody>\n<tr>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px;\">\n<p style=\"text-align: left;\"><b>Campo en BigQuery<\/b><\/p>\n<\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px;\"><b>Tipo de Campo<\/b><\/td>\n<td style=\"border-bottom: 1px solid black; border-right: 1px solid black; border-collapse: collapse; padding: 5px;\">\n<p style=\"text-align: center;\"><b>Qu\u00e9 significa<\/b><\/p>\n<\/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>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 Summary de BigQuery.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[583,585,486,11],"tags":[791,789,792,790],"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 Summary? - Doppler Help Center<\/title>\n<meta name=\"description\" content=\"\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery para generar reportes personalizados? Descubre el significado de cada Campo.\" \/>\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 Summary? - Doppler Help Center\" \/>\n<meta property=\"og:description\" content=\"\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery para generar reportes personalizados? Descubre el significado de cada Campo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/help.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/\" \/>\n<meta property=\"og:site_name\" content=\"Doppler Help Center\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-05T18:30:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-13T14:57:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33-300x240.png\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sebastian P\u00e9rsico\" \/>\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=8413#primaryimage\",\"url\":\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33.png\",\"contentUrl\":\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33.png\",\"width\":804,\"height\":644,\"caption\":\"BigQuery tabla Campaign Summary\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8413#webpage\",\"url\":\"https:\/\/help.fromdoppler.com\/es\/?p=8413\",\"name\":\"[:es]Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Summary?[:] - Doppler Help Center\",\"isPartOf\":{\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8413#primaryimage\"},\"datePublished\":\"2022-01-05T18:30:34+00:00\",\"dateModified\":\"2024-06-13T14:57:32+00:00\",\"author\":{\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/6ac8152541360db8d120580da8a47d0e\"},\"description\":\"\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery para generar reportes personalizados? Descubre el significado de cada Campo.\",\"breadcrumb\":{\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8413#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/help.fromdoppler.com\/es\/?p=8413\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8413#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 Summary?\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/6ac8152541360db8d120580da8a47d0e\",\"name\":\"Sebastian P\u00e9rsico\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1dec2cf63ec201930ee6f6f5d8bf27f5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1dec2cf63ec201930ee6f6f5d8bf27f5?s=96&d=mm&r=g\",\"caption\":\"Sebastian P\u00e9rsico\"},\"url\":\"https:\/\/help.fromdoppler.com\/es\/author\/sebastian-persico\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Summary? - Doppler Help Center","description":"\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery para generar reportes personalizados? Descubre el significado de cada Campo.","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 Summary? - Doppler Help Center","og_description":"\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery para generar reportes personalizados? Descubre el significado de cada Campo.","og_url":"https:\/\/help.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/","og_site_name":"Doppler Help Center","article_published_time":"2022-01-05T18:30:34+00:00","article_modified_time":"2024-06-13T14:57:32+00:00","og_image":[{"url":"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33-300x240.png"}],"twitter_card":"summary","twitter_misc":{"Escrito por":"Sebastian P\u00e9rsico","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=8413#primaryimage","url":"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33.png","contentUrl":"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33.png","width":804,"height":644,"caption":"BigQuery tabla Campaign Summary"},{"@type":"WebPage","@id":"https:\/\/help.fromdoppler.com\/es\/?p=8413#webpage","url":"https:\/\/help.fromdoppler.com\/es\/?p=8413","name":"[:es]Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Summary?[:] - Doppler Help Center","isPartOf":{"@id":"https:\/\/help.fromdoppler.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/help.fromdoppler.com\/es\/?p=8413#primaryimage"},"datePublished":"2022-01-05T18:30:34+00:00","dateModified":"2024-06-13T14:57:32+00:00","author":{"@id":"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/6ac8152541360db8d120580da8a47d0e"},"description":"\u00bfQuieres aprovechar la integraci\u00f3n de Doppler y BigQuery para generar reportes personalizados? Descubre el significado de cada Campo.","breadcrumb":{"@id":"https:\/\/help.fromdoppler.com\/es\/?p=8413#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/help.fromdoppler.com\/es\/?p=8413"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/help.fromdoppler.com\/es\/?p=8413#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 Summary?"}]},{"@type":"Person","@id":"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/6ac8152541360db8d120580da8a47d0e","name":"Sebastian P\u00e9rsico","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1dec2cf63ec201930ee6f6f5d8bf27f5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1dec2cf63ec201930ee6f6f5d8bf27f5?s=96&d=mm&r=g","caption":"Sebastian P\u00e9rsico"},"url":"https:\/\/help.fromdoppler.com\/es\/author\/sebastian-persico\/"}]}},"_links":{"self":[{"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/posts\/8413"}],"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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/comments?post=8413"}],"version-history":[{"count":18,"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/posts\/8413\/revisions"}],"predecessor-version":[{"id":9011,"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/posts\/8413\/revisions\/9011"}],"wp:attachment":[{"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/media?parent=8413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/categories?post=8413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.fromdoppler.com\/es\/wp-json\/wp\/v2\/tags?post=8413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}