Archive for the ‘Data’ Category



Brian Michael

02/02/2010

Is this Blog Post Any Good?
10:10 am by Brian Michael

The answer to the question in the title will hopefully be yes, but it probably depends on who you’re asking. It also depends what they consider a “good blog post”; in other words they all have different measures of success. The same is true with any Web site or online project.

Measures of success obviously can vary from project to project, but they can also vary within a project. In most cases there exist three levels of measures, for our purposes we’ll call them primary, secondary and tertiary.

Usually primary measures of success relate to an offline activity. Although some people may spend more time in front of a computer than away from it, there is still a real world out there – a world that revolves around exchanging money, voting, construction and other human activities. Thus some examples would include making a donation on a mobile phone, getting people to vote for a particular candidate, or winning approval for a new hospital. One or more of these are usually the “problems” a client will have when looking to partner with another firm. These are easily the most important measures of success.

Secondary measures have to do with the activities that lead to one of the primary objectives mentioned above. Since primary measures involve a serious commitment on the part of the end-user, a gradual process of building up to the ultimate goal is required. These nodes of engagement could include participating in an online poll or survey, posting a message on a Facebook Wall, or forwarding an email.

The way to judge the likelihood that the secondary actions will be taken by supporters remains the hard data of the tertiary measures. These indexes – like pageviews, open rates or Twitter followers – are the things successful managers follow on a daily basis; and their analysis will uncover trends among your audiences.  This will in turn allow you to optimize campaigns to drive up the response rates measured in the primary and secondary goals.

Taking a step back we have seen that measures of success directly correlate to a campaign goal.  Measuring those goals can be done on a variety of levels in this case primary, secondary, or tertiary.  These levels could also be called Offline, Engagement, and Indicators, respectively.

The goal of this post was to pass on some knowledge for the offline world, I hope it is measured as a success.

Brian Michael

11/30/2009

Awesome Excel Add-On
11:40 am by Brian Michael

In the email marketing world, you often find yourself inheriting lists of contacts for email delivery on behalf of clients.  Besides ascertaining the origin these lists (opt-in, matched file, etc.), it is important to do an initial cleansing of the lists.  This includes removing duplicates, filling in missing data and removing erroneous data.  If you have a person responsible for database administration he or she could probably get this done by loading the lists into a MySQL, SQL, or Access database and running a few scripts.  However, this person may not understand the specific logic that the data must follow (i.e. this type of record trumps this type), because it is often not known until someone actually rolls up their sleeves and starts digging.

So when you need to manipulate data using a fine point rather than the broad brush of database scripts, Microsoft Excel is a natural solution.  However it has its limitations in terms of sync-ing multiple lists.  Thankfully, DigDB is a useful Excel plug-in that allows you to do much of your data manipulation yourself.  Its website also features step-by-step instructions for common tasks like de-duping lists.  Check it out, it’s pretty cool and extremely useful.