Question: Please use the Facebook Ad dataset KAG_wrangled_dataset.csv for the next set of questions. We advise to solve these questions using R (preferably using dplyr library
Please use the Facebook Ad datasetKAG_wrangled_dataset.csvfor the next set of questions. We advise to solve these questions using R (preferably usingdplyrlibrary wherever applicable).
NOTE: For no clicks and no amount spent, please consider CPC as 0 for all the questions.
Load the dataset as:
data
Q: For thecampaign id (xyz)"916",what is themeanconversion rate?Here, the conversion ratefor each ad id is defined as approved conversions/ total conversions.Note that Conversion rate is 0 wheretotal conversion is 0
Provide the R code used to reach the answer.
I cannot attach the .csv file, so I am attaching a PORTION of the source file as an image reference, so please let me know what you advise the R code is.

\f
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
