Below is the glossary of key terms used in the Payout report.
Term | Description | Examples |
conversion_id | Partnerize identifier for the booking | 1101l1936359182 |
campaign_id | Partnerize identifier for the campaign (i.e. the expedia site on which the booking was made) | 100l75 |
publisher_id | Partnerize identifier for the affiliate | 1011l235010 |
conversion_date | Date of the booking | 2/7/2022 |
conversion_date_time | Date time of the booking | 2/7/2022 13:04 |
click_time | Time of the click that resulted in the booking | 14:24:48 |
click_date | Date of the click that resulted in the booking | 1/7/2022 |
click_date_time | Date & Time of the click that resulted in the booking | 1/7/2022 14:24 |
currency | Currency in which the traveller made the payment to Expedia Group | USD |
publisher_reference | Also known as PubRef, it is the reference/data point that an affiliate can pass in a link | - |
advertiser_reference | Also known as AdRef, it is the reference/data point that advertisor's such as Expedia Group can pass in a link | - |
conversion_reference | Booking reference on Expedia Group sites | 9155470000000 |
source_referer | Site that drove the booking | https://www.therooftopguide.com/ |
campaign_title | Name of the Expedia Group website on which the booking was made | Hotels.com USA |
publisher_name | Name of the affiliate | rooftopguide |
conversion_status | Status of the booking. It can be pending, approved and rejected. Pending implies a trip has not yet been completed. Approved implies it has been verified by Expedia Group as a completed booking & Rejected implies that booking has been either cancelled by the user or is not made within the cookie period. | approved |
conversion_lag | Number of seconds elapsed between the click time & the booking time. | 81557 |
publisher_commission | Commission that the affiliate is entitled to receive for this booking | 45.7627 |
creative_type | Optional categorization of the creative was used along with the link, not relevant for Affiliate Hub. | 0 |
creative_id | Optional reference id of the creative used along with the link, not relevant for Affiliate Hub | 0 |
specific_creative_id | Optional reference id of the creative used along with the link, not relevant for Affiliate Hub | 0 |
customer_type | Not populated for Expedia Group Affiliate website partners | |
conversion_item_id | Partnerize reference id of the trip element booked | 1101l765295988 |
sku | Some detail of the trip element booked | 3.5 |
category | Trip element booked (HC is hotel collect) | HC |
item_publisher_commission | Commission that the affiliate is entitled to receive for the particular trip element | 45.7627 |
value | Amount paid by the traveller | 1144.067 |
item_status | Status of the trip element. Can differ from the status of the booking, if there are more than one trip element in a booking. | approved |
approval_date_time | Date time of when the booking was verified as completed by Expedia Group | 24/8/2023 3:10 |