intouch.jpg (5786 bytes) .......FROM .......esplogo.jpg (6790 bytes)

ESPonDemand's Query Tool: Saving You Time and Money

Click here
for the full PDF Version

In This Issue:

Profile: Michael Jordan
Circulation Experience Helps Fulfillment Service

Fire Apparatus: One Hot New Magazine

Letter From the President

T & L Publications Selects ESP to fulfill Multiple Publications

ESPonDemand's Query Tool: Saving You Time and Money

ESP Receives Workforce Development Award

Law Officer: ESP Helps Jems Communications Get the 4-1-1 on the 9-1-1

ESP Computer Services Inc.

12444 Victory Blvd., Suite 400
N. Hollywood, CA 91606
Phone: (818) 487-4500
Fax: (818) 487-4501

Sales@espcomp.com

Feel Free to Share!
Readers may reprint or redistribute this newsletter or articles in it. However, the above contact information must be included.

For more information about our services, go to 
www.espcomp.com

 

 

Sometimes it’s just easier to do it yourself. At ESP, we mean to afford you that opportunity by providing direct and easy access to your subscriber database. Of course, there are lots of benefits to such access, but this article will focus on just one: the benefit of quickly and affordably selecting records for use by an outside party.

Have you ever received a request from an advertiser to use a small subset of your subscriber file? Ever wanted to use such a subset yourself? ESPonDemand enables you to pull virtually any such subset and download it to Excel in just seconds. Some examples of criteria you can use: zip code range, demographic, expire date, qual date, account status, only those with e-mail address, exclude do not promote, source code, and many more.

Once you’ve logged in to the ESPonDemand site, just click on "query." Use the "full query," to export as much data as possible and the "quick query" to exclude potentially extraneous financial fields. Either way, your results are easy to manipulate in Excel (for example, you can further eliminate columns to leave just the mailing address data).

You can also use the query tool to generate quick counts or modify existing queries. Say you’re looking to send a promotion to no more than 500 subscribers located in Manhattan. You run a query and determine you have 1,735 subscribers from which to choose. You can continue to change criteria and rerun queries until you’ve selected the best possible 500 prospects for this special promotion. You can also take advantage of the ‘N-thing’ feature to have the computer select exactly 500 accounts for you. There’s no cost to running any number of queries, nor do you need to wait for someone else to rerun the query if you change your mind as to the criteria. It’s all at your fingertips, so there’s no reason to hesitate running additional queries if you just want to know "what if I only want…?"

Try combining the query tool with ESPonDemand’s merge/purge tool (another free tool described in last summer’s newsletter). You can query for active subscribers from two of your publications, use one file as a prospect file and the other as a suppression file, drop them into the merge/purge tool, and voila! In minutes and at no additional cost, you have a file ready to cross-promote. For help in using the query tool or any tool featured in ESPonDemand, please contact your account executive.