Marketing Challenge

I have been working in the field of marketing for quite a few years now. Most of my job involves interaction with data in some level or another. Some things I regularly working on are - getting data files of customers for my next email campaign, status of payments received from a particular client, or simply an export of all the responses from my marketing survey.

Every time I get data I have to spend time doing some processing to it so that I can visualize it in a fashion that is understandable to me. Today I was faced with such a situation and PAW came to my rescue.

Today, I received twelve files of data exported in excel from a vendor who implemented one of my customer survey's. All of the raw data I collected was important to me however in addition to this raw data there was more value in analyzing the following -

1. 1. How many of my customers completed more than one survey?
   
2. 2. What is the number of new customers to the email file vs. my control?
3. 3. Isolate email addresses that have subscribed to my monthly newsletter
4. 4. Isolate the email addresses that have shown an interest in my next webinar

Traditionally, I had to have someone from my team or the database manager right some SQL query's to parse this information and send it to my team. In the PAW world today, I or some one from my team pulls all the information in PAW and withing the hour has all the various data files ready to send to the various teams.

Merging or de-duping data takes minutes in PAW even for large files (each of my files had over 35k rows in it) and what's even better is that I don't have wait for other teams to send me the parsed data. My email marketing campaigns are more releveant as they are sent out in a timely fashion bringing more ROI and revenue to PAW.