Generic Attributes

Generic Attributes	This is not a data set but rather a set of attributes that can give information to the client on the result set returned by the query
correlationID	totalCount	operatorID
pageInfo > hasPreviousPage	pageInfo > hasNextPage

Activity

Field Name	Field Type	Description
consumerID	Long	Identifier for the Consumer/Player
wager	Decimal	Wagering amount of the Consumer/Player
grossGamingRevenue	Decimal	Gross Gaming Revenue generated by the Consumer/Player
bonus	Decimal	Bonus amount of the Consumer/Player
brandID	Int	Identifier for the Brand
productID	Int	Identifier for the Product
subProductID	Int	Identifier for the Sub-Product
consumerCurrencyID	Short	Currency identifier of the Consumer Player. The Currency IDs may vary by operator. A list of Currency IDs can be requested from NetRefer
source	String	Device/Source of the Consumer/Player
sourceURL	String	Marketing Source/Referral URL of Consumer/Player
points	Decimal	Customer loyalty points generated on the day
transactions	Decimal	The number of transactions done by the customer
payouts	Decimal	Money given to the customer when a bet is won
timestamp	DateTime	Timestamp of Consumer/Player Activity
lastUpdated	DateTime	Indicates the date and time when the record was last updated

Affiliate

Field Name	Field Type	Description
affiliateId	Int	Identifier for the Affiliate
name	String	The name of the affiliate associated
companyRegistrationNumber	String	The official registration number assigned to the Affiliate's company
email	String	The email address associated with the affiliate
phoneNumber	String	The phone number associated with the affiliate
address	String	The registered address associated with the affiliate
country	String	The country where the affiliate is registered or located
state	String	The state or province of the affiliate. It must be a valid US or Canadian State
status	String	Indicates the current status of the affiliate
brandList	String	The list of brands associated with the affiliate
paymentMethod	String	The payment method configured for the affiliate
paymentDetails	String	The payment details associated with the affiliate
minimumPaymentValueAmount	Decimal	The minimum payment amount required for the affiliate to receive a payment
payeeName	String	Name of the configured payee associated with the affiliate
taxRegistrationCountry	String	The country where the affiliate is registered for tax purposes
taxRegistrationState	String	The state or province where the affiliate is registered for tax purposes. It must be a valid US or Canadian State
taxRegistrationNumber	String	The tax registration number assigned to the affiliate by the relevant tax authority
timeStamp	DateTime	Timestamp of affiliate creation
lastUpdated	DateTime	Indicates the date and time when the record was last updated
currency	String	The currency used for the affiliate’s payments and financial transactions

AffiliateDailyStats

Field Name	Field Type	Description
affiliateId	Int	Identifier for the Affiliate
brandId	Int	Identifier for the Brand
country	String	The country where the affiliate is registered or located
timestamp	DateTime	Timestamp of affiliate creation
productId	Int	Identifier for the Product
depositingCustomers	Int	Number of Depositing Customers. In the NetRefer system, Depositing Customers are customers that have deposited money on the operator's website for the date range viewed in the report. These are also known as 'Real Money Players'
newDepositingCustomers	Int	Number of New Depositing Customers. In the NetRefer system, New Depositing Customers are newly registered customers who have also made a deposit. To be defined as a New Depositing Customer, a Customer has to both sign up and deposit within the date range or date (if daily) filtered for in the report
firstTimeDepositingCustomers	Int	Number of First Time Depositors. In the NetRefer system, First Time Depositors (FTDs) are customers that deposited on the Operator’s website for the first time within a specified date range, irrelevant of whether they have signed up within that same date range or not
activeCustomers	Int	Number of Active Customers. In the NetRefer system, a Customer is considered as an Active Customer when they start generating gross revenue (either positive or negative representing wins or losses). If a Customer does not make a deposit and uses bonus or leftover money to generate revenue, they will still be considered as an Active Customer
newActiveCustomers	Int	Number of New Active Customers. In the NetRefer system, a New Active Customers is a newly registered customer who has also generated gross revenue, either positive or negative. To be defined as a New Active Customer, a customer has to both signup and generate revenue within the date range or date (if daily) filtered for in the report
firstTimeActiveCustomers	Int	Number of First Time Active Customers. In the NetRefer system, First Time Active Customers (FTAs) are customers that have generated revenue for the first time within a specified date range, irrelevant of whether they have signed up within that same date range or not
turnover	Decimal	Wagering generated by the players linked to the Affiliate
grossGamingRevenue	Decimal	Gross Gaming Revenue generated by the players linked to the Affiliate
bonus	Decimal	Bonus generated by the players linked to the Affiliate
adjustmentFee	Decimal	Any financial adjustments/fees that may be added/deducted from Affiliates’ Rewards
netRevenue	Decimal	Net Revenue generated by the players linked to the Affiliate
payout	Decimal	Payouts generated by the players linked to the Affiliate

AffiliateNetwork

Field Name	Field Type	Description
affiliateNetworkID	Int	Identifier for the Affiliate Network
affiliateNetworkName	String	Name of the Affiliate Network

AffiliateReward

Field Name	Field Type	Description
affiliateId	Int	Identifier for the Affiliate
rewardPlanId	Int	Identifier for the Reward Plan
productId	Int	Identifier for the Product
brandId	String	Identifier for the Brand List associated
marketingSourceId	String	Identifier for the Marketing Source
yearMonth	Int	The year and month associated with the Affiliate Reward generated
currencyExchangeRate	Decimal	The exchange rate used to convert amounts between the relevant currencies
playersContributions	String	The contributions made by players during the relevant period
totalPlayersContributions	Int	The total contributions made by players during the relevant period
rewardedOnComposition	String	Indicates the composition of rewards granted to players during the relevant period
revenueShareReward	Decimal	Revenue Share rewarded to the Affiliate during the relevant period
cpaReward	Decimal	CPA (Cost per Acquisition) rewarded to the Affiliate during the relevant period
fixedSumReward	Decimal	Fix sum rewarded to the Affiliate during the relevant period. It can be negative
subAffiliateReward	Decimal	Sub-Affiliate reward associated to the Affiliate during the relevant period
costPerMedia	Decimal	Cost per Media reward associated to the Affiliate during the relevant period
dynamicBonus	Decimal	Dynamic Bonus associated to the Affiliate during the relevant period
guaranteedRewardDifference	Decimal	Guarantee Reward rewarded to the Affiliate during the relevant period
otherReward	Decimal	Other rewards that are not revenue share reward, CPA reward or sub-affiliate rewards, associated to the Affiliate during the relevant period
totalReward	Decimal	The total rewards granted by the Affiliate during the relevant period
insertDateTime	DateTime	The date and time when the record was created

AffiliateStats

Field Name	Field Type	Description
affiliateId	Int	Identifier for the Affiliate
brandId	Int	Identifier for the Brand
country	String	The country where the affiliate is registered or located
yearMonth	Int	The year and month associated with the Affiliate generated stats
productId	Int	Identifier for the Product
depositingCustomers	Int	Number of Depositing Customers. In the NetRefer system, Depositing Customers are customers that have deposited money on the operator's website for the date range viewed in the report. These are also known as 'Real Money Players'
newDepositingCustomers	Int	Number of New Depositing Customers. In the NetRefer system, New Depositing Customers are newly registered customers who have also made a deposit. To be defined as a New Depositing Customer, a Customer has to both sign up and deposit within the date range or date (if daily) filtered for in the report
firstTimeDepositingCustomers	Int	Number of First Time Depositors. In the NetRefer system, First Time Depositors (FTDs) are customers that deposited on the Operator’s website for the first time within a specified date range, irrelevant of whether they have signed up within that same date range or not
activeCustomers	Int	Number of Active Customers. In the NetRefer system, a Customer is considered as an Active Customer when they start generating gross revenue (either positive or negative representing wins or losses). If a Customer does not make a deposit and uses bonus or leftover money to generate revenue, they will still be considered as an Active Customer
newActiveCustomers	Int	Number of New Active Customers. In the NetRefer system, a New Active Customers is a newly registered customer who has also generated gross revenue, either positive or negative. To be defined as a New Active Customer, a customer has to both signup and generate revenue within the date range or date (if daily) filtered for in the report
firstTimeActiveCustomers	Int	Number of First Time Active Customers. In the NetRefer system, First Time Active Customers (FTAs) are customers that have generated revenue for the first time within a specified date range, irrelevant of whether they have signed up within that same date range or not
turnover	Decimal	Wagering generated by the players linked to the Affiliate during the relevant period
grossGamingRevenue	Decimal	Gross Gaming Revenue generated by the players linked to the Affiliate during the relevant period
bonus	Decimal	Bonus generated by the players linked to the Affiliate during the relevant period
adjustmentFee	Decimal	Any financial adjustments/fees that may be added/deducted from Affiliates’ Rewards during the relevant period
netRevenue	Decimal	Net Revenue generated by the players linked to the Affiliate during the relevant period
payout	Decimal	Payouts generated by the players linked to the Affiliate during the relevant period
revenueShareReward	Decimal	A Revenue Share Reward rewarded to the Affiliate during the relevant period
cpaReward	Decimal	CPA (Cost per Acquisition) rewarded to the Affiliate during the relevant period
subAffiliateReward	Decimal	A Sub-Affiliate rewards associated to the Affiliate during the relevant period
otherReward	Decimal	Other rewards that are not revenue share reward, CPA reward or sub-affiliate rewards, associated to the Affiliate during the relevant period
totalReward	Decimal	The total rewards granted by the Affiliate during the relevant period

Brand

Field Name	Field Type	Description
brandID	Int	Identifier for the Brand
brandName	String	The name of the brand
brandURL	String	Adserver URL associated with the brand
brandDecommissioned	Short	Indicates whether the brand has been decommissioned. A value of 1 indicates the brand is decommissioned, while 0 indicates the brand is active

Click

Field Name	Field Type	Description
timestamp	DateTime	The date and time when the click occurred
country	String	The country associated with the click
state	String	The state or province associated with the click. Applicable only for clicks from US or Canadian states
marketingSourceID	Int	Identifier for the Marketing Source
mediaID	Int	Identifier for the Media
zoneName	String	The name of the media zone associated with the click
browserID	Int	Identifier for the Browser
operatingSystem	String	The operating system used by the player when the click occurred
mediaGroupID	Int	Identifier for the Media Group
affiliateID	Int	Identifier for the Affiliate
lastUpdated	DateTime	The date and time when the record was last updated
clickCounts	Int	The total number of clicks recorded for the Affiliate
uniqueClickCounts	Int	The total number of unique clicks recorded for the Affiliate

CustomerReward

Field Name	Field Type	Description
yearMonth	Int	The year and month associated with the Affiliate generated Rewards
affiliateId	Int	Identifier for the Affiliaate
playerId	Long	Identifier for the Consumer/Player
productId	Int	Identifier for the Product
brandId	Int	Identifier for the Brand
country	String	The country where the Affiliate is registered or located
commissionType	String	Identifier for the Reward Plan Type
reward	Decimal	Affiliate reward associated to the Player
commissionPlanId	Int	Identifier for the Reward Plan
criteriaType	String	Criteria Type of the Reward Plan associated to the Player

Deposit

Field Name	Field Type	Description
consumerID	Long	Identifier for the Consumer/Player
depositAmount	Decimal	Amount deposited
brandID	Int	Identifier for the Brand
consumerCurrencyID	Short	Identifier for the currency of the Consumer/Player. This ID may vary by operator. A list of Consumer Currency IDs can be requested from NetRefer
timestamp	DateTime	Timestamp of Deposit

EndofPeriodPayment

Field Name	Field Type	Description
paymentIdList	String	The list of payment IDs associated with the record
affiliateID	Int	Identifier for the Affiliate
paymentPeriod	Int	The period for which the payment is calculated or processed
paymentStatus	String	Indicates the current status of the payment
paymentGeneratedDate	DateTime	The date and time when the payment was generated
currencyID	Short	Identifier for the Currency Consumer/Player. The Currency IDs may vary by operator. A list of Currency IDs can be requested from NetRefer
totalGrossPayment	Decimal	The total payment amount before any deductions, fees, or taxes are applied
tax	Decimal	The tax amount applied to the payment
totalNetPayment	Decimal	The total payment amount after applicable taxes, fees, and other deductions
fixedPaymentsList	String	Fixed Sum List if available for affiliate in the given period
rewardPlanPaymentsList	String	Affiliate payments that have been generated for the given period for the affiliate apart from fixed sum and amount not equal to 0
marketingSourcePaymentsList	String	'Cost Per Media' commissiontype that has been generated as Affiliate payments for the given period for the affiliate and reward not equal to 0 by mapping the Reward Plan criteria type

FixedPayment

Field Name	Field Type	Description
affiliateID	Int	Identifier for the Affiliate
name	String	The name or description of the fixed payment associated with the Affiliate
description	String	The description of the fixed payment associated with the record
periodFrom	String	The start date of the period covered by the Fixed Payment
periodTo	String	The end date of the period covered by the Fixed Payment
type	String	The type of fixed payment
amount	Decimal	The amount associated with the fixed payment
fixedPaymentID	Int	Identifier for the Fixed Payment

MarketingSource

Field Name	Field Type	Description
marketingSourceId	Int	Identifier of the Marketing Source ID
marketingSourceName	String	The name of the Marketing Source
marketingSourceURLURI	String	The Marketing Source URL
marketingSourceType	String	The type of the Marketing Source
marketingSourceCategory	String	Source Categories of the Marketing Source
offlineTrackingCode	String	Offline Tracking Codes associated to the Affiliate
affiliateId	Int	Identifier for the Affiliate
rewardPlanId	Int	Identifier for the Reward Plan applied to the Marketing Source
usedCostPerMedia	Boolean	Identifier if the Marketing Source is used in Cost Per Media Reward Plans. A value of 1 indicates the Marketing Source is used for Cost Per Media rewarding, while 0 indicates it is not used
status	String	Status of the Marketing Source
lastUpdated	DateTime	The date and time when the record was last updated

Media

Field Name	Field Type	Description
mediaId	Int	Identifier for the Media
mediaType	String	The type of Media
mediaName	String	The name of Media
brandId	Int	Identifier for the Brand
productId	Int	Identifier for the Product
language	String	The language associated with the media
currency	String	The currency associated with the media
defaultBanner	Boolean	Indicates whether the media is configured as the default banner
bannerSize	String	The size or dimensions of the banner associated with the media
format	String	The format of the media
validFrom	DateTime	The date and time from which the media is valid or available for use
validTo	DateTime	The date and time until which the media is valid or available for use
htmlCode	String	The HTML code associated with the media
mediaSourceUrl	String	The URL of the source associated with the media
mediaCategory	String	Media categories to categorise media items into groups
timestamp	DateTime	The date and time associated with the media record
keywords	String	The keywords associated with the media
description	String	The description of the media associated with the record
lastUpdated	DateTime	The date and time when the record was last updated
landingPageList	String	The list of landing pages associated with the media, also known as ‘Target URL’
mediaGroup	String	The group to which the media belongs
localeList	String	List of Locals (languages) the media is linked to
status	String	Indicates the current status of the media

Player

Field Name	Field Type	Description
consumerID	Long	Identifier for the Consumer/Player
registrationTimestamp	DateTime	Timestamp of Consumer/Player registration
bTag	String	Banner Tag
consumerCountry	String	Country of the Consumer/Player
consumerState	String	State of the Consumer/Player Country. Applicable only for players from US or Canadian states
username	String	Username of the Consumer/Player in Operator system
brandID	Int	Identifier for the Brand
consumerCurrencyID	Short	Identifier for the Currency. The Currency IDs may vary by operator. A list of Currency IDs can be requested from NetRefer
consumerStatus	String	Status of the Consumer/Player
affiliateID	Int	Identifier for the Affiliate
source	String	Identifier of the Marketing Source
sourceName	String	Marketing Source Name associated with the player
rewardPlanID	Int	Identifier for the Reward Plan
customerTypeID	Int	Identifier for the Consumer/Player Type
cpaProcessed	Boolean	Indicates whether the player CPA has been processed. A value of 1 indicates processed, while 0 indicates not processed
expired	Boolean	Indicates whether the player has expired. A value of 1 indicates expired, while 0 indicates not expired
lastUpdated	DateTime	The date and time when the record was last updated

playerTransactions

Field Name	Field Type	Description
consumerId	Long	Identifier for the Consumer/Player
brandId	Int	Identifier for the Brand
timestamp	DateTime	Timestamp of Consumer/Player registration
transactionIDs	String	Identifier for the Transactions. Available only with Data Ingestion or CSV To API data transfer methods

Product

Field Name	Field Type	Description
productID	Int	Identifier for the Product
productName	String	Name of the Product

RewardPlan

Field Name	Field Type	Description
rewardPlanID	Int	Identifier for the Reward Plan
rewardPlanName	String	Name of the Reward Plan
affiliates	String	The Affiliate IDs associated with the Reward Plan
lastUpdated	DateTime	The date and time when the record was last updated

SubAffiliate

Field Name	Field Type	Description
affiliateID	Int	Identifier for the Affiliate
parentAffiliateID	Int	Identifier for the Parent Affiliate

View

Field Name	Field Type	Description
timestamp	DateTime	The date and time associated with the view
country	String	The country associated with the view
state	String	The state or province associated with the View. Applicable only for views from US or Canadian states
marketingSourceID	Int	Identifier for the Marketing Source
mediaID	Int	Identifier for the Media
zoneName	String	The name of the media zone associated with the view
browserID	Int	Identifier for the browser
operatingSystem	String	The operating system used by the player when the view occurred
mediaGroupID	Int	Identifier for the Media Group
affiliateID	Int	Identifier for the Affiliate
lastUpdated	DateTime	The date and time when the record was last updated
viewCounts	Int	The total number of views recorded
uniqueViewCounts	Int	The total number of unique views recorded

Withdrawal

Field Name	Field Type	Description
consumerID	Long	Identifier for the Consumer/Player
withdrawalAmount	Decimal	Amount Withdrawn
brandID	Int	Identifier for the Brand
consumerCurrencyID	Short	Identifier of Currency of the Consumer/Player. The Currency IDs may vary by operator. A list of Currency IDs can be requested from NetRefer
timestamp	DateTime	Timestamp of Withdrawal

LandingPage

Field Name	Field Type	Description
landingPageID	Long	Unique identifier of the landing page
landingPageName	String	Name of the landing page
landingPageURL	String	URL of the landing page
language	String	Language configured for the landing page