Teradata Forums / Marketing Tips and CRM Best Practices / Teradata

Task Broker's Available Servers Location Problem

Usman Ali — Wed, 08 Aug 2007 04:53:16 GMT

Hi,

I am getting a problem regarding Task Broker's Available Servers Locations in 'Task Server Connections' tab of task broker service properties. Previously it was working fine but then my IP got changed and it still has old 'machine name' (IP) associated with the server names and that’s why their status is 'Inactive' because it can't find it on that IP. I have tried 'Load Servers' and restarting task broker service but that didn't help.
Can anyone tell me how to refresh the location of these servers in Task Broker to the new IP/Machine Name?

Thanks in advance

Regards,
Usman Ali

TCRM/TRM Introduction manual/guide

mprade123 — Tue, 03 Nov 2009 16:19:00 GMT

Guys, Can any of you guys help me out by forwarding/attaching some useful docs related to TCRM/TRM. I am new using TCRM and please help me out by passing some docs/pointers.Thanks,Pradeep M

Adding user functions at TRM environment

Fabio — Wed, 16 Jan 2008 11:37:41 GMT

Hello,I would like to know if someone have already tried to add some user function at TCRM 5.2 or TRM 6.0 environments, to be made available as part of the solution to the users. In Java programming, it is called sometimes as "Add-ins" or "Add-ons" features.Example: For some reason, an user may decide to exclude from the segment an specific person or group of persons, belonging to a specific geographic region, from the current campaign. We would like to add a menu item called "Cancel lead groups" to provide user with this functionality, being this developed by ourselves.Thanks in advanced.

Segment Names In Recurring Communication

asmith — Thu, 04 Dec 2008 15:04:13 GMT

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

integrating web data into TCRM

tuttlr — Fri, 26 Jan 2007 11:21:56 GMT

It seems that not many organizations have begun adding web browsing behavior data into their data warehouse. Although almost everyone adds web sales data, browsing behavior is an excellent source of behavior data that can be used for campaign targeting and segmentation. Has anyone been successful in applying web based legends to TCRM as targeting attributes? How difficult was it to setup?

Big Batch Running long

Ince — Thu, 08 May 2008 05:57:38 GMT

HiOur big batch have been automatically scheduled to run everyday from 5pm.Mostly it runs fine during the week,but runs long over the weekend.We do our weekly back ups on weekend, and release all the held jobs to run after completing the back ups,but the biggest problem is that it runs for almost 14hours until we kill it.Normally it runs for 30 minutes.Please advice

Submitted Jobs going to Waiting Status

qjeste — Thu, 07 May 2009 16:09:08 GMT

Hi everyone,I'm new to this forum and thought I should get some help/feedback as to why some jobs go into Wait mode and is put in the Waiting section in my Inbox. Or I would go to the Taskbroker to watch a submitted communication job finish the segment query but the Output Job never appears. I check the errlogs and find in the cps.log file that the file: [i]Base CPS CPS Manager -3.10.94 Retailerization Error: Cannot create file "C:\CIOS\Buffers\MCMC_APPL_DB_BufferRegistry9.dta". The process cannot access the file because it is being used by another process [/i]I'm currently using CRM 5.1 but we plan to go to v6 sometime within the next few months. But while I wait I have this very annoying problem. Any help would be appreciated. I didn't want to have to go and log in an incident until I got some info on why I'm getting the error.Thank in advance for your responses/feedback.Quy

What is the difference between TCRM Analytical Functionality and Tearadata TWM Functionality

SHANTVCI — Fri, 27 Mar 2009 08:48:59 GMT

What are the additional functionality Teradata provides under TCRM than what is available under TWM product of Teradata?

Option Parcel information is invalid

SMay — Mon, 15 Dec 2008 12:36:01 GMT

Hi folks,I'm hoping this is where I should put this topic, since I found a similar one in the same forum. I was hoping I could get some help on an error a user has been getting when trying to run a simple query in Access. Now please, keep in mind, I am not an Access expert in the slightest... I've made simple databases before, but nothing fancy, and definitely nothing utilizing Teradata. Upon running his code:[code] SELECT ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BAN, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.CABS_BILL_DATE, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.JULIAN_DATE, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.CARRIER_ROUTE, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_ZIP_CODE, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_ZIP_SUFFIX, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_NAME_TAG, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_NAME_TYPE, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_CITY_STATE_ZIP, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.CPNI_IND, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILL_NAME_ADDRESS_1, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILL_NAME_ADDRESS_2, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILL_NAME_ADDRESS_3, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILL_NAME_ADDRESS_4, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILL_NAME_ADDRESS_5, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_NAME, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BILLED_ADDRESS, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.CUSTOMER_NAME, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.ACNA, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.ALT_EXCHANGE_COMPANY_NAME, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.CUSTOMER_IND, ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.FINANCIAL_DATA_MONTH INTO SWBTTESTaFROM ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDRWHERE (((ACCESS_VIEWS_R2_V82109_ACCESS_NAME_ADDR.BAN)="6100724017966")); [/code]The user receives an error of:ODBC call failed. [ncr][odbc teradata rdbms] Option Parcel information is invalid. 3749According to a PDF I found, error 3749 is due to Segmented Requests (no clue what that is really) not being support in S, B and P modes (again, no clue what that's referring to). It then goes on to say, "If these requests are submitted in either the S, B or P modes, the Teradata Database would return a failure parcel with the error code set to 3749."Is this the same thing? If so, where on Earth do I go to check these settings/change them? This query was apparently working just fine up until last week and then all of a sudden the user has been getting this.If anyone has any insight, it would be much appreciated!EDIT: To clarify, running a simple query against the DB in QueryBuilder works just fine, as well as executing this full script in Access when he's just viewing the data. However, when he switches it to Make Table, it prompts him telling him that it will display the 7 rows of data, and then blows this error. So... we know the information is there and viewable/accessible, but for whatever reason it doesn't want to be turned into a table. :(

Communication Personalization

Ince — Tue, 02 Dec 2008 02:23:20 GMT

HiI have read this chapter, Real-Time Communications, it says I should load data into IOS_CM_CHANN_CUST for real time event campaigns, the problem is that when I load data into this table, it causes Batch to fail.Has anyone work with Real-Time campaigns?Please help.

Loading Data to IOS tables

Ince — Mon, 01 Dec 2008 10:47:15 GMT

HiDoes anyone knows how to load data into IOS_CMS_CHANN_CUST table, I have tried to load data into this tables and it causing Batch to fail.Please advice.Thanks

how can we skip the multi load statement if the file is empty

rajesh4u4e — Sun, 23 Nov 2008 23:59:23 GMT

Hi I am new to teradata. I am using Teradata on unix. I am facing some problem. can anyone help me please.this is the problem.how can we skip the multi load statement if the file is empty.[b]grep 'test' file1> file2mload statement with file2[/b] Thanks,Rajesh

technologies

allpubs — Sun, 23 Nov 2008 18:06:08 GMT

We like to know if there are technologies like those posted at http://morsi.org/projects/atep/? Thanks

TCRM User Documentation

asmith — Tue, 18 Nov 2008 16:40:02 GMT

Does anyone know of any TCRM user documentation? More specifically, I'm a TCRM user who is new to the tool. My company has the administator documentation that tells me how CPS and RPS interact, but there is no documents about how to schedule a recurring communciation, when and how to use multi-step communications, etc. I've figured out how to run single step campaigns, but can tell there is much more I could be doing. Unfortunately with the economy being tough right now attending a training semiar that would answer this is out of the question so I'm hoping to self-teach a little bit.Thanks,Adam

Real_Time Campaign

Ince — Wed, 12 Nov 2008 05:09:59 GMT

Hi GuysWe are now working on creating events on the TCRM application. I have been through the documentation but there are some things that don't make sense to me. This is what has been done so far:• Created events in Communication Manager Administrator • Created a Real-time Communication Type ( we did not have this) • A view was created for one of the events, Significant Deposits (or Large Deposits) My question is, how do we link the view to the Campaign? The documentation does say that there has to be data in the IOS_CM_DIRECT_INJECT. How do I get data in there? I know in my head that there should be a trigger that should populate that table, but how?What should be done on batch in terms of the scripts? Your help will be greatly appreciated. Regards, Ince

TCRM RollUp Functions

Ince — Wed, 05 Nov 2008 06:18:17 GMT

Hi AllI have created a view that calculates the number of events performed by a client for 90 days, and further created the Legend to look at this field, i.e. number of credit event , and I have used the SUM function to give the total number of events done in 90 days.The problem Im experiencing is that when I use TCRM Query to count the number of cleints who have done the number of events from >=1 and < 8 and get nothing, but when I run the view referenced by TCRM I get the results.What could be the problem, and what can I do to solve this problem.Below is the query generated by TCRM:SELECTCOUNT(*) FROM "EIWTCRM"."VW_ACCT_DAY_CREDIT_EVENTS_CNT" "VW_ACCT_DAY_CREDIT_EVENTS_CNT" JOIN "EIWTCRM"."VW_ACCT_PARTY" "VW_ACCT_PARTY" ON ("VW_ACCT_DAY_CREDIT_EVENTS_CNT"."ACCOUNT_NUM" = "VW_ACCT_PARTY"."ACCOUNT_NUM") WHERE ("VW_ACCT_DAY_CREDIT_EVENTS_CNT"."SB_EVENT_PROCESSING_DT" BETWEEN '09/01/2008'(DATE,FORMAT 'MM/DD/YYYY') AND '11/30/2008'(DATE,FORMAT 'MM/DD/YYYY')) HAVING ((SUM("VW_ACCT_DAY_CREDIT_EVENTS_CNT"."COUNT_CREDIT_EVENTS") >= 1) AND (SUM("VW_ACCT_DAY_CREDIT_EVENTS_CNT"."COUNT_CREDIT_EVENTS") < 8)) GROUP BY "VW_ACCT_DAY_CREDIT_EVENTS_CNT"."ACCOUNT_NUM";Regards,Ince

TCRM Legends

Abhi93 — Wed, 08 Oct 2008 19:52:26 GMT

I got existing Legend which is used for customer age from customer table, however i need to use same legend incorporating customer age from a table called target_customers. Therefore when campaigns are build user will have choice either to select customer age from customer table or target_customers or bothI could not find how to use multiple source or tables for legends. Could you please help me in this matter.AP

Adding Negative

Ince — Wed, 20 Aug 2008 10:12:18 GMT

TCRM does not take negative values, does any knows how to include negatives values on TCRM?E.g. Value Range from -100 to 100

Upcoming CRM and Advanced Analytics User Group Event at PARTNERS 2008

Carol Barker — Mon, 21 Jul 2008 14:33:04 GMT

MARK YOUR CALENDARS!!!

Advanced Analytics & CRM Combined User Group Meeting
Sunday, October 12, 2008
7:30am: Registration Opens
8:00am - 12:30pm: User Group Meeting
Mandalay Bay A
Las Vegas, NV

The Advanced Analytics and CRM User Groups are joining forces at the 2008 PARTNERS conference to host an integrated agenda designed to give both user group attendees a more comprehensive session. Advanced Analytics plays a critical role in successful CRM initiatives, thus making an integrated session more appealing and useful so that participants can attend jointly and deepen their understanding of both practices and linkages between them. The session will begin with a world-renowned keynote speaker who has studied, presented and written about analytics and CRM for many years: Professor Mohan Sawhney from Kellogg School of Management. Following the keynote, Advanced Analytics and CRM customers and experts will take the stage to discuss their hands-on experiences from both sides of the equation. Interaction for this session will be encouraged, so come prepared to ask questions! Please check the Partners website (below) for session abstracts and speakers. http://www.teradata.com/teradata-partners/conference/aacrm.cfm

supporting action persistance

jc — Mon, 23 Jun 2008 00:34:14 GMT

Hello,We're embarking on making more extensive use of Supporting Actions within our CRM databases and downstream processing. I am trying to gain a better understanding of how the PERSIST_IND works in the context of Supporting Actions, and here is the picture I have in my mind at present:You might have an "primary" lead, P, (Supporting_Action_Id = 0)You might have a couple of Supporting Actions related to the above "primary" lead, SA1 and SA2.Lets assume SA1 has Persist_Id set to 0 and SA2 has Persist_Id set to 1. Hence assuming the arrow shows time:[font=Courier New] ------------------------------------------------------>P ------| terminated by channel responseSA1 ------| terminated by CM as a result of P terminationSA2 ----------------------------------------------------....[/font][font=Courier New] ------------------------------------------------------>P ------| terminated by CM as a result of SA2 terminationSA1 ------| terminated by CM as a result of SA2 terminationSA2 ------| terminated by channel response[/font]Can anyone please confirm whether this understanding is correct?Also: is it possible to have persistance against a primary lead (or is this only available for Supporting Actions)?Many thanks.JC

Collect Statistic on IOS tables

Ince — Fri, 09 May 2008 02:54:32 GMT

HiOn the WHERE CLAUSE, do I mention all the tables that I need to collect statistics on?Refer to the script provided on the TCRM maintenance guideline below/**/*----------------------------------------------------------------------------Description:This SQL will generate a Collect Statistics script for all of the columnsof each index in dbc.Indices.Instructions:1. Replace @YOURDATABASENAME w/ the correct DatabaseName2. Modify the "where" clause as necessary to target specific tables3. Execute this SQL and capture the resulting "Collect Stats" scripts4. Execute the resulting Collect Stats script as necessaryRequirements:- Select access to DBC database----------------------------------------------------------------------------*/select (case Min_Poswhen 1 then 'Collect Statistics on ' ||trim(upper(DatabaseName)) || '.' ||trim(upper(TableName)) || ' INDEX ('else ' ,' end) ||trim(upper(ColumnName)) ||(case Max_Poswhen 1 then ');'else '' end)from(selectDatabaseName,TableName,ColumnName,IndexNumber,ColumnPosition,rank() over (partition by DatabaseName, TableName, IndexNumber order by ColumnPosition)Min_Pos,rank() over (partition by DatabaseName, TableName, IndexNumber order by ColumnPositiondesc) Max_Posfrom dbc.Indiceswhere DatabaseName in('@YOURDATABASENAME')and TableName not like all ('IOSV%', 'IOS1%' , 'IOS2%', 'IOS3%', 'IOS4%', 'IOS5%')) xxxorder bydatabasename, tablename, indexnumber, columnposition;/*----------------------------------------------------------------------------Description:This SQL will generate a Collect Statistics script for individual columnsof index fields.Instructions:1. Replace @YOURDATABASENAME w/ the correct DatabaseName2. Modify the "where" clause as necessary to target specific tables3. Execute this SQL and capture the resulting "Collect Stats" scripts4. Execute the resulting Collect Stats script as necessaryRequirements:- Select access to DBC database----------------------------------------------------------------------------*/select'Collect Statistics on ' ||trim(upper(a.TableName)) ||' Column ' ||trim(upper(ColumnName)) ||';' ansfromdbc.indices awhere12.3 Periodic Maintenance Tasks12-63a.DatabaseName = '@YOURDATABASENAME' and-- Modify the TableName where clause to target specific tablesa.TableName like any ('IOS%','WCM%') anda.TableName not like all ('IOSV%', 'IOS1%' , 'IOS2%', 'IOS3%', 'IOS4%', 'IOS5%')order byTableName, ColumnPosition;**/

IOS table statistics

Ryan Murphy — Mon, 05 Nov 2007 21:41:20 GMT

Today I discovered that our IOS_ tables have no statistics defined, and I believe this may be contributing to a significant system performance degradation we're experiencing. Is anyone aware of any best practices documentation covering IOS table statistics? The issue concerns only the IOS_ tables, like IOS_ECAMP and IOS_ECAMP_X_SEG. Our IOS1_[BBBBXXXXXXXX] tables created by segmentation processing do have fresh stats.Thank you,Ryan

how tos of CRM ios schd jobs

wannabet — Mon, 14 Apr 2008 13:30:59 GMT

Does anyone have a script that can be used to purge old CRM job executions form the IOS_SCHD_JOBS, IOS_SCHD_TASK, and IOS_SCHD_TASKS tables. Our environment is getting pretty crowded after over a year of testing and production job executions. So crowded that when my users login to CRM they hang at the processing completed jobs step of the login.

Buffers not downloading

Kika — Tue, 08 Apr 2008 04:08:07 GMT

Hi All, our CRM application is not downloading the buffers. we cannot check the setup in metadata as we are unable to log on. if we check in task manager it says Not responding for all component(CPS,RPS, taskBroker) when we restart the services they are not coming up. below is the error in the logs. what could be the problem..970.131 The following error was encountered in a metadata query: Division ID = 0Application ID = 9Section ID = 900Query ID = 11000[NCR][ODBC Teradata Driver][Teradata Database] Syntax error, expected something like a name or a 'ROWID' keyword between '(' and '@'. 12.970.128 EODBC Database Error: SubError: 0 ErrorCode: -1 NativeErrorCode: -3707 Message: [NCR][ODBC Teradata Driver][Teradata Database] Syntax error, expected something like a name or a 'ROWID' keyword between '(' and '@'. CREATE MULTISET TABLE ModelImportTable ( VarFld1 Float ) UNIQUE PRIMARY INDEX (@IndexFields)thanks

CRMIOS Tables and Journaling

Robby — Wed, 11 Apr 2007 15:46:23 GMT

The DBA's would like to turn off Fallback and Journaling on tables in the CRMIOS Database. Specifically, IOS_ECAMP*, IOS_SCHD*, IOS_TBL* as well as others.

Since I came into this job when CRM was already up and going, I am assuming that these are system tables and they shipped as-is with Journaling turned on.

Is there a problem with letting the DBAs turnoff the Journaling on the CRM IOS tables?

EDW Metrics Dashboard

Sam_989898 — Wed, 19 Mar 2008 06:52:41 GMT

Hi - I am looking for some EDW Metrics or sample Dashboards or presentations which can show the value EDW brings to the organization. I appreciate if you have something available to share with meThanks in advanceRam

TCRM Error in TSegTableCreate.BUILDSQL

Krishna Seethamraju — Wed, 20 Feb 2008 14:52:27 GMT

Hi All,I am getting the following error in TCRM. Could you please guide me as to what the issue could be?Error in TSegTableCreate.BUILDSQL : 9.10.10560 Error in TAdHocSqlGen.Run - Part IIITQueryServerRelativeDate.getHardcodedDateFormulaString: The date origin you selected for your floating dates is not setup in the CRM Metadata.Origin date selected: "0

Intelligent cross-selling and up-selling

Charm City CRMer — Thu, 05 Apr 2007 16:07:12 GMT

Hi All,

I have 3 discussion questions that I'd like to throw out to the group.

1) How do you leverage your inbound channel and customer analytics to drive intelligent cross-sell and up-sell initiatives, ensuring the best opportunity is presented to each customer?
2) How much of this process is being done in a real-time environment and how do you derive the business case to justify the IT investment for real-time?
3) Can you share some examples specific to your company/industry?

Channel failure - Number of unsent leads

judy — Tue, 30 Oct 2007 21:05:24 GMT

If TCRM channel process fails we'd like to be able to log which communications are affected and the estimated number of leads that have not been sent for each of the communications as a result. Has anybody got any advice on the best way of doing this?

CRM Taskbroker / RPS Services Not found

FJ — Fri, 11 May 2007 02:20:57 GMT

Hi,

(Note:I am doing installation on windows XP)

When i choose to install CRM Online / Offline servers separately.then after

installation of offline server i do get the Taskbroker.exe and RPS.exe but

couldnt find their respective servics.So both of these applications do get

stuck.I know tht offline server should be installed on Win Server 2000 but

could anyone find me the solution so that i can configure it in win XP.

regards,

FJ

TCRM Chinese Help Files

judy — Wed, 05 Sep 2007 03:33:21 GMT

I'm working with a Chinese version of TCRM. Although we have been given some documentation translated from English to Chinese we have been told that there have not been full Chinese Help files developed for TCRM. Does anyone know if there are Chinese Help files available or any plans to develop Help files in Chinese?

Segmentation Module Error

FJ — Mon, 04 Jun 2007 03:14:49 GMT

Hi,

When i create a single-step communication and specify a segment in the segmentation module it gives me following error:

Memory: 25300 Virtual Memory: 18024 PID: 5972 05/21/2007 2:42:45 PM

CPS Form -
CPS Form - 3.10.68 Run Error:
Base CPS
CPS Manager -CPS SERVER=1
Base CPS
CPS Manager -3.10.83 Find Next Segment Error:
Base CPS
Base CPS Database:
CPS Find Next Segment Reset Segment Error:
Base CPS
Base CPS Database: Reset SQL Error: 12.970.131 The following error was encountered in a metadata query:
Division ID = 0
Application ID = 9
Section ID = 10
Query ID = 1003
[NCR][ODBC Teradata Driver][Teradata RDBMS] Column LOCID not found in TEAM2DR.IOS1_BBBBWQPDBBB3T.
12.970.128 EODBC Database Error:
SubError: 0
ErrorCode: -1
NativeErrorCode: -5628
Message: [NCR][ODBC Teradata Driver][Teradata RDBMS] Column LOCID not found in TEAM2DR.IOS1_BBBBWQPDBBB3T.
The offending query was written to file - C:\CIOS\errlog\0x9x10x1003_5976_14t42t39t839.err By Machine - WPKFJ250001-7IX User Name - SYSTEM

Note: This error occures when i create a segment through the GUI of segmentation module.

TCRM Migration

wannabGURU — Thu, 23 Aug 2007 05:56:08 GMT

I recently upgraded my IOS from v5.01.00.00 to v 5.02.00.04. When i create a single step communication and enter the segment tab the following exception appears :

CRM application error : 12.960.80
The following field was not found in the TDataArray: SEED_CAMP_QTY_IND.

I ignored the error, created a segment and when i validated it, it reports that no segments are created. Everytime i revisit the segmentation tab i get the same error.

Please help me out!

2007 Annual Teradata CRM User Group Meeting at Partners Conference, Las Vegas

Carol Barker — Fri, 10 Aug 2007 11:10:19 GMT

MARK YOUR CALENDARS TO ATTEND this year's annual Teradata CRM User Group meeting at the PARTNERS Conference in Las Vegas, Nevada. This year's session will showcase innovative CRM implementations from around the world as winners of our first annual Teradata Marketing Leadership Awards program will take the stage to share highlights of their winning submissions. (to learn more about Teradata Marketing Leadership Awards, visit: www.teradata.com/marketingleadershipawards/2007

Teradata CRM User Group Session
Thursday, October 11, 2007 - 12:30 p.m. - 3:30 p.m.
Location: Mandalay Bay Resort - Meeting Room - Palm D

The Teradata CRM User Group Session is designed to help you expand your knowledge of CRM best practices by supplying you with practical references and techniques for maximizing your return from your Teradata CRM software. You will discover new ideas that you can immediately put to use!

For more information on the Partners conference please visit: http://www.teradata.com/teradata-partners/

And, for more information about Teradata User Groups, please visit: www.teradata.com/cmusergroup

If you're interested in attending, please rsvp to carol.barker@teradata.com

TCRM 5.2 and Teradata V2R6.2 with Linux

DeAnna — Tue, 10 Apr 2007 14:03:09 GMT

Is anyone out there running TCRM 5.2 with Teradata V2R6.2 with Linux?

ANNOUNCING - FIRST ANNUAL TERADATA CRM Awards Program

Carol Barker — Tue, 01 May 2007 15:51:48 GMT

Attention all TCRM Users!
Announcing the first annual Teradata Marketing Leadership Awards program! This is a competition amongst TCRM users (all versions) designed to honor and showcase organizations that have demonstrated innovative and creative uses of the TCRM application.

The Marketing Leadership Award winners will present their winning submissions at the Teradata Partners CRM User Group meeting in October 2007 in Las Vegas.

There are four categories in which to compete:
*CRM Innovation
*Transforming the Organization
*Customer Strategy
*Rising Star (for newer users of the application)

To find out more and to download the application form, please go to the following web-site:
http://www.teradata.com/marketingleadershipawards/2007

Good luck!

Managing Control Groups within TCRM Application

Rupert at BA — Mon, 05 Feb 2007 05:48:20 GMT

I am very interested to hear other customers using TCRM manage control groups within their communication strategy and campaign plans.

I know that within individual communications it is very easy to set up controls and identify them within the contact history.

However I would like to be able to identify and manage Universal Controls (a fallow group). This group would allow you to assess the true value of all your communications and your relationship with customers via all the channels used, plus maybe a value to a loyalty scheme. Currently I have set up these groups using recurring communications which in ensure that the control has sample of new customers added every month. However, one of the problems is that I would like this group to be churned every so often, plus end users of the application are always having to remember to suppress the group in every communication.

I would also like to be able to set up a Campaign Control which is suppressed from a series of communications which are part of a program against one campaign. So you may have a big launch communication and then a series of follow up communications such as reminders, chasers, qualifiers. I would like to be able to have a group of customers which we ring fenced across the campaign. So at the end of it we can measure total contribution. Does anybody manage groups across campaigns like this and how do they do it within the TCRM application.

Are Follow Ups necessary in Comm. Plans?

chicken & telephone ice cream — Wed, 14 Mar 2007 13:01:43 GMT

Hi,

I was wondering if we can go straight from a Timeout to another Step, instead of going through a Follow Up. IMHO Is there a legacy reason for using Follow Ups? AFAIK I can connect non-terminating Timeouts directly to another step. However, Teradata folks during our setup seem to always use Follow Ups. So, there must be a reason, right?

Thanks,

-- Johnny

CRM - Online Middle Tier

cgard — Thu, 15 Mar 2007 14:03:53 GMT

Has anyone experienced any performance issues this week after the daylight saving time happened? We have seen performance issues on this middle tier server twice this week and I am just checking to see if others have seen similar issues.

Legends Report

kafrynrich — Mon, 12 Mar 2007 10:08:39 GMT

I have a manual report that was created to help show where the database fields are in the legends mapping. I have gotten behind on it since legends and columns are changed and added frequently. Does any one have SQL that they use for a report that is similar to this or do you have any suggestions on a better way to keep up with this report?

Here are the columns that I use and a small sample (I had to pst it this way so that it would show correctly in the posting page):

Columns:
Module
Tab
Table / View
TCRM Segmentation Selection
SQL Field added through TCRM
Category Definition
Time Interval
Field Reference for Time Interval

Data Row 1:
Customer
Absolute
I0023B_ADR
State
ST_PVN_CD
Household
Current
NA

Data Row 2:
Store Location
Region/District
i0050C_LCT
District
DIT_NBR
Store Activity
Year
CAL_DT

Thanks,
Kathryn