1

We have received a new ET environment for our customer and are starting to use it for marketing campaign . At the moment they will start with exact target Landing pages and the links are posted in the external pages to create a new leads / customers.

I am given a fields (names,company,phone,email,jobtitle,gender,optin,postalcode,city)for those the leads info we receive from landing pages.And was told to design/ create a DE by adding any necessary attribute/field required to it. Its just the starting point and they may have new fields addition in future.I was also told that there may be salesforce integration in future too.

Am just wondering, whats other fields i.e subscriberkey or customer id or sth like primary ids will be required. I worked with ET and CRM and just a little bit of exclusive Exacttarget. But i dont have much experience in it .. Any suggestion. I was given full responsibility on this and unfortunately am the only one in my team who is working or knew little on exacttarget. I really wanted to make it impressive(without having any trouble in future).Coz, last time when i did some small consulting work, we did have trouble with customer id which was 8 digit and was not easy to handle , so wonder like having some concrete primary key ...

Any suggestion is appreciated.

Also, wonder i don't see the Data Extension option in the Subscriber Section of the Exacttarget...is it hidden somewhere and have to enable it or do i have to contact Exacttarget support ??

-thx

2

Last question answered first: if you don't see data extensions in your account, contact support and they will turn it on for you. You are looking in the right place.

Secondly, you have a tremendous amount of flexibility for primary keys in data extensions:

  1. You can make any column you want to be a primary key. So if you make a customer ID column of type text (string) or number or whatever, that's fine.

  2. You can also make composite keys of any number of columns. So, perhaps you want the customer ID column + CreatedDate column to be the primary key. No problem, just mark them both as primary keys, and it will enforce uniqueness for that primary key.

Hope this helps!

  • thx..i like second option coz am concern more on the uniqueness. How about GUID()?? compared to second option... i feel your second option favor more to uniqueness than the GUID()..what do you say? thxxx again, – Jack85 Jul 28 '14 at 14:58
  • 1
    GUID seems like overkill for your solution. I would personally use option 2 as well. – Timothy Jul 28 '14 at 15:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.