...
parameter | value | description | example |
|---|---|---|---|
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 1 = processing date 2 = payout date | All transactions that have been created/processed/payed out in a certain period. | condition[timetype]=1 |
Definitions of columns names
column | description |
criterion | hashed transaction id |
trackingtime | timestamp of transaction |
advertiser_id | advertiser id |
campaign_title | name of the campaign |
campaign_id | campaign id |
project_id | project id |
project_title | title of project |
event | type of transaction e.g. – Lead, Sale, Bonus |
Payoutdate | date of payout |
processingdate | validation date |
salary_id | internal billing id |
salary | invoice number |
clicktime | timestamp of the click |
subid | subid |
referrer | referrer |
admedia_id | admedia id |
status | 0 = open | 1 = valid | 2 = cancelled | 3 = paid |
reason_of_cancellation | Reason of cancellation |
provision | commission of transaction |
turnover | Ordervalue |
trigger_id | ID of the event |
trigger_title | name of the event |
basket_count | in case of enabled basket-tracking, the amount of basket-items |