A couple of weeks ago I was at a client site doing ExactTarget API consulting. This client is standardizing on ExactTarget as their single source of all e-mail communications from three of their internal applications. They will use 5Buckets for the automation in certain cases, but also needed to develop their own integration with ExactTarget directly.

One of the developers posed me a question about “filters” in the ExactTarget web service. You can use
simplefilterpart() to specify what data point you want to filter on, and of course the value. For example, to filter on CustomerKey -

SimpleFilterPart sfp = new SimpleFilterPart();
sfp.Property = “CustomerKey”;
sfp.SimpleOperator = SimpleOperators.equals;
sfp.Value = new string[] { “TransactionalSendKey” };

Here you are first creating an instance of SimpleFilterPart. Then indicating that you want to filter using “CustomerKey”, indicating the operator and finally the value of the CustomerKey.

Now, if you have two filter criteria, you create two instances of the SimpleFilterPart and join the two using ComplexFilterPart (see code example in the Webserivces API guide, pg. 36)

Going back to the question that came up at client site - they wanted to know how they would add a third filter criteria. Well, it’s simple enough. Create a third instance of SimpleFilterPart and set the property and values as appropriate. Then create another instance of a ComplexFilterPart and assign you first ComplexFilterPart to the LeftOperand and the third SimpleFilterPart to the RightOperand.

ComplexFilterPart ComplexFilter2 = new ComplexFilterPart();
ComplexFilter2.LeftOperand = ComplexFilter1;
ComplexFilter2.LogicalOperator = LogicalOperators.AND;
ComplexFilter2.RightOperand = ThirdSimpleFilterPart;

If you are like most ExactTarget API users, your first introduction to the ExactTarget API must have been a PDF document. A large 100+ page PDF document. A little daunting, not so much because of the complexity, but because who the heck has the time to go through a 100+ PDF document. Then someone at ExactTarget probabaly mentioned the ExactTarget Developer Community to you. The community has many useful resources - the documentation, code samples (yes!), forums, a call wizard, ET API experts that respond to your questions!

Let me point out one more piece of the Developer Community that I find very useful - an online help file. It is listed on the “Resources” page, towards the very end of the page. This is the entire REST based API in a search-able, indexed Help format!!!! You can search for a specific API call and get to it directly, no need to thumb through a 100+ PDF. :)

Full disclosure - this Help file currently has only the REST based API and the Batch API guides. The Web services API and the ET for AppExchange API are not in there (ExactTarget - please add them in asap!!).

Here’s a quick little tip about the new ExactTarget Webservices API, particularly the one that does the integration between Salesforce.com and ExactTarget. When you trigger an email send using the ETforAppEx API, make sure you specify -

a) IndividualResults = true;

b) IndividualResultsSpecified = true;

This will ensure that the send, open(s), click(s) are dumped in to Salesforce.com by ExactTarget. The manual says there is no need to explicity specify IndividualResults, and that the tracking will be dumped in to SFDC by default. But as a good practice I would strongly recommend you specify it explicitly. You really don’t want to be left guessing if that tracking information will really be sent to SFDC or not.

Send me an email (adalvi -at- rightoninteractive.com) if you want a more detailed code sample.

The second day has flown by and was just as wonderful as the first day. The day was full of sessions on different tracks ranging from beginner level (Email 101) to advanced tracks (Email 201, Integration and Deliverability). Many attendees stopped by the Right On Interactive booth (in fact we had more stop by in the morning than the whole day Monday). I asked several of them what they thought of the conference and the sessions. Every one of them reported that they were very happy and were learning things. A handful did mention that the challenge to them is to take all this back and incorporate in their daily work life. Yep, that is definitely a hallmark of a successful conference.

The evening was a formal sit-down dinner and awards ceremony. The food, company and setting was wonderful. ExactTarget pulled a surprise on everyone when they had the “The evolution of dance” guy perform live on stage! He was just awesome!

Closer to home, 5Buckets has been very successful. We had several people walk up to the booth unsure of what we do; but I see their eyes light up just as soon as we walk them through 5Buckets. Check it out here if you are interested :)

The first day of ExactTarget’s Connections ‘07 conference has been absolutely wonderful! Scott Dorsey kicked off the conference at 1pm with his keynote followed by Scott McCorkle showcasing upcoming Fall release. Beyond email, ExactTarget will now support SMS and voice messaging! The focus seems to be on “one-to-one” marketing and a new feature called “Interactions” is being introduced. ExactTarget’s UI has been one of it’s strenghts and now there are some new features that take the UI to the next level. Thumbnail previews, context menus to edit emails in place! All good stuff.

One astonishing fact I learnt today - ExactTarget has invested $5MM in infrastructure. Wow, I can’t wait for the application to get speedy.

ExactTarget has their annual conference - Connections ‘07 - going on in Indianapolis, IN. ROI is a proud sponsor. We have a booth and several ExactTarget users have already stopped by and shown interest in “5Buckets”.

With over 500 attendees, this is going to be a great event. Come visit at Booth #10. Oct 1st through Oct 2nd, 2007.

I just want to take a moment and tell you about a book that has come out recently that I highly recommend - “Email Marketing by the Numbers“. It is a great book by Chris Baggott and Ali Sales - both of whom I collaborated very closely with during my days in marketing department at ExactTarget. They are both extremely talented marketers to which I can personally attest.

I bought the book as soon as it came available and was delighted to find it not just a book by Chris, but a compilation of work from many talented internet marketers from around the world. Many of those talented professionals are people I worked with while at ExactTarget like Morgan Stewart, Chip House, Joel Book, and Ali Sales. Other contributors, specifically Amol Dalvi, I continue to work with in my current position at tech start up Right On Interactive.

I also want to mention Kelly Rusk with Card Communications who is an email marketing expert who contributed to the book as well - she both posts and links here and is an extremely talented internet marketer. I met her by chance when I started blogging and have been faithfully reading her posts ever since!

Besides the fact that many reputable professionals contributed to the book (my friends!) - it is also an easy read. A book on email marketing could easily put anyone to sleep (even die-hards like me) but instead it flows nicely and the examples and insight are truly inspiring.

So if you are truly interested in adding email to your marketing arsenal or just want to hone in your existing skills - you cant go wrong buying this book. Good job guys!