E-goi

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”

3) On the Kondado platform, go to the add data sources page and select the E-goi data source

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

Add E-goi as a data source on Kondado

Connect your E-goi marketing data to Kondado for automated ETL pipelines into your data warehouse, data lake or BI tool.

1

Sign in to E-goi

Log in to your E-goi account with a user that can manage API keys for the workspace you want to replicate.

2

Copy your E-goi API Key

On the panel, click your username and then Pipelines. On the page that opens, copy the value shown as API Key.

3

Add E-goi as a data source in Kondado

On the Kondado platform, open the add data sources page and select the E-goi data source.

4

Configure and save the connection

Name your data source and paste the API key from the previous step into the API Key field, then save the data source.

5

Send E-goi data to your destination

Pick the entities you want to replicate — Campaigns, Lists and Subscribers Data — and route them to a supported destination such as a Data Lake, Data Warehouse or BI tool.

Frequently asked questions

What E-goi data can I integrate with Kondado?▼

You can sync Campaigns, Lists, and Subscribers Data tables, including fields like campaign status, subscriber emails, cellphone numbers, subscription dates, engagement metrics (opens, clicks, bounces), and push notification delivery data.

Where do I find my E-goi API Key?▼

Log in to your E-goi account, click on your username in the panel, then select Pipelines. The API Key will be displayed on that page for you to copy.

Can I connect E-goi data to BI tools through Kondado?▼

Yes. After adding E-goi as a source, you can send the data to various destinations and then visualize it in BI tools. See Data Studio integration with E-goi as one example.

Does Kondado offer pre-built reports for E-goi?▼

Yes, Kondado provides pre-built reports for E-goi to help you analyze your marketing data faster without building dashboards from scratch.

What happens after I save the E-goi data source?▼

Once saved, Kondado begins the automated ETL process to extract your E-goi data and load it into your chosen destination, such as a data warehouse, where it can be transformed and prepared for analysis.

Written by

Thassyo Pereira·Published 2023-07-18·Updated 2026-04-26