Data Schema (betfred_casino_processed.csv)¶
Describes columns in processed Betfred casino advertising dataset (betfred_casino_processed.csv).
Column Name |
Data Type |
Description |
Notes |
|---|---|---|---|
|
Date |
Date when ad performance was recorded |
|
|
String |
Name of advertising campaign |
e.g., “Mobile Casino |
|
String |
Name of specific ad creative |
e.g., “Ad 3 - june” |
|
String |
Unique identifier for ad creative |
e.g., “6539935727482” |
|
Integer |
Total number of times ad was shown |
|
|
Integer |
Total number of clicks on ad |
|
|
Float |
Total amount spent on ad for given date |
Assumed to be in GBP (£) |
|
Float |
Cost Per Click: Average cost for each click (Cost / Clicks) |
|
|
Float |
Click-Through Rate: Percentage of impressions resulting in click (Clicks / Impressions) |
|
|
Integer |
Number of unique users who saw ad |
|
|
Float |
Average number of times each user saw ad (Impressions / Reach) |
|
|
Integer |
Number of clicks on links within ad leading to destinations on or off platform |
|
|
Integer |
Number of clicks leading people off platform to external website |
|
|
Integer |
Number of times person loaded destination web page after clicking ad |