customer segmentation


customer segmentation


I have a daily aggregate table, which gives details about customer's activity - existing, new etc. There is a new requirement to identify customers who are "reactivated" within a certain time period.

To pre-build an aggregate table for reactivation customers based on a specific time period is easy - say 45 or 60 or n # of days. This is easy..

But there is a need to build an aggregate table to find all "reactivation" customers let us say in the last 2 weeks or last 3 weeks or last 3 days. This means that a dynamic list has to be prepared using daily level aggregation and it wont be a static table. Is there an easy way of building it in Teradata? I think in Oracle, we can use materialized views.

Appreciate your response.

Senior Apprentice

Re: customer segmentation

Hi Vas,
could you post some more details, especially DDL & some INSERTs & expected answer set?

This sounds like a task for OLAP functions.