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