1.Create a pivot table that includes the following columns broken down by show, ordered by spend (largest at top): Spend, $/Visit, $/Direct Signup, $/Survey Sign Up, Visit to Direct Signup CVR. The company has a CAC target of $40. Which week of 2019 would you consider to have performed best? Why? What would you consider to be the companys top-performing show? Why? Customers (D)VisitsShowSpendCustomers (S)Media Week213A Sandwich & Some Lovin$550311/12/20182286Stuff You Should Know$7,4253211/19/201812The Big O and Dukes Podcast$400111/26/2018448Bertcasts Podcast$3,530512/3/201821140Stuff You Should Know$7,4254112/10/2018
0 Comments