DateChannelProductRevenueShipping CostMarketing Cost

01/01/2018LinkedinT-shirt47-5-6

01/01/2018SnapchatT-shirt49-5-2

01/01/2018AdWordsT-shirt50-7-7

01/01/2018FacebookT-shirt41-7-8

01/01/2018SnapchatShorts39-4-2

02/01/2018AdWordsHat22-3-6

02/01/2018SnapchatShorts38-4-3

02/01/2018FacebookPants80-3-6

02/01/2018FacebookT-shirt48-6-6

02/01/2018SnapchatT-shirt45-5-4

02/01/2018InstagramShorts36-4-4

02/01/2018EmailShorts34-2-4

02/01/2018EmailShorts30-20

02/01/2018TwitterShorts30-4-7

02/01/2018AdWordsT-shirt48-5-7

03/01/2018InstagramHat30-3-3

03/01/2018EmailPants74-4-1

03/01/2018EmailHat21-2-2

03/01/2018TwitterHat23-1-6

03/01/2018AdWordsT-shirt42-5-5

03/01/2018InstagramPants80-7-3

03/01/2018AdWordsShorts32-3-6

03/01/2018FacebookHat27-1-6

03/01/2018EmailShorts34-40

03/01/2018TwitterT-shirt45-4-7

03/01/2018FacebookT-shirt43-7-7

03/01/2018SnapchatShorts33-4-4

03/01/2018AdWordsPants77-3-5

04/01/2018FacebookShorts31-4-6

04/01/2018AdWordsT-shirt43-7-8

04/01/2018SnapchatT-shirt48-7-6

04/01/2018FacebookHat26-2-6

04/01/2018SnapchatHat27-1-5

04/01/2018AdWordsHat22-2-6

04/01/2018InstagramShorts36-4-3

04/01/2018InstagramShorts33-3-3

04/01/2018LinkedinShorts35-2-7

05/01/2018EmailT-shirt49-6-4

05/01/2018EmailShorts32-3-3

05/01/2018AdWordsT-shirt46-5-8

05/01/2018AdWordsPants77-3-5

05/01/2018InstagramShorts40-3-5

05/01/2018AdWordsPants73-7-5

06/01/2018SnapchatShorts39-2-3

06/01/2018LinkedinT-shirt41-4-7

06/01/2018TwitterHat30-2-8

06/01/2018LinkedinT-shirt43-6-7

06/01/2018LinkedinShorts33-4-7

06/01/2018SnapchatHat28-2-6

06/01/2018LinkedinShorts32-2-6

06/01/2018EmailT-shirt41-30

06/01/2018SnapchatPants72-4-4

06/01/2018SnapchatHat28-3-4

06/01/2018SnapchatT-shirt49-7-2

06/01/2018LinkedinPants74-4-8

07/01/2018LinkedinPants72-3-6

07/01/2018TwitterHat20-2-7

07/01/2018EmailPants79-5-4

07/01/2018InstagramPants74-6-4

07/01/2018TwitterPants75-3-7

07/01/2018InstagramShorts35-4-3

07/01/2018TwitterT-shirt45-6-8

07/01/2018TwitterShorts38-2-7

07/01/2018FacebookPants78-7-9

07/01/2018LinkedinPants72-6-7

07/01/2018SnapchatPants71-5-2

07/01/2018EmailHat27-3-4

08/01/2018FacebookHat22-1-9

08/01/2018EmailT-shirt40-5-3

08/01/2018TwitterShorts32-2-7

08/01/2018EmailShorts40-2-1

08/01/2018TwitterHat27-2-7

08/01/2018TwitterPants74-4-7

08/01/2018SnapchatShorts37-2-6

08/01/2018InstagramPants71-6-3

08/01/2018EmailShorts34-4-2

08/01/2018SnapchatPants75-5-6

09/01/2018EmailShorts31-2-4

09/01/2018FacebookPants73-4-8

09/01/2018InstagramHat23-3-3

09/01/2018SnapchatPants78-4-3

09/01/2018AdWordsShorts32-2-5

09/01/2018FacebookShorts40-3-9

09/01/2018FacebookShorts36-2-8

09/01/2018AdWordsT-shirt40-4-7

09/01/2018InstagramPants77-5-5

09/01/2018LinkedinT-shirt48-4-8

09/01/2018AdWordsT-shirt49-3-8

09/01/2018InstagramT-shirt43-3-5

09/01/2018EmailHat30-1-2

10/01/2018LinkedinHat27-2-8

10/01/2018TwitterShorts30-4-6

10/01/2018SnapchatPants75-7-4

10/01/2018InstagramPants77-7-7

10/01/2018AdWordsT-shirt46-4-6

10/01/2018FacebookPants76-6-7

10/01/2018InstagramT-shirt50-5-5

10/01/2018SnapchatHat20-3-4

10/01/2018FacebookShorts38-4-8

10/01/2018LinkedinShorts32-4-6

12 Pivot Table - Data.xlsx Please download and open the attached file. Insert a Pivot Table, slicer, and timeline to answer the following questions. Round your answers to whole numbers, without the dollar symbol. For the first 5 days, the total revenue generated through Facebook and Instagram is From Jan 4th to 6th, the revenue generated through non-social media channels (AdWords and Email) totals to Page 12 of 15 Review Later 11 Pivot Table - Data.xlsx Please download and open the attached file. Round your answers to whole numbers, without the dollar symbol. Hats generated (channel) costed the most in marketing cost. total in revenue, and pants generated in revenue through Instagram. Shorts generated on average in revenue through AdWords. (product) costed the most in shipping costs and Review Later