Question

1 Approved Answer

Posted on Jul 30, 2024

Which day of the week had the lowest Average Revenue per Transaction? What was it? Which platform had the highest total profit? What was it?

Which day of the week had the lowest Average Revenue per Transaction? What was it?
Which platform had the highest total profit? What was it?
Which platform had the lowest total profit? What was it?
Which day of the week had the highest total profit? What was it?
Which day of the week had the lowest total profit? What was it?
Which Platform had the highest Average Profit per Transaction? What was it?

image text in transcribed

1 Date 2345 2 3 4 15 16 17 18 9 10 11 12 13 14 15 16 17 18 19 20 E 21 22 23 = 24 25 I 26 27 28 29 30 31 32 33 Day of Week 1/1/21 Monday 1/1/21 Monday 1/1/21 Monday 1/1/21 Monday 1/2/21 Tuesday 1/2/21 Tuesday 1/2/21 Tuesday 1/2/21 Tuesday 1/3/21 Wednesday 1/3/21 Wednesday 1/3/21 Wednesday 1/3/21 Wednesday 1/4/21 Thursday 1/4/21 Thursday 1/4/21 Thursday 1/4/21 Thursday 1/5/01 Friday 1/5/01 Friday 1/5/01 Friday 1/5/01 Friday 1/6/21 Saturday 1/6/21 Saturday 1/6/21 Saturday 1/6/21 Saturday 1/7/21 Sunday 1/7/21 Sunday 1/7/21 Sunday 1/7/21 Sunday 1/8/21 Monday 1/8/21 Monday 1/8/21 Monday 1/8/21 Monday Channel Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Impressions Clicks Transactions 43806 1326 42976 1275 14998 1833 32274 1182 10263 1959 41376 540 49723 1769 23944 1893 35090 1676 18977 827 25139 571 41473 890 43432 1461 47541 1244 47159 1611 35663 823 16201 1235 1834 45357 18855 1655 12331 1907 24462 1370 18565 1719 47560 985 44750 1622 41387 1462 47104 1853 19072 1322 15794 703 11066 1490 49791 1646 39031 1377 12915 1098 Revenues 48 $7,008.00 35 $ 6,615.00 37 $ 6,993.00 43 $6,536.00 34 $ 6,290.00 15 $ 990.00 49 $ 6,566.00 24 $1,824.00 17 $ 2,941.00 39 $3,432.00 34 $ 5,236.00 23 $2,300.00 36 $5,112.00 34 $ 5,678.00 16 $ 1,808.00 40 $4,760.00 21 $3,633.00 50 $4,600.00 30 $ 4,560.00 37 $ 3,996.00 32 $3,264.00 37 $ 2,923.00 43 $ 2,150.00 27 $ 3,510.00 33 $ 5,115.00 40 $3,400.00 46 $7,314.00 18 $ 2,808.00 27 $ 1,485.00 10 $1,880.00 42 $ 6,720.00 30 $2,220.00 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 1/9/21 Tuesday 1/9/21 Tuesday 1/9/21 Tuesday 1/9/21 Tuesday 1/10/21 Wednesday 1/10/21 Wednesday 1/10/21 Wednesday 1/10/21 Wednesday 1/11/21 Thursday 1/11/21 Thursday 1/11/21 Thursday 1/11/21 Thursday 1/12/21 Friday 1/12/21 Friday 1/12/21 Friday 1/12/21 Friday 1/13/21 Saturday 1/13/21 Saturday 1/13/21 Saturday 1/13/21 Saturday 1/14/21 Sunday 1/14/21 Sunday 1/14/21 Sunday 1/14/21 Sunday 1/15/21 Monday 1/15/21 Monday 1/15/21 Monday 1/15/21 Monday 1/16/21 Tuesday 1/16/21 Tuesday 1/16/21 Tuesday 1/16/21 Tuesday 1/17/21 Wednesday Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook 19850 1355 30174 141 12327 1182 26752 1557 23050 102 17594 1214 21797 1650 30228 1203 23326 740 45497 1525 44931 460 23143 1566 46183 319 48337 438 42442 1862 33160 1562 23637 1154 15556 1733 23987 950 17341 364 47285 430 39824 1057 26295 1724 20449 652 13878 609 20774 1995 12022 1504 31068 1039 47289 1069 37905 1655 15546 694 13990 630 28508 1942 28 $ 1,820.00 47 $ 6,063.00 43 $ 7,568.00 23 $ 2,553.00 28 $ 2,352.00 13 $2,340.00 16 $2,240.00 31 $ 2,883.00 48 $ 6,480.00 17 $ 2,992.00 36 $ 2,664.00 20 $ 3,820.00 34 $ 6,630.00 17 $ 1,649.00 37 $3,515.00 15 $ 1,620.00 20 $ 2,560.00 10 $ 1,140.00 11 $ 1,947.00 24 $3,456.00 49 $ 8,624.00 16 $ 2,384.00 29 $ 2,813.00 47 $4,700.00 30 $3,690.00 32 $ 2,944.00 24 $4,176.00 34 $ 6,562.00 41 $ 2,378.00 19 $3,021.00 26 $4,602.00 19 $ 1,007.00 17 $ 3,349.00 67 1/17/21 Wednesday 1/17/21 Wednesday 68 69 1/17/21 Wednesday 70 1/18/21 Thursday 71 1/18/21 Thursday 72 1/18/21 Thursday 73 1/18/21 Thursday 74 1/19/21 Friday 75 1/19/21 Friday 76 1/19/21 Friday 77 1/19/21 Friday 78 1/20/21 Saturday 79 1/20/21 Saturday 80 1/20/21 Saturday 81 1/20/21 Saturday 82 1/21/21 Sunday 83 1/21/21 Sunday 84 1/21/21 Sunday 85 1/21/21 Sunday 86 1/22/21 Monday 87 1/22/21 Monday 88 1/22/21 Monday 89 1/22/21 Monday 90 1/23/21 Tuesday 91 1/23/21 Tuesday 92 1/23/21 Tuesday 93 1/23/21 Tuesday 94 1/24/21 Wednesday 95 1/24/21 Wednesday 96 1/24/21 Wednesday 97 1/24/21 Wednesday 98 1/25/21 Thursday 99 1/25/21 Thursday Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram 46049 1769 48777 332 20084 1581 40329 1919 35993 1178 49510 748 42707 585 40752 462 29052 1666 29306 1780 24594 342 43841 777 40605 1165 27673 127 26774 1059 12530 120 34714 232 27482 289 38659 489 17757 1784 16414 993 46665 917 15976 1186 23092 399 21040 557 23126 682 45439 1359 11590 1195 33252 317 45356 1579 17703 475 22028 170 26710 522 30 $4,440.00 37 $ 6,623.00 22 $4,356.00 22 $ 1,430.00 21 $ 1,785.00 21 $3,318.00 17 $ 2,159.00 29 $ 1,479.00 42 $ 7,014.00 49 $9,359.00 34 $ 3,434.00 11 $ 1,023.00 26 $2,236.00 28 $ 2,212.00 12 $ 804.00 36 $6,084.00 48 $ 5,424.00 13 $2,379.00 45 $ 6,660.00 37 $5,402.00 18 $ 1,332.00 34 $ 6,494.00 39 $ 6,396.00 47 $ 9,259.00 30 $ 5,070.00 11 $1,529.00 25 $3,950.00 21 $ 2,604.00 43 $2,580.00 35 $ 5,810.00 32 $ 1,728.00 13 $ 2,132.00 28 $ 1,596.00 100 1/25/21 Thursday 101 1/25/21 Thursday 102 1/26/21 Friday 103 1/26/21 Friday 104 1/26/21 Friday 105 1/26/21 Friday 106 1/27/21 Saturday 1/27/21 Saturday 107 108 1/27/21 Saturday 109 1/27/21 Saturday 110 1/28/21 Sunday 111 1/28/21 Sunday 112 1/28/21 Sunday 113 1/28/21 Sunday 114 1/29/21 Monday 115 1/29/21 Monday 116 1/29/21 Monday 117 1/29/21 Monday 118 1/30/21 Tuesday 119 1/30/21 Tuesday 120 1/30/21 Tuesday 121 1/30/21 Tuesday 122 1/31/21 Wednesday 123 1/31/21 Wednesday 124 1/31/21 Wednesday 125 1/31/21 Wednesday TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter 10710 940 24655 1751 10215 1772 10495 928 13807 1201 44867 984 30467 954 14058 1250 18441 979 17430 1024 10517 1058 32065 714 23498 1223 18220 731 34951 1349 49929 305 12798 288 27801 486 31396 1882 23121 235 43459 497 47444 126 24554 115 28139 794 33717 1722 12062 1565 13 $ 806.00 16 $ 1,376.00 12 $ 1,404.00 34 $5,406.00 48 $ 6,288.00 42 $ 5,208.00 30 1,800.00 31 $ 1,550.00 36 $2,448.00 41 $ 2,911.00 29 $ 1,450.00 15 $ 2,205.00 35 $ 4,305.00 47 $ 2,585.00 14 $ 742.00 14 $ 840.00 42 $ 6,426.00 14 $ 2,758.00 25 $ 3,350.00 21 $ 3,360.00 31 $ 2,821.00 27 $ 1,728.00 26 $ 3,198.00 31 $ 3,596.00 47 $ 3,572.00 44 $ 5,192.00 1 Date 2345 2 3 4 15 16 17 18 9 10 11 12 13 14 15 16 17 18 19 20 E 21 22 23 = 24 25 I 26 27 28 29 30 31 32 33 Day of Week 1/1/21 Monday 1/1/21 Monday 1/1/21 Monday 1/1/21 Monday 1/2/21 Tuesday 1/2/21 Tuesday 1/2/21 Tuesday 1/2/21 Tuesday 1/3/21 Wednesday 1/3/21 Wednesday 1/3/21 Wednesday 1/3/21 Wednesday 1/4/21 Thursday 1/4/21 Thursday 1/4/21 Thursday 1/4/21 Thursday 1/5/01 Friday 1/5/01 Friday 1/5/01 Friday 1/5/01 Friday 1/6/21 Saturday 1/6/21 Saturday 1/6/21 Saturday 1/6/21 Saturday 1/7/21 Sunday 1/7/21 Sunday 1/7/21 Sunday 1/7/21 Sunday 1/8/21 Monday 1/8/21 Monday 1/8/21 Monday 1/8/21 Monday Channel Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Impressions Clicks Transactions 43806 1326 42976 1275 14998 1833 32274 1182 10263 1959 41376 540 49723 1769 23944 1893 35090 1676 18977 827 25139 571 41473 890 43432 1461 47541 1244 47159 1611 35663 823 16201 1235 1834 45357 18855 1655 12331 1907 24462 1370 18565 1719 47560 985 44750 1622 41387 1462 47104 1853 19072 1322 15794 703 11066 1490 49791 1646 39031 1377 12915 1098 Revenues 48 $7,008.00 35 $ 6,615.00 37 $ 6,993.00 43 $6,536.00 34 $ 6,290.00 15 $ 990.00 49 $ 6,566.00 24 $1,824.00 17 $ 2,941.00 39 $3,432.00 34 $ 5,236.00 23 $2,300.00 36 $5,112.00 34 $ 5,678.00 16 $ 1,808.00 40 $4,760.00 21 $3,633.00 50 $4,600.00 30 $ 4,560.00 37 $ 3,996.00 32 $3,264.00 37 $ 2,923.00 43 $ 2,150.00 27 $ 3,510.00 33 $ 5,115.00 40 $3,400.00 46 $7,314.00 18 $ 2,808.00 27 $ 1,485.00 10 $1,880.00 42 $ 6,720.00 30 $2,220.00 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 1/9/21 Tuesday 1/9/21 Tuesday 1/9/21 Tuesday 1/9/21 Tuesday 1/10/21 Wednesday 1/10/21 Wednesday 1/10/21 Wednesday 1/10/21 Wednesday 1/11/21 Thursday 1/11/21 Thursday 1/11/21 Thursday 1/11/21 Thursday 1/12/21 Friday 1/12/21 Friday 1/12/21 Friday 1/12/21 Friday 1/13/21 Saturday 1/13/21 Saturday 1/13/21 Saturday 1/13/21 Saturday 1/14/21 Sunday 1/14/21 Sunday 1/14/21 Sunday 1/14/21 Sunday 1/15/21 Monday 1/15/21 Monday 1/15/21 Monday 1/15/21 Monday 1/16/21 Tuesday 1/16/21 Tuesday 1/16/21 Tuesday 1/16/21 Tuesday 1/17/21 Wednesday Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook 19850 1355 30174 141 12327 1182 26752 1557 23050 102 17594 1214 21797 1650 30228 1203 23326 740 45497 1525 44931 460 23143 1566 46183 319 48337 438 42442 1862 33160 1562 23637 1154 15556 1733 23987 950 17341 364 47285 430 39824 1057 26295 1724 20449 652 13878 609 20774 1995 12022 1504 31068 1039 47289 1069 37905 1655 15546 694 13990 630 28508 1942 28 $ 1,820.00 47 $ 6,063.00 43 $ 7,568.00 23 $ 2,553.00 28 $ 2,352.00 13 $2,340.00 16 $2,240.00 31 $ 2,883.00 48 $ 6,480.00 17 $ 2,992.00 36 $ 2,664.00 20 $ 3,820.00 34 $ 6,630.00 17 $ 1,649.00 37 $3,515.00 15 $ 1,620.00 20 $ 2,560.00 10 $ 1,140.00 11 $ 1,947.00 24 $3,456.00 49 $ 8,624.00 16 $ 2,384.00 29 $ 2,813.00 47 $4,700.00 30 $3,690.00 32 $ 2,944.00 24 $4,176.00 34 $ 6,562.00 41 $ 2,378.00 19 $3,021.00 26 $4,602.00 19 $ 1,007.00 17 $ 3,349.00 67 1/17/21 Wednesday 1/17/21 Wednesday 68 69 1/17/21 Wednesday 70 1/18/21 Thursday 71 1/18/21 Thursday 72 1/18/21 Thursday 73 1/18/21 Thursday 74 1/19/21 Friday 75 1/19/21 Friday 76 1/19/21 Friday 77 1/19/21 Friday 78 1/20/21 Saturday 79 1/20/21 Saturday 80 1/20/21 Saturday 81 1/20/21 Saturday 82 1/21/21 Sunday 83 1/21/21 Sunday 84 1/21/21 Sunday 85 1/21/21 Sunday 86 1/22/21 Monday 87 1/22/21 Monday 88 1/22/21 Monday 89 1/22/21 Monday 90 1/23/21 Tuesday 91 1/23/21 Tuesday 92 1/23/21 Tuesday 93 1/23/21 Tuesday 94 1/24/21 Wednesday 95 1/24/21 Wednesday 96 1/24/21 Wednesday 97 1/24/21 Wednesday 98 1/25/21 Thursday 99 1/25/21 Thursday Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram 46049 1769 48777 332 20084 1581 40329 1919 35993 1178 49510 748 42707 585 40752 462 29052 1666 29306 1780 24594 342 43841 777 40605 1165 27673 127 26774 1059 12530 120 34714 232 27482 289 38659 489 17757 1784 16414 993 46665 917 15976 1186 23092 399 21040 557 23126 682 45439 1359 11590 1195 33252 317 45356 1579 17703 475 22028 170 26710 522 30 $4,440.00 37 $ 6,623.00 22 $4,356.00 22 $ 1,430.00 21 $ 1,785.00 21 $3,318.00 17 $ 2,159.00 29 $ 1,479.00 42 $ 7,014.00 49 $9,359.00 34 $ 3,434.00 11 $ 1,023.00 26 $2,236.00 28 $ 2,212.00 12 $ 804.00 36 $6,084.00 48 $ 5,424.00 13 $2,379.00 45 $ 6,660.00 37 $5,402.00 18 $ 1,332.00 34 $ 6,494.00 39 $ 6,396.00 47 $ 9,259.00 30 $ 5,070.00 11 $1,529.00 25 $3,950.00 21 $ 2,604.00 43 $2,580.00 35 $ 5,810.00 32 $ 1,728.00 13 $ 2,132.00 28 $ 1,596.00 100 1/25/21 Thursday 101 1/25/21 Thursday 102 1/26/21 Friday 103 1/26/21 Friday 104 1/26/21 Friday 105 1/26/21 Friday 106 1/27/21 Saturday 1/27/21 Saturday 107 108 1/27/21 Saturday 109 1/27/21 Saturday 110 1/28/21 Sunday 111 1/28/21 Sunday 112 1/28/21 Sunday 113 1/28/21 Sunday 114 1/29/21 Monday 115 1/29/21 Monday 116 1/29/21 Monday 117 1/29/21 Monday 118 1/30/21 Tuesday 119 1/30/21 Tuesday 120 1/30/21 Tuesday 121 1/30/21 Tuesday 122 1/31/21 Wednesday 123 1/31/21 Wednesday 124 1/31/21 Wednesday 125 1/31/21 Wednesday TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter Facebook Instagram TikTok Twitter 10710 940 24655 1751 10215 1772 10495 928 13807 1201 44867 984 30467 954 14058 1250 18441 979 17430 1024 10517 1058 32065 714 23498 1223 18220 731 34951 1349 49929 305 12798 288 27801 486 31396 1882 23121 235 43459 497 47444 126 24554 115 28139 794 33717 1722 12062 1565 13 $ 806.00 16 $ 1,376.00 12 $ 1,404.00 34 $5,406.00 48 $ 6,288.00 42 $ 5,208.00 30 1,800.00 31 $ 1,550.00 36 $2,448.00 41 $ 2,911.00 29 $ 1,450.00 15 $ 2,205.00 35 $ 4,305.00 47 $ 2,585.00 14 $ 742.00 14 $ 840.00 42 $ 6,426.00 14 $ 2,758.00 25 $ 3,350.00 21 $ 3,360.00 31 $ 2,821.00 27 $ 1,728.00 26 $ 3,198.00 31 $ 3,596.00 47 $ 3,572.00 44 $ 5,192.00