Ascend

Ascend by partnerise, ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	20120402
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Api Key
Replication Type	Key Based Replication, Full Replication
Replication Key	Date
Suggested Replication Frequency	1 hour

Tables/APIs Supported

CreativePerformance	PublisherDetails
ItemisedProductTransaction	PaymentsAndFees
PublisherPerformance	OrderCommissionRule
TransactionHistory

Generating Access Token for Ascend

• Login to https://www.ascendpartner.com/
• Click on LogIn

• Enter email and password

• Once logged in, go to Resources > API keys

• You can find the API Key for your account here

• Use this api key while creating an integration with Daton

Integrate Ascend with Daton

1. Sign in to Daton

2. Select Ascend 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. In the next step you will be asked to enter ascend api key

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

6. Then select all required fields

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

Ascend Data

CreativePerformance

Purpose: This API gives performance metrics of Creatives(like banners, coupons etc..)

Source API Documentation: https://support.ascendpartner.com/s/advertiser-api-documentation#CreativeDetails

Replication: Key Based Incremental

Replication Key: startDate, endDate

Fields

Name	Data Type
creative_id	NUMERIC
creative_type	STRING
creative_name	STRING
publisher_id	NUMERIC
publisher	STRING
date	DATE
affiliate_usage	NUMERIC
impressions	NUMERIC
transactions	NUMERIC
clicks	NUMERIC
click_through_rate	STRING
sales	STRING
earnings_per_click	STRING
commission	STRING

ItemisedProductTransactions

Purpose: This API is used to fetch itemised product transactions

Source API Documentation: https://support.ascendpartner.com/s/advertiser-api-documentation#ItemizedTransactions

Replication: Key Based Incremental

Replication Key: startDate, endDate

Fields

Name	Data Type
order_id	STRING
sale_date	DATETIME
status	STRING
publisher_id	NUMERIC
link_type	STRING
publisher_type	STRING
item_category_name	STRING
sale_amount	STRING
commission	STRING
item_name	STRING
publisher	STRING
company	STRING
transaction_id	NUMERIC
item_id	STRING
quantity	NUMERIC

PublisherPerformance

Purpose: This API is used to fetch metrics of each publisher performance

Source API Documentation: https://support.ascendpartner.com/s/advertiser-api-documentation#PublisherPerformance

Replication: Key Based Incremental

Replication Key: startDate, endDate

Fields

Name	Data Type
publisher_id	NUMERIC
date	DATE
impressions	NUMERIC
clicks	NUMERIC
sales	NUMERIC
leads	NUMERIC
sale_lead_amount	STRING
earnings_per_click	STRING
bonus_amount	STRING
total_commission	STRING
site_bonus	STRING
site_commission	STRING
publisher_bonus	STRING
publisher_commission	STRING
publisher_type	STRING
publisher	STRING
company	STRING
state	STRING
website	STRING

TransactionHistory

Purpose: This API is used to fetch publisher transaction history details

Source API Documentation: https://support.ascendpartner.com/s/advertiser-api-documentation#TransactionHistory

Replication: Key Based Incremental

Replication Key: startDate, endDate

Fields

Name	Data Type
publisher_id	NUMERIC
transaction_id	NUMERIC
sale_date	DATETIME
order_id	NUMERIC
status	STRING
link_type	STRING
transaction_type	STRING
publisher_type	STRING
commission	STRING
sale_amount	STRING
publisher_commission	STRING
site_commission	STRING
process_date	DATETIME
revision	NUMERIC
item_id	STRING
publisher	STRING
company	STRING
website_url	STRING

PublisherDetails

Purpose: This API is used to fetch information regarding publisher

Source API Documentation: https://support.ascendpartner.com/s/advertiser-api-documentation#Publisher

Replication: Full Replication

Replication Key: N/A

Fields

Name	Data Type
transparency	NUMERIC
id	NUMERIC
first_name	STRING
last_name	STRING
company	STRING
state	STRING
country	STRING
website	STRING
primary_promotional_method	STRING
status	STRING
request_date	STRING
join_date	STRING

PaymentAndFees

Purpose: This API is used to fetch all the payments and fees paid in the given timeframe

Source API Documentation: https://support.ascendpartner.com/s/advertiser-api-documentation#PaymentsAndFees

Replication: Key Based Incremental

Replication Key: startDate, endDate

Fields

Name	Data Type
id	NUMERIC
date	DATETIME
type	STRING
method	STRING
amount	STRING
description	STRING

OrderComissionRule

Purpose: This API will break down transactions based on how a Dynamic term pays out on the transaction. This is a child table that fetches transaction_ids from transaction_details table(Incremental) internally and uses it to fetch orderComissionRules data.

Source API Documentation: https://support.ascendpartner.com/s/advertiser-api-documentation#OrderCommissionRule

Replication: Key Based

Replication Key: startDate, endDate

Fields

Name	Data Type
id	NUMERIC
order_id	NUMERIC
is_new_to_file	STRING
order_date	DATETIME
sale_amount	STRING
transaction_payout_amount	STRING
transaction_payout_level	NUMERIC
total_publisher_commission	NUMERIC
total_site_commission	NUMERIC
custom_segment_custom_id	STRING
custom_segment_name	STRING
publisher_referral_url	STRING
total_order_commission	STRING
ruleId	NUMERIC
action_type	STRING
action_value	STRING
level	STRING
publisher_commission	NUMERIC
site_commission	NUMERIC
commission	STRING
item_name	STRING
quantity	NUMERIC
category_id	STRING
category_name	STRING
item_price	STRING