{"id":1003,"date":"2020-06-07T17:59:06","date_gmt":"2020-06-07T20:59:06","guid":{"rendered":"http:\/\/kondado.com.br\/blog\/?p=1003"},"modified":"2023-08-03T11:00:42","modified_gmt":"2023-08-03T14:00:42","slug":"como-adiconar-o-conector-do-e-goi-na-kondado","status":"publish","type":"post","link":"https:\/\/kondado.com.br\/blog\/wiki\/2020\/06\/07\/como-adiconar-o-conector-do-e-goi-na-kondado\/","title":{"rendered":"E-goi"},"content":{"rendered":"\n

O E-goi \u00e9 um SaaS de automa\u00e7\u00e3o de marketing e disparo de e-mails. A integra\u00e7\u00e3o de dados do E-goi para o Data Warehouse criada pela Kondado possibilita que voc\u00ea tenha acesso aos seus dados de disparo e campanhas na sua nuvem anal\u00edtica.<\/p>\n\n\n\n\n\n

<\/p>\n\n\n\n

Adicionando o conector<\/h2>\n\n\n\n

Para automatizar o ETL do E-goi com a Kondado para o seu banco de dados, siga os passos abaixo:<\/p>\n\n\n\n

1) Fa\u00e7a login na sua conta do E-goi e, no painel clique no seu usu\u00e1rio depois em Integra\u00e7\u00f5es<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

2) Na nova p\u00e1gina, copie o valor de “Chave da API”<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

3) Na plataforma da Kondado, v\u00e1 para a p\u00e1gina de adicionar conectores<\/a> e selecione o conector do E-goi<\/p>\n\n\n\n

4) D\u00ea um nome para o seu conector e, em “Chave da API” cole a chave gerada no passo (2)<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Agora basta salvar o conector e come\u00e7ar a integrar os seus dados do E-goi no Data Lake ou Data Warehouse<\/p>\n\n\n\n

Integra\u00e7\u00f5es<\/h2>\n\n\n\n
\n\t\t\n\t\t\t
\n\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t\t\tGr\u00e1fico de relacionamento entre tabelas\n\t\t\t\t\t<\/p>\n\t\t\t\t\t

\n\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/p>\n\t\t\t\t<\/p>\n\t\t\t<\/div>\n\t\t<\/a>\t\n\t<\/center>\n\n\n\n

Campanhas<\/strong><\/h3>\n\n\n\n\n<\/a>\n
\n\n\t\t\t \n\t\t\t \n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t
Campo<\/b><\/small><\/th>\n\t\t\t Tipo<\/b><\/small><\/th>\n\t\t\t <\/b><\/small><\/th>\n\t\t\t <\/tr>\n\t\t\n\n\t\t\t\t

key<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

status<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

campaign_end<\/p><\/small><\/td>\n\t\t\t\t\t

timestamp<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

listnum<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

subject<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

internal_name<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

campaign_start<\/p><\/small><\/td>\n\t\t\t\t\t

timestamp<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

hash<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

ref<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

campaign_url<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

channel<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

processed_messages<\/p><\/small><\/td>\n\t\t\t\t\t

int<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n<\/table><\/div>\n\n\n\n

Listas<\/strong><\/h3>\n\n\n\n\n<\/a>\n
\n\n\t\t\t \n\t\t\t \n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t
Campo<\/b><\/small><\/th>\n\t\t\t Tipo<\/b><\/small><\/th>\n\t\t\t <\/b><\/small><\/th>\n\t\t\t <\/tr>\n\t\t\n\n\t\t\t\t

key<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

listnum<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

title<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

title_ref<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

subs_activos<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

subs_total<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

grupo<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

user_id<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

idioma<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

unique_fields<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n<\/table><\/div>\n\n\n\n

Subscribers Data<\/strong><\/h3>\n\n\n\n\n<\/a>\n
\n\n\t\t\t \n\t\t\t \n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t
Campo<\/b><\/small><\/th>\n\t\t\t Tipo<\/b><\/small><\/th>\n\t\t\t <\/b><\/small><\/th>\n\t\t\t <\/tr>\n\t\t\n\n\t\t\t\t

key<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

uid<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

add_date<\/p><\/small><\/td>\n\t\t\t\t\t

timestamp<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

subscription_method<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

list<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

first_name<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

last_name<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

email<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

cellphone<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

telephone<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

fax<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

language<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

birth_date<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

status<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

status_email<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

status_cellphone<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

status_telephone<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

status_fax<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

bounces<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

email_sent<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

email_views<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

referrals<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

referrals_converted<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

clicks<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

sms_sent<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

sms_delivered<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

fax_sent<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

voice_calls_sent<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

voice_calls_answered<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

tags<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

modification_date<\/p><\/small><\/td>\n\t\t\t\t\t

date<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

last_open_date<\/p><\/small><\/td>\n\t\t\t\t\t

date<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

token_android<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

token_ios<\/p><\/small><\/td>\n\t\t\t\t\t

text<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

push_sent<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

push_open<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

push_click<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

push_delivered<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

push_not_delivered<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

push_canceled<\/p><\/small><\/td>\n\t\t\t\t\t

float<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n\n\t\t\t\t

push_last_open_date<\/p><\/small><\/td>\n\t\t\t\t\t

timestamp<\/p><\/small><\/td>\n\t\t\t\t\t

<\/small><\/td>\n\t\t\t\t<\/tr>\n\t\t\t\n<\/table><\/div>\n","protected":false},"excerpt":{"rendered":"

Integre os dados do E-goi ao seu Data Warehouse ou Data Lake utilizando a Kondado<\/p>\n","protected":false},"author":2,"featured_media":1004,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[229],"tags":[40,42,114,115,116,7,117,118,119,6,120],"_links":{"self":[{"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/posts\/1003"}],"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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/comments?post=1003"}],"version-history":[{"count":9,"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/posts\/1003\/revisions"}],"predecessor-version":[{"id":6283,"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/posts\/1003\/revisions\/6283"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/media\/1004"}],"wp:attachment":[{"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/media?parent=1003"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/categories?post=1003"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kondado.com.br\/blog\/wiki\/wp-json\/wp\/v2\/tags?post=1003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}