targeting in CRM TERADATA
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


targeting in CRM TERADATA Expand / Collapse
Author
Message
Posted 11/21/2006 3:56:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 1/10/2007 7:11:00 AM
Posts: 5, Visits: 1
I have a rather complex question about the use of the targeting in CRM TERADATA. If I want to make the targeting on a client relationship. For example: For example, is it possible to target the 35 years old customers having a 28 years old wife?. Is it possible? Can i go up in the customer hierarchy to target the spouse?
Thank you
Post #5906
Posted 11/22/2006 8:31:01 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Moderators
Last Login: 7/21/2008 2:27:50 PM
Posts: 24, Visits: 9
Thank you for your post. I am working to get you an answer on this question. Will post as soon as I get all the information.
Post #5923
Posted 11/22/2006 8:41:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 1/10/2007 7:11:00 AM
Posts: 5, Visits: 1
thanks a lot
Post #5924
Posted 11/22/2006 8:54:01 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Moderators
Last Login: 7/21/2008 2:27:50 PM
Posts: 24, Visits: 9
Here is an answer for you.

Yes, this can be done if the data is available and mapped. You would have to have at least 2 levels of the hierarchy mapped, (Household, Individual) and be able to show relationship (primary, spouse) and have age available.

We may have a reference account doing something like this if you're interested in pursuing further.
thank you again for your post.
Post #5925
Posted 11/22/2006 9:03:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 1/10/2007 7:11:00 AM
Posts: 5, Visits: 1
Thank you for your answer
But the information « age of spouse » must be present in the principal client table ???
Post #5926
Posted 11/22/2006 9:54:31 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Moderators
Last Login: 7/21/2008 2:27:50 PM
Posts: 24, Visits: 9
Not sure I understand the last question. Can you clarify a little more please. thanks
Post #5927
Posted 11/22/2006 10:06:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 1/10/2007 7:11:00 AM
Posts: 5, Visits: 1
It is a CRM projet for a bank.
We have a table client and a table for the relation between clients (for the relations like ,spouse ,children , partner….).
For exemple, We want to target the client who have a visa card and which the spouse don’t have it.
Is it more clear ??


thanks
Post #5928
Posted 12/5/2006 9:42:48 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Moderators
Last Login: 7/21/2008 2:27:50 PM
Posts: 24, Visits: 9
Sorry for the delay on getting this to you. See if this makes sense.


They need to have the information about each individual in the household, and then they need to have the relationship to the primary member…so then they could choose a spouse within a certain age range that did not have a particular product. The relationship would allow you to do something like pick best.
Post #5981
Posted 12/5/2006 9:55:59 AM