Question: 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

1 Expert Approved Answer
Step: 1 Unlock

ROI Revenue Cost Cost x 100 Revenue Number ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!