Adding the data source
To automate E-goi ETL with Kondado for your database, follow the steps below:
1) Log in to your E-goi account and, in the panel, click on your username, then on Pipelines
2) On the new page, copy the value of “API Key”
4) Name your data source and, in “API Key” paste the key generated in step (2)
Now just save the data source and start integrating your E-goi data into the Data Lake or Data Warehouse
PIpelines
Relationship Chart
Campaigns
a
| Field |
Type |
|
key |
text |
|
status |
text |
|
campaign_end |
timestamp |
|
listnum |
text |
|
subject |
text |
|
internal_name |
text |
|
campaign_start |
timestamp |
|
hash |
text |
|
ref |
text |
|
campaign_url |
text |
|
channel |
text |
|
processed_messages |
int |
|
Lists
| Field |
Type |
|
key |
text |
|
listnum |
text |
|
title |
text |
|
title_ref |
text |
|
subs_activos |
float |
|
subs_total |
text |
|
grupo |
text |
|
user_id |
text |
|
idioma |
text |
|
unique_fields |
text |
|
Subscribers Data
| Field |
Type |
|
key |
text |
|
uid |
text |
|
add_date |
timestamp |
|
subscription_method |
text |
|
list |
text |
|
first_name |
text |
|
last_name |
text |
|
email |
text |
|
cellphone |
text |
|
telephone |
text |
|
fax |
text |
|
language |
text |
|
birth_date |
text |
|
status |
text |
|
status_email |
text |
|
status_cellphone |
text |
|
status_telephone |
text |
|
status_fax |
text |
|
bounces |
float |
|
email_sent |
float |
|
email_views |
float |
|
referrals |
float |
|
referrals_converted |
float |
|
clicks |
float |
|
sms_sent |
float |
|
sms_delivered |
float |
|
fax_sent |
float |
|
voice_calls_sent |
float |
|
voice_calls_answered |
float |
|
tags |
text |
|
modification_date |
date |
|
last_open_date |
date |
|
token_android |
text |
|
token_ios |
text |
|
push_sent |
float |
|
push_open |
float |
|
push_click |
float |
|
push_delivered |
float |
|
push_not_delivered |
float |
|
push_canceled |
float |
|
push_last_open_date |
timestamp |
|
