From the course: Marketing Attribution and Mix Modeling
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Before and after an event: Trend analysis
From the course: Marketing Attribution and Mix Modeling
Before and after an event: Trend analysis
- [Instructor] How do you tell if an event or action effected sales? Often the best method is the simplest. Just look at sales before and after to see if there's a spike or a dip. Let's look at an example of how to do this. We're looking at marketing data from an ice cream store, and we can see that they ran a newspaper ad in weeks 24 to 35. They want to know if that impacted revenue and we can use the before and after analysis to find out. So first let's just copy the data that we care about, which is the columns week, revenue, and newspaper ads. And if I just press control shift down or command shift down, it's going to select everything. I'm going to go control C and then control V to paste. So now we have just the data we care about, which is the week, revenue, and newspaper ads. Now we can see that they ran the ad for 12 weeks total. So there's 12 cells there. We want to find a comparable period previous as well.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Before and after an event: Trend analysis4m 40s
-
(Locked)
Linear regression with a single variable6m 4s
-
(Locked)
Variables with positive and negative correlations5m 45s
-
(Locked)
Multivariable regression: Building your marketing mix model11m 30s
-
(Locked)
Feature transformation with diminishing returns and adstocks10m 27s
-
(Locked)
Statistical tests to validate your model's accuracy12m 47s
-
(Locked)
Forecasting future scenarios for planning11m 25s
-
(Locked)
-
-