Loyalty Marketing Manager

Code Name

ORA_LOY_LOYALTY_MARKETING_MANAGER_JOB

Duty Roles

This job role is related to the following duty roles:

• Loyalty Managerial Transaction Analysis Duty

Subject Areas

This job role secures access to the following subject areas:

• Loyalty - Member Status Real Time

• Loyalty - Member Tier Real Time

• Loyalty - Members Real Time

• Loyalty - Membership Trend Real Time

• Loyalty - Partner Point Usage Real Time

• Loyalty - Point Balances Real Time

• Loyalty - Transactions Real Time

• Loyalty - Voucher Status Trend Real Time

• Loyalty - Vouchers Real Time

Business Questions

This job role secures access to data that can answer the following business questions:

• How many accrued points are available at the start and end of a period for each member?

• How many partner points are credited on a particular processed date, day, or month?

• How many vouchers are available at the start and end of a period over a calendar month?

• How are members distributed among the program tiers?

• What is the total liability of the loyalty program?

• How many vouchers are available for Gold Tier members?

• How many partner points are consumed, credited, or debited for a particular member based on various member dimensions ?

• How does the average number of status changes compare between different programs or tiers?

• How many active members are in the loyalty program?

• What is the number of redemptions in the program?

• What is the average number of days to move to a higher tier level for each member group?

• What is the change in the number of closed vouchers over a period of a calendar week?

• How many status changes occurred under a given program?

• What is the number of transactions by partner and product?

• How many new members were added to a program in a previous month?

• What member names belong to each member type?

• What is the number of accruals for each member?

• How many vouchers are in Used status?

• How many partner points are consumed on a particular processed date, day, or month?

• How many partner points are consumed, credited, or debited for a particular transaction dimension?

• How many canceled members are in the loyalty program?

• How many times have statuses changed from Active to Inactive within a date range?

• How many points are expiring in the next 90 days for each member type?

• How do different Promotions compare on Liability Growth Rate over a rage of time?

• How many vouchers are issued to members?

• How many partner points are debited on a particular processed date, day, or month?

• Which members were added through referrals?

• What is the membership growth rate since the start of the program?

• How many members have moved to a higher tier level for each tier?

• What is the change in the number of available points in the period over the point balances week end date?

• What is the trend of Points Earning, Points Burning, and Breakage rates over a range of time?