RDStation

Creating the data source

Requirements

Your RD Station plan must be Light, Basic, Pro or Enterprise
Your user must have an access profile of Owner, Manager or Marketing

Instructions

1) Login to Kondado, go to add data source and select the RDStation data source

2) Click AUTHORIZE

3) On the RD authorization page, select the account you will use and click on “Continue

4) Then click Connect

5) You will be directed back to Kondado. Give your connector a name and click SAVE

6) If you are using webhook, check the additional instructions for the correct operation of the data source and its historical data at the end of this tutorial in "Webhook Configuration"

Pipelines

Relationship chart

Click to expand

Contacts

Replication type: Incremental with update window

Parameters:

Update window (days): How many days prior to the savepoint the data will still be replcated
Segmentation: Select the segmentation
Read start date (Savepoint): Data replication start date based on created date and last conversion date

Campo	Tipo
uuid	text	[pt] O uuid exclusivo associado a cada contato do RD Station
created_at	timestamp	[pt] Data de criação do contato
email	text	[pt] Email do contato
last_conversion_date	timestamp	[pt] Data da última conversão do contato
name	text	[pt] Nome do contato

Contacts: conversion events

Replication type: Incremental with update window

Parameters:

Update window (days): How many days prior to the savepoint the data will still be replcated
Segmentation: Select the segmentation
Read start date (Savepoint): Data replication start date based on created date and last conversion date

Relationships:

contact_uuid → Contacts > uuid

Main object

Campo	Tipo
contact_uuid	text	[pt] Código de identificador unico de usuario Contacts > > uuid
event_family	text	[pt] Identificador interno do RDSM
event_identifier	text	[pt] Identificador do evento
event_timestamp	timestamp	[pt] Data/hora de criação do evento
event_type	text	[pt] O tipo de evento (CONVERSION ou OPPORTUNITY)
payload_city	float
payload_company_name	text
payload_email	text
payload_name	text
payload_personal_phone	text
event_number	float	[pt] Identificador do evento criado pela Kondado

rdstation_contatos_eventos_conversoes_traffic_source

Campo	Tipo
contact_uuid	text	[pt] Código de identificador unico de usuario
event_number	float	[pt] Identificador do evento criado pela Kondado
traffic_source_param_key	text	[pt] Chave do parâmetro identificado no payload traffic_source. A string original é identificada como __kdd_raw. Caso a string original seja uma URL, também serão enviados os valores __kdd_hostname para o hostname (por exemplo app.kondado.com.br) e __kdd_path para o path da URL (por exemplo /signup para a URL https://app.kondado.com.br/signup)
traffic_source_param_value	text	[pt] Valor do parâmetro identificado do payload traffic_source
traffic_source_session_order	text	[pt] Indica se os parâmetros referem-se à sessão atual (current) ou à primeira (first)

Contacts: custom fields

Replication type: Incremental with update window

Parameters:

Update window (days): How many days prior to the savepoint the data will still be replcated
Segmentation: Select the segmentation
Read start date (Savepoint): Data replication start date based on created date and last conversion date

Relationships:

uuid → Contacts > uuid

Campo	Tipo
uuid	text	[pt] O uuid exclusivo associado a cada contato do RD Station Contacts > > uuid
custom_field_a	text	[pt] Exemplo de custom field
custom_field_b	timestamp	[pt] Exemplo de custom field
custom_field_c	text	[pt] Exemplo de custom field

Contacts: funnels

Replication type: Incremental with update window

Parameters:

Update window (days): How many days prior to the savepoint the data will still be replcated
Segmentation: Select the segmentation
Read start date (Savepoint): Data replication start date based on created date and last conversion date

Relationships:

contact_uuid → Contacts > uuid

Campo	Tipo
contact_uuid	text	[pt] Código de identificador unico de usuario Contacts > > uuid
contact_owner_email	text	[pt] O e-mail do usuário responsável pelo contato
fit	float	[pt] A pontuação de ajuste do contato no funil atual
interest	float	[pt] A pontuação de interesse do contato no funil atual
lifecycle_stage	text	[pt] O estágio no funil ao qual o contato pertence.
opportunity	boolean	[pt] Indica se o contato é uma oportunidade ou não no funil
origin	text

Contacts: opportunity events

Replication type: Incremental with update window

Parameters:

Update window (days): How many days prior to the savepoint the data will still be replcated
Segmentation: Select the segmentation
Read start date (Savepoint): Data replication start date based on created date and last conversion date

Relationships:

contact_uuid → Contacts > uuid

Campo	Tipo
contact_uuid	text	[pt] Código de identificador unico de usuario Contacts > > uuid
event_number	float	[pt] Identificador do evento criado pela Kondado
event_family	text	[pt] Identificador interno do RDSM
event_identifier	text	[pt] Identificador do evento
event_timestamp	timestamp	[pt] Data/hora de criação do evento, utilizando o formato UTC
event_type	text	[pt] O tipo de evento (CONVERSION ou OPPORTUNITY)
payload_funnel_name	text	[pt] Nome do funil

Contacts: tags

Replication type: Incremental with update window

Parameters:

Update window (days): How many days prior to the savepoint the data will still be replcated
Segmentation: Select the segmentation
Read start date (Savepoint): Data replication start date based on created date and last conversion date

Relationships:

uuid → Contacts > uuid

Campo	Tipo
uuid	text	[pt] Indentificador unico do contato Contacts > > uuid
tags	text	[pt] Tags do contato

Campo

Tipo

uuid

text

[pt] Indentificador unico do contato

Contacts > > uuid

Email analytics

This integration is available only for Pro accounts (with a 45-day history limit) or Advanced accounts - other plans won't return data
The API returns data starting from August 2021. The data is consolidated up to the day before the analysis date (D-1) and is provided in UTC format.

Replication type: Incremental

Parameters:

Read start date (Savepoint): Data replication start date based on metric date
Period: Time granularity of the data
Update window: How many periods will be updated at each pipeline run

Relationships:

campaign_id → Emails > campaign_id

Campo	Tipo
metric_start_date	timestamp
campaign_id	text	[pt] Id da campanha Emails > > campaign_id
campaign_name	text	[pt] Nome da campanha de e-mail
contacts_count	float	[pt] Quantidade de contatos selecionados
email_bounced_count	float	[pt] Total de e-mails de rejeitados
email_clicked_count	float	[pt] Total de cliques únicos por lead
email_clicked_rate	float	[pt] Taxa de cliques em comparação com o número de e-mails entregues
email_delivered_count	float	[pt] Total de e-mails entregues
email_delivered_rate	float	[pt] Taxa de entrega
email_dropped_count	float	[pt] Total de e-mails descartados
email_opened_count	float	[pt] Total de aberturas únicas por lead
email_opened_rate	float	[pt] Taxa de abertura em comparação com o número de e-mails entregues
email_spam_reported_count	float	[pt] Total reportado como spam
email_spam_reported_rate	float	[pt] Taxa de spam em comparação com o número de e-mails entregues
email_unsubscribed_count	float	[pt] Total não inscrito
send_at	timestamp	[pt] Data de envio do e-mail
metric_end_date	timestamp

Emails

This pipeline is free

Replication type: Full

Campo	Tipo
id	text	[pt] ID do email
behavior_score_info_disengaged	boolean	[pt] Informa se estão selecionados leads desengajados
behavior_score_info_engaged	boolean	[pt] Informa se estão selecionados leads engajados
behavior_score_info_indeterminate	boolean	[pt] Informa se estão selecionados leads indeterminados
campaign_id	text	[pt] ID da campanha
component_template_id	float	[pt] ID do componente do template de email
created_at	text	[pt] Data da criação do email
is_predictive_sending	boolean	[pt] Informa se a campanha tem envio preditivo
leads_count	float	[pt] Quantidade de leads do email
name	text	[pt] Nome do email
send_at	text	[pt] Data do envio do email
sending_is_imminent	boolean	[pt] Informa se o envio é iminente
status	text	[pt] Status da campanha
type	text	[pt] Tipo do email
updated_at	text	[pt] Data da atualização do email

Forms

This pipeline is free

Replication type: Full

Relationships:

conversion_identifier → Contacts: conversion events > event_identifier

Campo	Tipo
id	text	[pt] Identificador único do formulário
conversion_identifier	text	[pt] Identificador da conversão Contacts: conversion events > > event_identifier
created_at	timestamp	[pt] Data de criação do formulário
status	text	[pt] Status de publicação do formulário
title	text	[pt] Título do formulário
updated_at	timestamp	[pt] Data da última atualização do formulário

Landing pages

This pipeline is free

Replication type: Full

Relationships:

conversion_identifier → Contacts: conversion events > event_identifier

Campo	Tipo
id	text	[pt] Identificador único da landing page
conversion_identifier	text	[pt] Identificador da conversão Contacts: conversion events > > event_identifier
created_at	timestamp	[pt] Data de criação da landing page
had_experiment	boolean	[pt] Informa se a landing page já possuiu um teste A/B
has_active_experiment	boolean	[pt] Informa se a landing page possui um teste A/B ativo
status	text	[pt] Status de publicação da landing page
title	text	[pt] Título da Landing Page
updated_at	timestamp

Pop Ups

This pipeline is free

Replication type: Full

Relationships:

conversion_identifier → Contacts: conversion events > event_identifier

Campo	Tipo
id	text	[pt] Identificador único do pop-up
conversion_identifier	text	[pt] Identificador da conversão Contacts: conversion events > > event_identifier
created_at	timestamp	[pt] Data de criação do pop-up
status	text	[pt] Status de publicação do pop-up
title	text	[pt] Título do Pop-up
trigger	text	[pt] Gatilho para exibição do pop-up
updated_at	timestamp	[pt] Data da última atualização do pop-up

Webhook Leads

Replication type: Incremental

Main object

Campo	Tipo
id	text	[pt] ID do lead no RD Station
bio	text	[pt] Anotacoes no perfil do lead
city	text	[pt] Cidade do lead
company	text	[pt] Nome da empresa associada ao lead
created_at	timestamp	[pt] Data em que o lead foi criado
email	text	[pt] Email do lead
first_conversion_conversion_origin_campaign	text
first_conversion_conversion_origin_channel	text
first_conversion_conversion_origin_medium	text
first_conversion_conversion_origin_source	text
first_conversion_conversion_origin_value	text
first_conversion_created_at	timestamp
first_conversion_cumulative_sum	float
first_conversion_source	text
fit_score	text	[pt] Perfil do Lead Scoring do lead
interest	float	[pt] Interesse do Lead Scoring do lead
job_title	text	[pt] Cargo
last_conversion_conversion_origin_campaign	text
last_conversion_conversion_origin_channel	text
last_conversion_conversion_origin_medium	text
last_conversion_conversion_origin_source	text
last_conversion_conversion_origin_value	text
last_conversion_created_at	timestamp
last_conversion_cumulative_sum	float
last_conversion_source	text
last_marked_opportunity_date	timestamp
lead_stage	text	[pt] Estagio do lead
mobile_phone	text	[pt] Celular do lead
name	text	[pt] Nome do lead
number_conversions	float	[pt] Numero de conversoes
opportunity	boolean	[pt] Se o lead e uma oportunidade
personal_phone	text	[pt] Telefone do lead
public_url	text	[pt] URL publica do lead
state	text	[pt] Estado do lead
user	text	[pt] Email do dono do lead
uuid	text
website	text	[pt] Site do lead
__kdd_request_id	text	[pt] ID do request feito ao endpoint de wehbook da Kondado - retornado para a aplicacao que fez o POST
__kdd_request_unix_timestamp	float	[pt] UNIX timestamp do request feito ao endpoint de wehbook da Kondado - retornado para a aplicacao que fez o POST
__kdd_requester_key	text	[pt] Chave utilizada para autenticar o POST feito ao endpoint de webhook da Kondado

rdstation_leads_tags

Campo	Tipo
lead_id	text	[pt] ID do lead ao qual o registro se refere
tag	text	[pt] Tag associada ao lead_id

rdstation_leads_first_conversion_content

Campo	Tipo
lead_id	text	[pt] ID do lead ao qual o registro se refere
key	text	[pt] Chave do campo da primeira conversao
val	text	[pt] Valor preenchido na primeira conversao pelo lead_id para o campo representado pela chave da coluna key

rdstation_leads_last_conversion_content

Campo	Tipo
lead_id	text	[pt] ID do lead ao qual o registro se refere
key	text	[pt] Chave do campo da ultima conversao
val	text	[pt] Valor preenchido na ultima conversao pelo lead_id para o campo representado pela chave da coluna key

rdstation_leads_custom_fields

Campo	Tipo
lead_id	text	[pt] ID do lead ao qual o registro se refere
key	text	[pt] Chave do campo customizado
val	text	[pt] Valor preenchido na pelo lead_id para o campo representado pela chave da coluna key

Workflow email analytics

This integration is available only for Pro accounts (with a 45-day history limit) or Advanced accounts - other plans won't return data
The API returns data starting from January 2022. The data is consolidated and provided in UTC format.

Replication type: Incremental

Parameters:

Read start date (Savepoint): Data replication start date based on metric date
Period: Time granularity of the data
Update window: How many periods will be updated at each pipeline run

Campo	Tipo
metric_start_date	timestamp
workflow_action_id	text	[pt] Id do email de automação
email_name	text	[pt] Nome da campanha enviada pela automação
contacts_count	float
count_processed	float
created_at	timestamp
email_bounced_unique_count	float	[pt] Total de e-mails de rejeitados
email_clicked_rate	float	[pt] Taxa de cliques em comparação com o número de e-mails entregues
email_clicked_unique_count	float	[pt] Total de cliques únicos por lead
email_delivered_count	float	[pt] Total de e-mails entregues
email_delivered_rate	float	[pt] Taxa de entrega
email_dropped_count	float	[pt] Total de e-mails descartados
email_opened_rate	float	[pt] Taxa de abertura em comparação com o número de e-mails entregues
email_opened_unique_count	float	[pt] Total de aberturas únicas por lead
email_spam_reported_count	float	[pt] Total reportado como spam
email_spam_reported_rate	float	[pt] Taxa de spam em comparação com o número de e-mails entregues
email_unsubscribed_count	float	[pt] Total não inscrito
metric_end_date	timestamp
updated_at	timestamp
workflow_id	text	[pt] Id da automação
workflow_name	text	[pt] Nome da automação

Asset analytics

This integration is available only for Pro accounts (with a 45-day history limit) or Advanced accounts - other plans won't return data
The API returns data starting from January 2022. The data is consolidated and provided in UTC format.

Replication type: Incremental

Parameters:

Read start date (Savepoint): Data replication start date based on metric date
Period: Time granularity of the data
Update window: How many periods will be updated at each pipeline run

Relationships:

asset_id → Landing pages > id
asset_id → Pop Ups > id
asset_id → Forms > id

Campo	Tipo
metric_start_date	timestamp
asset_id	text	[pt] Identificador único do "Asset Landing pages > > id Pop Ups > > id Forms > > id
account_id	text	[pt] Identificador único da conta do RD Station relacionada aos dados retornados
asset_identifier	text	[pt] Nome ou identificador textual do ativo
asset_type	text	[pt] Tipo do ativo (exemplo: Landing Page)
asset_created_at	timestamp	[pt] Data em que o ativo foi criado
asset_updated_at	timestamp	[pt] Data da última atualização no ativo
visits_count	float	[pt] Número total de visitas ao ativo durante o período solicitado
conversion_count	float	[pt] Número total de conversões geradas pelo ativo no período solicitado
conversion_rate	float	[pt] Taxa de conversão do ativo
metric_end_date	timestamp

Notes

Webhook Configuration

To finish configuring the webhook RD pipeline, follow the steps below:

1) It will be necessary to create a token on the Kondado platform so that the RD can send us data securely. At the top right, click your email and then Settings

2) On the settings page, click on the TOKENS menu and then on New token

3) Give the New Token a name (eg RD Token) and then click CREATE

4) After clicking CREATE, only this time Token Key and Token will be displayed. Copy these values into a text editor and click OK to continue with the tutorial

If you have not copied the Token value, it will not be displayed again. In this case, deactivate the previously generated key and restart the tutorial from step (4) onwards

5) Now, let's first create the pipeline and then continue the process. Go to the Kondado platform pipelines section and click on New Pipeline

6) Select your data destination, and as a data source use the one created in step (2)

7) Then select Leads (webhook) as the object to be replicated

8) Follow the normal creation flow and add a new pipeline

9) Once the pipeline is created, notice that the URL that will be in your browser's address bar will look something like

https://app.kondado.com.br/pipelines/123456

Copy the value after “pipelines/“, in this example it will be the value 123456 – this is your pipeline id (pipeline_id) and will be used next

10) Now login to RDStation marketing

11) In the upper right menu, click on “My account” and then on “Integrations”

12) On the integrations page, access the “My Integrations” tab, look for the “Webhooks” section and click on “Configure"

13) On the new screen, click on “Create Webhook”

14) In the popup that will open, fill in the information as follows:

Name: A name for internal use, for example “New Webhook”
URL: Fill in the URL by replacing values as instructed below:
Use https://k1.kondado.com.br?pipeline_id={pipelineid}&token={token}&key={tokenkey} replacing the values as follows:
- In {pipelineid} replace with the value obtained in step 11 (for example, 123456)
- In {token} replace with the value of the Token obtained in step 6 (it will be a large alphanumeric value and without hyphens)
- In {tokenkey} replace it with the value of the Token Key obtained in step 6 (it will be a smaller value than the token, and has hyphens)
Trigger: Select the trigger that will send data to the webhook:
- When sending Conversion data, leads that converted in RDStation Marketing will be sent, in addition you can choose below the Conversion Events that will be considered or leave blank to send all conversions:
- According to the RD Station website: “If the conversions are carried out in a Landing Page, Form or Pop-up of RD Station Marketing, the identifier will be the title of the page/name of the element created; if it is integrated (integrated forms, API, etc), they can be identified by the conversion identifier”
- When sending Opportunity data, leads marked as Opportunity will be sent – only after being marked as an opportunity (little star) manually or by an automation flow

In each execution of the integration, data from leads with the same id will be read only once. This means that if you use the same pipeline_id in the URL of different webhooks – for example one for Conversion and another for Opportunity, if a lead is sent twice, only one of these events will be considered. Therefore, we recommend that you create different integrations for Conversion and Opportunity – just repeat the step by step from step 7 for each Trigger, it is not necessary to create another token or another connector

15) Now just click on “Save Webhook” and you will see your new webhook that will start sending the data to your data warehouse or spreadsheet!

Historical Data

Webhook data is sent to its destination only from the time the webhook is created.

To send the leads that are already registered in your RD Station account (historical load), just click here and follow our tutorial

Only conversion events in RD Station cause leads to be sent to the webhook and thus replicated into your destination. If you want lead information to update in your destination when other types of lead changes are made, such as stage changes that don't set up conversion events, follow that tutorial here.

Tips on mismatches between integration and RD Station tool data

1) If you notice that any contact is not being sent to your destination table, we recommend checking that all conversion events are being correctly sent to the integration URL (check step 16 of the tutorial on this page).

2) Only conversion events in RD Station cause leads to be sent to the webhook and thus integrated into your destination. If you want lead information to update in your destination when other types of lead changes are made, such as stage changes that don't set up conversion events, follow that tutorial here.

3) Webhook data is sent to its destination only from the time the webhook is saved. To send contacts that are already registered in your RD Station account (historical load), just click here and follow our tutorial.

4)Some RD dashboard indicators are calculated differently. For example, the number of Leads on the dashboard shows all visitors who have at least one conversion in the period, whether it be the first one or not. Understanding what each metric in the tool's reports means is important for identifying possible divergences with the views created from Kondado's integration data. We recommend reading the RD Station documentation pages listed below to understand these differences:

5) Meaning of each metric in RD Station reports

6) RD Station dashboard indicators explained

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