Customers & Marketing

Marketing mailing list q03 Not attempted

Everyone who has opted in to marketing email, for the spring campaign mail-merge.

This page is waiting for query q03. Open student/queries.php and write it.
Customers yet to order q10 Not attempted

Customers who registered but have never bought anything. Marketing wants to send them a welcome voucher.

This page is waiting for query q10. Open student/queries.php and write it.
VIP customers (above average spend) q11 Not attempted

VIP customers: anyone whose lifetime spend beats the average spend across all ordering customers.

This page is waiting for query q11. Open student/queries.php and write it.