Pivot Table

by

Business Finance

Answer the following questions using the LARGE dataset from the Air France spreadsheet:

a. Which campaign got the most clicks? how about click-through-rate? which campaign generated the most revenue? which campaign generated the highest return on ad dollars spent?

b. which keyword group got the most clicks? how about click-through-rate? which keyword group generated the most revenue? which keyword group generated the highest return on ad dollars spent?

c. which keyword got the most clicks? how about click-through-rate? which keyword generated the most revenue? which keyword generated the highest return on ad dollars spent?

PLEASE COMPLETE THE ASSIGNMENT IN EXCEL, under separate tabs as shown in the ANSWERS.

Please, answer this question in the Word Doc:

Are these answers (above) consistently pointing to the same campaign/keyword group/keyword? Why or why not?