posted 10 years ago
One of the user requirements is to mark down the customers
that have never spent since last 6 months.
This is basically done by a joined query.
Now the client asks me how to take care of the customers
whom have been followed but still not yet done any spending afterwards.
They asked me to export a list of customer who haven't spent since last 6 months.
After this list has been followed, the customers, sometimes, will not be dealt with
anymore.
Do you think it is not good idea to open up another table?
and just dump the list to Excel, and let the user deal with them manually
But if I am, how do I store this kind of information.
The customer table is not a good choice, I think.
What do you think?
Thanks
Jack