Spreadsheet: 123359d1317605216-lookup-three-demensional-values-test
Sheet: Sheet1

Site | Month | Coupon Channel | Campaigns (Parent) | Revenue | Coupon Check |  |  | Site | Month | Campaigns (Parent) | Revenue Participation | CC Revenue | Coupon Revenue | Coupon Check
bd | 2011-08-01 00:00:00 | Affiliates | Affiliates | 50316.72 | Remove |  |  | bd | 2011-08-01 00:00:00 | ::unspecified:: | 1534814.93 | 0 | 0
bd | 2011-08-01 00:00:00 | Affiliates | ::unspecified:: | 25605.95 |  |  |  | bd | 2011-08-01 00:00:00 | CSE - Comparison Shopping Engine | 336909.41 | 0 | 0
bd | 2011-08-01 00:00:00 | Affiliates | PPC - Pay Per Click | 10431.3 |  |  |  | bd | 2011-08-01 00:00:00 | PPC - Pay Per Click | 171686.71 | 0 | 0
bd | 2011-08-01 00:00:00 | Affiliates | CSE - Comparison Shopping Engine | 9795.03 |  |  |  | bd | 2011-08-01 00:00:00 | Affiliates | 159207.96 | 0 | 14713.5
bd | 2011-08-01 00:00:00 | Affiliates | [NAME] | 2832.24 |  |  |  | bd | 2011-08-01 00:00:00 | [NAME] | 145403.31 | 0 | 0
bd | 2011-08-01 00:00:00 | Affiliates | Quote | 628.47 |  |  |  | bd | 2011-08-01 00:00:00 | Quote | 90776 | 0 | 0
bd | 2011-08-01 00:00:00 | Affiliates | Retargeting | 606.9 |  |  |  | bd | 2011-08-01 00:00:00 | Site Referral | 22646.54 | 0 | 0
bd | 2011-08-01 00:00:00 | Affiliates | Social Media | 584.99 |  |  |  | bd | 2011-08-01 00:00:00 | Retargeting | 1902.88 | 0 | 2427
bd | 2011-08-01 00:00:00 | Affiliates | Social | 265.87 |  |  |  | bd | 2011-08-01 00:00:00 | Social Media | 4082.21 | 0 | 0
bd | 2011-08-01 00:00:00 | Print | ::unspecified:: | 85927.24 |  |  |  | bd | 2011-08-01 00:00:00 | Social | 617.69 | 0 | 628.62
bd | 2011-08-01 00:00:00 | Print | PPC - Pay Per Click | 21640.87 |  |  |  | bd | 2011-09-01 00:00:00 | ::unspecified:: | 2050051.07 | 0 | 0
bd | 2011-08-01 00:00:00 | Print | Affiliates | 20653.88 |  |  |  | bd | 2011-09-01 00:00:00 | CSE - Comparison Shopping Engine | 313447.95 | 0 | 0
bd | 2011-08-01 00:00:00 | Print | [NAME] | 11096.27 |  |  |  | bd | 2011-09-01 00:00:00 | PPC - Pay Per Click | 189921.03 | 0 | 0
bd | 2011-08-01 00:00:00 | Print | CSE - Comparison Shopping Engine | 9286.6 |  |  |  | bd | 2011-09-01 00:00:00 | Affiliates | 155206.28 | 0 | 162415.13
bd | 2011-08-01 00:00:00 | Print | Quote | 6186.75 |  |  |  | bd | 2011-09-01 00:00:00 | [NAME] | 124584.72 | 0 | 4218.74
bd | 2011-08-01 00:00:00 | Print | Site Referral | 960.66 |  |  |  | bd | 2011-09-01 00:00:00 | Quote | 48373.99 | 0 | 0
bd | 2011-08-01 00:00:00 | Print | Social | 74.01 |  |  |  | bd | 2011-09-01 00:00:00 | Site Referral | 6096.73 | 0 | 0
bd | 2011-08-01 00:00:00 | Print | Retargeting | 11.13 |  |  |  | bd | 2011-09-01 00:00:00 | Retargeting | 19408.22 | 0 | 12149.12
bd | 2011-08-01 00:00:00 | Marketing | ::unspecified:: | 37379.84 |  |  |  | bd | 2011-09-01 00:00:00 | Social Media | 0 | 0 | 0
bd | 2011-08-01 00:00:00 | Marketing | Site Referral | 14182.52 |  |  |  | bd | 2011-09-01 00:00:00 | Social | 560.7 | 0 | 271.14
bd | 2011-08-01 00:00:00 | Marketing | [NAME] | 7104.52 |  |  |  | fd | 2011-08-01 00:00:00 | ::unspecified:: | 5961167.31 | 1498910.94 | 0
bd | 2011-08-01 00:00:00 | Marketing | PPC - Pay Per Click | 1927.01 |  |  |  | fd | 2011-08-01 00:00:00 | PPC - Pay Per Click | 3593441.89 | 54235.93 | 0
bd | 2011-08-01 00:00:00 | Marketing | Affiliates | 1422.53 |  |  |  | fd | 2011-08-01 00:00:00 | Affiliates | 1517467.47 | 4778.11 | 955654.4800000001
bd | 2011-08-01 00:00:00 | Marketing | CSE - Comparison Shopping Engine | 1162.86 |  |  |  | fd | 2011-08-01 00:00:00 | CSE - Comparison Shopping Engine | 1125385.62 | 23250.22 | 0
bd | 2011-08-01 00:00:00 | Retargeting | ::unspecified:: | 2217 |  |  |  | fd | 2011-08-01 00:00:00 | [NAME] | 475812.15 | 11193.19 | 0
bd | 2011-08-01 00:00:00 | Retargeting | Affiliates | 210 |  |  |  | fd | 2011-08-01 00:00:00 | Quote | 421474.11 | 4634.06 | 0
bd | 2011-08-01 00:00:00 | [NAME] | None | 0 |  |  |  | fd | 2011-08-01 00:00:00 | Google Product Extensions | 99497.17 | 1256.36 | 0
bd | 2011-08-01 00:00:00 | Social | Social Media | 628.62 |  |  |  | fd | 2011-08-01 00:00:00 | Retargeting | 98833.42 | 3351.64 | 2481
bd | 2011-09-01 00:00:00 | Affiliates | Affiliates | 86107.65 | Remove |  |  | fd | 2011-08-01 00:00:00 | Store Programs | 59508.89 | 260.35 | 0
bd | 2011-09-01 00:00:00 | Affiliates | ::unspecified:: | 36320.37 |  |  |  | fd | 2011-08-01 00:00:00 | Site Referral | 34665.39 | 0 | 0
bd | 2011-09-01 00:00:00 | Affiliates | CSE - Comparison Shopping Engine | 16622.8 |  |  |  | fd | 2011-08-01 00:00:00 | Social Media | 864.8 | 0 | 0
bd | 2011-09-01 00:00:00 | Affiliates | PPC - Pay Per Click | 13226.74 |  |  |  | fd | 2011-08-01 00:00:00 | Dotomi | 0 | 0 | 0
bd | 2011-09-01 00:00:00 | Affiliates | Quote | 4512.2 |  |  |  | fd | 2011-08-01 00:00:00 | Orders Placed by CSR | 42 | 0 | 0
bd | 2011-09-01 00:00:00 | Affiliates | Retargeting | 3850.52 |  |  |  | fd | 2011-09-01 00:00:00 | ::unspecified:: | 6270410.08 | 1367034.12 | 0
bd | 2011-09-01 00:00:00 | Affiliates | [NAME] | 1009.62 |  |  |  | fd | 2011-09-01 00:00:00 | PPC - Pay Per Click | 2701633.9 | 52747.66 | 0
bd | 2011-09-01 00:00:00 | Affiliates | Social | 560.7 |  |  |  | fd | 2011-09-01 00:00:00 | Affiliates | 1003374.78 | 5547.68 | 1095735.41
bd | 2011-09-01 00:00:00 | Affiliates | Site Referral | 204.53 |  |  |  | fd | 2011-09-01 00:00:00 | CSE - Comparison Shopping Engine | 779631.62 | 9789.64 | 0
bd | 2011-09-01 00:00:00 | Print | ::unspecified:: | 53163.13 |  |  |  | fd | 2011-09-01 00:00:00 | [NAME] | 347189.89 | 11873.66 | 11376.69
bd | 2011-09-01 00:00:00 | Print | [NAME] | 13544.94 |  |  |  | fd | 2011-09-01 00:00:00 | Quote | 226958.89 | 1604.77 | 0
bd | 2011-09-01 00:00:00 | Print | Affiliates | 10675.99 |  |  |  | fd | 2011-09-01 00:00:00 | Google Product Extensions | 70059.69 | 18.29 | 0
bd | 2011-09-01 00:00:00 | Print | PPC - Pay Per Click | 10480.24 |  |  |  | fd | 2011-09-01 00:00:00 | Retargeting | 61456.29 | 1154.16 | 3182.69
bd | 2011-09-01 00:00:00 | Print | CSE - Comparison Shopping Engine | 8968.49 |  |  |  | fd | 2011-09-01 00:00:00 | Store Programs | 58263.16 | 0 | 0
bd | 2011-09-01 00:00:00 | Print | Quote | 5902.29 |  |  |  | fd | 2011-09-01 00:00:00 | Site Referral | 25324.87 | 2597.18 | 0
bd | 2011-09-01 00:00:00 | Print | Retargeting | 1862.08 |  |  |  | fd | 2011-09-01 00:00:00 | Social Media | 485.47 | 0 | 0
bd | 2011-09-01 00:00:00 | Print | Site Referral | 113.3 |  |  |  | fd | 2011-09-01 00:00:00 | Dotomi | 177.41 | 0 | 0
bd | 2011-09-01 00:00:00 | Marketing | ::unspecified:: | 25103.95 |  |  |  | fd | 2011-09-01 00:00:00 | Orders Placed by CSR | 0 | 0 | 0
bd | 2011-09-01 00:00:00 | Marketing | Affiliates | 2952.29 |  |  |  | bd | 2011-08-01 00:00:00 | Organic | 233627 | 0 | 0
bd | 2011-09-01 00:00:00 | Marketing | CSE - Comparison Shopping Engine | 2664.82 |  |  |  | bd | 2011-09-01 00:00:00 | Organic | 299607.47 | 0 | 0
bd | 2011-09-01 00:00:00 | Marketing | [NAME] | 1619.06 |  |  |  | fd | 2011-08-01 00:00:00 | Organic | 1805931.22 | 21793.21 | 0
bd | 2011-09-01 00:00:00 | Marketing | Quote | 1528.01 |  |  |  | fd | 2011-09-01 00:00:00 | Organic | 1201081.79 | 32601.25 | 0
bd | 2011-09-01 00:00:00 | Marketing | PPC - Pay Per Click | 1492.16
bd | 2011-09-01 00:00:00 | Marketing | Site Referral | 509.76
bd | 2011-09-01 00:00:00 | Retargeting | ::unspecified:: | 7350.73
bd | 2011-09-01 00:00:00 | Retargeting | [NAME] | 1909.63
bd | 2011-09-01 00:00:00 | Retargeting | Retargeting | 1663.94 | Remove
bd | 2011-09-01 00:00:00 | Retargeting | CSE - Comparison Shopping Engine | 619.66
bd | 2011-09-01 00:00:00 | Retargeting | Affiliates | 396.2
bd | 2011-09-01 00:00:00 | Retargeting | PPC - Pay Per Click | 208.96
bd | 2011-09-01 00:00:00 | [NAME] | ::unspecified:: | 3310.37
bd | 2011-09-01 00:00:00 | [NAME] | [NAME] | 908.37 | Remove
bd | 2011-09-01 00:00:00 | Social | ::unspecified:: | 271.14
fd | 2011-08-01 00:00:00 | Affiliates | Affiliates | 537453.25 | Remove
fd | 2011-08-01 00:00:00 | Affiliates | PPC - Pay Per Click | 163922.71
fd | 2011-08-01 00:00:00 | Affiliates | ::unspecified:: | 145375.32
fd | 2011-08-01 00:00:00 | Affiliates | CSE - Comparison Shopping Engine | 57238.78
fd | 2011-08-01 00:00:00 | Affiliates | [NAME] | 25349.59
fd | 2011-08-01 00:00:00 | Affiliates | Quote | 12384.02
fd | 2011-08-01 00:00:00 | Affiliates | Google Product Extensions | 9065.52
fd | 2011-08-01 00:00:00 | Affiliates | Retargeting | 4865.29
fd | 2011-08-01 00:00:00 | Print | ::unspecified:: | 282968.73
fd | 2011-08-01 00:00:00 | Print | PPC - Pay Per Click | 127681.24
fd | 2011-08-01 00:00:00 | Print | Affiliates | 84298.12
fd | 2011-08-01 00:00:00 | Print | Quote | 58951.71
fd | 2011-08-01 00:00:00 | Print | CSE - Comparison Shopping Engine | 44022.8
fd | 2011-08-01 00:00:00 | Print | [NAME] | 40393.45
fd | 2011-08-01 00:00:00 | Print | Retargeting | 4514.27
fd | 2011-08-01 00:00:00 | Print | Site Referral | 2423.23
fd | 2011-08-01 00:00:00 | Print | Google Product Extensions | 1381.55
fd | 2011-08-01 00:00:00 | Marketing | ::unspecified:: | 63770.82
fd | 2011-08-01 00:00:00 | Marketing | [NAME] | 14874.76
fd | 2011-08-01 00:00:00 | Marketing | PPC - Pay Per Click | 13726.36
fd | 2011-08-01 00:00:00 | Marketing | Affiliates | 7640.28
fd | 2011-08-01 00:00:00 | Marketing | Site Referral | 7261.84
fd | 2011-08-01 00:00:00 | Marketing | CSE - Comparison Shopping Engine | 6107.22
fd | 2011-08-01 00:00:00 | Marketing | Store Programs | 678.29
fd | 2011-08-01 00:00:00 | Marketing | Quote | 619.19
fd | 2011-08-01 00:00:00 | Marketing | Google Product Extensions | 235.18
fd | 2011-08-01 00:00:00 | Retargeting | [NAME] | 1224.04
fd | 2011-08-01 00:00:00 | Retargeting | CSE - Comparison Shopping Engine | 838.36
fd | 2011-08-01 00:00:00 | Retargeting | ::unspecified:: | 418.6
fd | 2011-08-01 00:00:00 | [NAME] | None | 0
fd | 2011-08-01 00:00:00 | Social | Social Media | 530
fd | 2011-08-01 00:00:00 | Social | ::unspecified:: | 56.92
fd | 2011-09-01 00:00:00 | Affiliates | Affiliates | 584864.8 | Remove
fd | 2011-09-01 00:00:00 | Affiliates | ::unspecified:: | 198221.47
fd | 2011-09-01 00:00:00 | Affiliates | PPC - Pay Per Click | 191790.11
fd | 2011-09-01 00:00:00 | Affiliates | CSE - Comparison Shopping Engine | 76017.73
fd | 2011-09-01 00:00:00 | Affiliates | [NAME] | 16605.9
fd | 2011-09-01 00:00:00 | Affiliates | Quote | 12651.66
fd | 2011-09-01 00:00:00 | Affiliates | Google Product Extensions | 5063.36
fd | 2011-09-01 00:00:00 | Affiliates | Retargeting | 4703.91
fd | 2011-09-01 00:00:00 | Affiliates | Store Programs | 4097.52
fd | 2011-09-01 00:00:00 | Affiliates | Site Referral | 1718.95
fd | 2011-09-01 00:00:00 | Print | ::unspecified:: | 302610.84
fd | 2011-09-01 00:00:00 | Print | PPC - Pay Per Click | 155925.98
fd | 2011-09-01 00:00:00 | Print | Affiliates | 124980.2
fd | 2011-09-01 00:00:00 | Print | CSE - Comparison Shopping Engine | 54505.15
fd | 2011-09-01 00:00:00 | Print | [NAME] | 34912.39
fd | 2011-09-01 00:00:00 | Print | Quote | 27213.91
fd | 2011-09-01 00:00:00 | Print | Store Programs | 4899.57
fd | 2011-09-01 00:00:00 | Print | Site Referral | 1789.57
fd | 2011-09-01 00:00:00 | Print | Retargeting | 1482.97
fd | 2011-09-01 00:00:00 | Print | Google Product Extensions | 355.78
fd | 2011-09-01 00:00:00 | Marketing | ::unspecified:: | 84441.67
fd | 2011-09-01 00:00:00 | Marketing | PPC - Pay Per Click | 11421.38
fd | 2011-09-01 00:00:00 | Marketing | [NAME] | 10503.55
fd | 2011-09-01 00:00:00 | Marketing | CSE - Comparison Shopping Engine | 8832.22
fd | 2011-09-01 00:00:00 | Marketing | Affiliates | 5026.67
fd | 2011-09-01 00:00:00 | Marketing | Site Referral | 2991.41
fd | 2011-09-01 00:00:00 | Marketing | Quote | 1131.1
fd | 2011-09-01 00:00:00 | Retargeting | ::unspecified:: | 2491.45
fd | 2011-09-01 00:00:00 | Retargeting | [NAME] | 287
fd | 2011-09-01 00:00:00 | Retargeting | Affiliates | 179
fd | 2011-09-01 00:00:00 | Retargeting | PPC - Pay Per Click | 116.2
fd | 2011-09-01 00:00:00 | Retargeting | CSE - Comparison Shopping Engine | 109.04
fd | 2011-09-01 00:00:00 | [NAME] | PPC - Pay Per Click | 4533.82
fd | 2011-09-01 00:00:00 | [NAME] | ::unspecified:: | 3570.07
fd | 2011-09-01 00:00:00 | [NAME] | [NAME] | 3272.8 | Remove
fd | 2011-09-01 00:00:00 | Social | ::unspecified:: | 5591.12
fd | 2011-09-01 00:00:00 | Social | Quote | 2839.27
fd | 2011-09-01 00:00:00 | Social | PPC - Pay Per Click | 218.52