Segment Names In Recurring Communication
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.


Segment Names In Recurring Communication Expand / Collapse
Author
Message
Posted 12/4/2008 3:04:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/22/2009 10:04:45 AM
Posts: 3, Visits: 13
Hello,

I'm currently setting up a recurring commmunication for one of the communications that we run every 2 weeks.

I've succeeded in getting it to run correctly and on time. I also see that each time it runs the "child" communciation has a date stamp added to its name. However, in each child run the same segment name is applied to the output file. So if I load the output files from two runs and key off of segment name (as our downstream vendor does) there is no way to tell who was in which communication.

Is there a way to add a date parameter to the segment name in a recurring communication?

Thanks,
Adam
Post #13765
Posted 12/4/2008 4:17:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/22/2009 1:29:51 PM
Posts: 7, Visits: 11

Is it possible to also key off other fields? Or, perhaps, add an extra field to the layout?

The easiest unique identifier would be to use ecamp_id. This will be different for each run. You could use this in conjunction with the segment name.

Or, you could incorporate this as part of the segment name, or, for that matter, a date variable.

If you're not already using a view for output, you could create a view, then...have one of the view fields defined as:

trim(segment_name) || '-' || trim(ecamp_id) as segment_name

or

trim(segment_name) || '-' || trim(current_date) as segment_name

You'd have to mess around with the format statement for the date to get it the way you want, and perhaps mess around the concatenation construct (not sure I like the dash '-' but...it's a starting place).

Or, simply output both the segment name and the ecamp_id into 2 separate fields. The ecamp_id is stored in the internal CRM tables, so if you ever needed to tie back to anything from your campaign, you'd have the ecamp_id on the list to do so.
Post #13766
Posted 8/30/2009 9:56:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 8/30/2009 11:49:52 PM
Posts: 1, Visits: 2
Glad to hear you're using this: I plan to keep it much more aggressively up-to-date than has been the case in the past, but don't hesitate to let me know if you find errors or need clarifications.

Cheers!
Natalyah
[/color][color=#FFFFFF]Une simulation credit auto instannee et facile ici si vous avez une
voiture[/color][/color]
Post #16709
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 7:54pm

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.047. 10 queries. Compression Disabled.