Skip to main content

Media Tracking

As I'm updating my resume and looking over past work, I came across some media tracking spreadsheets I'd crafted. The company is international, but the data I had was (mostly) national (US), with little bits of Canada thrown in. Anyway, what I received were spreadsheets from an agency covering all media stories. The main thing I did with this was break it down by focus (positive vs. negative, for the most part).

So, I've been considering what I would do differently now. This is just a stream of ideas, so please understand them as such. I would like to build reports with more depth. Look at regional coverage. Map out city by city, etc, across the globe if possible. Layer this on top of a map. Then with that report I'd break out positive, negative & neutral focus. It's important to note that it's hard to ascertain focus when one doesn't see the coverage. Anyway, I also thought it would be good to look at what's generating the coverage: new products, new markets, "issues" (which should be tracked by individual issues/campaigns. It would be elucidating to track how the issue moves across the landscape.). I also would add social media to this. I want to see/show how awareness is impacted by those tools.

On a technical note, I would not use Excel for data collection. Collect raw data in a database. The challenge is being proactive with the structure. I'd love to build something that was accessible at a more macro level. Perhaps with SQL and displayed in a Sharepoint site. I have an aversion to myriad individual databases globally distributed.

Anyway, I'm learning and growing.



Labels:

Comments

Post a Comment

Popular posts from this blog

Oh, A Meeting We Will Go

This post gives me pause. Meetings, the infernal overwrought obsession of our lives. It's not just corporate America, but the various groups and org's I've dallied with over the years suffer from meetopia, too. No one I know likes the blasted things, yet I don't know anyone offering up a successful resistance. Related to this, methinks, I have noted that I do a great deal over my workdays (check off a ridiculous number of to-dos) and accomplish little or nothing. The mass of tasks don't roll up to anything. And I've noticed a lingering sense of frustration lately. I spend precious little time reflecting on my goals, and how I can link them to what I do over the course of any given day. I'm so divorced from this, I really wonder what I really want to do, to accomplish any more. Within a recess of my brain comes a niggling thought. Perhaps this passion for meetings offers up a substitute for reflection. Knowing that we must account, personally, face-to-face f...
2 comments
Read more

Seattle, The Viaduct, and Life In The City

Here’s my response to this article/survey ( online at the Seattle PI ). The Question: What's the best option for the viaduct? Gov. Gregoire seems to have resuscitated the possibility for a tunnel to replace the Alaskan Way Viaduct. Have you decided what transportation option you want on the waterfront? If not, what information do you need in order to come to a decision? Looking over the debate, the mayor only seems to be concerned about the beautification aspects of this whole debate. I'm bothered by the fact that few folks are mentioning the economic impact of tunnel construction, how we will mitigate the effects of this roadway being inaccessible for nearly a decade, or, of course, the justification of the extra expense. The tunnel hasn't been sold to me, at least. Personally, I’m worried that this project has not been thought through. The economic impacts for areas such as Ballard and immense, and haven’t been publicly addressed/discussed. May...
2 comments
Read more

The Eleventh Day Of September

Today, acknowledging summer’s demise, I finally turned on the heat. Air chill, perhaps related to the gray, darkening sky. Or, perhaps, the turning of the seasons announced boldly; the date on the calendar be damned! I wonder, how cold was it, nine years ago, when the world went a bit chill? Well, perhaps not cold, but rather hot. So often, since Nine-Eleven, Americans delved head-first into fear based reaction. Easily wrenched into “evil=muslim” paradigm. Fear. Our world shown uncontrolled, our dominance shown illusory, and the grand mirage of a world looking longingly at us (US?) for love and guidance blown apart. Fear shoved into our face, our people unused to this sensation. Irrational rage birthed. I hoped that we, as a people, would remain above petty vindictiveness and bigoted rage. That we would be stronger, less alarmist. Our reaction to such tragedy based on effectiveness and reason. My hope remains longing for fulfillment. At moments glimmers of hope exist. Yet, I see this ...
2 comments
Read more