Unbounce

Unbounce ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	2.0
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	unbounce email unbounce password
Replication Type	Full Replication Key based replication
Replication Key	NA lastRunDate
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Global	Accounts
SubAccounts	SubAccountsDomains
SubAccountsPageGroups	Pages
FormFields	Leads

Integrate unbounce with Daton

1. Sign in to Daton

2. Select Unbounce from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your unbounce email and password to authorize Daton to periodically extract data unbounce.

5. Post successful authentication you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Unbounce Data

Global

Purpose: Retrieve the global API meta-information.

Source API Documentation https://developer.unbounce.com/api_reference/#id_

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
documentation	STRING
related	RECORD
supported_formats	STRING
specifications	RECORD

Accounts

Purpose: The accounts collection is the entry point to the rest of the Unbounce API. Your API key will give you access to all of the clients owned by your primary account.

Source API Documentation https://developer.unbounce.com/api_reference/#id_accounts

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
metadata	RECORD
id	NUMERIC
name	STRING
createdAt	TIMESTAMP
state	STRING
options	STRING

SubAccounts

Purpose: Unbounce users can use sub-accounts to manage multiple projects or clients. Each sub-account has it's own collection of pages, domains and other objects.

Source API Documentation https://developer.unbounce.com

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
metadata	RECORD
id	NUMERIC
accountId	NUMERIC
name	STRING
createdAt	TIMESTAMP
website	STRING
uuid	STRING
options	STRING

SubAccountsDomains

Purpose:Retrieve a list of all custom domains belonging to a given sub-account.

Source API Documentation https://developer.unbounce.com/api_reference/#id_sub_accounts__sub_account_id_

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
metadata	RECORD
accountId	STRING
subaccountid	STRING
id	NUMERIC
name	STRING

SubAccountPageGroups

Purpose: Retrieve a list of all page groups for a given sub-account.

Source API Documentation https://developer.unbounce.com/api_reference/#id_sub_accounts__sub_account_id__page_groups

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
metadata	RECORD
id	NUMERIC
accountId	STRING
subaccountid	STRING
name	STRING

Pages

Purpose: Access all pages for the authenticated principal.Any Unbounce customer can be invited to author or view a page on a different client than their own.

Source-Api documentation: https://developer.unbounce.com/api_reference/#id_pages

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
subAccountid	NUMERIC
integrations	RECORD
integrationsCount	NUMERIC
id	STRING
url	STRING
tests	STRING
metadata	RECORD
name	STRING
createdAt	TIMESTAMP
lastPublishedAt	TIMESTAMP
variantsCount	NUMERIC
domain	STRING

FormFields

Purpose: Retrieve a full list of all form fields across all page variants of a specific page.

Source API Documentation https://developer.unbounce.com/api_reference/#id_pages__page_id__leads

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
pageId	NUMERIC
name	STRING
id	STRING
type	STRING
validations	RECORD

Leads

Purpose: There are two sets of data associated with each lead; the form data submitted when the lead was collected, and any optional extra data provided by 3rd party integrations with Unbounce (such as lead scoring or social data).

Source-Api documentation: https://developer.unbounce.com/api_reference/#id_pages__page_id__leads

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
created_at	TIMESTAMP
id	STRING
extra_data	RECORD
form_data	RECORD
page_id	RECORD
variant_id	STRING
submitter_ip	STRING
metadata	RECORD