• About Us
    • New York
  • Work
  • Capabilities
  • Careers
  • Technology
  • Blog
  • Contact Us
  • About Us
    • New York
  • Work
  • Capabilities
  • Careers
  • Technology
  • Blog
  • Contact Us

COVID-19

Updates &
Industry Insights

Read

Author: Preston Smith

April 18, 2018
Posted by Preston Smith

“How Much Should We Spend?” – A Diminishing Returns Analysis

At PMG, data and technology are at the heart of everything we do. So, when our clients ask us “How much we should be spending?”, we typically start with a data-driven approach. After some research, we decided to pursue the idea of calculating the point of diminishing returns to answer such a question. When will […]

Read
June 20, 2017
Posted by Preston Smith

How to Insert R data frame into SQL

I’ve run into this issue a couple of times during my time at PMG. I’ve used R to perform some kind of analysis, forecasting, clustering, etc., and I need to get the result into our database so anyone on our analytics team could use the output in a SQL query or connect to it in […]

Read
March 14, 2017
Posted by Preston Smith

SQL Join on One Column Contained in Another

SQL joins typically look to combine two tables into a set of columns that exist in both. Usually, the values match exactly, making the join straightforward. We can also use ILIKE to make the join case-insensitive and BETWEEEN if we have the date in one table and start date and end date in another. Those […]

Read
November 09, 2016
Posted by Preston Smith

How to Calculate Impression Share

My last blog post took a look at calculating average position. Let’s now look at another instance where people make the dreaded “take the average of an average” mistake, calculating impression share. (See the average position post to learn more about averages of averages.) Again, let’s take a look at some dummy data. We have date, […]

Read
June 07, 2016
Posted by Preston Smith

How to Calculate Average Position

I’ve been asked more times than I can remember, “How do you calculate the real average position?” The good news is that everyone asking realizes that taking an average of an average will get you in trouble. The bad news is they still don’t know how to actually calculate the true average position. In this post, […]

Read
May 23, 2016
Posted by Preston Smith

Google’s Causal Impact: Part 2 – Caution

Here it is. The highly anticipated second and final installment of my two-part series on Google’s Causal Impact R package. Please try to control your excitement. In part 1, we took a general look at how the package helps marketers measure incrementality and ran through a quick toy example. Here’s a quick refresher on the […]

Read
April 04, 2016
Posted by Preston Smith

Google’s Causal Impact: Part 1 – Intro

Incrementality. It’s one of the toughest things to tackle in digital analytics. “How many incremental conversions did that branding campaign drive?” “How many additional clicks did we drive by implementing that new Adwords feature?” The most common solution is a simple lift analysis: calculate the difference between the average conversions before and after the intervention. […]

Read
November 12, 2015
Posted by Preston Smith

WRGMG: Using Correlation to Imply Causation

You know what really grinds my gears? Using correlation to imply causation. It’s 2015 people, you should know better by now. When you Google “correlation vs causation,” about 5.3 million results are returned in a quarter of a second. The first one? “Correlation does not imply causation,” courtesy of Wikipedia. The only positive thing to come […]

Read
September 21, 2015
Posted by Preston Smith

Visualizing Impact of Different Products on ROI

You’re wanting to look at ROI by product over time against your goal, and you want to do more than show a data table. You want to come up with a way to visualize the data that’s meaningful and easy to understand. Naturally, you start by plotting a line graph of ROI over time with […]

Read
July 06, 2015
Posted by Preston Smith

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 […]

Read
Next
1 2

Latest White Papers

  • Shifting Plans for 2020 & Beyond
  • Game On: How Brands Can Log Into A Diverse Multi-Billion Dollar Industry
  • What CCPA Means For Brands
  • How Google is Improving Consumer Data Privacy
  • Ways to Prepare for the Cookieless Future
  • See all White Papers

Featured Posts

  • Ad Age Names PMG #1 Best Place to Work in 2021
  • MediaPost Names PMG Independent Agency of the Year
  • PMG Client Portfolio Trends During Amazon Prime Day 2020
  • A Closer Look at the Congressional Big Tech Market Power Report
  • What to Know About Reddit

Categories

  • Consumer Insights
  • Content
  • Creative Design
  • Data Analytics
  • Development
  • Digital TV & Video
  • Ecommerce
  • Industry News
  • Local
  • Mobile
  • Paid Search
  • PMG Culture
  • Programmatic & Display
  • SEO
  • Social Media
  • Structured Data
Fort Worth

2845 West 7th Street
Fort Worth, TX 76107

Dallas

3102 Oak Lawn Avenue
Suite 650
Dallas, TX 75219

Austin

823 Congress Avenue
Suite 800
Austin, TX 78701

London

33 Broadwick Street
London
W1F 0DQ

New York

120 East 23rd Street
New York, NY 10010

Get in touch

(817) 420 9970
info@pmg.com

Subscribe to the PMG Newsletter
© 2021 PMG Worldwide, LLC, All Rights Reserved
  • Contact
  • Privacy Policy
 Tweet
 Share
 Tweet
 Share
 Tweet
 Share
 LinkedIn
We and our partners use cookies to personalize content, analyze traffic, and deliver ads. By using our website, you agree to the use of cookies as described in our Cookie Policy.