The transaction API is used to call the transactions. To do this, the following parameter must be appended to the API call:
API | parameter |
|---|---|
transactions | get-statistic_transactions |
Example: https://www.domain.de/api//ACCESS-TOKEN/publisher/ID/get-statistic_transactions.csv
For the transaction API there are additional parameters that can be queried. Below is a list of all parameters:
Transaction API filters
parameter | value | description | example |
|---|---|---|---|
condition[l:advertiser] | ID of the advertiser as integer. | All transactions that are stored under the given advertiser ID within the program. | condition[l:advertiser]=1 |
condition[l:projects] | ID of the project as integer. | All transactions that are stored under the given project ID within the program. | condition[l:projects]=1234 |
condition[l:campaigns] | ID of the campaign as integer. | All transactions that are stored under the given campaign ID within the program. | condition[l:campaigns]=1 |
condition[timetype] | 0 = creation date | All transactions that have been created/processed/payed out in a certain period. | condition[timetype]=1 |
Definition of the fields delivered by the transaction api
The columns of downloaded transactions contain the following parameters:
criterion | encrypted transaction id |
trackingtime | timestamp of the transaction |
advertiser_id | id of the advertiser within the system |
campaign_title | title of the campaign |
campaign_id | id of the campaign within the system |
project_id | id of the project |
project_title | title of the project |
event | type of transaction – lead, sale, bonus |
payoutdate | Payout date - empty if not payed out yet, format: YYYY-MM-DD HH:MM:SS |
processingdate | Processing time - empty if not processed yet, format: YYYY-MM-DD HH:MM:SS |
salary_id | internal salary id, -1 if not payed out yet |
salary | Credit note number – document can be downloaded as unter settings =>billing |
clicktime | timestamp of the click - format: YYYY-MM-DD HH:MM:SS |
subid | Subid you passed in click / postview - default: NONE |
referrer | The click referrer if determinable – default: ://NONE |
admedia_id | admedia id which led to the transaction |
status | 0 = open | 1 = confirmed | 2 = canceled | 3 = paid |
reason_of_cancellation | cancel reason (if given) |
provision | your provision |
turnover | net basked value |
trigger_id | internal id of the event |
trigger_title | name of the event |
basket_count | in case of basket-tracking, the number of items in the basket, otherwise 0 |