Spreadsheet: 91729d1291393507-new-data-column-but-lost-on-how-to-use-it-sample
Sheet: Sheet1

[NAME]
Newsletter | From | Date | Subject | Sends | Opens | Clicks | Send Group | Open Rate | [NAME] | Sales | Conversion rate
Big News | 123 Buisness | 2010-11-11 00:00:00 | Cyber monday Starts Deals | 55723 | 547 | 167 | TV |  |  | 45
Big News | 123 Buisness | 2010-11-11 00:00:00 | Cyber monday Starts Deals | 57769 | 598 | 119 | Earth |  |  | 45
Big News | 123 Buisness | 2010-11-11 00:00:00 | Cyber monday Starts Deals | 31522 | 590 | 96 | Office |  |  | 45
Big News | 123 Buisness | 2010-11-11 00:00:00 | Cyber monday Starts Deals | 450558 | 2183 | 755 | Movies |  |  | 45
Official | 123 Buisness | 2010-11-13 00:00:00 | Cyber monday Starts Now | 45497 | 771 | 183 | [NAME] |  |  | 45
Official | 123 Buisness | 2010-11-13 00:00:00 | Cyber monday Starts Now | 47014 | 1064 | 193 | PDF |  |  | 45
Official | 123 Buisness | 2010-11-13 00:00:00 | Cyber monday Starts Now | 38660 | 608 | 192 | Music |  |  | 45
Official | 123 Buisness | 2010-11-13 00:00:00 | Cyber monday Starts Now | 21529 | 408 | 99 | Antivirus |  |  | 45
Official | 123 Buisness | 2010-11-13 00:00:00 | Cyber monday Starts Now | 28242 | 508 | 130 | Flash |  |  | 45
Big News | 123 Buisness | 2010-11-10 00:00:00 | Cyber monday | 34437 | 365 | 41 | [NAME] |  |  | 45
Big News | 123 Buisness | 2010-11-10 00:00:00 | Cyber monday | 19993 | 483 | 42 | PDF |  |  | 45
Big News | 123 Buisness | 2010-11-10 00:00:00 | Cyber monday | 32966 | 281 | 59 | Music |  |  | 45
Big News | 123 Buisness | 2010-11-10 00:00:00 | Cyber monday | 16186 | 213 | 28 | Flash |  |  | 45
Big News | 123 Buisness | 2010-11-10 00:00:00 | Cyber monday | 16215 | 220 | 23 | Antivirus |  |  | 45
Big News | 123 Buisness | 2010-11-11 00:00:00 | Cyber monday | 146298 | 740 | 157 | Movies |  |  | 45
Big News | 123 Buisness | 2010-11-11 00:00:00 | Cyber monday | 26847 | 198 | 38 | TV |  |  | 45
Big News | 123 Buisness | 2010-11-11 00:00:00 | Cyber monday | 5443 | 80 | 11 | Earth |  |  | 45
Big News | 123 Buisness | 2010-11-11 00:00:00 | Cyber monday | 9318 | 129 | 16 | Office |  |  | 45
Big News | 123 Buisness | 2010-11-14 00:00:00 | Cyber monday | 58546 | 1001 | 164 | Flash |  |  | 45
Big News | 123 Buisness | 2010-11-14 00:00:00 | Cyber monday | 49569 | 829 | 137 | [NAME] |  |  | 45
Big News | 123 Buisness | 2010-11-14 00:00:00 | Cyber monday | 44327 | 818 | 144 | Antivirus |  |  | 45
Big News | 123 Buisness | 2010-11-14 00:00:00 | Cyber monday | 35364 | 625 | 69 | PDF |  |  | 45
Big News | 123 Buisness | 2010-11-14 00:00:00 | Cyber monday | 85700 | 1239 | 278 | Music |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Cyber monday | 83636 | 1933 | 519 | Antivirus |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Cyber monday | 5197 | 102 | 47 | [NAME] |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Cyber monday | 216823 | 4085 | 1649 | Music |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Cyber monday | 301987 | 6156 | 1686 | Flash |  |  | 45
Big News | 123 Buisness | 2010-11-16 00:00:00 | Cyber monday | 370944 | 2200 | 312 | Movies |  |  | 45
Working | 123 Buisness | 2010-11-11 00:00:00 | Black Friday Sale | 19374 | 172 | 13 | Office |  |  | 45
Working | 123 Buisness | 2010-11-11 00:00:00 | Black Friday Sale | 54940 | 290 | 33 | TV |  |  | 45
Working | 123 Buisness | 2010-11-11 00:00:00 | Black Friday Sale | 28041 | 237 | 24 | Earth |  |  | 45
Working | 123 Buisness | 2010-11-11 00:00:00 | Black Friday Sale | 232121 | 808 | 124 | Movies |  |  | 45
CD's | 123 Buisness | 2010-11-13 00:00:00 | Black Friday | 116861 | 909 | 187 | [NAME] |  |  | 45
CD's | 123 Buisness | 2010-11-13 00:00:00 | Black Friday | 47354 | 426 | 84 | Flash |  |  | 45
CD's | 123 Buisness | 2010-11-13 00:00:00 | Black Friday | 84135 | 1531 | 178 | PDF |  |  | 45
CD's | 123 Buisness | 2010-11-13 00:00:00 | Black Friday | 248719 | 2455 | 556 | Music |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Black Friday | 32129 | 216 | 29 | Antivirus |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Black Friday | 49140 | 447 | 53 | PDF |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Black Friday | 51021 | 179 | 33 | Music |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Black Friday | 49485 | 316 | 45 | Flash |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Black Friday | 56744 | 318 | 29 | [NAME] |  |  | 45
CD's | 123 Buisness | 2010-11-11 00:00:00 | Black Friday | 63570 | 565 | 83 | TV |  |  | 45
CD's | 123 Buisness | 2010-11-11 00:00:00 | Black Friday | 30700 | 374 | 43 | Office |  |  | 45
CD's | 123 Buisness | 2010-11-11 00:00:00 | Black Friday | 8960 | 166 | 25 | Earth |  |  | 45
CD's | 123 Buisness | 2010-11-11 00:00:00 | Black Friday | 257266 | 2023 | 359 | Movies |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Black Friday | 32670 | 238 | 43 | TV |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Black Friday | 22829 | 357 | 44 | PDF |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Black Friday | 18601 | 187 | 30 | Flash |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Black Friday | 35645 | 283 | 96 | Music |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Black Friday | 18073 | 179 | 36 | Antivirus |  |  | 45
CD's | 123 Buisness | 2010-11-14 00:00:00 | Black Friday | 36840 | 319 | 49 | [NAME] |  |  | 45
Img iTunes | 123 Buisness | 2010-09-19 00:00:00 | Save Now | 17669 | 499 | 34 | Earth |  |  | 45
Img iTunes | 123 Buisness | 2010-09-19 00:00:00 | Save Now | 289258 | 2847 | 316 | Movies |  |  | 45
Img iTunes | 123 Buisness | 2010-09-19 00:00:00 | Save Now | 5363 | 98 | 11 | Office |  |  | 45
Img iTunes | 123 Buisness | 2010-09-19 00:00:00 | Save Now | 81710 | 1236 | 147 | TV |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 21513 | 253 | 28 | Antivirus |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 15661 | 264 | 27 | Antivirus |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 15020 | 211 | 17 | Antivirus |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 161718 | 1485 | 204 | [NAME] |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 32795 | 362 | 39 | [NAME] |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 32795 | 362 | 39 | [NAME] |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 13913 | 88 | 8 | [NAME] |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 12166 | 195 | 32 | Flash |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 3892 | 80 | 6 | Flash |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 36125 | 602 | 24 | Flash |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 39265 | 409 | 89 | Music |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 16823 | 155 | 25 | Music |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 16823 | 155 | 25 | Music |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 29070 | 276 | 27 | Music |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 17516 | 982 | 115 | PDF |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 12724 | 266 | 28 | PDF |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 22928 | 1060 | 88 | PDF |  |  | 45
Img iTunes | 123 Buisness | 2010-09-20 00:00:00 | Save Now | 22928 | 1060 | 88 | PDF |  |  | 45
Img iTunes | 123 Buisness | 2010-09-25 00:00:00 | Save Now | 21514 | 208 | 20 | Antivirus |  |  | 45
Img iTunes | 123 Buisness | 2010-09-25 00:00:00 | Save Now | 14874 | 345 | 42 | Earth |  |  | 45
Img iTunes | 123 Buisness | 2010-09-25 00:00:00 | Save Now | 9645 | 269 | 19 | Earth |  |  | 45
Img iTunes | 123 Buisness | 2010-09-25 00:00:00 | Save Now | 196277 | 1629 | 314 | Movies |  |  | 45
Img iTunes | 123 Buisness | 2010-09-25 00:00:00 | Save Now | 140350 | 891 | 118 | Movies |  |  | 45
Img iTunes | 123 Buisness | 2010-09-25 00:00:00 | Save Now | 2349 | 50 | 7 | Office |  |  | 45
Img iTunes | 123 Buisness | 2010-09-25 00:00:00 | Save Now | 4712 | 79 | 8 | Office |  |  | 45
Img iTunes | 123 Buisness | 2010-09-25 00:00:00 | Save Now | 5417 | 66 | 5 | TV |  |  | 45
Img iTunes | 123 Buisness | 2010-09-30 00:00:00 | Save Now | 16980 | 365 | 21 | Earth |  |  | 45
Img iTunes | 123 Buisness | 2010-09-30 00:00:00 | Save Now | 286641 | 1964 | 203 | Movies |  |  | 45
Img iTunes | 123 Buisness | 2010-09-30 00:00:00 | Save Now | 5305 | 72 | 8 | Office |  |  | 45
Img iTunes | 123 Buisness | 2010-09-30 00:00:00 | Save Now | 80744 | 921 | 84 | TV |  |  | 45
Img iTunes | 123 Buisness | 2010-10-04 00:00:00 | Save Now | 37249 | 645 | 37 | Antivirus |  |  | 45
Img iTunes | 123 Buisness | 2010-10-04 00:00:00 | Save Now | 67288 | 855 | 43 | [NAME] |  |  | 45
Img iTunes | 123 Buisness | 2010-10-04 00:00:00 | Save Now | 35617 | 509 | 28 | Flash |  |  | 45
Img iTunes | 123 Buisness | 2010-10-04 00:00:00 | Save Now | 89144 | 1301 | 79 | Music |  |  | 45
Img iTunes | 123 Buisness | 2010-10-04 00:00:00 | Save Now | 33043 | 717 | 42 | PDF |  |  | 45
New | 123 Buisness | 2010-09-25 00:00:00 | Save Now | 47498 | 990 | 88 | Antivirus |  |  | 45
New | 123 Buisness | 2010-09-25 00:00:00 | Save Now | 91801 | 1742 | 150 | [NAME] |  |  | 45
New | 123 Buisness | 2010-09-25 00:00:00 | Save Now | 62210 | 1050 | 80 | Flash |  |  | 45
New | 123 Buisness | 2010-09-25 00:00:00 | Save Now | 104370 | 1706 | 174 | Music |  |  | 45
New | 123 Buisness | 2010-09-25 00:00:00 | Save Now | 90700 | 2369 | 178 | PDF |  |  | 45
New | 123 Buisness | 2010-09-04 00:00:00 | Holiday Savings | 41652 | 1005 | 106 | Earth |  |  | 45
New | 123 Buisness | 2010-09-04 00:00:00 | Holiday Savings | 417353 | 5950 | 584 | Movies |  |  | 45
New | 123 Buisness | 2010-09-04 00:00:00 | Holiday Savings | 24697 | 521 | 35 | Office |  |  | 45
New | 123 Buisness | 2010-09-04 00:00:00 | Holiday Savings | 85253 | 1139 | 85 | TV |  |  | 45
New | 123 Buisness | 2010-09-05 00:00:00 | Holiday Savings | 67176 | 1762 | 169 | Antivirus |  |  | 45
New | 123 Buisness | 2010-09-05 00:00:00 | Holiday Savings | 12274 | 449 | 29 | Earth |  |  | 45
New | 123 Buisness | 2010-09-05 00:00:00 | Holiday Savings | 108070 | 2542 | 228 | [NAME] |  |  | 45
New | 123 Buisness | 2010-09-05 00:00:00 | Holiday Savings | 342696 | 5520 | 462 | Movies |  |  | 45
New | 123 Buisness | 2010-09-05 00:00:00 | Holiday Savings | 123856 | 2570 | 254 | Music |  |  | 45
New | 123 Buisness | 2010-09-05 00:00:00 | Holiday Savings | 16424 | 462 | 27 | Office |  |  | 45
New | 123 Buisness | 2010-09-05 00:00:00 | Holiday Savings | 84463 | 2242 | 184 | PDF |  |  | 45
New | 123 Buisness | 2010-09-05 00:00:00 | Holiday Savings | 60053 | 1306 | 125 | TV |  |  | 45
New | 123 Buisness | 2010-09-05 00:00:00 | Holiday Savings | 50137 | 899 | 75 | Antivirus |  |  | 45
New | 123 Buisness | 2010-09-05 00:00:00 | Holiday Savings | 82488 | 1083 | 93 | [NAME] |  |  | 45
New | 123 Buisness | 2010-09-05 00:00:00 | Holiday Savings | 46480 | 747 | 52 | Flash |  |  | 45
New | 123 Buisness | 2010-09-05 00:00:00 | Holiday Savings | 107250 | 1452 | 78 | Music |  |  | 45
New | 123 Buisness | 2010-09-05 00:00:00 | Holiday Savings | 47145 | 1224 | 52 | PDF |  |  | 45
New | 123 Buisness | 2010-09-12 00:00:00 | Holiday Savings | 65573 | 1586 | 151 | Antivirus |  |  | 45
New | 123 Buisness | 2010-09-12 00:00:00 | Holiday Savings | 106496 | 2136 | 157 | [NAME] |  |  | 45
New | 123 Buisness | 2010-09-12 00:00:00 | Holiday Savings | 100066 | 2066 | 153 | Flash |  |  | 45
New | 123 Buisness | 2010-09-12 00:00:00 | Holiday Savings | 121711 | 2267 | 196 | Music |  |  | 45
New | 123 Buisness | 2010-09-12 00:00:00 | Holiday Savings | 82756 | 2011 | 157 | PDF |  |  | 45
New | 123 Buisness | 2010-09-13 00:00:00 | Holiday Savings | 176753 | 3344 | 261 | Antivirus |  |  | 45
New | 123 Buisness | 2010-09-13 00:00:00 | Holiday Savings | 15143 | 205 | 16 | Antivirus |  |  | 45
New | 123 Buisness | 2010-09-13 00:00:00 | Holiday Savings | 9767 | 263 | 19 | Earth |  |  | 45
New 112 | Franks | 2010-06-21 00:00:00 | Save Big Here | 12303 | 373 | 13 | Earth |  |  | 22
New 112 | Franks | 2010-06-21 00:00:00 | Save Big Here | 195549 | 2100 | 167 | [NAME] |  |  | 22
New 112 | Franks | 2010-06-21 00:00:00 | Save Big Here | 69348 | 934 | 65 | Flash |  |  | 22
New 112 | Franks | 2010-06-21 00:00:00 | Save Big Here | 141031 | 980 | 110 | Movies |  |  | 22
New 112 | Franks | 2010-06-21 00:00:00 | Save Big Here | 357805 | 5780 | 346 | Movies |  |  | 22
New | 123 Buisness | 2010-09-13 00:00:00 | Holiday Savings | 16877 | 150 | 13 | Music |  |  | 2
New | 123 Buisness | 2010-09-13 00:00:00 | Holiday Savings | 335548 | 4940 | 389 | Music |  |  | 2
New | 123 Buisness | 2010-09-13 00:00:00 | Holiday Savings | 4774 | 73 | 8 | Office |  |  | 2
New | 123 Buisness | 2010-09-13 00:00:00 | Holiday Savings | 3001 | 88 | 4 | Office |  |  | 2
New | 123 Buisness | 2010-09-13 00:00:00 | Holiday Savings 111222331 | 126028 | 2932 | 192 | PDF |  |  | 3
New | 123 Buisness | 2010-09-13 00:00:00 | Holiday Savings 111222331 | 23184 | 980 | 33 | PDF |  |  | 3
New | 123 Buisness | 2010-09-13 00:00:00 | Holiday Savings 111222331 | 34327 | 551 | 52 | TV |  |  | 3
New | 123 Buisness | 2010-09-13 00:00:00 | Holiday Savings 111222331 | 73376 | 1305 | 115 | TV |  |  | 3
 |  |  |  |  |  | so a total of these clicks generated 3 sales for us
 |  |  |  |  |  | Campaign
 |  |  |  |  |  | I want the sum of clicks/divided by sales to appear here as a percentage
 |  |  |  |  |  | important - its not 192/3 that I want, rather I want g132 to g135/k135 to appear along each row highlighted in green as a percentage