Answered step by step
Verified Expert Solution
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
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