Program ID Unique identifier of the program |
| ||||||
Program Name Name of the program |
| ||||||
Program Currency Currency of the program |
| ||||||
Program Market Market of the program |
| ||||||
Year Year such as 2017. |
| ||||||
Year Quarter Year and quarter. |
| ||||||
Year month Year and month. |
| ||||||
Year week Year and week. |
| ||||||
Date Year, month, and day. |
| ||||||
Year month day hour Year, month, day, and hour. |
| ||||||
Quarter of the year Quarter of the year |
| ||||||
Month of the year Month of the year |
| ||||||
Week of the year Week of the year |
| ||||||
Month and day Month and day |
| ||||||
Day of the week Week of the year |
| ||||||
Day of the month Day of the year |
| ||||||
Hour of the day Hour of the day |
| ||||||
Channel Affiliate ID Numerical ID of a partner account. |
| ||||||
Channel Affiliate Name Name of the partner. Individual or company. |
| ||||||
Channel ID Numerical ID of a channel. |
| ||||||
Channel Name Name of a channel. |
| ||||||
Channel Description A description of a channel. |
| ||||||
Channel URL The URL of a channel, if applicable. |
| ||||||
Channel Channel Type The type of a channel, such as Blog, Content, Facebook, Cashback, etc. |
| ||||||
Channel Approval Status Approval status of a channel for a partner program: 0 = rejected, 1 = approved, 2 = pending review |
| ||||||
Channel Application Date The date when the channel first applied to join your program. |
| ||||||
Channel Reject Reason Available when approvalStatus is set to: 0. The reason for the program application being rejected, where: 0 = Not enough content/posts, 1 = Not relevant content, 2 = A closed site/group/account, 3 = 404 on site, 4 = Site does not exist, 5 = Wrong contact details / shady details, 6 = Unethical content, 7 = Incorrect site owner, 8 = Missing info about the channel. No URL/link, 9 = To few followers/visitors, 10 = Poor design, 11 = Traffic is not relevant. 12 = Outdated content |
| ||||||
Channel Reject Reason Text Available when approvalStatus is set to: 0. The reason for the program application being rejected. |
| ||||||
Ad ID Numerical ID of an ad |
| ||||||
Ad Name Name of banner or link |
| ||||||
Ad Type Type of banner or link |
| ||||||
Click Date UTC timestamp of the click that generated the transaction |
| ||||||
Click Status Current status of the click, where Fresh means still in cookie duration and Stale means outside cookie duration. |
| ||||||
Segment ID Numerical Adtraction ID of the segment |
| ||||||
Segment Name The name of the segment |
| ||||||
Transaction Cost The cost of the transaction, including partner commission and Adtraction platform fee. |
| ||||||
Transaction Currency Currency in ISO 4217 format |
| ||||||
Transaction Payment Status Specifies what payment status of transaction should be included in the dataset. 1 = not invoiced, 2 = invoiced to advertiser, 3 = ready for payment, 4 = paid to partner |
| ||||||
Transaction Order ID Advertiser order ID |
| ||||||
Transaction Order Value Order value of the transaction |
| ||||||
Transaction Reason Text For rejected transactions (transactionStatus = 5) you may choose to provide the reason for the transaction being rejected. |
| ||||||
Transaction Transaction Date UTC timestamp of when the transaction was reported by the advertiser. |
| ||||||
Transaction Last Updated UTC timestamp of when the transactionStatus or orderValue of the transaction was last updated. Only available for transactions where transactionStatus or orderValue has been updated. |
| ||||||
Transaction Auto Approval Date Date when a pending transaction (transactionStatus = 2) will be automatically approved unless already approved or rejected. |
| ||||||
Transaction Name Name of the transaction |
| ||||||
Transaction Status The status of the transactions to be included in the dataset. Impressions and clicks are not affected by this input. 1 = approved, 2 = pending, 3 = approved + pending, 4 = open claims, 5 = rejected |
| ||||||
Transaction ID Unique ID for the transaction |
| ||||||
Transaction Device The type of device that was used to complete the transaction |
| ||||||
Transaction Operating System The operating system used on the device that was used to complete the transaction |
| ||||||
Transaction Geo Location The geographic market where the transaction was completed, defined by an ISO 3166-1 Alpha-2 country code |
| ||||||
Clicks Number of clicks |
| ||||||
Unique Clicks Number of unique clicks |
| ||||||
Cost The total cost of the transaction, including partner commission and platform fee |
| ||||||
Impressions Number of banner / links impressions |
| ||||||
Unique Impressions Number of unique banner / links impressions |
| ||||||
Order Value Order value of the sale transactions |
| ||||||
Leads Number of lead transactions |
| ||||||
Sales Number of sale transactions |
| ||||||
CTR Click Through Ratio, obtained by dividing clicks by impressions |
| ||||||
Lead Ratio Lead Ratio, obtained by dividing leads by clicksUnique |
| ||||||
Conversion Ratio Conversion Ratio, obtained by dividing sales by clicksUnique |
| ||||||
Average Order Value Average order value, obtained by dividing order value by number of sale transactions |
| ||||||
Week of the year (start Sunday) Week of the year |
| ||||||
Commission Amount of partner commission |
| ||||||
EPC Earnings Per Click obtained by dividing the commission by clicksUnique |
| ||||||
Extracted Date The date where the extraction take times. |
| ||||||
Platform Name Return the platform name |
|