Spreadsheet: 757219d1638125796-calculations-vlookup-social-fuel-excel-test-for-sem-
Sheet: KW Data

 | Keyword Template
 | Date Range: 7/1/19 - 7/14/19
 | Date | Campaign | Ad Group | Keyword | Impr | Clicks | Cost | Leads | Revenue
 | 2019-07-01 00:00:00 | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 145 | 18 | 151 | 0 | 0
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 94 | 7 | 47 | 0 | 0
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 134 | 36 | 115 | 1 | 50
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 209 | 61 | 706 | 5 | 210
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 135 | 7 | 83 | 0 | 0
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 287 | 42 | 225 | 4 | 217
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 291 | 10 | 29 | 1 | 66
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 97 | 10 | 72 | 1 | 52
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 283 | 84 | 140 | 8 | 498
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 211 | 11 | 62 | 1 | 58
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 216 | 61 | 613 | 6 | 358
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 262 | 67 | 208 | 5 | 262
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 91 | 23 | 107 | 0 | 0
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 1 | 185 | 43 | 311 | 2 | 97
 | 2019-07-01 00:00:00 | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 271 | 67 | 616 | 4 | 210
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 249 | 20 | 72 | 1 | 61
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 185 | 29 | 127 | 2 | 84
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 195 | 28 | 193 | 0 | 0
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 259 | 12 | 40 | 0 | 0
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 94 | 15 | 179 | 0 | 0
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 196 | 48 | 539 | 4 | 287
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 213 | 50 | 585 | 1 | 64
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 279 | 74 | 110 | 2 | 145
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 222 | 23 | 117 | 0 | 0
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 295 | 23 | 74 | 2 | 87
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 173 | 49 | 72 | 4 | 298
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 201 | 10 | 112 | 0 | 0
 |  | Campaign - Midwest - IL | Ad Group 1 | keyword 2 | 256 | 8 | 45 | 0 | 0
 | 2019-07-01 00:00:00 | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 270 | 20 | 27 | 2 | 83
 |  | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 148 | 23 | 271 | 2 | 106
 |  | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 237 | 13 | 24 | 0 | 0
 |  | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 109 | 24 | 118 | 2 | 116
 |  | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 133 | 30 | 297 | 3 | 209
 |  | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 255 | 38 | 367 | 1 | 68
 |  | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 172 | 7 | 35 | 0 | 0
 |  | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 230 | 33 | 199 | 0 | 0
 |  | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 194 | 21 | 87 | 2 | 69
 |  | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 239 | 33 | 275 | 0 | 0
 |  | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 253 | 43 | 471 | 1 | 65
 |  | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 226 | 57 | 467 | 1 | 69
 |  | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 275 | 21 | 124 | 1 | 73
 |  | Campaign - Midwest - MN | Ad Group 1 | keyword 3 | 137 | 39 | 90 | 0 | 0
 | 2019-07-01 00:00:00 | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 200 | 21 | 48 | 0 | 0
 |  | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 89 | 6 | 57 | 0 | 0
 |  | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 83 | 24 | 81 | 0 | 0
 |  | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 179 | 21 | 180 | 1 | 57
 |  | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 226 | 12 | 49 | 0 | 0
 |  | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 121 | 8 | 79 | 0 | 0
 |  | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 126 | 15 | 26 | 1 | 33
 |  | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 196 | 34 | 74 | 0 | 0
 |  | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 206 | 27 | 152 | 2 | 85
 |  | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 81 | 3 | 30 | 0 | 0
 |  | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 188 | 47 | 390 | 3 | 116
 |  | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 92 | 8 | 93 | 0 | 0
 |  | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 196 | 30 | 317 | 3 | 165
 |  | Campaign - Midwest - MN | Ad Group 1 | [NAME] | 240 | 37 | 121 | 1 | 70
 | 2019-07-01 00:00:00 | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 235 | 50 | 513 | 4 | 193
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 157 | 28 | 135 | 2 | 102
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 194 | 29 | 342 | 1 | 52
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 93 | 3 | 14 | 0 | 0
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 198 | 27 | 59 | 0 | 0
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 99 | 23 | 255 | 1 | 70
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 259 | 19 | 62 | 0 | 0
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 78 | 9 | 101 | 0 | 0
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 84 | 21 | 208 | 1 | 36
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 106 | 29 | 300 | 2 | 98
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 104 | 5 | 57 | 0 | 0
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 171 | 13 | 75 | 0 | 0
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 193 | 34 | 291 | 1 | 50
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 5 | 95 | 18 | 45 | 1 | 52
 | 2019-07-01 00:00:00 | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 147 | 22 | 134 | 0 | 0
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 141 | 17 | 66 | 0 | 0
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 263 | 74 | 813 | 2 | 109
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 240 | 31 | 227 | 1 | 40
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 278 | 44 | 90 | 1 | 41
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 120 | 19 | 203 | 1 | 71
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 273 | 35 | 119 | 2 | 120
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 235 | 52 | 118 | 1 | 59
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 159 | 16 | 20 | 0 | 0
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 77 | 18 | 174 | 1 | 75
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 100 | 23 | 263 | 2 | 94
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 224 | 64 | 188 | 3 | 213
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 240 | 66 | 288 | 5 | 175
 |  | Campaign - Midwest - WI | Ad Group 1 | keyword 6 | 202 | 21 | 225 | 2 | 97
 | 2019-07-01 00:00:00 | Campaign - East - NJ | Ad Group 1 | keyword 7 | 236 | 61 | 297 | 4 | 282
 |  | Campaign - East - NJ | Ad Group 1 | keyword 7 | 228 | 30 | 46 | 2 | 148
 |  | Campaign - East - NJ | Ad Group 1 | keyword 7 | 134 | 10 | 19 | 0 | 0
 |  | Campaign - East - NJ | Ad Group 1 | keyword 7 | 289 | 29 | 227 | 2 | 132
 |  | Campaign - East - NJ | Ad Group 1 | keyword 7 | 79 | 17 | 142 | 1 | 65
 |  | Campaign - East - NJ | Ad Group 1 | keyword 7 | 227 | 43 | 347 | 4 | 138
 |  | Campaign - East - NJ | Ad Group 1 | keyword 7 | 183 | 18 | 48 | 0 | 0
 |  | Campaign - East - NJ | Ad Group 1 | keyword 7 | 119 | 25 | 172 | 0 | 0
 |  | Campaign - East - NJ | Ad Group 1 | keyword 7 | 145 | 13 | 102 | 0 | 0
 |  | Campaign - East - NJ | Ad Group 1 | keyword 7 | 242 | 29 | 88 | 0 | 0
 |  | Campaign - East - NJ | Ad Group 1 | keyword 7 | 172 | 16 | 21 | 1 | 68
 |  | Campaign - East - NJ | Ad Group 1 | keyword 7 | 264 | 23 | 187 | 2 | 53
 |  | Campaign - East - NJ | Ad Group 1 | keyword 7 | 281 | 59 | 398 | 3 | 170
 |  | Campaign - East - NJ | Ad Group 1 | keyword 7 | 174 | 29 | 304 | 2 | 87
 | 2019-07-01 00:00:00 | Campaign - East - NJ | Ad Group 1 | keyword 8 | 261 | 71 | 818 | 1 | 60
 |  | Campaign - East - NJ | Ad Group 1 | keyword 8 | 254 | 61 | 133 | 6 | 348
 |  | Campaign - East - NJ | Ad Group 1 | keyword 8 | 93 | 18 | 59 | 0 | 0
 |  | Campaign - East - NJ | Ad Group 1 | keyword 8 | 189 | 24 | 136 | 1 | 64
 |  | Campaign - East - NJ | Ad Group 1 | keyword 8 | 194 | 52 | 327 | 2 | 65
 |  | Campaign - East - NJ | Ad Group 1 | keyword 8 | 292 | 77 | 291 | 0 | 0
 |  | Campaign - East - NJ | Ad Group 1 | keyword 8 | 163 | 45 | 134 | 3 | 195
 |  | Campaign - East - NJ | Ad Group 1 | keyword 8 | 228 | 17 | 135 | 1 | 44
 |  | Campaign - East - NJ | Ad Group 1 | keyword 8 | 228 | 49 | 267 | 0 | 0
 |  | Campaign - East - NJ | Ad Group 1 | keyword 8 | 78 | 21 | 145 | 0 | 0
 |  | Campaign - East - NJ | Ad Group 1 | keyword 8 | 94 | 16 | 50 | 0 | 0
 |  | Campaign - East - NJ | Ad Group 1 | keyword 8 | 109 | 8 | 18 | 0 | 0
 |  | Campaign - East - NJ | Ad Group 1 | keyword 8 | 225 | 44 | 97 | 4 | 225
 |  | Campaign - East - NJ | Ad Group 1 | keyword 8 | 178 | 15 | 20 | 0 | 0
 | 2019-07-01 00:00:00 | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 300 | 82 | 574 | 1 | 71
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 138 | 22 | 240 | 1 | 62
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 286 | 73 | 463 | 7 | 280
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 214 | 43 | 286 | 0 | 0
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 76 | 6 | 51 | 0 | 0
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 196 | 10 | 98 | 1 | 41
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 267 | 53 | 258 | 1 | 55
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 237 | 36 | 165 | 1 | 60
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 282 | 47 | 510 | 4 | 200
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 265 | 75 | 629 | 5 | 316
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 244 | 44 | 100 | 1 | 64
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 269 | 17 | 150 | 1 | 64
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 156 | 26 | 132 | 2 | 134
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 9 | 158 | 43 | 175 | 0 | 0
 | 2019-07-01 00:00:00 | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 141 | 18 | 106 | 1 | 40
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 97 | 21 | 83 | 2 | 112
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 185 | 20 | 200 | 2 | 146
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 122 | 33 | 215 | 3 | 116
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 96 | 20 | 103 | 2 | 111
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 248 | 73 | 854 | 7 | 495
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 131 | 23 | 190 | 1 | 46
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 153 | 11 | 99 | 1 | 62
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 231 | 16 | 53 | 0 | 0
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 160 | 8 | 91 | 0 | 0
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 194 | 42 | 275 | 3 | 203
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 199 | 26 | 81 | 0 | 0
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 216 | 61 | 213 | 2 | 115
 |  | Campaign - East - NY | Ad Group 1 | [NAME] 10 | 289 | 44 | 205 | 1 | 74