Tag: data
ICYMI: WTH Is Blockchain?
PMG’s head of product strategy and new ventures, Dustin Engel, recently gave an ANA webinar about blockchain and its relevance to marketers. Dustin touched on why it’s okay for marketers to get excited about the hype, and how blockchain technology can positively impact the advertising industry over the next two years. For more, check out […]
ICYMI: Measurement Matters
PMG founder and CEO George Popstefanov recently shared his thoughts on how the foundational pillars of measurement will continue to rest on transparency, business-impacting insights, and applicability with Think with Google. George highlighted that as a strategic partner, agencies have the job to help brands navigate complex measurement processes, and ensure that data is reliable and transparent. […]
ICYMI: Maximizing Customer Lifetime Value
PMG founder and CEO George Popstefanov recently shared his thoughts in a Think with Google interview on how brands should focus on lifetime value instead of ROAS as a key success measure. In the interview, which is part of Google’s Executive Perspective series, George highlighted how brands that don’t have some kind of lifetime value […]
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, […]
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 […]