Spreadsheet: 169797d1343063849-lookup-matching-value-and-return-name-email-sample
Sheet: Sheet1

Campaign | Account | [NAME] | Creative | [NAME] | Logo | Follow up | # of Campaigns | Sent | Bounced | [NAME] | Delivered | Delivered Rate | Total Opens | Total Open Rate | Unique Opens | Unique Open Rate | Total Clicks | Total Click-Through Rate | Unique Click-Throughs | Unique Click Through Rate | Unsubscribes | Unsubscribe Rate
ACCO BRANDS . INC | ACCO BRANDS . INC | 40703 |  |  |  |  | 1 | 1183 | 33 | 0.02789999917149544 | 1150 | 0.9720999598503113 | 366 | 0.3182999789714813 | 185 | 0.1608999967575073 | 41 | 0.0356999970972538 | 38 | 0.03299999982118607 | 4 | 0.003499999875202775
AEGIS MEDIA NORTH AMERICA | AEGIS MEDIA NORTH AMERICA | 40567 |  |  |  |  | 3 | 1323.666666666667 | 31.33333333333333 | 0.02226666666666667 | 1292.333333333333 | 0.9666 | 725.5 | 0.53355 | 288.5 | 0.21205 | 34 | 0.02505 | 27.5 | 0.02025 | 0.5 | 0.00035
AEGIS MEDIA NORTH AMERICA | AMBROSE EMPLOYER GROUP LLC | 40645 |  |  |  |  | 1 | 8257 | 760 | 0.09199999272823334 | 7497 | 0.9079999923706055 | 6968 | 0.9294000267982483 | 2389 | 0.3187000155448914 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 10 | 0.001299999887123704
AEGIS MEDIA NORTH AMERICA | AMERICAN REPROGRAPHICS COMPANY | 40723 |  |  |  |  | 3 | 1518.666666666667 | 73.33333333333333 | 0.04753333317091068 | 1445.333333333333 | 0.9524666497548422 | 705 | 0.4940333309809367 | 370.3333333333333 | 0.2591333293914795 | 47.5 | 0.03354999967962503 | 34.5 | 0.02434999952167273 | 9.5 | 0.006699999875202775
AMBROSE EMPLOYER GROUP LLC | [NAME] | 40701 |  |  |  |  | 2 | 1285 | 208 | 0.162200003862381 | 1077 | 0.8377999663352966 | 454 | 0.4268999993801117 | 316.5 | 0.2964999824762344 | 45 | 0.04130000062286854 | 41 | 0.03775000013411045 | 6 | 0.005799999693408608
AMERICAN REPROGRAPHICS COMPANY | [NAME] | 40680 |  |  |  |  | 3 | 1031 | #[NAME]! | #[NAME]! | 1031 | 1 | 1081.666666666667 | 1.151899998029073 | 340.3333333333333 | 0.3395666611671448 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 3 | 0.003666666656763603
AMERICAN REPROGRAPHICS COMPANY | CAPE FEAR COMMUNITY COLLEGE | 40729 |  |  |  |  | 1 | 517 | 64 | 0.1238000020384789 | 453 | 0.8762000203132629 | 105 | 0.2318000048398972 | 88 | 0.1942999958992004 | 33 | 0.07280000299215317 | 28 | 0.06179999560117722 | 3 | 0.0066
AMERICAN REPROGRAPHICS COMPANY | CBEYOND COMMUNICATIONS | 40827 |  |  |  |  | 1 | 1956 | 1 | 0.0005000000237487257 | 1955 | 0.9994999766349792 | 716 | 0.3661999702453613 | 236 | 0.1206999942660332 | 60 | 0.03069999814033508 | 58 | 0.02969999983906746 | 8 | 0.0041
[NAME] | CENTURION INDUSTRIES | 40785 |  |  |  |  | 1 | 183 | 8 | 0.04369999840855598 | 175 | 0.9562999606132507 | 71 | 0.4056999981403351 | 35 | 0.199999988079071 | 21 | 0.119999997317791 | 20 | 0.1142999976873398 | 2 | 0.0113999992609024
[NAME] | CENTURYLINK | 40785 |  |  |  |  | 2 | 19440 | 172.5 | 0.008900000000000002 | 19267.5 | 0.9911 | 7442 | 0.38625 | 3640 | 0.189 | 978 | 0.0501 | 900 | 0.0461 | 40 | 0.002
[NAME] | CITY OF TEMPE | 40806 |  |  |  |  | 2 | 1529 | 7.5 | 0.0049 | 1521.5 | 0.9951 | 1085.5 | 0.71315 | 422.5 | 0.2775 | 65 | 0.0428 | 63 | 0.0415 | 9 | 0.0059
[NAME] | DAVID EVANS & ASSOCIATES | 40820 |  |  |  |  | 2 | 738 | 3 | 0.0046 | 735 | 0.9908000230789185 | 20 | 0.03099999763071537 | 12 | 0.01860000006854534 | 13 | 0.02019999921321869 | 13 | 0.02019999921321869 | 0 | 0
[NAME] | FIELD FORCE OF NEW ENGLAND FINANCIA | 40820 |  |  |  |  | 1 | 2491 | 255 | 0.1023999974131584 | 2236 | 0.897599995136261 | 395 | 0.1766999959945679 | 277 | 0.1239000037312508 | 67 | 0.02999999932944775 | 61 | 0.02730000019073486 | 4 | 0.001800000085495412
CAPE FEAR COMMUNITY COLLEGE | [NAME] | 40702 |  |  |  |  | 1 | 1916 | 59 | 0.0308 | 1857 | 0.9692 | 1609 | 0.8665 | 393 | 0.2116 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
CBEYOND COMMUNICATIONS | GEBA | 40709 |  |  |  |  | 1 | 7084 | 0 | 0 | 7084 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
CENTURION INDUSTRIES | MAXELL CORPORATION OF AMERICA | 40708 |  |  |  |  | 1 | 60 | #[NAME]! | #[NAME]! | 60 | 1 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 5 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
CENTURYLINK | MEDICA HEALTH PLANS | 40674 |  |  |  |  | 3 | 1157.666666666667 | 0 | 0 | 1157.666666666667 | 1 | 643.3333333333334 | 0.5551000003178914 | 354 | 0.30493332584699 | 66.5 | 0.05805 | 64.5 | 0.0563 | 7.333333333333333 | 0.006266666615506014
CENTURYLINK | Microchip | 40799 |  |  |  |  | 3 | 1558.666666666667 | 5.333333333333333 | 0.003033333333333334 | 1553.333333333333 | 0.9969666666666667 | 758 | 0.5444666666666667 | 347.3333333333333 | 0.2509666666666667 | 67 | 0.0286 | 63 | 0.0269 | 3 | 0.0013
CITY OF TEMPE | MICROCHIP TECHNOLOGY | 40638 |  |  |  |  | 1 | 2315 | 2 | 0.0009 | 2313 | 0.9991 | 910 | 0.3934 | 483 | 0.2088 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
CITY OF TEMPE | MINNESOTA MEDICAL ASSOCIATION | 40717 |  |  |  |  | 1 | 2107 | 50 | 0.0237 | 2057 | 0.9763 | 328 | 0.1595 | 267 | 0.1298 | 3 | 0.0015 | 3 | 0.0015 | 2 | 0.001
DAVID EVANS & ASSOCIATES | MRV COMMUNICATIONS, INC | 40571 |  |  |  |  | 1 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
DAVID EVANS & ASSOCIATES | New England Financial | 40710 |  |  |  |  | 1 | 2418 | 52 | 0.0215000007301569 | 2366 | 0.9784999489784241 | 406 | 0.1715999990701675 | 291 | 0.1229999959468842 | 27 | 0.0113999992609024 | 27 | 0.0113999992609024 | #[NAME]! | #[NAME]!
FIELD FORCE OF NEW ENGLAND FINANCIA | NTA precision axle | 40703 |  |  |  |  | 1 | 21 | 2 | 0.0952 | 19 | 0.9048 | 11 | 0.5789 | 6 | 0.3158 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
[NAME] | NW FINANCIAL ASSOC.EE BENEFIT TRUST | 40787 |  |  |  |  | 1 | 4000 | 0 | 0 | 4000 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
GEBA | NYPRO | 40585 |  |  |  |  | 1 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
MAXELL CORPORATION OF AMERICA | PATNI COMPUTER SYSTEMS, INC | 40771 |  |  |  |  | 1 | 2252 | 35 | 0.01549999881535769 | 2217 | 0.9844999313354492 | 658 | 0.2967999875545502 | 244 | 0.1101000010967255 | 144 | 0.06499999761581421 | 128 | 0.05769999697804451 | 2 | 0.0009000000427477062
MEDICA HEALTH PLANS | Premier Home Health Care | 40674 |  |  |  |  | 1 | 662 | 37 | 0.05590000003576279 | 625 | 0.944100022315979 | 104 | 0.1663999855518341 | 71 | 0.113599993288517 | 10 | 0.01600000075995922 | 8 | 0.0127999996766448 | #[NAME]! | #[NAME]!
MEDICA HEALTH PLANS | Providence Hospitals | 40743 |  |  |  |  | 1 | 2077 | 21 | 0.0101 | 2056 | 0.9899 | 293 | 0.1425 | 137 | 0.0666 | 130 | 0.0632 | 120 | 0.0584 | 4 | 0.0019
MEDICA HEALTH PLANS | PUBLIC EMPLOYEES FEDERATION | 40813 |  |  |  |  | 2 | 15051.5 | 213 | 0.0273 | 14740 | 0.9684999999999999 | 7707.5 | 0.57585 | 5595.5 | 0.41135 | 381 | 0.06970000000000001 | 318 | 0.05895 | #[NAME]! | #[NAME]!
Microchip | SPRINT | 40764 |  |  |  |  | 3 | 26114.66666666667 | 0 | 0 | 26114.66666666667 | 1 | 10492.66666666667 | 0.5253999995539586 | 4736 | 0.2359666669160128 | 640 | 0.01620000042021275 | 600 | 0.0151999993249774 | 88.33333333333333 | 0.003433333327372869
Microchip | State of Alabama | 40848 |  |  |  |  | 2 | 5511.5 | 605.5 | 0.1096999980509281 | 4906 | 0.8902999758720398 | 2206 | 0.4494999945163727 | 1603.5 | 0.3267499804496765 | 154 | 0.03129999898374081 | 131.5 | 0.02674999833106995 | 24 | 0.00484999967738986
Microchip | TOLL BROTHERS, INC. | 40848 |  |  |  |  | 2 | 228 | 4 | 0.01755 | 224 | 0.98245 | 87.5 | 0.3897500019550323 | 54.5 | 0.2416499955296516 | 15.5 | 0.06974999701976776 | 10.04 | 0.06299999822974205 | 0 | 0
MICROCHIP TECHNOLOGY | WINDSTREAM COMMUNICATIONS | 40666 |  |  |  |  | 4 | 4881 | 101.5 | 0.02082499922364951 | 4779.5 | 0.9791749923944473 | 3124 | 0.6544249816417694 | 1621.75 | 0.3397499990224838 | 248 | 0.0509 | 0.04785 | 0.0233 | 5.5 | 0.0011
MINNESOTA MEDICAL ASSOCIATION | Totals | 40716 |  |  |  |  | 55 | 120867.3333333333 | 2804 |  | 117964.8333333333 |  | 49472.66666666666 |  | 24804.75 |  | 3295.5 |  | 2757.08785 |  | 235.1666666666667
MRV COMMUNICATIONS, INC | Averages | 40878 |  |  |  |  | 1.666666666666667 | 3898.94623655914 | 96.6896551724138 | 0.0369899421956144 | 3805.317204301075 | 0.9623226924707149 | 1766.880952380952 | 0.4512491042085348 | 885.8839285714286 | 0.2179113068623202 | 137.3125 | 0.0427739125414387 | 119.8733847826087 | 0.03775869494825602 | 10.68939393939394 | 0.003357575681687079
New England Financial |  | 40849
NTA precision axle | [NAME] | 40757 |  |  |  |  | 4 | 26114.66666666667 | 760 | 0.162200003862381 | 26114.66666666667 | 1 | 10492.66666666667 | 1.151899998029073 | 5595.5 | 0.41135 | 978 | 0.119999997317791 | 900 | 0.1142999976873398 | 88.33333333333333 | 0.0113999992609024
NW FINANCIAL ASSOC.EE BENEFIT TRUST | Highest Company | 40568 |  |  |  |  | Windstream | Sprint | Ambrose Employer Group LLC | [NAME] | Sprint | [NAME] | Sprint | [NAME] | Public Employees Federation | Public Employees Federation | CenturyLink | Centurion Industries | CenturyLink | Centurion Industires | Sprint | Centurion Industries
NYPRO | Min | 40876 |  |  |  |  | 1 | 21 | 0 | 0 | 19 | 0.8377999663352966 | 11 | 0.03099999763071537 | 6 | 0.01860000006854534 | 3 | 0.0015 | 0.04785 | 0.0015 | 0 | 0
PATNI COMPUTER SYSTEMS, INC | Lowest Company | 40533 |  |  |  |  | N/A | NTA [NAME] | N/A | N/A | NTA [NAME] | [NAME] | NTA [NAME] | David Evans & Assoc. | NTA [NAME] | David Evans & Assoc. | Minnesota Medical Assoc. | Minnesota Medical Assoc. | Windstream | Minnesota Medical Assoc. | N/A | N/A
Premier Home Health Care |  | 40848
Providence Hospitals |  | 40722
PUBLIC EMPLOYEES FEDERATION |  | 40710
PUBLIC EMPLOYEES FEDERATION |  | 40710
SPRINT |  | 40603
Sprint |  | 40806
SPRINT |  | 40806
State of Alabama |  | 40827
State of Alabama |  | 40827
TOLL BROTHERS, INC. |  | 40639
TOLL BROTHERS, INC. |  | 40855
WINDSTREAM COMMUNICATIONS |  | 40631
WINDSTREAM COMMUNICATIONS |  | 40631
WINDSTREAM COMMUNICATIONS |  | 40722
WINDSTREAM COMMUNICATIONS |  | 40722