E-goi

Creating the data source

E-goi is a marketing automation and email-sending SaaS. The E-goi data integration to the Data Warehouse built by Kondado gives you access to your sending and campaign data in your analytics cloud.

Adding the connector

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 and then on "Integrations"

2) On the new page, copy the value of "API Key"

3) On the Kondado platform, go to the add connectors page and select the E-goi connector

4) Name your connector and, in "API Key", paste the key copied in step (2)

Now just save the connector and start integrating your E-goi data into the Data Lake or Data Warehouse.

Pipelines

Relationship chart

Click to expand

Advanced report

Replication type: Incremental

E-goi advanced report exported as cells (row/column), with values per report template.

Campo	Tipo
row_number	int	[en] Row number of the cell in the exported advanced report.
column_number	int	[en] Column number of the cell in the exported advanced report.
first_column_value	text	[en] Value of the first column of the row, used as the row label/identifier in the report.
value	text	[en] Value of the advanced report cell at the indicated row and column.
template_id	text	[en] Identifier of the advanced report template that generated the data.
__kdd_insert_time	timestamp	[en] Date and time the record was loaded by Kondado (technical field, not from the API).

Campaigns

Replication type: Full

E-goi marketing campaigns (email, SMS, voice and push), with identifiers, channel, status and sending dates.

Campo	Tipo
key	text	[en] Record key/index returned by the E-goi API for the campaign.
status	text	[en] Current campaign status (e.g. standby, processing, finished, archived).
campaign_end	timestamp	[en] Date and time the campaign sending was completed.
listnum	text	[en] Identifier number of the contact list associated with the campaign. Lists > > listnum
subject	text	[en] Subject/title of the campaign.
internal_name	text	[en] Internal campaign name used for organization within the account.
campaign_start	timestamp	[en] Date and time the campaign sending was launched/started.
hash	text	[en] Unique code (hash) identifying the campaign.
ref	text	[en] Unique reference number identifying the campaign.
campaign_url	text	[en] Public URL to view the campaign.
channel	text	[en] Distribution channel of the campaign (email, SMS, voice, push, web push).
processed_messages	int	[en] Number of messages processed/sent in the campaign.

Lists

Replication type: Full

E-goi contact lists, with identifiers, language, grouping and active/total subscriber counts.

Campo	Tipo
key	text	[en] Record key/index returned by the E-goi API for the list.
listnum	text	[en] Identifier number of the contact list.
title	text	[en] Public name of the list.
title_ref	text	[en] Internal (reference) name of the list.
subs_activos	float	[en] Number of currently active subscribers in the list.
subs_total	text	[en] Total number of subscribers in the list, including inactive ones.
grupo	text	[en] Group/category the list belongs to.
user_id	text	[en] Identifier of the user that owns the list.
idioma	text	[en] Primary language of the list.
unique_fields	text	[en] Identifier fields used to detect duplicate subscribers in the list.

Subscribers Data

Replication type: Full

Subscriber (contact) data for an E-goi list, including profile data, per-channel status and engagement metrics for email, SMS, voice and push.

Campo	Tipo
key	text	[en] Record key/index of the subscriber returned by the E-goi API.
uid	text	[en] Unique identifier of the subscriber (contact).
add_date	timestamp	[en] Date the subscriber was added to the list (subscription).
subscription_method	text	[en] Method by which the subscriber was added to the list.
list	text	[en] Identifier number of the list the subscriber belongs to. Lists > > listnum
first_name	text	[en] First name of the subscriber.
last_name	text	[en] Last name of the subscriber.
email	text	[en] Email address of the subscriber.
cellphone	text	[en] Mobile phone number of the subscriber.
telephone	text	[en] Landline phone number of the subscriber.
fax	text	[en] Fax number of the subscriber.
language	text	[en] Language of the subscriber.
birth_date	text	[en] Birth date of the subscriber.
status	text	[en] Subscriber status (0=unconfirmed, 1=active, 2=removed, 4=inactive).
status_email	text	[en] State of the subscriber email channel (0=inactive, 1=active).
status_cellphone	text	[en] State of the subscriber mobile/SMS channel (0=inactive, 1=active).
status_telephone	text	[en] State of the subscriber phone channel (0=inactive, 1=active).
status_fax	text	[en] State of the subscriber fax channel (0=inactive, 1=active).
bounces	float	[en] Number of message delivery failures for the subscriber.
email_sent	float	[en] Total emails sent to the subscriber.
email_views	float	[en] Number of email opens by the subscriber.
referrals	float	[en] Number of referrals initiated by the subscriber.
referrals_converted	float	[en] Number of converted referrals (the referred person signed up).
clicks	float	[en] Number of clicks made by the subscriber.
sms_sent	float	[en] Number of SMS messages sent to the subscriber.
sms_delivered	float	[en] Number of SMS messages successfully delivered to the subscriber.
fax_sent	float	[en] Number of faxes sent to the subscriber.
voice_calls_sent	float	[en] Number of voice calls made to the subscriber.
voice_calls_answered	float	[en] Number of voice calls answered by the subscriber.
tags	text	[en] Tags associated with the subscriber.
modification_date	date	[en] Date of the last update to the subscriber information.
last_open_date	date	[en] Date of the subscriber last email open.
token_android	text	[en] Android device push token of the subscriber.
token_ios	text	[en] iOS device push token of the subscriber.
push_sent	float	[en] Number of push notifications sent to the subscriber.
push_open	float	[en] Number of push notifications opened by the subscriber.
push_click	float	[en] Number of push notification clicks by the subscriber.
push_delivered	float	[en] Number of push notifications delivered to the subscriber.
push_not_delivered	float	[en] Number of push notifications not delivered to the subscriber.
push_canceled	float	[en] Number of push notifications canceled for the subscriber.
push_last_open_date	timestamp	[en] Date of the subscriber last push notification open.

Notes

Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

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-06-01