{"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:\/\/helpqa.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 decoding=\"async\" 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:\/\/helpqa.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33-300x240.png 300w, https:\/\/helpqa.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33-768x615.png 768w, https:\/\/helpqa.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":{"_acf_changed":false,"footnotes":""},"categories":[583,585,486,11],"tags":[791,789,792,790],"class_list":["post-8413","post","type-post","status-publish","format-standard","hentry","category-destacados-en-integraciones","category-destacados-en-reportes","category-integraciones","category-reportes","tag-fuente-de-datos-doppler-en-bigquery","tag-integracion-doppler-y-bigquery","tag-que-significan-los-campos-en-bigquery","tag-tablas-de-datos-bigquery"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\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:\/\/helpqa.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=\"author\" content=\"Sebastian P\u00e9rsico\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\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\":\"Article\",\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/integracion-doppler-bigquery-tabla-campaign-summary\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/integracion-doppler-bigquery-tabla-campaign-summary\\\/\"},\"author\":{\"name\":\"Sebastian P\u00e9rsico\",\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/en\\\/#\\\/schema\\\/person\\\/6ac8152541360db8d120580da8a47d0e\"},\"headline\":\"Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Summary?\",\"datePublished\":\"2022-01-05T18:30:34+00:00\",\"dateModified\":\"2024-06-13T14:57:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/integracion-doppler-bigquery-tabla-campaign-summary\\\/\"},\"wordCount\":705,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/integracion-doppler-bigquery-tabla-campaign-summary\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/help.fromdoppler.com\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/Screenshot_33-300x240.png\",\"keywords\":[\"fuente de datos doppler en bigquery\",\"integraci\u00f3n doppler y bigquery\",\"que significan los campos en bigquery\",\"tablas de datos bigquery\"],\"articleSection\":[\"Destacados en Integraciones\",\"Destacados en Reportes\",\"Integraciones\",\"Reportes\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/integracion-doppler-bigquery-tabla-campaign-summary\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/integracion-doppler-bigquery-tabla-campaign-summary\\\/\",\"url\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/integracion-doppler-bigquery-tabla-campaign-summary\\\/\",\"name\":\"[:es]Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Summary?[:] - Doppler Help Center\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/integracion-doppler-bigquery-tabla-campaign-summary\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/integracion-doppler-bigquery-tabla-campaign-summary\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/help.fromdoppler.com\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/Screenshot_33-300x240.png\",\"datePublished\":\"2022-01-05T18:30:34+00:00\",\"dateModified\":\"2024-06-13T14:57:32+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/en\\\/#\\\/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:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/integracion-doppler-bigquery-tabla-campaign-summary\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/integracion-doppler-bigquery-tabla-campaign-summary\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/integracion-doppler-bigquery-tabla-campaign-summary\\\/#primaryimage\",\"url\":\"https:\\\/\\\/help.fromdoppler.com\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/Screenshot_33-300x240.png\",\"contentUrl\":\"https:\\\/\\\/help.fromdoppler.com\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/Screenshot_33-300x240.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/integracion-doppler-bigquery-tabla-campaign-summary\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Summary?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/en\\\/\",\"name\":\"Doppler Help Center\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/helpqa.fromdoppler.com\\\/en\\\/#\\\/schema\\\/person\\\/6ac8152541360db8d120580da8a47d0e\",\"name\":\"Sebastian P\u00e9rsico\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/099b046362a69e9c8d74ad97f549d505033cfbb70ae284a0b90eaafd6c1d259b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/099b046362a69e9c8d74ad97f549d505033cfbb70ae284a0b90eaafd6c1d259b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/099b046362a69e9c8d74ad97f549d505033cfbb70ae284a0b90eaafd6c1d259b?s=96&d=mm&r=g\",\"caption\":\"Sebastian P\u00e9rsico\"},\"url\":\"https:\\\/\\\/helpqa.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:\/\/helpqa.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","type":"","width":"","height":""}],"author":"Sebastian P\u00e9rsico","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Sebastian P\u00e9rsico","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/helpqa.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/#article","isPartOf":{"@id":"https:\/\/helpqa.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/"},"author":{"name":"Sebastian P\u00e9rsico","@id":"https:\/\/helpqa.fromdoppler.com\/en\/#\/schema\/person\/6ac8152541360db8d120580da8a47d0e"},"headline":"Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Summary?","datePublished":"2022-01-05T18:30:34+00:00","dateModified":"2024-06-13T14:57:32+00:00","mainEntityOfPage":{"@id":"https:\/\/helpqa.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/"},"wordCount":705,"commentCount":0,"image":{"@id":"https:\/\/helpqa.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/#primaryimage"},"thumbnailUrl":"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33-300x240.png","keywords":["fuente de datos doppler en bigquery","integraci\u00f3n doppler y bigquery","que significan los campos en bigquery","tablas de datos bigquery"],"articleSection":["Destacados en Integraciones","Destacados en Reportes","Integraciones","Reportes"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/helpqa.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/helpqa.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/","url":"https:\/\/helpqa.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/","name":"[:es]Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Summary?[:] - Doppler Help Center","isPartOf":{"@id":"https:\/\/helpqa.fromdoppler.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/helpqa.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/#primaryimage"},"image":{"@id":"https:\/\/helpqa.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/#primaryimage"},"thumbnailUrl":"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33-300x240.png","datePublished":"2022-01-05T18:30:34+00:00","dateModified":"2024-06-13T14:57:32+00:00","author":{"@id":"https:\/\/helpqa.fromdoppler.com\/en\/#\/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:\/\/helpqa.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/helpqa.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/helpqa.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/#primaryimage","url":"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33-300x240.png","contentUrl":"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/12\/Screenshot_33-300x240.png"},{"@type":"BreadcrumbList","@id":"https:\/\/helpqa.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/helpqa.fromdoppler.com\/es\/"},{"@type":"ListItem","position":2,"name":"Integraci\u00f3n Doppler y BigQuery: \u00bfQu\u00e9 significan los Campos de la tabla Campaign Summary?"}]},{"@type":"WebSite","@id":"https:\/\/helpqa.fromdoppler.com\/en\/#website","url":"https:\/\/helpqa.fromdoppler.com\/en\/","name":"Doppler Help Center","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/helpqa.fromdoppler.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/helpqa.fromdoppler.com\/en\/#\/schema\/person\/6ac8152541360db8d120580da8a47d0e","name":"Sebastian P\u00e9rsico","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/099b046362a69e9c8d74ad97f549d505033cfbb70ae284a0b90eaafd6c1d259b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/099b046362a69e9c8d74ad97f549d505033cfbb70ae284a0b90eaafd6c1d259b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/099b046362a69e9c8d74ad97f549d505033cfbb70ae284a0b90eaafd6c1d259b?s=96&d=mm&r=g","caption":"Sebastian P\u00e9rsico"},"url":"https:\/\/helpqa.fromdoppler.com\/es\/author\/sebastian-persico\/"}]}},"_links":{"self":[{"href":"https:\/\/helpqa.fromdoppler.com\/es\/wp-json\/wp\/v2\/posts\/8413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpqa.fromdoppler.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/helpqa.fromdoppler.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/helpqa.fromdoppler.com\/es\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/helpqa.fromdoppler.com\/es\/wp-json\/wp\/v2\/comments?post=8413"}],"version-history":[{"count":18,"href":"https:\/\/helpqa.fromdoppler.com\/es\/wp-json\/wp\/v2\/posts\/8413\/revisions"}],"predecessor-version":[{"id":9011,"href":"https:\/\/helpqa.fromdoppler.com\/es\/wp-json\/wp\/v2\/posts\/8413\/revisions\/9011"}],"wp:attachment":[{"href":"https:\/\/helpqa.fromdoppler.com\/es\/wp-json\/wp\/v2\/media?parent=8413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/helpqa.fromdoppler.com\/es\/wp-json\/wp\/v2\/categories?post=8413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/helpqa.fromdoppler.com\/es\/wp-json\/wp\/v2\/tags?post=8413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}