gistfile1.txt

    "data": {
        "report": {
            "rtmDaily": [{
                "adgroup": "13980786660",
                "type": "1",
                "datetime": "2014-06-28 00:00:00",
                "demo_data": "[{\"s\":\"100366\", \"uc\":\"1477\", \"ec\":\"1784\"}, {\"s\":\"100367\", \"uc\":\"290\", \"ec\":\"336\"}, {\"s\":\"100364\", \"uc\":\"718\", \"ec\":\"851\"}, {\"s\":\"100365\", \"uc\":\"410\", \"ec\":\"486\"}, {\"s\":\"100368\", \"uc\":\"240\", \"ec\":\"276\"}, {\"s\":\"100369\", \"uc\":\"932\", \"ec\":\"1105\"}, {\"s\":\"100370\", \"uc\":\"155\", \"ec\":\"191\"}, {\"s\":\"100649\", \"uc\":\"41\", \"ec\":\"44\"}, {\"s\":\"100648\", \"uc\":\"27\", \"ec\":\"30\"}, {\"s\":\"100906\", \"uc\":\"191\", \"ec\":\"220\"}, {\"s\":\"100647\", \"uc\":\"34\", \"ec\":\"46\"}, {\"s\":\"100907\", \"uc\":\"149\", \"ec\":\"165\"}, {\"s\":\"100374\", \"uc\":\"1428\", \"ec\":\"1649\"}, {\"s\":\"100373\", \"uc\":\"1565\", \"ec\":\"1819\"}, {\"s\":\"100372\", \"uc\":\"2490\", \"ec\":\"2925\"}, {\"s\":\"100371\", \"uc\":\"707\", \"ec\":\"823\"}, {\"s\":\"100642\", \"uc\":\"4\", \"ec\":\"4\"}, {\"s\":\"100646\", \"uc\":\"31\", \"ec\":\"38\"}, {\"s\":\"100645\", \"uc\":\"25\", \"ec\":\"28\"}, {\"s\":\"100644\", \"uc\":\"12\", \"ec\":\"14\"}, {\"s\":\"100643\", \"uc\":\"12\", \"ec\":\"12\"}, {\"s\":\"100353\", \"uc\":\"1167\", \"ec\":\"1384\"}, {\"s\":\"100354\", \"uc\":\"563\", \"ec\":\"660\"}, {\"s\":\"100355\", \"uc\":\"371\", \"ec\":\"427\"}, {\"s\":\"100356\", \"uc\":\"1221\", \"ec\":\"1426\"}, {\"s\":\"100357\", \"uc\":\"765\", \"ec\":\"873\"}, {\"s\":\"100358\", \"uc\":\"623\", \"ec\":\"742\"}, {\"s\":\"100359\", \"uc\":\"280\", \"ec\":\"332\"}, {\"s\":\"100552\", \"uc\":\"148\", \"ec\":\"172\"}, {\"s\":\"100551\", \"uc\":\"337\", \"ec\":\"391\"}, {\"s\":\"100554\", \"uc\":\"10\", \"ec\":\"12\"}, {\"s\":\"100553\", \"uc\":\"98\", \"ec\":\"109\"}, {\"s\":\"100361\", \"uc\":\"440\", \"ec\":\"522\"}, {\"s\":\"100555\", \"uc\":\"42\", \"ec\":\"52\"}, {\"s\":\"100360\", \"uc\":\"513\", \"ec\":\"611\"}, {\"s\":\"100363\", \"uc\":\"609\", \"ec\":\"729\"}, {\"s\":\"100362\", \"uc\":\"935\", \"ec\":\"1104\"}, {\"s\":\"100349\", \"uc\":\"826\", \"ec\":\"979\"}, {\"s\":\"100348\", \"uc\":\"395\", \"ec\":\"458\"}, {\"s\":\"100347\", \"uc\":\"1154\", \"ec\":\"1344\"}, {\"s\":\"100346\", \"uc\":\"813\", \"ec\":\"933\"}, {\"s\":\"100345\", \"uc\":\"726\", \"ec\":\"839\"}, {\"s\":\"100344\", \"uc\":\"705\", \"ec\":\"825\"}, {\"s\":\"100343\", \"uc\":\"1110\", \"ec\":\"1284\"}, {\"s\":\"100351\", \"uc\":\"899\", \"ec\":\"1062\"}, {\"s\":\"100352\", \"uc\":\"846\", \"ec\":\"990\"}, {\"s\":\"100350\", \"uc\":\"904\", \"ec\":\"1052\"}, {\"s\":\"999999\", \"uc\":\"27560\", \"ec\":\"32227\"}, {\"s\":\"100548\", \"uc\":\"730\", \"ec\":\"858\"}, {\"s\":\"100549\", \"uc\":\"524\", \"ec\":\"606\"}, {\"s\":\"100379\", \"uc\":\"348\", \"ec\":\"404\"}, {\"s\":\"100541\", \"uc\":\"74\", \"ec\":\"82\"}, {\"s\":\"100542\", \"uc\":\"53\", \"ec\":\"66\"}, {\"s\":\"100543\", \"uc\":\"170\", \"ec\":\"190\"}, {\"s\":\"100375\", \"uc\":\"561\", \"ec\":\"639\"}, {\"s\":\"100544\", \"uc\":\"252\", \"ec\":\"294\"}, {\"s\":\"100376\", \"uc\":\"724\", \"ec\":\"849\"}, {\"s\":\"100545\", \"uc\":\"348\", \"ec\":\"411\"}, {\"s\":\"100546\", \"uc\":\"361\", \"ec\":\"441\"}, {\"s\":\"100377\", \"uc\":\"884\", \"ec\":\"1028\"}, {\"s\":\"100378\", \"uc\":\"1015\", \"ec\":\"1180\"}, {\"s\":\"100547\", \"uc\":\"498\", \"ec\":\"590\"}, {\"s\":\"100550\", \"uc\":\"284\", \"ec\":\"334\"}, {\"s\":\"100381\", \"uc\":\"450\", \"ec\":\"522\"}, {\"s\":\"100380\", \"uc\":\"1483\", \"ec\":\"1752\"}, {\"s\":\"100654\", \"uc\":\"7\", \"ec\":\"7\"}, {\"s\":\"100651\", \"uc\":\"30\", \"ec\":\"34\"}, {\"s\":\"100650\", \"uc\":\"39\", \"ec\":\"44\"}, {\"s\":\"100653\", \"uc\":\"17\", \"ec\":\"17\"}, {\"s\":\"100652\", \"uc\":\"25\", \"ec\":\"29\"}]",
                "social_audience_count": "0",
                "social_event_count": "0",
                "model_user_count": "27560",
                "model_event_count": "32227",
                "impr": "32048",
                "clk": "17",
                "ctr": "0.0530",
                "campaign": "3885",
                "audienceGroupKeyword": null
            }, {
                "adgroup": "13980785460",
                "type": "0",
                "datetime": "2014-06-28 00:00:00",
                "demo_data": "[{\"s\":\"100366\", \"uc\":\"3726\", \"ec\":\"6104\"}, {\"s\":\"100367\", \"uc\":\"752\", \"ec\":\"1241\"}, {\"s\":\"100364\", \"uc\":\"1961\", \"ec\":\"3116\"}, {\"s\":\"100365\", \"uc\":\"1100\", \"ec\":\"1764\"}, {\"s\":\"100368\", \"uc\":\"732\", \"ec\":\"1196\"}, {\"s\":\"100369\", \"uc\":\"2550\", \"ec\":\"4152\"}, {\"s\":\"100370\", \"uc\":\"495\", \"ec\":\"814\"}, {\"s\":\"100649\", \"uc\":\"120\", \"ec\":\"183\"}, {\"s\":\"100648\", \"uc\":\"71\", \"ec\":\"120\"}, {\"s\":\"100906\", \"uc\":\"606\", \"ec\":\"988\"}, {\"s\":\"100647\", \"uc\":\"88\", \"ec\":\"147\"}, {\"s\":\"100907\", \"uc\":\"300\", \"ec\":\"487\"}, {\"s\":\"100374\", \"uc\":\"3600\", \"ec\":\"5843\"}, {\"s\":\"100373\", \"uc\":\"3626\", \"ec\":\"5938\"}, {\"s\":\"100372\", \"uc\":\"6006\", \"ec\":\"9852\"}, {\"s\":\"100371\", \"uc\":\"1770\", \"ec\":\"2886\"}, {\"s\":\"100642\", \"uc\":\"9\", \"ec\":\"18\"}, {\"s\":\"100646\", \"uc\":\"72\", \"ec\":\"120\"}, {\"s\":\"100645\", \"uc\":\"78\", \"ec\":\"121\"}, {\"s\":\"100644\", \"uc\":\"62\", \"ec\":\"103\"}, {\"s\":\"100643\", \"uc\":\"24\", \"ec\":\"41\"}, {\"s\":\"100353\", \"uc\":\"3039\", \"ec\":\"5000\"}, {\"s\":\"100354\", \"uc\":\"1347\", \"ec\":\"2134\"}, {\"s\":\"100355\", \"uc\":\"962\", \"ec\":\"1621\"}, {\"s\":\"100356\", \"uc\":\"3042\", \"ec\":\"4911\"}, {\"s\":\"100357\", \"uc\":\"1838\", \"ec\":\"2994\"}, {\"s\":\"100358\", \"uc\":\"1796\", \"ec\":\"2916\"}, {\"s\":\"100359\", \"uc\":\"743\", \"ec\":\"1251\"}, {\"s\":\"100552\", \"uc\":\"407\", \"ec\":\"681\"}, {\"s\":\"100551\", \"uc\":\"747\", \"ec\":\"1246\"}, {\"s\":\"100554\", \"uc\":\"44\", \"ec\":\"79\"}, {\"s\":\"100553\", \"uc\":\"301\", \"ec\":\"487\"}, {\"s\":\"100361\", \"uc\":\"1178\", \"ec\":\"1905\"}, {\"s\":\"100555\", \"uc\":\"87\", \"ec\":\"133\"}, {\"s\":\"100360\", \"uc\":\"1487\", \"ec\":\"2424\"}, {\"s\":\"100363\", \"uc\":\"1639\", \"ec\":\"2652\"}, {\"s\":\"100362\", \"uc\":\"2403\", \"ec\":\"3941\"}, {\"s\":\"100349\", \"uc\":\"1897\", \"ec\":\"3125\"}, {\"s\":\"100348\", \"uc\":\"1035\", \"ec\":\"1725\"}, {\"s\":\"100347\", \"uc\":\"3098\", \"ec\":\"4930\"}, {\"s\":\"100346\", \"uc\":\"2018\", \"ec\":\"3300\"}, {\"s\":\"100345\", \"uc\":\"1960\", \"ec\":\"3174\"}, {\"s\":\"100344\", \"uc\":\"1765\", \"ec\":\"2791\"}, {\"s\":\"100343\", \"uc\":\"2631\", \"ec\":\"4362\"}, {\"s\":\"100351\", \"uc\":\"2090\", \"ec\":\"3371\"}, {\"s\":\"100352\", \"uc\":\"2101\", \"ec\":\"3428\"}, {\"s\":\"100350\", \"uc\":\"2308\", \"ec\":\"3745\"}, {\"s\":\"999999\", \"uc\":\"93993\", \"ec\":\"138777\"}, {\"s\":\"100548\", \"uc\":\"1846\", \"ec\":\"3123\"}, {\"s\":\"100549\", \"uc\":\"1345\", \"ec\":\"2182\"}, {\"s\":\"100379\", \"uc\":\"936\", \"ec\":\"1548\"}, {\"s\":\"100541\", \"uc\":\"219\", \"ec\":\"356\"}, {\"s\":\"100542\", \"uc\":\"122\", \"ec\":\"184\"}, {\"s\":\"100543\", \"uc\":\"416\", \"ec\":\"676\"}, {\"s\":\"100544\", \"uc\":\"615\", \"ec\":\"965\"}, {\"s\":\"100375\", \"uc\":\"1596\", \"ec\":\"2575\"}, {\"s\":\"100545\", \"uc\":\"823\", \"ec\":\"1386\"}, {\"s\":\"100376\", \"uc\":\"1792\", \"ec\":\"2906\"}, {\"s\":\"100377\", \"uc\":\"2172\", \"ec\":\"3561\"}, {\"s\":\"100546\", \"uc\":\"965\", \"ec\":\"1492\"}, {\"s\":\"100378\", \"uc\":\"2389\", \"ec\":\"3870\"}, {\"s\":\"100547\", \"uc\":\"1299\", \"ec\":\"2107\"}, {\"s\":\"100381\", \"uc\":\"1118\", \"ec\":\"1875\"}, {\"s\":\"100550\", \"uc\":\"876\", \"ec\":\"1486\"}, {\"s\":\"100380\", \"uc\":\"4298\", \"ec\":\"6970\"}, {\"s\":\"100654\", \"uc\":\"23\", \"ec\":\"38\"}, {\"s\":\"100651\", \"uc\":\"90\", \"ec\":\"161\"}, {\"s\":\"100650\", \"uc\":\"105\", \"ec\":\"172\"}, {\"s\":\"100653\", \"uc\":\"28\", \"ec\":\"33\"}, {\"s\":\"100652\", \"uc\":\"60\", \"ec\":\"94\"}]",
                "social_audience_count": "93993",
                "social_event_count": "138777",
                "model_user_count": "0",
                "model_event_count": "0",
                "impr": "0",
                "clk": "0",
                "ctr": "0.0000",
                "campaign": "3883",
                "audienceGroupKeyword": "Employment Job",
                "social_index": 29.470588235294
            }, {