HW Minor - Data Analysis

docx

School

Harvard University *

*We aren’t endorsed by this school

Course

101

Subject

Economics

Date

Jan 9, 2024

Type

docx

Pages

Uploaded by JusticeOctopusPerson1028

Jake Kunzler 11/14/2023 Data 2100 Homework Minor: Data Analysis Questions 1/2: Question 3: Imps: Count . This is the total number of times the ads were observed. Clicks: Count. This is the total number of times the ads were clicked on. CTR: Rate. This is the ratio of clicks to impressions. Cost: Sum. This is the total cost associated with the campaign. CPC: Rate. This is the result of dividing total costs by total clicks. Conversions: Count. This is the total number of conversions resulting from the campaign. CRate: Rate. This is a ratio of conversions to clicks. Rev: Sum. This is the sum of revenue generated by ads. ACV: Rolling Average. This is the average value per conversion and is calculated over time. Rev/$: Rate. This is the revenue generated per dollar spent on the campaign. Question 4: a.) Ad F. It has the highest number of clicks b.) Ad A. It has the highest value in the “CPC” column. c.) Ad D. It has the highest value in the “revenue” column. d.) Ad G. It has the highest value in the "imps” column. e.) Ad H. It has the lowest value in the "CTR” column.

Question 5: a.) Ad G has the highest value in the Rev/$ column, which means that it had the highest revenue per dollar spent, and would then have the highest return on investment. An investment of $50,000 into Ad G would return $705,000. You find this by multiplying the initial investment, (50,000) by the Rev/$ value for Ad G, (14.10). This works because Rev/$ represents the revenue generated per dollar spent. Multiplying that value by any initial investment will result in the approximate return on that investment. Question 6: a.) H1 and H2 for ad B invoke imagery of funny videos of cats and dogs riding around on vacuums. This is going to draw the attention of people who want to watch those videos, but there is not a direct correlation between people who like watching videos of pets on vacuums, and people who need a vacuum for a pet. The natural result is a high volume of people clicking on the ad for a funny video, but with no interest in purchasing a vacuum. b.) I’m guessing that the question is associating Colorado with marijuana use, and Utah with family values. In that case, an advertisement that promotes vacuums by associating them with family time is going to succeed in Utah, and an ad that promotes vacuums by associating them with more time to mellow out and chill is going to succeed in Colorado. Different regions share different cultural identities and hold different values. Effective advertising campaigns need to take geography based demographics into account.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

Econ 340 homework 4-3 Maribel. Perez.doc

econ wksht wk 8.pdf

econ extra cred wksht week 13.pdf

Assigment #4 - APPLIED STATISTICS.pdf

CFUMemo#12.docx

CFUMemo#8.JoseDiaz.docx

midterm review questions 2023 .pdf

MAT 240 Module 5-3 Assignment .docx

Recommended textbooks for you

Managerial Economics: A Problem Solving Approach

Economics

ISBN:9781337106665

Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor

Publisher:Cengage Learning

Economics:

Economics

ISBN:9781285859460

Author:BOYES, William

Publisher:Cengage Learning

Economics Today and Tomorrow, Student Edition

Economics

ISBN:9780078747663

Author:McGraw-Hill

Publisher:Glencoe/McGraw-Hill School Pub Co

Microeconomics: Principles & Policy

Economics

ISBN:9781337794992

Author:William J. Baumol, Alan S. Blinder, John L. Solow

Publisher:Cengage Learning

Microeconomics: Private and Public Choice (MindTa...

Economics

ISBN:9781305506893

Author:James D. Gwartney, Richard L. Stroup, Russell S. Sobel, David A. Macpherson

Publisher:Cengage Learning

Macroeconomics: Private and Public Choice (MindTa...

Economics

ISBN:9781305506756

Author:James D. Gwartney, Richard L. Stroup, Russell S. Sobel, David A. Macpherson

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Economics:
Economics
ISBN:9781285859460
Author:BOYES, William
Publisher:Cengage Learning
Economics Today and Tomorrow, Student Edition
Economics
ISBN:9780078747663
Author:McGraw-Hill
Publisher:Glencoe/McGraw-Hill School Pub Co
Microeconomics: Principles & Policy
Economics
ISBN:9781337794992
Author:William J. Baumol, Alan S. Blinder, John L. Solow
Publisher:Cengage Learning
Microeconomics: Private and Public Choice (MindTa...
Economics
ISBN:9781305506893
Author:James D. Gwartney, Richard L. Stroup, Russell S. Sobel, David A. Macpherson
Publisher:Cengage Learning
Macroeconomics: Private and Public Choice (MindTa...
Economics
ISBN:9781305506756
Author:James D. Gwartney, Richard L. Stroup, Russell S. Sobel, David A. Macpherson
Publisher:Cengage Learning