User Account

All Pages

Which site has the highest cpc and the lowest cpc

Assignment Help Marketing Research
Reference no: EM131749507

Application Exercise -Tools of Measurement

This is an individual assignment and should reflect individual work.

Using the online ad data provided in the accompanying Excel document, create pivot tables to answer the following questions. Each answer should include a screenshot of the pivot table that you created to analyze the data.

NOTE: For all answers, disregard DoubleClick. You can filter it out via the pivot table.

Part One: Analyze CPC.

Add a calculated field for cost per click (CPC).

(1) Which site has the highest CPC and the lowest CPC?

(2) Which creative type has the highest CPC? Which creative type has the lowest CPC?

(3) Which pixel size has the highest CPC and the lowest CPC?

Part Two: Analyze CTR.

Add a calculated field for click-through-rate (CTR).

(4) Which creative type has the highest CTR?

(5) To answer this question, expand the table to show creative type by month. Which creative type is the highest performing and in which month?

(6) Based on CTR, what was the best performing ad on endocrineweb.com? (Describe the Creative, Creative Type, and Pixel Size). In which month did it perform the best?

Part Three: Develop Insights & Make Recommendations.

Add a calculated field for Cost Per Mille (CPM), which represents the cost per 1,000 impressions.

(7) Analyze the site and creative type using CTR, CPC, and CPM. If you were going to run another campaign for this client, what 3 sites would you recommend the client keep in the campaign?

What placement and creative type would you recommend for each site that you recommended? Explain your answer.

Attachment:- Online Ad Data for AE3.rar

Reference no: EM131749507

Questions Cloud

Define balance sheet presentation of the long-term liability : Discount on Bonds Payable account has been amortized. Show the balance sheet presentation of the long-term liability
Prepare a monthly flexible manufacturing overhead budget : Prepare a monthly flexible manufacturing overhead budget for each increment of 3,000 direct labour hours. Prepare a flexible budget report for October
Analyze a speech and a news article : Using any critique method covered in the Foss book, analyze a speech, news article or broadcast, advertisement, or film.
Discuss what benefit will show up when you record property : What benefit will show up when you record property, plant and equipment (PP&E) on the income statement as an expense
Which site has the highest cpc and the lowest cpc : Which site has the highest CPC and the lowest CPC?Which creative type has the highest CPC? Which creative type has the lowest CPC?
Compute the proportion of rejected lots : Selecting the appropriate control chart and limits. At the present time, about 6 out of every 1000 lots of material arriving at a plant site from outside.
Develop a paper on reseon state of us social security system : Research and develop a 4-6 page research paper (excluding title and reference pages) on the state of the United States social security system.
Capability of the film thickness process : Capability of the film thickness process. The specifications call for film thickness 830 ± 25 mm × 10-4.
What are the essence of management : How an individual employee participates in the decision-making process depends on his or her position within the overall structure of the company.

Reviews

Write a Review

Marketing Research Questions & Answers

  Would you use an app-platform like this

How do you think the consumer AIDA model could be impacted by this type of promotion or one like it ?Would you use an app/platform like this? Why or why not?

  Do you believe that some industries are unfairly targeted

In the land of free trade, the public does not view all industries as equal. Do you believe that is ethical? Do you believe that some industries are unfairly targeted? Should it be consumers' choice to partake in products that are not healthy for ..

  How should amazon stave off walmarts attacks

Is this a battle or core competencies or just a price war? Walmart vs Amazon.

  Discuss about the economic concept of operating

Do you think the high-end designer apparel brands, such as Gucci, Chanel, or Prada, sell their goods direct to consumers through the Internet?

  How might these technologies minimize risk

The authors of the assigned article, "A Patient-Driven Adaptive Prediction Technique to Improve Personalized Risk Estimation for Clinical Decision Support have found that using patient-driven, adaptive technologies to guide clinical decision mak..

  Develop an initial training plan for the company

Create a report that describes and critically analyzes at least 5 contemporary best practices to improve customer loyalty in a health care organization.

  Discuss the organizational characteristics

Describe the three (3) primary forms of organizational structure: functional, divisional, and matrix, and discuss the strengths and weaknesses of each.

  What questions are different critics asking and answering

Post a short (200-300 word) description of some of the major trends you see in the research for your own secondary sources.

  Prepare a variety of business correspondence media

Prepare a variety of business correspondence media.How many hours per week you can dedicate to this volunteer project .

  Describe your product or service offering

Describe an offering based on features, benefits, price, and costs of ownership. Describe your product or service offering.

  How would you characterize the communication style of each

The company currently employs more than 75 salespeople who call directly on businesses and organizations throughout the United States.

  How does the agency normally get its clients

Contact any one of the top-WO market research agencies in the world either by phone or email. Find out: How does the agency normally get its clients? Does the agency do most of its data analysis in-house, or does it contract out its data analysis req..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd