{"id":2345,"date":"2021-04-26T10:18:54","date_gmt":"2021-04-26T13:18:54","guid":{"rendered":"https:\/\/kondado.com.br\/blog\/wiki\/?p=2345"},"modified":"2026-01-09T17:02:27","modified_gmt":"2026-01-09T20:02:27","slug":"mandrill","status":"publish","type":"post","link":"https:\/\/kondado.com.br\/blog\/wiki\/2021\/04\/26\/mandrill\/","title":{"rendered":"Mandrill"},"content":{"rendered":"<h2 id='add-instructions' name='add-instructions'>Adicionando o conector<\/h2><div><h4><strong>Requisitos<\/strong><\/h4>\n<ul>\n<li>Para gerar a API Key \u00e9 necess\u00e1rio uma conta Standard ou Premium do Mailchimp<\/li>\n<\/ul>\n\n<h4><strong>Instru\u00e7\u00f5es<\/strong><\/h4>\n<ol>\n<li>Fa\u00e7a login na sua conta do Mandrill (Mailchimp Transactional) em <a href=\"https:\/\/mandrillapp.com\" target=\"_blank\">mandrillapp.com<\/a><\/li>\n<li>Navegue at\u00e9 as <a href=\"https:\/\/mandrillapp.com\/settings\" target=\"_blank\">configura\u00e7\u00f5es<\/a>, busque pela se\u00e7\u00e3o de API Keys e clique em \"New API Key\"\n<ol>\n<li><img src=\"https:\/\/public-files.kondado.io\/wiki\/images\/mandrill\/mandrill_step_1.png\" alt=\"Mandrill Settings API Keys\" \/><\/li>\n<\/ol>\n<\/li>\n<li>Preencha uma descri\u00e7\u00e3o para sua API Key, por exemplo \"Kondado\", deixe as outras op\u00e7\u00f5es n\u00e3o marcadas e depois clique em \"Create API Key\"\n<ol>\n<li><img src=\"https:\/\/public-files.kondado.io\/wiki\/images\/mandrill\/mandrill_step_2.png\" alt=\"Mandrill Create API Key\" \/><\/li>\n<\/ol>\n<\/li>\n<li>Agora basta copiar o valor da \"Key\" que ir\u00e1 aparecer\n<ol>\n<li><img src=\"https:\/\/public-files.kondado.io\/wiki\/images\/mandrill\/mandrill_step_3.png\" alt=\"Mandrill Copy API Key\" \/><\/li>\n<\/ol>\n<\/li>\n<li>Fa\u00e7a login na Kondado, v\u00e1 para a se\u00e7\u00e3o de adicionar conectores e selecione o conector do Mandrill<\/li>\n<li>No conector, em \"Nome\" d\u00ea um nome para o seu conector e, em \"API Key\" copie o valor obtido no passo anterior\n<ol>\n<li><img src=\"https:\/\/public-files.kondado.io\/wiki\/images\/mandrill\/mandrill_step_4.png\" alt=\"Kondado Mandrill Connector\" \/><\/li>\n<\/ol>\n<\/li>\n<li>Clique em <strong>SALVAR<\/strong> para come\u00e7ar a receber dados do Mandrill no Data Warehouse ou Data Lake<\/li>\n<\/ol><\/div><h2 id='pipelines' name='pipelines'>Integra\u00e7\u00f5es<\/h2><h4 id='pipeline-index' name='pipeline-index'>\u00cdndice<\/h4><div><ul>\n<li><a href='#anchor..parent_pipeline::object..mandrill::email_activity'>Atividade dos emails<\/a><\/li>\n<li><a href='#anchor..parent_pipeline::object..mandrill::message_templates'>Templates de Mensagens<\/a><\/li>\n<\/ul><\/div><h4 id='erd-chart' name='erd-chart'>Gr\u00e1fico de relacionamento<\/h4><a style='width: 100%;min-width: 100%' href='https:\/\/public-files.kondado.io\/wiki\/erd\/mandrill_1.svg' target='_blank' rel='noopener'>\n                        <div style='padding-bottom:10px;width: 100%'>\n                            <p style='width: 100%;min-width: 100%'>\n                                <p style='width: 100%;min-width: 100%;font-size:small'>Clique para ampliar<\/p>\n                                <p style='width: 100%;min-width: 100%'>\n                                    <div style='width: 50%;height:auto;background-color: white'>\n                                        <img src='https:\/\/public-files.kondado.io\/wiki\/erd\/mandrill_1.svg' style='width: 150px'>\n                                    <\/div>\n                                <\/p>\n                            <\/p>\n                        <\/div>\n                    <\/a>\n\n\n<div class='pipeline-item'><h3>Atividade dos emails<\/h3><div><small><div class=\"kdd-auto-generated-notes\"><p><strong>Tipo de replicacao:<\/strong> Incremental com janela de atualizacao<\/p>\n<p><strong>Parametros:<\/strong><\/p>\n<ul>\n<li><strong>Data inicial de leitura (Savepoint):<\/strong> A partir de qual data de atividade dos emails iniciaremos a leitura<\/li>\n<li><strong>Janela de atualiza\u00e7\u00e3o ap\u00f3s publica\u00e7\u00e3o (dias):<\/strong> Quantos dias anteriores ao savepoint os emails continuar\u00e3o sendo lidos<\/li>\n<\/ul>\n<p><strong>Relacionamentos:<\/strong><\/p>\n<ul>\n<li><a href=\"#anchor..parent_pipeline::field..mandrill::email_activity::::Message ID\" style=\"border:0\">message_id<\/a> \u2192 <a href=\"#anchor..parent_pipeline::field..mandrill::message_templates::::_id\" style=\"border:0\">Templates de Mensagens > message_id<\/a><\/li>\n<\/ul><\/div><\/small><\/div><div><!--- __kdd_doc_updated:2026-01-09T17:07:04.010718Z --->\n<a id=\"parent_pipeline_type:email_activity\"><\/a>\n<a id=\"anchor..parent_pipeline::object..mandrill::email_activity\"><\/a>\n<a style=\"border:0\" href=\"#anchor..parent_pipeline::table..mandrill::email_activity::\" id=\"anchor..parent_pipeline::table..mandrill::email_activity::\"><i class=\"fas fa-link\"><\/i><\/a>\n<p style='padding-left:10%'><small><em>Registros de atividade de e-mails enviados pelo Mandrill, com status, m\u00e9tricas e detalhes por mensagem.<\/em><\/small><\/p>\n<div style=\"padding-left:10%\"><table>\n\n\t\t\t  <tr style=\"border-bottom:1px solid gray\">\n\t\t\t    <th><small><b>Campo<\/b><\/small><\/th>\n\t\t\t    <th style=\"padding-left:10px\"><small><b>Tipo<\/b><\/small><\/th>\n\t\t\t    <th style=\"padding-left:10px\"><small><b><\/b><\/small><\/th>\n\t\t\t  <\/tr>\n\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::email_activity::::__kdd_rowkey\" href=\"#anchor..parent_pipeline::field..mandrill::email_activity::::__kdd_rowkey\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t_kdd_rowkey\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Chave de replica\u00e7\u00e3o da linha (gerada pela Kondado).<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::email_activity::::_id\" href=\"#anchor..parent_pipeline::field..mandrill::email_activity::::_id\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tmessage_id\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Identificador \u00fanico da mensagem no Mandrill. Use para JOIN com a tabela de templates.<\/small><\/p>\n\t\t\t\t\t\t<p style=\"padding:0;border:0;margin:0\"><small><small><small>\u00a0\u00a0\u00a0\u00a0<i class=\"fas fa-link\"><\/i><a style=\"border:0\" href=\"#anchor..parent_pipeline::field..mandrill::message_templates::::_id\">Templates de Mensagens >  > message_id<\/a><\/small><\/small><\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::email_activity::::Date\" href=\"#anchor..parent_pipeline::field..mandrill::email_activity::::Date\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tevent_date\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>timestamp<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Data e hora do evento.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::email_activity::::Email Address\" href=\"#anchor..parent_pipeline::field..mandrill::email_activity::::Email Address\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\temail_address\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Endere\u00e7o de e-mail do destinat\u00e1rio.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::email_activity::::Sender\" href=\"#anchor..parent_pipeline::field..mandrill::email_activity::::Sender\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tsender\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Endere\u00e7o de e-mail do remetente.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::email_activity::::Subject\" href=\"#anchor..parent_pipeline::field..mandrill::email_activity::::Subject\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tsubject\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Linha de assunto utilizada na mensagem.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::email_activity::::Status\" href=\"#anchor..parent_pipeline::field..mandrill::email_activity::::Status\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tstatus\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Situa\u00e7\u00e3o do envio da mensagem. Valores poss\u00edveis: \"sent\", \"bounced\" ou \"rejected\".<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::email_activity::::Tags\" href=\"#anchor..parent_pipeline::field..mandrill::email_activity::::Tags\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\ttags\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Lista de tags associadas \u00e0 mensagem.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::email_activity::::Subaccount\" href=\"#anchor..parent_pipeline::field..mandrill::email_activity::::Subaccount\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tsubaccount\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Subconta utilizada na mensagem.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::email_activity::::Opens\" href=\"#anchor..parent_pipeline::field..mandrill::email_activity::::Opens\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\topens\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>int<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Quantidade de aberturas registradas para a mensagem.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::email_activity::::Clicks\" href=\"#anchor..parent_pipeline::field..mandrill::email_activity::::Clicks\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tclicks\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>int<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Quantidade de cliques em links dessa mensagem.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::email_activity::::Bounce Detail\" href=\"#anchor..parent_pipeline::field..mandrill::email_activity::::Bounce Detail\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tbounce_detail\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Detalhes adicionais sobre o motivo do bounce, quando dispon\u00edvel.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n<\/table><\/div><\/div><\/div><div class='pipeline-item'><h3>Templates de Mensagens<\/h3><div><small><div class=\"kdd-auto-generated-notes\"><p><strong>Tipo de replicacao:<\/strong> Incremental com janela de atualizacao<\/p>\n<p><strong>Parametros:<\/strong><\/p>\n<ul>\n<li><strong>Janela de atualiza\u00e7\u00e3o (dias):<\/strong> Quantidade de dias para buscar retroativamente por atualiza\u00e7\u00f5es<\/li>\n<li><strong>Data inicial de leitura (Savepoint):<\/strong> A partir de qual data iniciaremos a leitura dos templates de mensagens<\/li>\n<\/ul><\/div><\/small><\/div><div><!--- __kdd_doc_updated:2026-01-09T17:07:13.878573Z --->\n<a id=\"parent_pipeline_type:message_templates\"><\/a>\n<a id=\"anchor..parent_pipeline::object..mandrill::message_templates\"><\/a>\n<a style=\"border:0\" href=\"#anchor..parent_pipeline::table..mandrill::message_templates::\" id=\"anchor..parent_pipeline::table..mandrill::message_templates::\"><i class=\"fas fa-link\"><\/i><\/a>\n<p style='padding-left:10%'><small><em>Mensagens do Mandrill com informa\u00e7\u00e3o de template\/slug para permitir JOINs com a tabela de atividade.<\/em><\/small><\/p>\n<div style=\"padding-left:10%\"><table>\n\n\t\t\t  <tr style=\"border-bottom:1px solid gray\">\n\t\t\t    <th><small><b>Campo<\/b><\/small><\/th>\n\t\t\t    <th style=\"padding-left:10px\"><small><b>Tipo<\/b><\/small><\/th>\n\t\t\t    <th style=\"padding-left:10px\"><small><b><\/b><\/small><\/th>\n\t\t\t  <\/tr>\n\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::message_templates::::_id\" href=\"#anchor..parent_pipeline::field..mandrill::message_templates::::_id\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tmessage_id\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Identificador \u00fanico da mensagem no Mandrill.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::message_templates::::template\" href=\"#anchor..parent_pipeline::field..mandrill::message_templates::::template\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\ttemplate_slug\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Slug do template utilizado para enviar a mensagem (se aplic\u00e1vel).<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::message_templates::::email\" href=\"#anchor..parent_pipeline::field..mandrill::message_templates::::email\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\temail_address\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Endere\u00e7o de e-mail do destinat\u00e1rio.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::message_templates::::subject\" href=\"#anchor..parent_pipeline::field..mandrill::message_templates::::subject\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tsubject\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Linha de assunto da mensagem.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::message_templates::::sender\" href=\"#anchor..parent_pipeline::field..mandrill::message_templates::::sender\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tsender\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Endere\u00e7o de e-mail do remetente.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::message_templates::::state\" href=\"#anchor..parent_pipeline::field..mandrill::message_templates::::state\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tstatus\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Situa\u00e7\u00e3o do envio da mensagem.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::message_templates::::ts\" href=\"#anchor..parent_pipeline::field..mandrill::message_templates::::ts\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tevent_timestamp\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>timestamp<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Data e hora do evento.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::message_templates::::tags\" href=\"#anchor..parent_pipeline::field..mandrill::message_templates::::tags\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\ttags\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>text<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Lista de tags associadas \u00e0 mensagem, separadas por v\u00edrgula.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::message_templates::::opens\" href=\"#anchor..parent_pipeline::field..mandrill::message_templates::::opens\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\topens\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>int<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Quantidade de aberturas registradas.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t<tr>\n\t\t\t\t\t<td style=\"vertical-align:top\">\n\t\t\t\t\t\t<p>\n\t\t\t\t\t\t\t<small>\n\t\t\t\t\t\t\t\t<a style=\"border:0;\" id=\"anchor..parent_pipeline::field..mandrill::message_templates::::clicks\" href=\"#anchor..parent_pipeline::field..mandrill::message_templates::::clicks\">\n\t\t\t\t\t\t\t\t\t<i class=\"fas fa-link\"><\/i>\n\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\tclicks\n\t\t\t\t\t\t\t<\/small>\n\t\t\t\t\t\t<\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>int<\/small><\/p>\n\t\t\t\t\t<\/td>\n\t\t\t\t\t<td style=\"padding-left:10px;vertical-align:top;\">\n\t\t\t\t\t\t<p><small>[pt] Quantidade de cliques em links.<\/small><\/p>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n<\/table><\/div><\/div><\/div>\n\n\n<h2 id='end-notes' name='end-notes'>Notas<\/h2><div><div class=\"kdd-auto-generated-notes\"><ul><li>Parte desta documentacao foi gerada automaticamente por IA e pode conter erros. Recomendamos verificar informacoes cr\u00edticas<\/li><\/ul><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Adicione o conector do Mandrill na Kondado e integre os dados do seu disparador de emails ao seu Data Warehouse ou Data Lake<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[229],"tags":[40,338,7,118,119,462,461,6,457,458,460,459],"_links":{"self":[{"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/posts\/2345"}],"collection":[{"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/comments?post=2345"}],"version-history":[{"count":10,"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/posts\/2345\/revisions"}],"predecessor-version":[{"id":10671,"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/posts\/2345\/revisions\/10671"}],"wp:attachment":[{"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/media?parent=2345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/categories?post=2345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/tags?post=2345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}