Spreadsheet: 39770d1238061559-creating-a-dynamic-report-tab-raw-20data-20spec-20v5-1-
Sheet: Sheet1

Date | (Multiple Items) |  |  |  |  |  |  |  |  | first date: | 2009-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | last date: | 2009-02-05 00:00:00
 |  | Keyword
Source | Data | Keyword 1 | [NAME] | [NAME] | [NAME] | Grand Total
PPC | Sum of Clicks | 500 | 1000 | 1500 | 2000 | 5000
 | Sum of Cost | 500 | 1000 | 1250 | 1375 | 4125
 | Sum of CPC | 1 | 1 | 0.8333333333333334 | 0.6875 | 0.825
 | Sum of CPQ | 5 | 5 | 8.333333333333334 | 4.583333333333333 | 5.5
 | Sum of CPS | 10 | 13.33333333333333 | 10.8695652173913 | 7.857142857142857 | 9.939759036144578
 | Sum of CTQ | 0.2 | 0.2 | 0.1 | 0.15 | 0.15
 | Sum of QTS | 0.5 | 0.375 | 0.7666666666666667 | 0.5833333333333334 | 0.5533333333333333
 | Sum of CTS | 0.1 | 0.075 | 0.07666666666666666 | 0.0875 | 0.083
 | Sum of Quotes | 100 | 200 | 150 | 300 | 750
 | Sum of Sales | 50 | 75 | 115 | 175 | 415
SEO | Sum of Clicks | 1165 | 2335 | 3500 | 4665 | 11665
 | Sum of Cost | 116.5 | 233.5 | 350 | 466.5 | 1166.5
 | Sum of CPC | 0.1 | 0.1 | 0.1 | 0.1 | 0.09999999999999998
 | Sum of CPQ | 0.4568627450980392 | 0.4533980582524272 | 0.9090909090909091 | 0.6058441558441559 | 0.6059740259740258
 | Sum of CPS | 1.941666666666667 | 2.594444444444445 | 2.5 | 2.221428571428572 | 2.333
 | Sum of CTQ | 0.2188841201716738 | 0.2205567451820128 | 0.11 | 0.165058949624866 | 0.1650235747963995
 | Sum of QTS | 0.2352941176470588 | 0.1747572815533981 | 0.3636363636363636 | 0.2727272727272727 | 0.2597402597402597
 | Sum of CTS | 0.05150214592274678 | 0.03854389721627409 | 0.04 | 0.04501607717041801 | 0.04286326618088299
 | Sum of Quotes | 255 | 515 | 385 | 770 | 1925
 | Sum of Sales | 60 | 90 | 140 | 210 | 500
Blend | Sum of Clicks | 1665 | 3335 | 5000 | 6665 | 16665
 | Sum of Cost | 616.5 | 1233.5 | 1600 | 1841.5 | 5291.5
 | Sum of CPC | 0.3702702702702703 | 0.3698650674662669 | 0.32 | 0.2762940735183796 | 0.3175217521752175
 | Sum of CPQ | 1.736619718309859 | 1.725174825174825 | 2.990654205607477 | 1.721028037383178 | 1.978130841121495
 | Sum of CPS | 5.604545454545454 | 7.475757575757576 | 6.274509803921569 | 4.783116883116883 | 5.783060109289617
 | Sum of CTQ | 0.2132132132132132 | 0.2143928035982009 | 0.107 | 0.1605401350337584 | 0.1605160516051605
 | Sum of QTS | 0.3098591549295774 | 0.2307692307692308 | 0.4766355140186916 | 0.3598130841121495 | 0.3420560747663551
 | Sum of CTS | 0.06606606606606606 | 0.0494752623688156 | 0.051 | 0.05776444111027757 | 0.05490549054905491
 | Sum of Quotes | 355 | 715 | 535 | 1070 | 2675
 | Sum of Sales | 110 | 165 | 255 | 385 | 915
Total Sum of Clicks |  | 3330 | 6670 | 10000 | 13330 | 33330
Total Sum of Cost |  | 1233 | 2467 | 3200 | 3683 | 10583
Total Sum of CPC |  | 0.3702702702702702 | 0.3698650674662669 | 0.32 | 0.2762940735183796 | 0.3175217521752175
Total Sum of CPQ |  | 1.736619718309859 | 1.725174825174825 | 2.990654205607477 | 1.721028037383178 | 1.978130841121495
Total Sum of CPS |  | 5.604545454545454 | 7.475757575757576 | 6.274509803921569 | 4.783116883116883 | 5.783060109289617
Total Sum of CTQ |  | 0.2132132132132132 | 0.2143928035982009 | 0.107 | 0.1605401350337584 | 0.1605160516051605
Total Sum of QTS |  | 0.3098591549295774 | 0.2307692307692308 | 0.4766355140186916 | 0.3598130841121495 | 0.3420560747663551
Total Sum of CTS |  | 0.06606606606606606 | 0.0494752623688156 | 0.051 | 0.05776444111027757 | 0.05490549054905491
Total Sum of Quotes |  | 710 | 1430 | 1070 | 2140 | 5350
Total Sum of Sales |  | 220 | 330 | 510 | 770 | 1830