Ascend
Ascend by partnerise, ETL connector for data replication
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 |
CreativePerformance | PublisherDetails |
ItemisedProductTransaction | PaymentsAndFees |
PublisherPerformance | OrderCommissionRule |
TransactionHistory | |
- 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
- 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
- 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
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Last modified 3mo ago