Your task
Using campaign-performance.csv, compute conversions divided by clicks across all six rows. Write the metric definition and output unit before choosing a formula.
Hint
Use a separate calculation area so the raw source stays unchanged. Keep excluded rows and reconcile the total.
Worked solution
=SUM(E2:E7)/SUM(D2:D7) =54/900 =6%. An average of campaign percentages would weight unequal-sized campaigns equally.
Boundary check
Search is 27/270=10%; Social 9/450=2%; Email 18/180=10%. Explain why the overall result is 6%.
Make the reasoning yours.
Try the activity before reading its reference. Keep your sources, commands and assumptions with your work. Companion activities are unsaved self-practice and do not award a certificate or change lesson progress.