ConversionReport Model

A report detailing Conversions. For more information, see: help.tune.com/hasoffers/using-the-conversion-report/.

NameTypeDescription
Advertiser.companyNullable String The name of the Advertiser company
Advertiser.ref_idNullable String Optional ID used to reference offers or campaigns in advertisers' third-party systems
AdvertiserManager.full_nameNullable String The first and last names of the Employee who is the account manager for the Advertiser
Affiliate.companyString The name of the Affiliate company
Affiliate.ref_idNullable String Optional ID used to reference offers or campaigns in affiliates' third-party systems
AffiliateManager.full_nameNullable String The first and last names of the Employee who is the account manager for the Affiliate
Browser.display_nameNullable String The name of the Browser
ConversionMeta.noteNullable String A note, visible to the Affiliate
ConversionsMobile.adv_sub2Nullable String ID of Advertiser Sub object 2
ConversionsMobile.adv_sub3Nullable String ID of Advertiser Sub object 3
ConversionsMobile.adv_sub4Nullable String ID of Advertiser Sub object 4
ConversionsMobile.adv_sub5Nullable String ID of Advertiser Sub object 5
ConversionsMobile.android_idNullable String ID of (Mobile) Android object
ConversionsMobile.android_id_md5Nullable String ID of (Mobile) Android object MD5
ConversionsMobile.android_id_sha1Nullable String ID of (Mobile) Android object SHA1
ConversionsMobile.device_brandNullable String (Mobile) Device Brand
ConversionsMobile.device_idNullable String ID of (Mobile) Device object
ConversionsMobile.device_id_md5Nullable String ID of (Mobile) Device object MD5
ConversionsMobile.device_id_sha1Nullable String ID of (Mobile) Device object SHA1
ConversionsMobile.device_modelNullable String (Mobile) Device Model
ConversionsMobile.device_osNullable String (Mobile) Device Operating System
ConversionsMobile.device_os_versionNullable String (Mobile) Device Operating System Version
ConversionsMobile.google_aidNullable String (Mobile) Google AID
ConversionsMobile.google_aid_md5Nullable String (Mobile) Google AID MD5
ConversionsMobile.google_aid_sha1Nullable String (Mobile) Google AID SHA1
ConversionsMobile.ios_ifaNullable String (Mobile) iOS IFA
ConversionsMobile.ios_ifa_md5Nullable String (Mobile) iOS IFA MD5
ConversionsMobile.ios_ifa_sha1Nullable String (Mobile) iOS IFA SHA1
ConversionsMobile.ios_ifvNullable String (Mobile) iOS IFV
ConversionsMobile.mac_addressNullable String (Mobile) MAC Address
ConversionsMobile.mac_address_md5Nullable String (Mobile) MAC Address MD5
ConversionsMobile.mac_address_sha1Nullable String (Mobile) MAC Address SHA1
ConversionsMobile.mobile_carrierNullable String (Mobile) Carrier
ConversionsMobile.odinNullable String (Mobile) ODIN
ConversionsMobile.unknown_idNullable String ID of (Mobile) Unknown object
ConversionsMobile.user_idNullable String ID of (Mobile) User object
ConversionsMobile.windows_aidNullable String (Mobile) Windows AID
ConversionsMobile.windows_aid_md5Nullable String (Mobile) Windows AID MD5
ConversionsMobile.windows_aid_sha1Nullable String (Mobile) Windows AID SHA1
Country.nameNullable String The name of the Country
Customer.provided_idNullable String ID of A reference object for the Customer
Goal.nameString Name of the goal. Returns the string "Default" for unnamed default goals.
Offer.nameString The name of the Offer
Offer.ref_idNullable String ID of An optional object used to reference campaigns or offers in 3rd party systems
OfferUrl.nameNullable String The name of the Offer URL
OfferUrl.preview_urlNullable String The preview link for the Offer URL
PayoutGroup.idNullable IntegerThe ID of the Payout Group for this Conversion. For more information, see: http://support.hasoffers.com/hc/en-us/articles/202305336-Payout-Revenue-Groups.
PayoutGroup.nameNullable String The name of the Payout Group for this Conversion. For more information, see: http://support.hasoffers.com/hc/en-us/articles/202305336-Payout-Revenue-Groups.
RevenueGroup.idNullable IntegerThe ID of the Revenue Group for this Conversion. For more information, see: http://support.hasoffers.com/hc/en-us/articles/202305336-Payout-Revenue-Groups.
RevenueGroup.nameNullable String The name of the Revenue Group for this Conversion. For more information, see: http://support.hasoffers.com/hc/en-us/articles/202305336-Payout-Revenue-Groups.
Stat.ad_idString ID of Transaction object created by the Ad Server
Stat.advertiser_idIntegerID of Advertiser object If no Advertiser is set, defaults to "0".
Stat.advertiser_infoNullable String Advertiser sub passed in by the Advertiser when the conversion pixel / URL called
Stat.advertiser_manager_idIntegerThe ID of the Employee who is the account manager for the Advertiser. If none is set, defaults to "0".
Stat.affiliate_idIntegerID of Affiliate object
Stat.affiliate_info1Nullable String Affiliate sub 1 passed in by the Affiliate when the session was started
Stat.affiliate_info2Nullable String Affiliate sub 2 passed in by the Affiliate when the session was started
Stat.affiliate_info3Nullable String Affiliate sub 3 passed in by the Affiliate when the session was started
Stat.affiliate_info4Nullable String Affiliate sub 4 passed in by the Affiliate when the session was started
Stat.affiliate_info5Nullable String Affiliate sub 5 passed in by the Affiliate when the session was started
Stat.affiliate_manager_idIntegerThe ID of the Employee who is the account manager for the Affiliate. If none is set, defaults to "0".
Stat.approved_payoutDecimalThe amount of payout for approved conversions. If a single conversion, this is the same as "Stat.payout", but if aggregating this is the sum of the payouts of the approved Conversions.
Stat.approved_rateDecimalIf aggregating, this is the proportion of grouped conversions whose status is "approved"
Stat.browser_idIntegerThe ID of the Browser. If a Browser was not identified, defaults to "0".
Stat.countIntegerAn aggregate counting function that returns the total number of conversions represented by the row
Stat.count_adjustmentIntegerAn aggregate counting function that returns the number of Conversions which are adjustments in the row
Stat.count_approvedIntegerAn aggregate counting function that returns the number of Conversions whose status is "approved" in the row
Stat.count_pendingIntegerAn aggregate counting function that returns the number of Conversions whose status is "pending" in the row
Stat.count_rejectedIntegerAn aggregate counting function that returns the number of Conversions whose status is "rejected" in the row
Stat.country_codeString The country code
Stat.creative_url_idIntegerThe ID of the Offer URL. If none is set, defaults to "0".
Stat.currencyNullable String Currency (3-letter code); available when Multiple Currencies is set to "Enabled".
Stat.customer_idIntegerID of Customer object If none is set, defaults to "0".
Stat.dateDate The Date the Conversion was generated
Stat.datetimeDatetimeThe Date (with time) the Conversion was generated
Stat.datetime_diffString The difference between when the session was started and when the Conversion was generated
Stat.goal_idIntegerID of Goal object If none is set, defaults to "0".
Stat.hourIntegerHour part (0 to 23) from "Stat.datetime".
Stat.idIntegerID of unique object for the conversion
Stat.ipNullable String IP address that created the conversion
Stat.is_adjustmentBoolean Flag to mark if the conversion was created as an adjustment. For more information, see: http://support.hasoffers.com/hc/en-us/articles/202266913-Adjusting-Stats#adjust-conversions.
Stat.monthIntegerMonth part (1 to 12) from "Stat.datetime".
Stat.net_payoutDecimalThe payout amount for approved Conversions. If used with group-bys this is the sum of approved Conversion payouts in the row.
Stat.net_revenueDecimalThe revenue amount for approved Conversions. If used with group-bys this is the sum of approved Conversion revenues in the row.
Stat.net_sale_amountDecimalThe sale amount for approved Conversions. If used with group-bys this is the sum of approved Conversion sale amounts in the row.
Stat.offer_idIntegerID of Offer object
Stat.offer_url_idIntegerID of Offer URL object. If none is set, defaults to "0".
Stat.payoutDecimalThe Affiliate payout for this Conversion
Stat.payout_typeString The Offer (or Goal, if applicable) payout typeShow Supported Values
Stat.pending_payoutDecimalThe payout amount for pending Conversions. If used with group-bys this is the sum of pending Conversion payouts in the row.
Stat.pending_revenueDecimalThe revenue amount for pending Conversions. If used with group-bys this is the sum of pending Conversion revenues in the row.
Stat.pending_sale_amountDecimalThe sale amount for pending Conversions. If used with group-bys this is the sum of pending Conversion sale amounts in the row.
Stat.pixel_referNullable String Referral URL for the conversion pixel
Stat.referNullable String Referral URL where session was started
Stat.rejected_rateDecimalIf aggregating, this is the proportion of grouped conversions whose status is "rejected"
Stat.revenueDecimalThe amount of revenue generated by this Conversion
Stat.revenue_typeString The Offer (or Goal, if applicable) revenue typeShow Supported Values
Stat.sale_amountDecimalThe sale amount
Stat.session_dateDate The date part (YYYY-MM-DD) of the "Stat.session_datetime".
Stat.session_datetimeDatetimeThe date and time that the session was started
Stat.session_ipString The IP address used to start the session
Stat.sourceString Affiliate source passed in by the Affiliate when the session was started
Stat.statusString Status of the ConversionShow Supported Values
Stat.status_codeIntegerThe code providing granular status details. See: Conversion Status Codes
Stat.user_agentNullable String User agent for user when session was started
Stat.weekIntegerThe week in which "Stat.datetime" took place. Range is 1 to 53, where week 1 is the first week with four (4) or more days. Weeks begin on Monday.
Stat.yearIntegerYear part (YYYY) from "Stat.datetime".
Have a Question? Please contact support@tune.com for technical support.