COM0015 Blog #4 Out of the box, into the cell

When I began the social media certificate at Algonquin College learning to use new tools was expected. What I did not expect was to fall back on a very handy (and powerful) tool – the spreadsheet. This tool has been in my toolbox for years and I didn’t expect it would be so useful as a building block for monitoring and measuring my social media platforms.


I started off with a simple list using data from a Facebook page I administer.  I created columns for:

  • Date
  • Categories
  • Subcategories
  • Target
  • Calls to Action
  • Posts
  • Impressions
  • Comments (replies)
  • Likes (favorites)
  • Shares (retweets)
  • Clicks
  • Total Engagement
  • Total Reach

The data for each of the above can be imported from Facebook Insights, as an example. Without too much thought, I can see what content was most effective but simply sorting my data by descending order.


Based on this, I can see a huge increase on October 29. On this day, a slide show was posted. Consistently, over the life of this page, slide shows have boosted engagement.

Once the top content is identified, it can be compared to trends upward or downward over a certain period of time. Did this trend result in a change in ROI – did more participants enrol at the next registration?

This is just a very simplistic example of how an old tool can be used to keep things new.

COM0015 Assignment #5 | Socially Driven Collaboration: How Social Business Is Changing the Role of Marketing and IT

Marketing and IT statOn Nov. 19, I participated in a webinar hosted by Social Media Today entitled Socially Driven Collaboration: How Social Business Is Changing the Role of Marketing and IT. As the person responsible for marketing and communications for my organization, I’m interested in any opportunity to learn about trends and best practices related to my field. And, as our organization is incorporating social media more into its communications and business models, I thought this webinar would be a worthwhile experience.

The webinar explored the fact that as more companies are embracing social business activities (e.g. using social technologies to listen, respond, gather feedback and connect with customers and partners), marketing and IT departments are having to work together to achieve social business goals. The webinar focused on how to achieve better alignment between the marketing and IT departments as collaboration improves all outputs/outcomes. The webinar offered five tips for better collaboration:

  1.  Get C-suite buy-in for shared goals.
  2. Understand your peer’s perspective. Understand the needs and offerings of each group.
  3. Be the role model. Reach out to the other department. Make the first move to work together.
  4. Find meaningful metrics to measure your success. Collaboration can yield many benefits.
  5. Avoid tech mistakes by carefully choosing your tools.

The webinar was moderated by Paul Dunay, Global Vice President of Marketing for Maxymiser, and featured panellists Erika Jolly Brookes, Vice President of Product Strategy for Oracle, and Vanessa DiMauro, CEO of Leader Networks. The speakers and participants could all interact with each other through Go to Webinar or on Twitter using the hashtag #SMTLive. Many people, including me, were tweeting quotable quotes from the webinar or asking questions and tagging them with the hashtag. I was happy to see Vanessa DiMauro answer my question. As an organization without an IT department—we have one person on staff for basic support and to liaise with our IT consultants—and as an organization that has a number of small businesses as stakeholders, I wanted to know if the rise of social business was enough of a business case for convincing your CEO to build an IT department into the business plan. Vanessa responded that identifying a business process that could be enhanced or accelerated via social technologies could help make the case for an in-house IT department.

Through the webinar, I gained a better appreciation for our IT consultants and see how it’s important to keep them in the loop of our activities. The message that I took away is: “When marketing and IT collaborate, the results are stronger marketing messages and a reduction in operational costs.” The webinar left me thinking of how I could work more collaboratively with our IT consultants to select or develop tools that will help us become more socially enabled.

Social Media Today offers free, weekly webinars on a variety of topics related to social business. I find the topics relevant to my job, and as they take place over the lunch hour, they’re very convenient. You also get a copy of the presentation, which makes great reference material. I highly recommend these webinars and will be attending more in the future.

What free social business-based webinars have you come across and would recommend?

Image from the presentation Socially Driven Collaboration: How Social Business Is Changing the Role of Marketing and IT by Erika Jolly Brookes and Vanessa DiMauro.