Magic formula to predict PPC effectiveness?

The tantalising prospect of being able to say with certainty how well a brand will perform as a result of pay per click (PPC) activity could well become a reality if marketers know their maths. These are the intriguing...

Continue reading →

Grouping MS Excel Data In Pivot Tables (e.g. By Month, Quarter, Year)

Slightly off topic, but this has been driving me mad, and after wasting time with formulas, calculated fields, formatting as short date, today I found a nice simple solution. This might be useful for anyone who wants to export and...

Continue reading →

Is the #ilovemcr Twitter campaign counter-productive?

When the Manchester riots kicked off last month, Twitter went into overdrive, with city residents tweeting information about what was going on and, most importantly, where it was happening. One of the most common tweets, which did the rounds the...

Continue reading →

Twitter performs at the Edinburgh Fringe

Thousands of people descend on Edinburgh every August for the world’s biggest arts festival, the Fringe, now 64 years old and big business. This year’s event just wrapped up and was no different, with a constant stream of people...

Continue reading →