Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

The click throughs obtained for Eltronix Inc during an eight-week period are provided in the table below. Eltronix ran a branded keyword search campaign in

The click throughs obtained for Eltronix Inc during an eight-week period are provided in the table below. Eltronix ran a branded keyword search campaign in the first four weeks at a CPC of $0.15. Eltronix did not sponsor branded keywords in the second four-week period. Assume no systematic difference exists between the two four-week periods. The conversion rate was 3.00 % and the margin per order was $ 15.00 during the eight weeks.

The data:

weeksponsored click-throughsorganic click-throughs
1                                   31,002198,566
2                                   29,005199,025
3                                   27,852193,255
4                                   24,056201,255
5220,040
6218,508
7210,004
8218,540


(please show excel pivot chart and formulae that summarize differences in click-throughs between the two 4-week periods)

Compute the ROI% that should be attributed to the campaign.


Step by Step Solution

3.50 Rating (163 Votes )

There are 3 Steps involved in it

Step: 1

ROI Revenue Cost Cost x 100 Revenue Number ... 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_2

Step: 3

blur-text-image_3

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

Essentials Of Federal Taxation 2018

Authors: Brian Spilker, Benjamin Ayers, John Robinson, Edmund Outslay, Ronald Worsham, John Barrick, Connie Weaver

9th Edition

1260007642, 978-1260150292, 1260150291, 978-1260007640

More Books

Students explore these related Accounting questions

Question

Compare Web 2.0 and Web 3.0.

Answered: 3 weeks ago