Ascend
Ascend by partnerise, ETL connector for data replication
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
- Sign in to Daton
- Select Ascend from Integrations page
- Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
- In the next step you will be asked to enter ascend api key
- Post successful authentication you will be prompted to choose required tables from the list
- Then select all required fields
- Submit the integration
Workflow
- 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
- Users would be able to edit/pause/re-activate/delete integration anytime
- 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 |
