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:

week sponsored click-throughs organic click-throughs
1 31,002 198,566
2 29,005 199,025
3 27,852 193,255
4 24,056 201,255
5 220,040
6 218,508
7 210,004
8 218,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

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

Financial and Managerial Accounting

Authors: Horngren, Harrison, Oliver

3rd Edition

978-0132497992, 132913771, 132497972, 132497999, 9780132913775, 978-0132497978

More Books

Students also viewed these Accounting questions

Question

=+b. Who would choose to buy clothing insurance?

Answered: 1 week ago