Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

*** MOST IMPORTANT - DO NOT RESPOND IF YOU ARE NOT USING MS-EXCEL . ADD SCREENSHOTS IN YOUR ANSWER*** Data from a campaign run by

*** MOST IMPORTANT - DO NOT RESPOND IF YOU ARE NOT USING MS-EXCEL. ADD SCREENSHOTS IN YOUR ANSWER***

Data from a campaign run by a retailer for a period of 1 month. The retailer "bought" a set of Ad words from Google and monitored the performance of those Ad words over this time period.

We have daily data on the following variables,

- Whether any sale can be attributable to the adword (SALE [Yes=1 or No=0])

- Number of Clicks (CLICKS) generated by the adword

- Number of impressions (IMPS) adword gets

- The average position (AvgPOS) occupied by the adword.

Higher the AvgPOS, lower is the adword displayed in the rankings and hence less likely to be viewed

(a) Estimate an appropriate regression model with SALE as your dependent variable and CLICKS, IMPS and AvgPOS as the independent variables. Report and interpret the estimated coefficient on AvgPOS

(b) Notice that the CLICKS have a 'positive' impact on the likelihood of SALE, while AvgPOS has a 'negative' impact on the likelihood of sale. Suppose the average position occupied by an adword drops by 3 (i.e. the variable AvgPOS increases by 3). How much should the number of CLICKS increase so that the odds of getting a SALE do not change.

(c) We will now investigate the interaction between AvgPOS and CLICKS. Please introduce such an interaction variable in your model and estimate the model. Report and interpret the estimated coefficient on this interaction variable.

(d) Use the estimated model (with interaction effects) from part(c) for this question. An adword currently occupies an average position equal to 1.9 and the number of CLICKS generated by the adword are 5. Suppose the average position occupied by the adword increases by 3 (i.e. the variable AvgPOS drops from 1.9 to 4.9). By what % do the odds of getting a SALE change?

Please briefly show your calculations.

Data is here:

https://docs.google.com/spreadsheets/d/1k-C2-n8z4c22_L9bjkSq44AfxJBHEke-iwuD-ZYG_E0/edit?usp=sharing

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Trigonometry A Unit Circle Approach (Subscription)

Authors: Michael Sullivan

9th Edition

032183075X, 9780321830753

More Books

Students also viewed these Mathematics questions