Entities used in daily reporting and processing that are not loaded into BQ by the Analytics team.
Entity | Source | Description | Used in |
|---|---|---|---|
ROI_fact.Flats_GS | Google sheets | Contains flat-rate transaction data for ROI calculations, sourced from Google Sheets. | Total_bills |
ROI_fact.Flats_history_GS | Google sheets | Historical flat-rate transaction records used for trend analysis and ROI tracking. | Total_bills |
ROI_fact.Prepaid_GS | Google sheets | Prepaid transaction data for ROI and billing purposes. | Total_bills |
SHORT_LINK_STATS: crusino richardcasino slotozen staycasino wantedwin | External Integration | Aggregated statistics on short link usage across multiple brands. | visits_report |
SLOTO_EVENTS_US SLOTO_EVENTS STAY_EVENTS WANTEDWIN_EVENTS RICHARD_EVENTS CRUSINO_EVENTS | External integration | Consolidated event logs from various platforms for user activity tracking. | stag_optim_form logins |
staging.Referers_live | Google sheets | Live data on traffic referers, used for session and login attribution. | …_amplitude_sessions logins_dep |
clean.bonustag_live | Google sheets | Active bonus tag assignments for user accounts and betting activities. | Bonus_tag Bonus_for_bets |
vadymk_personal.CRM_Camps_type_live | Google sheets | Live CRM campaign type definitions for marketing segmentation. | clean.crm_campaign_type |
clean.countries_codes | Static table | Standardized list of country codes for traffic and user segmentation. | aff_trafic |
clean.country_code | Static table | Lookup table for country codes, used for data normalization. | ar_report |
antir_personal.PPC_spends | Google sheets | Pay-per-click advertising spend data for marketing analytics. | MB_spends |
clean.finance_result | Static table | Financial results summary for ROI and performance reporting. | ROI_table_NK |
STAG_MODIFIER.execution_stats | Static table | Execution statistics for staging modifiers, used in optimization. | stag_optim_form |
task_temporary.UNI_PartnerId | Google sheets | Temporary mapping of unique partner IDs for affiliate tracking. | aff_users |
clean.vip_routing_partners | Static table | List of VIP routing partners for specialized reporting. | ar_report |
clean.Wallet_names | Static table | Standardized wallet names for payment and reporting consistency. | ar_report |
clean.bin_table | Static table | Bank Identification Number (BIN) reference for payment processing. | ar_report PAYMENTS.grouped_declines |
staging.decline_groups | Static table | Groupings of payment declines for categorization and analysis. | decline_mapping |
PAYMETNS.grouped_declines | External integration | Aggregated data on grouped payment declines from external sources. | PAYMENTS.grouped_declines |
PAYMETNS.decline_types | External integration | Definitions of payment decline types for reporting and troubleshooting. | PAYMENTS.grouped_declines |
PAYMENTS.stay_failed_payments | External integration | Records of failed payment attempts for the "Stay" brand. | PAYMENTS.grouped_declines |