Spreadsheet: 745663d1630086074-lookup-partial-string-of-one-cell-and-return-the-entire-value-sample-sheet
Sheet: Dataset1

Product Category | Google Ads Campaign ID | Quantity | Unique Purchases | Product Revenue | Avg. Price | Avg. QTY | Full Campaign
MEMBER | (not set) | 20789 | 20789 | 3339106.724495 | 160.6189198371735 | 1
CERTIFICATION | (not set) | 9729 | 9568 | 2748483.427996 | 282.5042068039881 | 1.016826923076923
ELRN | (not set) | 6861 | 6803 | 1850102.258323 | 269.6548984583879 | 1.008525650448332
EXAM | (not set) | 5340 | 5340 | 1533998.136171 | 287.2655685713483 | 1
CONF | (not set) | 1931 | 1931 | 1013780.314188 | 525.0027520393578 | 1
VIRT | (not set) | 571 | 571 | 835561.199268 | 1463.329595915937 | 1
HGN | (not set) | 8953 | 7915 | 660228.525933 | 73.74383178074388 | 1.131143398610234
STD | (not set) | 1478 | 600 | 238654.442758 | 161.4712061962111 | 2.463333333333333
MEMBER | [PHONE] | 1068 | 1068 | 175775.953518 | 164.5842261404494 | 1
CERTIFICATION | [PHONE] | 541 | 541 | 165374.230426 | 305.6824961663586 | 1
CERTIFICATION | 364036963 | 351 | 351 | 146648.202918 | 417.8011479145299 | 1
MEMBER | [PHONE] | 731 | 731 | 115545.441605 | 158.0648995964432 | 1
CERTIFICATION | [PHONE] | 366 | 366 | 110249.48695 | 301.228106420765 | 1
STRE | (not set) | 571 | 380 | 105304.645312 | 184.421445380035 | 1.502631578947368
E | (not set) | 1858 | 1858 | 100532.141645 | 54.10771886167922 | 1
CRS | (not set) | 59 | 59 | 93571.618702 | 1585.959639016949 | 1
RUCR | (not set) | 1141 | 1112 | 92371.982564 | 80.95703993339177 | 1.026079136690647
SIX | (not set) | 15 | 15 | 73133.915242 | 4875.594349466666 | 1
ELRN | [PHONE] | 263 | 263 | 68130.554768 | 259.0515390418251 | 1
EXAM | [PHONE] | 190 | 190 | 66082.395509 | 347.8020816263158 | 1
ELRN | [PHONE] | 249 | 249 | 62132.374082 | 249.5276067550201 | 1
MEMBER | 72127286 | 293 | 293 | 47429.516546 | 161.8754830921502 | 1
ELRN | [PHONE] | 59 | 59 | 45893.397102 | 777.8541881694915 | 1
HGN | [PHONE] | 527 | 527 | 41846.819596 | 79.40572978368121 | 1
VIRT | [PHONE] | 44 | 44 | 41592.262659 | 945.2786967954545 | 1
CERTIFICATION | 61450963 | 117 | 117 | 37598.352105 | 321.3534367948718 | 1
BAL | (not set) | 1156 | 351 | 34672.410307 | 29.9934345216263 | 3.293447293447294
VIRT | [PHONE] | 29 | 29 | 33633.700969 | 1159.782792034483 | 1
CERTIFICATION | 364037083 | 73 | 73 | 33443.514752 | 458.1303390684931 | 1
BALE | (not set) | 2780 | 1419 | 33355.736498 | 11.99846636618705 | 1.959126145172657
HGN | 61450963 | 351 | 146 | 32309.712305 | 92.05046240740741 | 2.404109589041096
HGN | [PHONE] | 336 | 336 | 28874.656634 | 85.93647807738095 | 1
CERTIFICATION | 364036723 | 59 | 59 | 27533.11232 | 466.6629206779661 | 1
ELRN | 364036963 | 102 | 102 | 25280.137135 | 247.8444817156863 | 1
VIRT | 61450963 | 15 | 15 | 20115.849862 | 1341.056657466667 | 1
EXAM | [PHONE] | 59 | 59 | 19793.996264 | 335.4914621016949 | 1
EXAM | 364036963 | 44 | 44 | 19516.031793 | 443.5461771136364 | 1
ELRN | 364037083 | 44 | 44 | 18389.544201 | 417.9441863863636 | 1
MEMBER | [PHONE] | 102 | 102 | 17306.945735 | 169.6759385784314 | 1
MEMBER | 364036963 | 146 | 146 | 16648.608831 | 114.0315673356164 | 1
SECTION | (not set) | 20833 | 20833 | 15800.085709 | 0.7584162486919791 | 1
MEMBER | 61450963 | 117 | 117 | 15741.566873 | 134.5433066068376 | 1
CERTIFICATION | 72127286 | 59 | 59 | 14571.190154 | 246.9693246440678 | 1
ELRN | [PHONE] | 29 | 29 | 13795.815578 | 475.7177785517241 | 1
EXAM | 364037083 | 44 | 44 | 13108.219255 | 297.9140739772727 | 1
EXAM | [PHONE] | 59 | 59 | 12493.771478 | 211.7588386101695 | 1
HGN | 364036723 | 117 | 117 | 11411.173012 | 97.53139326495726 | 1
REC | (not set) | 117 | 117 | 10869.87378 | 92.9049041025641 | 1
CONF | [PHONE] | 15 | 15 | 10226.166584 | 681.7444389333333 | 1
CONF | [PHONE] | 15 | 15 | 8412.082669 | 560.8055112666666 | 1
CONF | 72127286 | 15 | 15 | 8412.082669 | 560.8055112666666 | 1
RUCR | [PHONE] | 102 | 102 | 8148.747908 | 79.88968537254901 | 1
MEMBER | [PHONE] | 44 | 44 | 7417.262458 | 168.5741467727273 | 1
CRED | (not set) | 44 | 44 | 7270.965368 | 165.2492129090909 | 1
HGN | 72127286 | 102 | 102 | 7263.650514 | 71.21225994117647 | 1
ELRN | [PHONE] | 15 | 15 | 6568.739337 | 437.9159558 | 1
EXAM | 364036723 | 15 | 15 | 6407.812538 | 427.1875025333334 | 1
CERTIFICATION | [PHONE] | 29 | 29 | 6261.515448 | 215.9143257931034 | 1
HGN | [PHONE] | 44 | 44 | 6144.477776 | 139.6472221818182 | 1
CERTIFICATION | 364036843 | 15 | 15 | 6115.218358 | 407.6812238666667 | 1
EXAM | 72127286 | 29 | 29 | 5822.624178 | 200.7801440689655 | 1
EXAM | 61450963 | 15 | 15 | 5764.105342 | 384.2736894666667 | 1
HGN | [PHONE] | 59 | 59 | 5471.511162 | 92.7374773220339 | 1
ELRN | 72127286 | 44 | 44 | 5091.138729 | 115.7076983863636 | 1
HGN | 364036843 | 44 | 44 | 5061.879311 | 115.0427116136364 | 1
HGN | 364036963 | 29 | 29 | 4096.318517 | 141.2523626551724 | 1
PUB | (not set) | 161 | 117 | 3796.409483 | 23.5801831242236 | 1.376068376068376
ELRN | 364036843 | 29 | 29 | 3335.57365 | 115.0197810344828 | 1
MEMBER | 364037083 | 29 | 29 | 2925.941798 | 100.8945447586207 | 1
E | [PHONE] | 29 | 29 | 2779.644708 | 95.84981751724138 | 1
E | [PHONE] | 44 | 44 | 2713.811018 | 61.67752313636363 | 1
MEMBER | 364036723 | 15 | 15 | 2472.420819 | 164.8280546 | 1
MEMBER | [PHONE] | 15 | 15 | 2472.420819 | 164.8280546 | 1
STD | [PHONE] | 15 | 15 | 2165.196931 | 144.3464620666667 | 1
STRE | 72127286 | 15 | 15 | 2165.196931 | 144.3464620666667 | 1
E | 364036963 | 15 | 15 | 2121.307804 | 141.4205202666667 | 1
E | 364037083 | 15 | 15 | 2121.307804 | 141.4205202666667 | 1
HGN | 364037083 | 29 | 29 | 2106.678095 | 72.6440722413793 | 1
ELRN | 364036723 | 15 | 15 | 1740.93537 | 116.062358 | 1
ELRN | 61450963 | 15 | 15 | 1740.93537 | 116.062358 | 1
REC | [PHONE] | 15 | 15 | 1448.34119 | 96.55607933333333 | 1
HGN | [PHONE] | 15 | 15 | 1375.192645 | 91.67950966666668 | 1
RUCR | [PHONE] | 15 | 15 | 1316.673809 | 87.77825393333333 | 1
PUB | 61450963 | 15 | 15 | 1169.645234 | 77.97634893333334 | 1
LATE | (not set) | 15 | 15 | 1024.079629 | 68.27197526666667 | 1
RUCR | [PHONE] | 15 | 15 | 1009.44992 | 67.29666133333333 | 1
RESEARCH | (not set) | 102 | 102 | 994.820211 | 9.75313932352941 | 1
SECTION | [PHONE] | 1053 | 1053 | 877.782539 | 0.8336016514719848 | 1
DIVISION | (not set) | 89373 | 89373 | 731.48545 | 0.008184635740100478 | 1
PUB | 72127286 | 15 | 15 | 306.492403 | 20.43282686666667 | 1
SECTION | [PHONE] | 731 | 731 | 292.59418 | 0.4002656361149111 | 1
SECTION | 364037083 | 44 | 44 | 292.59418 | 6.649867727272728 | 1
BALE | [PHONE] | 15 | 15 | 175.556508 | 11.7037672 | 1
DIVISION | [PHONE] | 380 | 380 | 0 | 0 | 1
DIVISION | [PHONE] | 278 | 278 | 0 | 0 | 1
DIVISION | [PHONE] | 5808 | 5808 | 0 | 0 | 1
DIVISION | [PHONE] | 2999 | 2999 | 0 | 0 | 1
DIVISION | 364036723 | 190 | 190 | 0 | 0 | 1
DIVISION | 364036963 | 512 | 512 | 0 | 0 | 1
DIVISION | 364037083 | 688 | 688 | 0 | 0 | 1
DIVISION | 61450963 | 1009 | 1009 | 0 | 0 | 1
DIVISION | 72127286 | 1770 | 1770 | 0 | 0 | 1
DIVISION | [PHONE] | 29 | 29 | 0 | 0 | 1
RECP | (not set) | 59 | 59 | 0 | 0 | 1
SECTION | [PHONE] | 102 | 102 | 0 | 0 | 1
SECTION | [PHONE] | 29 | 29 | 0 | 0 | 1
SECTION | 364036723 | 15 | 15 | 0 | 0 | 1
SECTION | 364036963 | 132 | 132 | 0 | 0 | 1
SECTION | 61450963 | 117 | 117 | 0 | 0 | 1
SECTION | 72127286 | 293 | 293 | 0 | 0 | 1
SECTION | [PHONE] | 15 | 15 | 0 | 0 | 1
SES | (not set) | 644 | 644 | 0 | 0 | 1
 |  | 198374 | 193604 | 14443422.76119 | 72.80905139378144 | 1.024637920704118