Payout report glossary

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

 

Articles in this section

Sign in
Start building your links and earning commission
Provide feedback
We are always looking for ways to improve your experience. Please tell us what you think.