Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a two-page dashboard in Looker Studio with the data below. Please include in the dashboard: Fields Conversion Rate (purchases/users) Average Order Value (revenue/purchases) Average

Create a two-page dashboard in Looker Studio with the data below. Please include in the dashboard:

Fields

  • Conversion Rate (purchases/users)
  • Average Order Value (revenue/purchases)
  • Average Orders per User (purchases/userr
  • Visualizations
  • Page Views trended
  • Totals for: page views, users, conversion rate, average order value, average order per user
  • Some kind of chart showing Users by channel
  • Some kind of chart showing Orders by channel
  • Some kind of chart showing Conversion Rate by channel
  • On one page, please include an image or shapes
  • On one page, please include a control
date medium users purchases revenue
20231001 cross-network 87 15 843
20231002 cross-network 98 14 1076
20231003 cross-network 106 9 381
20231004 cross-network 152 8 259
20231005 cross-network 185 13 1033
20231006 cross-network 278 7 591
20231007 cross-network 249 23 931
20231008 cross-network 225 13 1061
20231009 cross-network 142 23 1444
20231010 cross-network 131 27 2363
20231011 cross-network 198 18 1082
20231012 cross-network 257 22 1238
20231013 cross-network 246 14 830
20231014 cross-network 229 14 938
20231015 cross-network 201 15 994
20231016 cross-network 138 25 1505
20231017 cross-network 144 29 1013
20231018 cross-network 180 13 746
20231019 cross-network 219 8 504
20231020 cross-network 279 2 130
20231021 cross-network 265 3 77
20231022 cross-network 231 9 533
20231023 cross-network 153 15 938
20231024 cross-network 147 8 440
20231025 cross-network 220 3 76
20231026 cross-network 264 2 25
20231027 cross-network 343 4 204
20231028 cross-network 275 6 262
20231029 cross-network 221 2 76
20231030 cross-network 170 6 390
20231031 cross-network 161 4 255
20231001 (none) 564 25 1208
20231002 (none) 632 14 522
20231003 (none) 631 20 1064
20231004 (none) 778 14 819
20231005 (none) 1021 22 1223
20231006 (none) 1392 8 383
20231007 (none) 1047 22 1555
20231008 (none) 978 31 3397
20231009 (none) 736 31 2374
20231010 (none) 689 27 2723
20231011 (none) 889 38 2401
20231012 (none) 1065 26 1782
20231013 (none) 1073 11 491
20231014 (none) 1025 22 1305
20231015 (none) 924 36 2770
20231016 (none) 758 34 2919
20231017 (none) 676 25 1590
20231018 (none) 805 35 2012
20231019 (none) 931 13 802
20231020 (none) 1088 2 77
20231021 (none) 1036 20 1095
20231022 (none) 924 14 554
20231023 (none) 713 11 1373
20231024 (none) 681 3 64
20231025 (none) 876 4 117
20231026 (none) 875 3 90
20231027 (none) 986 4 287
20231028 (none) 994 10 729
20231029 (none) 865 8 421
20231030 (none) 668 3 32
20231031 (none) 625 2 54
20231001 380 17 1395
20231002 432 10 544
20231003 474 12 644
20231004 512 6 386
20231005 669 8 501
20231006 900 4 230
20231007 681 9 565
20231008 613 16 693
20231009 482 14 1656
20231010 484 11 350
20231011 624 12 822
20231012 717 10 567
20231013 687 13 553
20231014 623 12 1226
20231015 594 11 709
20231016 484 7 585
20231017 439 4 212
20231018 567 11 687
20231019 598 2 279
20231020 708 2 81
20231021 689 4 193
20231022 577 9 479
20231023 505 9 466
20231024 424 4 127
20231025 584
20231026 597 1 120
20231027 626 1 18
20231028 595 2 68
20231029 540 4 241
20231030 415 2 211
20231031 405 2 97
20231001 cpc 104 3 246
20231002 cpc 147 5 308
20231003 cpc 109 1 50
20231004 cpc 164 3 95
20231005 cpc 197 1 307
20231006 cpc 260
20231007 cpc 207 5 345
20231008 cpc 183 6 208
20231009 cpc 136 2 82
20231010 cpc 153 2 53
20231011 cpc 163 7 432
20231012 cpc 202 2 64
20231013 cpc 218 1 95
20231014 cpc 188 2 240
20231015 cpc 161 4 230
20231016 cpc 117 4 410
20231017 cpc 129 4 303
20231018 cpc 157 3 194
20231019 cpc 176 2 83
20231020 cpc 198
20231021 cpc 224 1 14
20231022 cpc 197 1 61
20231023 cpc 146 1 17
20231024 cpc 144 2 68
20231025 cpc 175 1 26
20231026 cpc 190
20231027 cpc 182
20231028 cpc 172 1 22
20231029 cpc 157
20231030 cpc 129
20231031 cpc 154 1 27
20231001 organic 804 22 1266
20231002 organic 957 22 2006
20231003 organic 978 26 1141
20231004 organic 1158 39 2290
20231005 organic 1605 25 1971
20231006 organic 2100 12 547
20231007 organic 1649 22 3517
20231008 organic 1455 22 1127
20231009 organic 1158 47 3631
20231010 organic 1053 42 3435
20231011 organic 1356 47 3050
20231012 organic 1596 29 1436
20231013 organic 1514 20 1522
20231014 organic 1480 25 2801
20231015 organic 1333 45 3472
20231016 organic 1085 35 3773
20231017 organic 1082 33 1648
20231018 organic 1245 27 1715
20231019 organic 1437 19 748
20231020 organic 1608 9 861
20231021 organic 1557 15 842
20231022 organic 1319 11 494
20231023 organic 1018 22 998
20231024 organic 1000 3 201
20231025 organic 1345 5 213
20231026 organic 1360 7 332
20231027 organic 1522 5 198
20231028 organic 1344 14 924
20231029 organic 1291 5 132
20231030 organic 959 7 200
20231031 organic 963 5 283
20231001 referral 350 24 1300
20231002 referral 433 16 745
20231003 referral 454 21 1037
20231004 referral 556 25 2609
20231005 referral 751 17 1361
20231006 referral 991 11 577
20231007 referral 737 27 1559
20231008 referral 712 33 2209
20231009 referral 548 29 1676
20231010 referral 447 33 1832
20231011 referral 646 38 2613
20231012 referral 800 17 1197
20231013 referral 762 15 904
20231014 referral 745 22 1995
20231015 referral 647 27 1563
20231016 referral 546 37 2317
20231017 referral 477 29 1979
20231018 referral 584 17 1270
20231019 referral 745 7 366
20231020 referral 812 5 250
20231021 referral 820 9 1208
20231022 referral 740 15 1109
20231023 referral 543 9 626
20231024 referral 523 3 292
20231025 referral 656 4 120
20231026 referral 702 3 167
20231027 referral 818 6 454
20231028 referral 759 2 92
20231029 referral 637 5 548
20231030 referral 514 5 771
20231031 referral 484 10 1879

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

Mind Management Not Time Management

Authors: David Kadavy

1st Edition

0578733692, 978-0578733692

More Books

Students also viewed these General Management questions

Question

Find the price of the book "Database Systems".

Answered: 1 week ago

Question

3.2 Discuss the strategic importance of technology in HRM.

Answered: 1 week ago