1
Case Study: In-App Advertising Feed & Loyalty Programme
Условие
Context: A bank is developing an in-app advertising feed. The feed features Shop products, Stays, and Plane tickets. Objectives: Increase sales from advertising and increase user engagement in the app as a whole and in the widget.
Data Schemas:
Table 1: shop_transactions
transaction_id (STRING/UUID), user_id (STRING/UUID), merchant_id (STRING/UUID), total_amount (FLOAT), cashback_used (FLOAT), cashback_earned (FLOAT), transaction_date (TIMESTAMP), status (STRING), bonus_cashback_flag (BOOLEAN), created_at (TIMESTAMP)Table 2: stay_transactions
transaction_id (STRING/UUID), user_id (STRING/UUID), hotel_id (STRING/UUID),…