[Phased out] V1 API documentation
The Affiliate Reporting API provides access to the affiliate reports, within a given period.
Only request the data for the period you need and prevent unnecessarily large reports from being requested |
Non-required fields from schema won’t be present in the response if they’re null. |
Orders
In this overview, the following data is shown per product: the order number, order date, product title, website, promotional tool, name, subid, number of products, sales price, commission, commission percentage, status and product category (GPC).
Field descriptions
Field Name |
Description |
orderNumber |
The identifier of the order. |
orderDate |
The date when the order was placed. (yyyy-MM-dd) |
productTitle |
The title of the product ordered. |
productId |
The unique identifier for the product. |
siteName |
The name of the site where the order originated from. |
frameType |
The promotion type used by the affiliate link (e.g., "Tekstlink", "Productlink"). |
name |
The name given to the affiliate link. |
subId |
The identifier given to the affiliate link. |
quantity |
The quantity of the product ordered. |
priceIncludingVat |
The price of the order item including VAT (Value Added Tax). |
priceExcludingVat |
The price of the order item excluding VAT. |
commission |
The commission earned on the order item. This does not take returns and cancellations into account. |
commissionPercentage |
The commission rate as a percentage of the order item value. |
status |
The current status of the order item (e.g., "Open", "Geaccepteerd", "Geweigerd"). |
chunkName |
The name of the product category. |
Promotion
In the promotional tool overview you can see the results of your promotional tools per day, website, promotional tool, name, and subid. The results include clicks, impressions, click-through rate (CTR), commission, earnings per click (EPC), order quantity, conversion, turnover and average order value (AOV).
Data in this dataset is grouped by: date, siteName, frameType, name, subId. |
Field descriptions
Field Name |
Description |
date |
The date when the order was placed. (yyyy-MM-dd) |
siteName |
The name of the site where the order originated from. |
frameType |
The promotion type used by the affiliate link (e.g., "Tekstlink", "Productlink"). |
name |
The name given to the affiliate link. |
subId |
The identifier given to the affiliate link. |
clicks |
The number of clicks recorded. |
impressions |
The number of impressions recorded. |
clickThroughRate |
The ratio of clicks to impressions. |
commission |
The total commission earned. This does not take returns and cancellations into account. |
earningsPerClick |
The amount earned per click. |
earningsPerMille |
The earnings per 1000 impressions. |
orders |
The number of orders. |
conversion |
The conversion rate. |
revenueExclVat |
The total revenue excluding VAT (Value Added Tax). |
revenueInclVat |
The total revenue including VAT. |
averageOrderValue |
The average value of each order. |
Commission
In this overview you will find your commission and turnover per day, website, promotional tool, name, subid and commission percentage. In this file you will also find a breakdown of approved and outstanding turnover and commission, and the number of products purchased.
Data in this dataset is grouped by: orderDate, siteName, frameType, name, subId and commissionPercentage. |
Field descriptions
Field Name |
Description |
orderDate |
The date when the order was placed. (yyyy-MM-dd) |
siteName |
The name of the site where the order originated from. |
frameType |
The promotion type used by the affiliate link (e.g., "Tekstlink", "Productlink"). |
name |
The name given to the affiliate link. |
subId |
The identifier given to the affiliate link. |
commissionPercentage |
The commission percentage of the order item. |
commissionOriginal |
The original commission amount calculated for the order. |
commissionApproved |
The approved commission amount. |
commissionOpen |
The open commission amount. |
revenueOriginalExclVat |
The original revenue excluding VAT (Value Added Tax). |
revenueOriginalInclVat |
The original revenue including VAT. |
revenueApprovedExclVat |
The approved revenue excluding VAT. |
revenueApprovedInclVat |
The approved revenue including VAT. |
revenueOpenExclVat |
The open revenue excluding VAT. |
revenueOpenInclVat |
The open revenue including VAT. |
quantityPayable |
The quantity of items that are eligible for payment. |