You could use program to split up your group and then insert delays to send to the rest of your list days later, or exclude them all together. In the example below, I send immediately to 20%, take another 40% and wait 3 days before sending, and take another 40% and exclude them all together.
Q&A: Can you do a nested SQL query in Responsys?
Although I have not heard this directly from Responsys, I believe you can execute any SELECT statements that can normally be executed on an ORACLE database. We run this SQL statement, where you can see nested select statements:
SELECT * FROM ( SELECT RANK() OVER (PARTITION BY A.EMAIL_ADDRESS_ ORDER BY A.CREATED_DATE_) RNK, A.* FROM $A$ A JOIN (SELECT EMAIL_ADDRESS_ FROM $A$ GROUP BY EMAIL_ADDRESS_ HAVING count(EMAIL_ADDRESS_) > 1) B ON (A.EMAIL_ADDRESS_ = B.EMAIL_ADDRESS_) ) WHERE RNK <> 1
Steve Jobs: 1955 – 2011
Introducing the New Jewelry Television Mobile App
Our team recently finished the new Jewelry Television iPhone app, and I wanted to show off some of the features. Take a look!
Continue reading
Creating Timed Events in Your iPhone App with Titanium
Timers are core elements of games. I’ll show you how to write a basic timer function that will let you trigger an event on an interval for your iphone app, using Appcelerator’s Titanium.
Continue reading
Apple will sell an iPhone with Verizon – or die
The stars are aligning for Apple and Verizon to finally come together in a deal that will bring the iPhone to the biggest mobile carrier in the US. While some are still in denial, you can’t ignore the circumstantial evidence that points to a not-so-distant partnership.
Continue reading
Spring Cleaning: It’s Time To Clean Your Email List
It’s that time of year again – spring cleaning time. Why not apply the same vigor to cleaning your email list as you do with cleaning out that flower bed full of weeds?
Continue reading
Online CPG Sales Heat Up
As retailers like Walmart begin to offer more and more lower priced consumer packaged goods (CPG) for sale online, all signs point to a race to be the leader in sales of everyday household items. Continue reading
Online Font Recognition Website Can Save Designers Precious Time
Occasionally designers have to have a quick way to find out what font is used in an image in order to create complimentary works. Sometimes the original designer or layered file are not always available to make it easy. There is a website that can help.
Continue reading
Get XML Data into Magento via the Magento API
Recently I needed to write some code to get a dropshipper’s xml product data into Magento to update my products price, quantity available, and stock status. This is how I went about it.
Continue reading