8.4 Google AdWords: Optimizing Online Advertising (Recitation)
Video 1: Introduction
The slides from all videos in this recitation can be downloaded here: Optimizing Online Advertising (PDF - 1.1MB).
Video 2: How Online Advertising Works
Video 3: Prices and Queries
Video 4: Modeling the Problem
Video 5: Solving the Problem
In this video, we’ll be using the spreadsheet GoogleAdWords_LO. If you are using LibreOffice or OpenOffice, please download and open the spreadsheet GoogleAdWords_LO (ODS) to follow along with this video. If you are using Microsoft Excel, please download and open the spreadsheet GoogleAdWords_LO (XLSX) to follow along with this video. The following spreadsheets provide the final model, as it is at the end of the video: GoogleAdWords_LO_Complete (ODS) and GoogleAdWords_LO_Complete (XLSX).
Video 6: A Greedy Approach
In this video, we’ll be using the spreadsheet GoogleAdWords_Greedy.ods. If you are using LibreOffice or OpenOffice, please download and open the spreadsheet GoogleAdWords_Greedy (ODS) to follow along with this video. If you are using Microsoft Excel, please download and open the spreadsheet GoogleAdWords_Greedy (XLSX) to follow along with this video. The following spreadsheets provide the final model, as it is at the end of the video: GoogleAdWords_Greedy_Complete (ODS) and GoogleAdWords_Greedy_Complete (XLSX).
Video 7: Sensitivity Analysis
In this video, we’ll be using the spreadsheet GoogleAdWords_LO_Sensitivity. If you are using LibreOffice or OpenOffice, please download and open the spreadsheet GoogleAdWords_LO_Sensitivity (ODS). If you are using Microsoft Excel, please download and open the spreadsheet GoogleAdWords_LO_Sensitivity (XLSX).