Data dictionary
The fields below define one record of bonus terms. They are fixed before collection so that every coder, and every reader, uses the same definitions.
Short answer
A record holds eighteen fields describing one bonus offer's written terms on one capture date: offer type, wagering multiplier and its base, time limit, maximum stake, withdrawal cap, game contribution and minimum deposit. Amounts are in Canadian dollars, durations in days, and every missing value carries a reason code instead of a blank.
Conventions
- Field names are lower case with underscores, and are the column names of the future CSV file.
- Types:
text,integer,decimal(point as separator, no thousands separator),date(ISO 8601, YYYY-MM-DD),category(one value from a closed list). - Amounts are Canadian dollars as written in the terms. Terms in another currency are excluded, not converted.
- Missing values are never left blank. They use one of the reason codes listed under missing values.
Record and capture fields
| Field | Type | Unit or format | Definition |
|---|---|---|---|
record_id |
text | opaque identifier | Unique within a release. Carries no operator or offer name. |
capture_date |
date | YYYY-MM-DD, Eastern Time | Day the terms text was saved. |
window_id |
text | release window label | Collection window the record belongs to. |
jurisdiction |
category | closed list | Market the terms are published for. Scope for the first release: to be confirmed. |
source_type |
category | terms_page, bonus_policy_page |
Kind of public page the text was saved from. |
Offer fields
Offer type
| Value | Meaning |
|---|---|
deposit_match |
A bonus calculated as a percentage of a qualifying deposit. |
no_deposit |
A bonus granted without a qualifying deposit. |
free_spins |
A set number of spins on specified games. |
reload |
A deposit-linked bonus for an existing account. |
cashback |
A credit calculated on net losses over a period. |
other |
Any offer type not listed; described in the coding notes. |
| Field | Type | Unit or format | Definition |
|---|---|---|---|
offer_type |
category | see above | Kind of offer the terms describe. |
match_rate_pct |
decimal | percent | Bonus as a share of the qualifying deposit. Only for deposit-linked offers. |
bonus_cap_cad |
decimal | Canadian dollars | Largest bonus amount the terms allow. |
min_deposit_cad |
decimal | Canadian dollars | Smallest deposit that qualifies. |
wagering_multiplier |
decimal | times (x) | Number of times the base must be wagered, as written. |
wagering_base |
category | bonus, deposit_plus_bonus, winnings, none |
Amount the multiplier applies to. Required whenever a multiplier is present. |
wagering_days |
decimal | days | Time allowed to complete the wagering. Hours are divided by 24. |
max_stake_cad |
decimal | Canadian dollars | Largest single stake allowed while the bonus is active. |
withdrawal_cap_cad |
decimal | Canadian dollars | Largest amount of bonus-derived winnings that can be withdrawn. |
withdrawal_cap_stated |
category | cap, no_cap_stated |
Whether the terms set a withdrawal cap. |
slots_contribution_pct |
decimal | percent | Share of a slot stake that counts toward wagering. |
table_contribution_pct |
decimal | percent | Share of a table-game stake that counts toward wagering. |
coding_note |
text | free text | Short note on any ambiguity. Never contains an operator or offer name. |
Missing values
A blank cell cannot tell a reader whether the clause is absent, irrelevant or unreadable. Each missing value therefore carries one reason code:
| Code | Meaning | Counted in |
|---|---|---|
NS |
Not stated: the terms say nothing about this clause. | "Not stated (%)" |
NA |
Not applicable: the clause cannot exist for this offer type (for example, a match rate on a no-deposit offer). | Excluded from the denominator |
UC |
Unclear: the wording allows more than one reading, even after arbitration. | "Unclear (%)" |
Statistics are computed on the records that hold a value. The shares of NS and UC are printed next to every figure, as percentages of the records in scope (all records except NA). NA records are left out of both the figure and its denominator.
Versions and revisions
A release will be identified by its collection window and a version number. No version has been released, so the numbers below only illustrate the scheme.
- Major version (hypothetical example: a future 2.0): a change to the protocol or to this dictionary, such as a new field or a changed definition. Figures from different major versions will not be directly comparable, and the change will be described on the methodology page.
- Minor version (hypothetical example: a future 1.1): a correction within the same protocol, such as a coding error found after release. The corrected figures will replace the old ones in the tables, and the old values will stay visible in the revision log on the observations page.
- Withdrawal: if a figure cannot be corrected, it will be withdrawn, and the revision log will say so.
The first release will be numbered 1.0.
Aggregate file (CSV)
With the first release, the published figures will also be offered as a CSV file: one row per indicator (and per category for categorical indicators), comma-separated, UTF-8, with the columns below. Record-level data is not part of this file.
| Column | Type | Definition |
|---|---|---|
release_version |
text | Version of the release. |
window_id |
text | Collection window of the release. |
indicator |
text | Field name from this dictionary. |
wagering_base |
category | Base of the multiplier; empty for other indicators. |
category |
text | Category value, for categorical indicators only. |
records_in_scope |
integer | Records where the clause could apply (all except NA). |
records_with_value |
integer | Records in scope holding a value. |
median |
decimal | Median of the records with a value (numeric indicators). |
p25 |
decimal | 25th percentile (numeric indicators). |
p75 |
decimal | 75th percentile (numeric indicators). |
mean |
decimal | Mean of the records with a value; not a headline figure. |
share_pct |
decimal | Share of records with a value in this category (categorical indicators). |
not_stated_pct |
decimal | NS records as a percentage of records in scope. |
unclear_pct |
decimal | UC records as a percentage of records in scope. |