Monday, December 5, 2011

Uh-oh...Here Comes the Numbers.

I'll be honest when not at work in my cube, I'm not a huge fan of dealing with numbers.  My Grandfather was a chemical engineer, and my Father was a systems analyst for the Navy...I can barely add.  The prospect of dealing with a volume of numbers is daunting, but I think it's necessary to start the analysis of Phaidon's direct marketing efforts via email with a look at the sheer numbers.

I started receiving emails from Phaidon shortly after setting up this blog and joining their emailing list in mid-September. I kept collecting data from that point until the end of November to give myself a few days to distill down the data.

From September 19th, which was the first email occurrence, until the last email from November 30th, here are the raw numbers:

Total number of emails:  23

Total number of topic subjects:  11

Total number of themed emails: 6

Total number of topics: 124

A quick word about "topics" and "topic subjects" and how these are defined.  I'm defining topics as individual stories, offers, profiles, etc., that were included in the emails I received.  A topic could range from a news story about an artist exhibition, to an advertisement for a new book, to an announcement of a offers for sales of signed copies.

Topic subjects refers to the containers I have created that the topics fall into.  In keeping with the example above, a topic about an artist exhibition would fall in the "news" topic subject, while an offer for a photography book would fall into the "book: photography/film" topic subject, and an offer for a signed copy of a new design book would fall into the "book: design" topic subject.

Finally, below is what my color-coded Excel spreadsheet ended up looking like:

















No comments:

Post a Comment