Question: For each publisher, note three key metrics from your previous analysis: 1 . CPC 2 . Probability of Transaction 3 . Total Aggregate Cost Calculate
For each publisher, note three key metrics from your previous analysis: CPC Probability of Transaction Total Aggregate CostCalculate if you havent done so already, the overall averages for i probability of booking and ii CPC across all publishers. Note that the overall averages should not be calculated by averaging the averages of all the publishers. For example, to get an overall average of CPC you will have to divide the aggregate costs across all the publishers by the aggregate number of clicks you get these numbers in the last row of the pivot table NOT by averaging the calculated CPCs for each publisher. A similar calculation will need to be applied for the overall probability of booking
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
