Saturday, July 26, 2008

Customer data model for analytics

Which DATA INPUTS are required to answer the business question

Out of the plethora of business questions which frame the 'optimal contact strategy for a stores loyalty card' holders, What data inputs are required to answer the business question. In this case its

1. Loyalty card membership information
2. POS Data of loyalty card holders
3. Purchase channel

Ellaborating Loyalty card information further we have
- Loyalty card number
- Customer name
- Member since
- Profession
- Age / Date of birth
- Sex
- City
- State
- Zip

Ellaborating POINT OF SALE data furtger we have
- Store identifier
- Purchase date
- Total Purchase amount
- Product identifier
- Product quantity
- Product value

No comments: