Tag: data
Making a case for SQL Case Statements
The CASE statement is SQL’s method of handling your standard IF/THEN logic in Excel. You begin with CASE, followed by at least one pair of WHEN and THEN statements, and then you END it. You can be exhaustive in your WHEN/THEN statements, accounting for every possibility, or you can also use the ‘else’ functionality, and […]
How Data Convinced Netflix to Double Down on Adam Sandler
Back in 2014, Netflix signed Adam Sandler to a four movie deal worth $250 million. Even though only three of the four have been released so far, Netflix just offered him another four movies which puts his total contract at 8 movies for at least half a billion dollars. How and why has a successful production company with original content like House […]
Tracking is an increasingly important piece of the digital advertising landscape, and there is an ever-growing number of ways to gather information on the clicks heading to a website. One of the most versatile ways is through Google’s ValueTrack Parameters. Below is one way to use these parameters in Google Shopping campaigns to obtain the […]
A Starter Setup to Using SEO Crawls and Databases
Most people in digital marketing have so much data available at their fingertips now that working with databases is a necessity. On the SEO team, site crawls, performance numbers, and other data can be worked with in Microsoft Excel, but often it goes into our internal data warehouse where much of the work can be automated. For this example, […]
During a recent all-company meeting at PMG, I decided to give a pop quiz, featuring 11 stats and data points from various data and research sources. The feedback on the pop quiz was fantastic, so I decided to turn my pop quiz into a blog post. So without further ado, here are several recent stats from the world of digital marketing.
Omniture Metric Definitions
When working with Omniture data on a daily basis it is much easier to say “Your site had ten thousand unique visitors who visited your site 15 thousand times and consumed 400 thousand page views,” than to explain what that means in layman’s terms. Unique Visitor or UVs: A cookie based method of counting users that […]
2016 Data Strategy Checklist For Digital Marketers
Congratulations! You’re just wrapping up a (hopefully) successful 2015. You’re also well into 2016 planning. Based on what we’re hearing and seeing, 2016 seems to be the year that advertisers will put data strategies in the lead, more so than any year we’ve seen. These data strategies can be new forms of CRM activation, new […]
Google’s Travel Dashboard & Travel Category Trends Tool
Today I stumbled across this Travel Dashboard on Google’s ThinkWithGoogle.com website. It looks like Google officially calls this data tool the Travel Category Trends Tool. I have not ever seen this tool, and I don’t know how long it has been live. But wow – it has a lot of travel-related information that is presented in an easy-to-use interface. Well done, Google. [Side note: ThinkWithGoogle.com is quickly becoming one of my favorite websites.]
WRGMG: Table Formatting
You know what really grinds my gears? Poor table formatting. It can be hard enough to stare at a large table of numbers and try to find what you need, but sometimes it’s more difficult than it should be thanks to poor formatting. In this episode of WRGMG, let’s take a look at some common […]
A Beginners Guide to Omniture SiteCatalyst
Data Analytics. Big Data. These are buzz words we all use, but many have trouble making sense of. With these tips and tricks for using Omniture SiteCatalyst, one of the most common portals for data collection, I’m about to make your life a heck of a lot easier. Let’s begin with getting the data you want out of Omniture without necessarily having to log into SiteCatalyst each time you need it.
