Posts Tagged ‘match’

Excel Dynamic Named Ranges = Never Manually Updating Your Charts

17th August 2010 by Tim Wilson No Comments

I’ve had a pretty good run of theoretical posts about the nature of marketing measurement of late, so it seemed like I was due for a more down-in-the-weeds-Excel-efficiency-tactics write-up.  This blog isn’t really focussed on all of the myriad ways that Excel can be contorted to represent data effectively, but I’m a big believer in [...]

Answering the “Why doesn’t the data match?” Question

18th May 2010 by Tim Wilson 3 Comments

Anyone who has been working with web analytics for more than a week or two has inevitably asked or been asked to explain why two different numbers that “should” match don’t: Banner ad clickthroughs reported by the ad server don’t match the clickthroughs reported by the web analytics tool Visits reported by one web analytics [...]