Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need to know how to do the following on my own on excel! Please give the an explanation and formulas! Thank you! Which platform had

Need to know how to do the following on my own on excel! Please give the an explanation and formulas! Thank you!

  1. Which platform had the highest ROAS (Revenue)? What was it?
  2. Which platform had the highest ROAS (Profit)? What was it?
  3. Which platform had the lowest ROAS (Profit)? What was it?
Date Day of Week Channel Impressions Clicks Transactions Revenues
1/1/23 Monday Facebook 38,167 868 49 $ 4,018.00
1/1/23 Monday Instagram 12,239 1,924 24 $ 3,624.00
1/1/23 Monday TikTok 10,656 400 49 $ 7,154.00
1/1/23 Monday Twitter 24,132 1,745 30 $ 5,280.00
1/2/23 Tuesday Facebook 28,407 264 32 $ 5,888.00
1/2/23 Tuesday Instagram 44,482 1,884 40 $ 3,880.00
1/2/23 Tuesday TikTok 36,934 681 11 $ 682.00
1/2/23 Tuesday Twitter 16,497 1,062 11 $ 1,705.00
1/3/23 Wednesday Facebook 26,265 1,173 25 $ 3,800.00
1/3/23 Wednesday Instagram 24,726 1,889 48 $ 4,032.00
1/3/23 Wednesday TikTok 11,659 1,252 30 $ 3,870.00
1/3/23 Wednesday Twitter 28,923 776 43 $ 4,730.00
1/4/23 Thursday Facebook 19,487 278 46 $ 5,520.00
1/4/23 Thursday Instagram 43,027 1,068 27 $ 2,349.00
1/4/23 Thursday TikTok 42,740 960 49 $ 3,626.00
1/4/23 Thursday Twitter 41,357 1,480 28 $ 2,128.00
1/5/23 Friday Facebook 10,426 279 22 $ 2,794.00
1/5/23 Friday Instagram 39,938 1,775 12 $ 1,188.00
1/5/23 Friday TikTok 20,831 776 40 $ 7,080.00
1/5/23 Friday Twitter 20,835 1,842 44 $ 8,008.00
1/6/23 Saturday Facebook 32,627 1,547 21 $ 3,885.00
1/6/23 Saturday Instagram 33,965 221 31 $ 4,092.00
1/6/23 Saturday TikTok 12,963 1,918 27 $ 2,916.00
1/6/23 Saturday Twitter 12,515 1,349 26 $ 3,978.00
1/7/23 Sunday Facebook 20,101 536 50 $ 3,800.00
1/7/23 Sunday Instagram 43,511 604 50 $ 3,800.00
1/7/23 Sunday TikTok 45,536 1,672 50 $ 4,650.00
1/7/23 Sunday Twitter 36,854 1,286 18 $ 2,970.00
1/8/23 Monday Facebook 23,927 563 12 $ 1,092.00
1/8/23 Monday Instagram 24,757 1,246 35 $ 4,655.00
1/8/23 Monday TikTok 10,455 803 17 $ 1,530.00
1/8/23 Monday Twitter 41,955 1,224 37 $ 6,845.00
1/9/23 Tuesday Facebook 40,765 1,267 36 $ 7,056.00
1/9/23 Tuesday Instagram 41,675 1,168 33 $ 4,917.00
1/9/23 Tuesday TikTok 10,484 428 28 $ 3,612.00
1/9/23 Tuesday Twitter 25,417 1,069 31 $ 4,588.00
1/10/23 Wednesday Facebook 38,419 882 15 $ 1,320.00
1/10/23 Wednesday Instagram 48,624 1,502 47 $ 7,896.00
1/10/23 Wednesday TikTok 24,032 276 40 $ 4,080.00
1/10/23 Wednesday Twitter 34,712 1,688 36 $ 3,024.00
1/11/23 Thursday Facebook 48,026 1,611 45 $ 7,515.00
1/11/23 Thursday Instagram 47,293 1,118 10 $ 780.00
1/11/23 Thursday TikTok 48,739 833 13 $ 1,040.00
1/11/23 Thursday Twitter 14,646 789 32 $ 4,160.00
1/12/23 Friday Facebook 27,207 1,995 27 $ 3,618.00
1/12/23 Friday Instagram 23,861 1,284 22 $ 2,090.00
1/12/23 Friday TikTok 36,299 1,477 10 $ 670.00
1/12/23 Friday Twitter 35,337 963 35 $ 3,255.00
1/13/23 Saturday Facebook 30,717 700 30 $ 2,400.00
1/13/23 Saturday Instagram 36,162 102 10 $ 690.00
1/13/23 Saturday TikTok 11,126 117 17 $ 3,145.00
1/13/23 Saturday Twitter 17,153 602 48 $ 7,344.00
1/14/23 Sunday Facebook 27,251 997 28 $ 2,800.00
1/14/23 Sunday Instagram 22,840 315 22 $ 1,320.00
1/14/23 Sunday TikTok 20,680 383 36 $ 6,876.00
1/14/23 Sunday Twitter 31,197 1,834 21 $ 1,323.00
1/15/23 Monday Facebook 29,773 590 35 $ 1,960.00
1/15/23 Monday Instagram 16,945 887 32 $ 5,472.00
1/15/23 Monday TikTok 28,076 877 37 $ 3,959.00
1/15/23 Monday Twitter 18,870 1,039 49 $ 8,967.00
1/16/23 Tuesday Facebook 48,064 1,919 31 $ 4,805.00
1/16/23 Tuesday Instagram 41,881 961 10 $ 750.00
1/16/23 Tuesday TikTok 12,398 1,856 32 $ 3,040.00
1/16/23 Tuesday Twitter 44,905 1,076 29 $ 3,538.00
1/17/23 Wednesday Facebook 16,716 747 21 $ 3,843.00
1/17/23 Wednesday Instagram 12,487 150 13 $ 2,444.00
1/17/23 Wednesday TikTok 25,205 1,465 12 $ 2,172.00
1/17/23 Wednesday Twitter 27,359 1,416 18 $ 2,484.00
1/18/23 Thursday Facebook 34,543 794 36 $ 7,164.00
1/18/23 Thursday Instagram 38,342 1,031 27 $ 4,860.00
1/18/23 Thursday TikTok 22,642 388 47 $ 3,149.00
1/18/23 Thursday Twitter 39,149 1,042 28 $ 4,032.00
1/19/23 Friday Facebook 39,166 1,832 34 $ 4,828.00
1/19/23 Friday Instagram 20,357 102 40 $ 4,000.00
1/19/23 Friday TikTok 31,744 1,455 10 $ 1,880.00
1/19/23 Friday Twitter 16,275 138 20 $ 3,000.00
1/20/23 Saturday Facebook 49,648 169 35 $ 1,925.00
1/20/23 Saturday Instagram 48,878 1,848 45 $ 2,700.00
1/20/23 Saturday TikTok 24,718 1,685 24 $ 1,536.00
1/20/23 Saturday Twitter 43,388 1,595 27 $ 4,401.00
1/21/23 Sunday Facebook 28,000 916 26 $ 1,404.00
1/21/23 Sunday Instagram 17,374 1,768 38 $ 5,890.00
1/21/23 Sunday TikTok 35,665 438 23 $ 1,495.00
1/21/23 Sunday Twitter 26,503 1,860 15 $ 2,790.00
1/22/23 Monday Facebook 12,979 636 11 $ 1,936.00
1/22/23 Monday Instagram 43,127 1,521 25 $ 4,150.00
1/22/23 Monday TikTok 30,219 159 22 $ 2,288.00
1/22/23 Monday Twitter 48,321 1,598 40 $ 5,920.00
1/23/23 Tuesday Facebook 16,143 211 33 $ 3,696.00
1/23/23 Tuesday Instagram 39,806 1,967 19 $ 1,102.00
1/23/23 Tuesday TikTok 28,403 1,687 18 $ 3,312.00
1/23/23 Tuesday Twitter 12,465 1,474 23 $ 4,462.00
1/24/23 Wednesday Facebook 13,108 793 41 $ 4,920.00
1/24/23 Wednesday Instagram 18,269 1,926 11 $ 1,430.00
1/24/23 Wednesday TikTok 45,903 793 48 $ 6,576.00
1/24/23 Wednesday Twitter 30,607 459 30 $ 4,740.00
1/25/23 Thursday Facebook 14,225 1,543 42 $ 5,628.00
1/25/23 Thursday Instagram 14,265 236 38 $ 2,964.00
1/25/23 Thursday TikTok 29,843 1,992 19 $ 2,660.00
1/25/23 Thursday Twitter 48,370 804 19 $ 3,249.00
1/26/23 Friday Facebook 46,948 936 31 $ 3,565.00
1/26/23 Friday Instagram 16,871 351 35 $ 5,600.00
1/26/23 Friday TikTok 28,339 574 27 $ 2,943.00
1/26/23 Friday Twitter 42,003 341 31 $ 2,356.00
1/27/23 Saturday Facebook 49,085 640 43 $ 6,622.00
1/27/23 Saturday Instagram 10,799 1,732 41 $ 8,036.00
1/27/23 Saturday TikTok 30,149 107 30 $ 4,470.00
1/27/23 Saturday Twitter 34,380 336 36 $ 5,724.00
1/28/23 Sunday Facebook 14,254 355 28 $ 2,968.00
1/28/23 Sunday Instagram 41,998 1,862 12 $ 1,392.00
1/28/23 Sunday TikTok 20,259 337 35 $ 5,950.00
1/28/23 Sunday Twitter 14,912 1,188 19 $ 1,159.00
1/29/23 Monday Facebook 48,979 685 47 $ 6,768.00
1/29/23 Monday Instagram 27,046 454 40 $ 3,640.00
1/29/23 Monday TikTok 11,680 1,034 29 $ 1,566.00
1/29/23 Monday Twitter 34,528 1,727 47 $ 4,559.00
1/30/23 Tuesday Facebook 29,389 1,812 34 $ 3,536.00
1/30/23 Tuesday Instagram 49,308 1,874 27 $ 3,645.00
1/30/23 Tuesday TikTok 26,261 480 33 $ 5,643.00
1/30/23 Tuesday Twitter 46,447 1,379 18 $ 1,080.00
1/31/23 Wednesday Facebook 31,093 476 12 $ 816.00
1/31/23 Wednesday Instagram 47,819 1,128 30 $ 5,190.00
1/31/23 Wednesday TikTok 44,678 283 49 $ 3,136.00
1/31/23 Wednesday Twitter 14,699 1,724 36 $ 5,724.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Corporate Finance

Authors: Berk, Peter DeMarzo, Jarrad Harford

3rd Global Edition

1292018402, 9781292018409

More Books

Students also viewed these Finance questions

Question

- SA 0 6 - ( ) , . . . . .

Answered: 1 week ago

Question

Whats involved in listening?

Answered: 1 week ago