Ascend
Ascend by partnerise, ETL connector for data replication
Snapshot
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
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
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
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
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
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
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
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 updated