« Lead Source - A Blessing or A Curse? | Main | How did my data quality get so bad? »

February 20, 2009

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d834fe5ccc53ef0111688aa21e970c

Listed below are links to weblogs that reference Naming Standards in Marketing Automation systems:

Comments

Nicole Mossinger

I could not agree more with the importance of creating naming standards.

When using dates in campaign, program, or other names, there is an advantage to putting the year first:

If you ever have to do an alphanumeric sort by date (e.g. in your reports), putting the year first will return things like:

CMP_2008-06_some_campaign
CMP_2009-03_another_campaign
CMP_2009-06_yet_another_campaign
CMP_2009-11_last_campaign

If you have the month before the year, the alphanumeric sort will return the following:

CMP_03-2009_another_campaign
CMP_06-2008_some_campaign
CMP_06-2009_yet_another_campaign
CMP_11-2009_last_campaign

Note how the 2008 campaign got mixed in with the 2009 campaigns.

If you have lots of campaigns or programs, this can get really confusing.

I know that putting the year first is counter-intuitive to many of us, but the functional advantages speak for themselves.

The comments to this entry are closed.

Enter your email address:

Delivered by FeedBurner

Authors

B2B Marketing Zone

  • B2B Marketing Zone
    B2B Marketing