Use pivot tables and other formulas$/$functions to evaluate this data. For example, this

screenshot is calculating total clicks, grouped by social media channel, and by day of

the week. $($Pro Tip: Notice how I used conditional formatting to highlight the highest and

lowest values in each data range$).$ Do not try to match these numbers, this is just for

reference.

Include all of your calculations, pivot tables, and graphs in your excel document $($in other

words, $$show all of your work$).$

Calculate the following values and enter them in the $$Answer Sheet$$ tab of the

Campaign Data file:

$1.$ Which platform had the highest number of clicks? What was it$?$

$2.$ Which platform had the lowest number of clicks? What was it$?$

$3.$ Which day of the week had the highest number of clicks? What was it$?$

$4.$ Which day of the week had the lowest number of clicks? What was it$?$

$5.$ Which platform had the highest Click$-$Thru rate? What was it$?$

$6.$ Which platform had the lowest Click$-$Thru rate? What was it$?$

$7.$ Which day of the week had the highest Click$-$Thru rate? What was it$?$

$8.$ Which day of the week had the lowest Click$-$Thru rate? What was it$?$

$9.$ Which platform had the highest conversion rate? What was it$?$

$10.$ Which platform had the lowest conversion rate? What was it$?$

$11.$ Which day of the week had the highest conversion rate? What was it$?$

$12.$ Which day of the week had the lowest conversion rate? What was it$?$

$13.$ Which platform had the highest total revenue? What was it$?$

$14.$ Which platform had the lowest total revenue? What was it$?$

$15.$ Which day of the week had the highest total revenue? What was it$?$

$16.$ Which day of the week had the lowest total revenue? What was it$?$

$17.$ Which Platform had the highest Revenue per Transaction? What was it$?$

$18.$ Which Platform had the lowest Revenue per Transaction? What was it$?$

$19.$ Which day of the week had the highest Revenue per Transaction? What was it$?$

$20.$ Which day of the week had the lowest Revenue per Transaction? What was it$?$

$21.$ Which platform had the highest total profit? What was it$?$

$22.$ Which platform had the lowest total profit? What was it$?$

$23.$ Which day of the week had the highest total profit? What was it$?$

$24.$ Which day of the week had the lowest total profit? What was it$?$

$25.$ Which Platform had the highest Profit per Transaction? What was it$?$

$26.$ Which Platform had the lowest Profit per Transaction? What was it$?$

$27.$ Which day of the week had the highest Profit per Transaction? What was it$?$

$28.$ Which day of the week had the lowest Profit per Transaction? What was it$?$

$29.$ Which platform had the highest ROAS $($Revenue$)?$ What was it$?$

$30.$ Which platform had the lowest ROAS $($Revenue$)?$ What was it$?$

$31.$ Which platform had the highest ROAS $($Profit$)?$ What was it$?$

$32.$ Which platform had the lowest ROAS $($Profit$)?$ What was it$?$

Check Digits:

To make sure you are calculating your values correctly, you should be able to

reproduce these profit values:

To make sure you are setting up your pivot tables correctly, you should be able to

reproduce these impressions values:

Example of Pivot Table:

Here$$s an example $($not part of the check digits above, values do not pertain to this

assignment$)$ of how you might approach each category of questions $($e$.$g$.$Clicks$).$

Please note these values may not match...this is just to represent how you might

setup a pivot table with some addition formulas & functions:

Glossary of Terms:

$$ Platform: A specific social media$/$advertising channel, like Facebook.

$$ Impression: An impression represents one advertising $$view$.$ If five people

seen an ad$,$ there are five impressions.

$$ Click: When a person sees an ad and clicks on it$.$

$$ Transaction: A purchase.

$$ Click$-$Thru Rate: The percent of views that resulted in a click.

$$ Conversion Rate: The percent of clicks that resulted in a transaction

$($purchase$).$

$$ ROAS: This is the percent $$return on ad spend$.$ It is identical to ROI. You

may be asked to calculate it using revenue and$/$or profit.

$$ Pivot Tables: This is a simple but powerful data analysis tool built into

Microsoft Excel. If you haven$$t used pivot tables before $($or don$$t remember

how to use them$),$ I$$ve provided a series of short tutorial videos in the

zition: Students will construct clear and specific problem statements using

contextually relevant evidence.