Loyalty - Point Balances Real Time

Description

Use this subject area to analyze and report on members' points that are accrued, redeemed, expired and available, and the change in these points over a period.

This subject area provides analysis on the members' point trends such as change in point balances, total liability, and so on in real time. Loyalty marketing managers can filter the available facts based on dimensions such as Point Type, Program, Tier, and various Calendar attributes.

Business Questions

This subject area 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 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?

• 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?

Job Roles

The following job roles secure access to this subject area:

• Loyalty Marketing Manager

• Loyalty Program Administrator

Duty Roles

The following duty roles secure access to this subject area:

• Loyalty Administrative Transaction Analysis Duty

• Loyalty Managerial Transaction Analysis Duty

Primary Navigation

Navigator > Loyalty > Loyalty Members > Point Balances

Time Reporting

This subject area supports historical and trend reporting of Point Accruals, Redemptions, Expirations and Balances.

Time dimension is linked to Point Balance Date.

Transactional Grain

The grain of this subject area is the combination of Time, Member, Tier, Program, Point Type, Promotion, Partner, and Product.

Special Considerations

None.