Goals

Using integrated first-party data to drive business result and going beyond marketing to make business decisions.

A dashboard also created to measure the performance of activations specific to the loyalty program or segments.

Approach

Using first-party data in BigQuery, the metrics needed are created with SQL and then visualized in LookerStudio.

Results/Answers

• Engagement Rates
• Active Loyal Rates (Formal Program = Monthly Active Loyal Users)
• Content Reach
• Loyalty Post / Coupon Reach
• Loyalty Program Adoption / Sign Ups
• Time to Return Process (Customer Service)
• Loyalty Rates (Over Time)
• Churn Rate
• Upsell / Cross-sell rates
• Average Annual Customer Value