template to start a new coupon
Procedure to prepare selective mailer to customers who have purchased a certain class of product ...
- Create a file to transfer product class from online db to local db
- click db/downClass.php
- ftp db/productClass.tab to c: ome
- the updateclass procedure in codeselectivemail.prg will perhaps import productClass.tab into rawclass and then might update the tome product database.
- Update local speak db by secleced class
- set theclass ="<Desired class>" in codeselectivemail.prg
- run codeselectivemail which puts the the selective class in product.temp
- Compose a filter for labelm.prg to print 1" labels
- for example: set filter to temp="Christmas" and !empty(zip) and empty(country) and media!="c" and statusdate>{^2009-01-01}
- run labels as usual
- Stick them on a mail piece that looks like something this ...
.......................................................................................................
I am going to be tracking the effect of this mailing compared to its cost.
Printing: $266.09
Mailing: $346.84 (1196 pieces mailed)
Total direct cost: $612.93
cost of free shipping for people who use the coupon: ? = 112.50
people responding to the postcard: ? = 11
total revenue from those orders: ? = 494.25
Additional benefit: we needed a piece to put in our packages anyway. value? = unknown
..........................................................................................................
the mailers in a tray going to the post office today
Tags
- speaktomecatalog.com
- postcard
- mailing
- advertising
- chpostcard
- printing
See Also
- Thought BlackListt speaktomecatalog.com ... get speaktomecatalog off the list with 57 viewings related by tag "mailing".
- Thought Speak.txt - mailing Procedure with 50 viewings related by tag "mailing".
- Thought 1704b with 43 viewings related by tag "mailing".
- Thought Speak To Me Print Catalog with 31 viewings related by tag "speaktomecatalog.com".
- Thought Speak To Me Catalog (Production of the Print Version) with 20 viewings related by tag "speaktomecatalog.com".
- Thought It is all Advertizing, Brainwshing & Neuro-linguistic Programming & AI with 17 viewings related by tag "advertising".
- Thought about: it took america 200 years to abolish boredom. now that looks like a huge mistake. - vox with 16 viewings related by tag "advertising".
- Thought Enhancing Your Shopping Experience with YouTube Videos with 15 viewings related by tag "speaktomecatalog.com".
- Thought The win-win Oxymoron with 11 viewings related by tag "advertising".
- Thought about: Laughing Hillary Pen from Speak To Me Catalog with 10 viewings related by tag "speaktomecatalog.com".
- Thought Automating Selling on Amazon with 8 viewings related by tag "speaktomecatalog.com".
- Thought Promotions in the Speak To Me Catalog Shopping Basket with 6 viewings related by tag "speaktomecatalog.com".
- Thought about: SpeakToMeCatalog: free with 6 viewings related by tag "speaktomecatalog.com".
- Thought renewal of ssl certificate for www.speaktomecatalog.com with 4 viewings related by tag "speaktomecatalog.com".
- Thought about: Testing Spin To Win with 2 viewings related by tag "speaktomecatalog.com".
- Thought An enemy turns into a friend ... with 2 viewings related by tag "speaktomecatalog.com".
- Thought Google SEO for speaktomecatalog.com with 1 viewings related by tag "advertising".
- Thought G+ business page for SpeakToMeCatalog.com with 1 viewings related by tag "speaktomecatalog.com".
- Thought speak amazon store with 1 viewings related by tag "speaktomecatalog.com".
- Thought SQL for selecting triples inside of one field. with 1 viewings related by tag "speaktomecatalog.com".
- Thought about: when the data bubble bursts, companies will have to actually sell things again with 1 viewings related by tag "advertising".
- Thought Facebook Ads with 0 viewings related by tag "advertising".
- Thought Syndicating our products with 0 viewings related by tag "speaktomecatalog.com".
- Thought New coupon method request for our catalog ... with 0 viewings related by tag "speaktomecatalog.com".
- Thought about: hd radio give away! with 0 viewings related by tag "speaktomecatalog.com".
- Thought about: speaktomecatalog.com | facebook with 0 viewings related by tag "speaktomecatalog.com".
- Thought Setting Time on the with 0 viewings related by tag "speaktomecatalog.com".
- Thought about: amazon.com at a glance: speak_to_me_catalog with 0 viewings related by tag "speaktomecatalog.com".
- Thought Black Friday with 0 viewings related by tag "speaktomecatalog.com".
- Thought about: Official Google Blog: An update on payments with 0 viewings related by tag "advertising".
- Thought First Time I Ever Saw a Scrolling Advertisement On A Truck with 0 viewings related by tag "advertising".
- Thought PayPal with 0 viewings related by tag "speaktomecatalog.com".
- Thought about: speaktomecatalog.com - web analysis with 0 viewings related by tag "speaktomecatalog.com".
- Thought A great little online png editor with 0 viewings related by tag "speaktomecatalog.com".
- Thought Building stufftalks.com with 0 viewings related by tag "speaktomecatalog.com".
- Thought Speak To Me Catalog TV Channel with 0 viewings related by tag "speaktomecatalog.com".
- Thought about: Final Results for 2006 Disabled Singing Contest with 0 viewings related by tag "speaktomecatalog.com".
- Thought I'm wondeing if a meme like this would go viral ? with 0 viewings related by tag "advertising".
- Thought about: George Bush Talking Opener with 0 viewings related by tag "speaktomecatalog.com".
- Thought Online Marketing and/or PR with 0 viewings related by tag "advertising".
- Thought Revision of our catalog request form with 0 viewings related by tag "speaktomecatalog.com".
- Thought 2016A - CD catalog production with 0 viewings related by tag "speaktomecatalog.com".
- Thought New Speaktomecatalog facebook share button with 0 viewings related by tag "speaktomecatalog.com".
- Thought Follow dev here with 0 viewings related by tag "speaktomecatalog.com".
- Thought 1914 Postcard view of East Wall of Jerusalem with 0 viewings related by tag "postcard".
- Thought A quick question ? with 0 viewings related by tag "speaktomecatalog.com".
- Thought Eliminating the large shopping cart ...... with 0 viewings related by tag "speaktomecatalog.com".
- Thought 12 Days of Christmas with 0 viewings related by tag "speaktomecatalog.com".
- Thought Working on Speak To Me Catalog with 0 viewings related by tag "speaktomecatalog.com".
- Thought Product Placements with 0 viewings related by tag "advertising".