...
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 |
...
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 |