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