The structured entities support the database schema by capturing key details on customer incentives and transactions. They record data on coupons, promotions, subscriptions, and payment methods. They also enable effective integration and analysis across applications such as Campaign+, Metrics, 360 Profile, and Interactive Queries.

The following are the promotional entities:

• Coupon: Stores details about individual coupons or discount codes. It acts as a dimension table.
• Promotion: Holds information on marketing campaigns and special offers. It acts as a dimension table.
• Coupon History: Tracks the usage history of coupons by customers, which includes redemption details. It acts as a fact table.
• Subscription: Contains information about customer subscriptions, such as type and duration. It acts as a child table. 
• Payment Method: Stores information on available payment options for customers. It acts as a child reference table.

Use cases¶

The following are the use cases:

• Tracking coupon usage and effectiveness: Stream data on individual coupons to monitor redemption rates and the effectiveness of promotional campaigns.
• Managing promotions and marketing campaigns: Stream promotion data to analyze campaign reach, customer engagement, and Return on Investment (ROI).
• Recording coupon redemption history: Track historical data on coupon redemptions to understand customer preferences and optimize future offers.
• Monitoring subscription status and history: Stream subscription data to manage customer membership statuses, renewal rates, and usage patterns.
• Capturing and organizing payment method preferences: Stream data on customer payment methods to streamline processing and gain insights into preferred options.