The goal of every search engine marketing (SEM) advertiser is to maximize their returns at the lowest possible cost. Campaign performance is primarily tuned by adjusting the maximum cost per click (CPC) bid for each ad.
Data Science
-
From deterministic to probabilistic SEM bid optimization -
Firearm Sales: How are Americans coping with 2020? The US has a peculiar relationship with guns where we frequently observe nontrivial spikes in firearm sales. These are triggered (pun intended) by various political, economic, and social events at the time.
-
Build a loan amortization schedule with Python With mortgage rates at a historical low there are inklings the US housing market is heating up again. Buying a home is a huge decision and in a perfect world everyone weighs their options and makes a (relatively) rational choice.
-
Star Wars: exploring Lucas vs Disney era ticket sales With the end of the latest Star Wars trilogy, I wanted to compare, contrast, and explore Lucas vs Disney era domestic box office revenue. The analysis and python code below will parse weekly ticket sales from Box Office Mojo , adjust revenue numbers for inflation, visualize, and attempt to uncover insights from the data.
-
Examining drug effectiveness studies via simulation One of my dogs was recently diagnosed with an enlarged heart so the vet prescribed some medicine to mitigate the problem. The box came with a pamphlet which included the company’s effectiveness study for the drug, Vetmedin .
-
Algorithm to prioritize home improvement projects I moved to Los Angeles with my wife in October 2019 where we had a list of home improvement projects we wanted to complete or things to purchase. The problem we faced was disagreement on where to start since we had to juggle costs and compromise on what was most important at the time.
-
R script for the CausalImpact package Google has an amazing #rstats package called CausalImpact to predict the counterfactual: what would have happened if an intervention did not occur. This is a quick technical post to get someone up and running rather than a review of its literature, usage, or idiosyncrasies Load libraries library(tidyverse) library(CausalImpact) Download (dummy) data df <- read_csv("https://raw.
-
Exploratory data analysis on COVID-19 search queries The team at Bing were generous enough to release search query data with COVID-19 intent. The files are broken down by country and state level granularity so we can understand how the world is coping with the pandemic through search.
-
Using R to calculate car lease payments Purchasing a car is a significant time and financial commitment. There is so much at stake that the required song and dance with the sales manager don’t alleviate any fears about over paying.
-
How to interact with Slack from R I think my tweet speaks for itself: Words can not express how excited I am to use this :D — Christopher Yee ( @Eeysirhc ) March 10, 2020 The goal of this article is to document how to send #rstats code and plots directly to Slack. Load packages library(slackr) library(slackteams) library(slackreprex) Slack credentials Member ID You can easily grab that from this guide here .
-
Deciphering Hopper's Data Puzzle I like to browse company career pages once in awhile to see what positions they have open. In my opinion, this provides a glimpse into what they are investing in for the next few years.
-
Using R & GSC data to identify stale content My friend John-Henry Scherck recently tweeted his process on how to refresh stale content: Put together a quick video on how to refresh stale content using nothing more than Google Search Console and a word doc. Check out the full video here: https://t.
-
Calculating & estimating annual salaries with R A couple weeks ago, a friend asked me about my base annual salary during my time as Square’s SEO Lead. Rather than spitting out a number, I thought it would be more interesting to see if we could answer her question using #rstats .
-
R functions for simulation, sampling & visualization In my previous article about simulating page speed data , I broke one of the cardinal rules in programming: don’t repeat yourself . There was a reason for this: I wanted to show what is going on under the hood and the theoretical concepts associated with them before using other functions in R.
-
Simulating data to explore page speed performance We may be inundated with data but sometimes collecting it can be a challenge in and of itself. A few reasons off the top of my head: Sparsity Difficult to measure Impractical to devote company resources to it Lack of technical expertise to actually build or acquire it Lazy (yours truly - except for that one time ) Through simulation we can generate our own dataset with the added benefit of fully understanding what…