...
Finally, it can be decided in which format the data should be provided. The output of the file is possible in CSV, XLS, XML and JSON. The file extension must be adapted accordingly. The CSV file format is recommended!
Available
...
file formats
file format | parameter |
|---|---|
CSV format - seperated by comma | .csv |
XLS format - default format of Microsoft Excel | .xls |
XML format- extensible markup language | .xml |
...
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 |