Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop.
2. Use an Enter Data query to create a table called R07_Table with the following data:

Campaign	# of Clicks	Cost Per Click	New Customers
Click-ad Campaign 1	200	50	20
Click-ad Campaign 2	200	100	20
Click-ad Campaign 3	200	200	20

 

This table represents data on three different pay-per-click ad campaigns. For each campaign, the number of clicks paid for was 200, and for each campaign 20 new customers were acquired. The cost per click for each campaign varied.