« 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.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment

Enter your email address:

Delivered by FeedBurner

Authors

B2B Marketing Zone

  • B2B Marketing Zone
    B2B Marketing