StatReport Model

A report detailing stats (clicks, conversions, impressions) over time. For more information, see: help.tune.com/hasoffers/using-the-stats-report/.

NameTypeDescription
AdCampaign.nameNullable String The name of the Ad Campaign
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
Category.idNullable IntegerID of Offer Category object; note: Including this field can cause duplicate rows if an offer belongs to more than one Category
Category.nameNullable String The name of the Offer Category; note: Including this field can cause duplicate rows if an offer belongs to more than one Category
Country.nameNullable String The name of the Country
Goal.nameString The name of the Goal. Returns the string "Default" for unnamed default goals.
Offer.display_advertiserString Whether or not the Advertiser is visible to users who otherwise lack permission to view them in the application
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
OfferFile.displayString The display name of the OfferFile
OfferUrl.nameString The name of the Offer URL
OfferUrl.preview_urlString The preview link for the Offer URL
Stat.ad_campaign_creative_idIntegerThe Ad Campaign Creative ID
Stat.ad_campaign_idIntegerID of AdCampaign object
Stat.advertiser_idIntegerID of Advertiser object
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_countIntegerAn aggregate field counting the distinct number of Affiliate IDs
Stat.affiliate_idIntegerID of Affiliate object
Stat.affiliate_info1String Affiliate sub 1 passed in by the Affiliate when the session was started
Stat.affiliate_info2String Affiliate sub 2 passed in by the Affiliate when the session was started
Stat.affiliate_info3String Affiliate sub 3 passed in by the Affiliate when the session was started
Stat.affiliate_info4String Affiliate sub 4 passed in by the Affiliate when the session was started
Stat.affiliate_info5String 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.browser_idIntegerThe ID of the Browser. If a Browser was not identified, defaults to "0".
Stat.clicksIntegerAn aggregate field counting the number of clicks
Stat.conversionsIntegerAn aggregate field counting the number of conversions
Stat.countIntegerAn aggregate field counting the number of matching rows
Stat.country_codeString The country code
Stat.cpaDecimalCost per Acquisition, Payout per Conversion: (Stat.payout / Stat.conversions).
Stat.cpcDecimalCost per Click, Payout per Click: (Stat.payout / Stat.clicks).
Stat.cpmDecimalCost per Thousand Impressions: (Stat.payout / (Stat.impressions / 1000)).
Stat.creative_url_idIntegerThe ID of the Offer URL. If none is set, defaults to "0".
Stat.ctrDecimalClick through Rate: (Stat.clicks / Stat.impressions); note: If the "track_uniques" Preference is enabled, this is (Stat.unique_clicks / Stat.impressions).
Stat.dateDate The date of the event
Stat.device_brandNullable String Brand of the device
Stat.device_modelNullable String Model of the device
Stat.device_osNullable String OS of the device
Stat.device_os_versionNullable String OS Version of the device
Stat.epcDecimalEarnings per click: ((Stat.revenue - Stat.payout) / Stat.clicks).
Stat.erpcDecimalElectronic Rate Per Click. This refers to the amount paid out to the Affiliate per click.
Stat.goal_idIntegerID of Goal object If none is set, defaults to "0".
Stat.gross_clicksIntegerSum of gross clicks
Stat.gross_ctrDecimalGross Click through Rate: (Stat.gross_clicks / Stat.impressions).
Stat.hourIntegerHour (0 to 23) of the event
Stat.impressionsIntegerSum of impressions
Stat.ltrDecimalLead through Rate: (Stat.conversions / Stat.clicks); note: If the "track_uniques" Preference is enabled, this is (Stat.conversions / Stat.unique_clicks).
Stat.mobile_carrierNullable String Carrier of the device
Stat.monthIntegerMonth (1 to 12) of the event
Stat.offer_countIntegerAn aggregate field counting the distinct number of Offer IDs
Stat.offer_file_idIntegerID of OfferFile object If none is set, defaults to "0".
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 amount
Stat.payout_typeString The Offer (or Goal, if applicable) payout typeShow Supported Values
Stat.profitDecimalThe amount of profit (Stat.revenue - Stat.payout).
Stat.revenueDecimalThe amount of revenue generated
Stat.revenue_typeString The Offer (or Goal, if applicable) revenue typeShow Supported Values
Stat.rpaDecimalRevenue per Acquisition, Revenue per Conversion: (Stat.revenue / Stat.conversions).
Stat.rpcDecimalRevenue per Click: (Stat.revenue / Stat.clicks); note: If the "track_uniques" Preference is enabled, this is (Stat.revenue / Stat.unique_clicks).
Stat.rpmDecimalRevenue per Thousand Impressions: (Stat.revenue / (Stat.impressions / 1000)).
Stat.sale_amountDecimalThe sale amount
Stat.sourceString Affiliate source passed in by the Affiliate when the session was started. Empty string if none.
Stat.unique_clicksIntegerThe sum of unique clicks
Stat.unique_ctrDecimalUnique Click through Rate: (Stat.unique_clicks / Stat.impressions).
Stat.weekIntegerThe week in which the event 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.yearIntegerThe year (YYYY) the event took place
Have a Question? Please contact support@tune.com for technical support.