{
  "fields": [{"type":"int","id":"_id"},{"type":"text","id":"Query ID"},{"type":"text","id":"Spreadsheet ID"},{"type":"text","id":"Sheet name"},{"type":"text","id":"Range address"},{"type":"text","id":"Created"},{"type":"text","id":"Updated"},{"type":"text","id":"Last status"},{"type":"text","id":"Last refresh ID"},{"type":"text","id":"Results contain sampled data"},{"type":"text","id":"Execution time (sec)"},{"type":"text","id":"Object type"},{"type":"text","id":"Linked chart ID"},{"type":"text","id":"Data source"},{"type":"text","id":"Date range type"},{"type":"text","id":"Start date"},{"type":"text","id":"End date"},{"type":"text","id":"Compare to"},{"type":"text","id":"Comparison value type"},{"type":"text","id":"Accounts/views"},{"type":"text","id":"Metrics"},{"type":"text","id":"Dimensions"},{"type":"text","id":"Pivot dimensions"},{"type":"text","id":"Filters"},{"type":"text","id":"Segment ID"},{"type":"text","id":"Sort"},{"type":"text","id":"Max rows"},{"type":"text","id":"Max pivot categories"},{"type":"text","id":"Special settings"},{"type":"text","id":"Other parameters"},{"type":"text","id":"Result type"},{"type":"text","id":"Language/country"},{"type":"text","id":"Translate to"},{"type":"text","id":"SQL"},{"type":"text","id":"Database name"},{"type":"text","id":"Range address (static)"},{"type":"text","id":"Report type"},{"type":"text","id":"Scope (Moz)"},{"type":"text","id":"Sort (Moz)"},{"type":"text","id":"Highlight with colour"},{"type":"text","id":"Refresh with user account"},{"type":"text","id":"Returned data"}],
  "records": [
    [1,"paramsID","ssID","sheetName","rangeAddress","created","updated","lastStatus","lastqueryID","sampled","runtime_sec","objType","linkedChartID","dataSource","dateRangeType","startDateString","endDateString","comp","cvt","profiles","metrics","dimensions","sd","filterArr","segment","sort","maxResults","maxCategories","specialSettings","otherParams","sds_result_type","sds_lang","sds_tolang","sql","db_name","rangeAddressStatic","rt","scopeMZ","sortMZ","condform","authUser","metaDataToUser"],
    [2,"z0NpXtf9nmQVVGIe0gOayEVQQYfjWp","","Sheet1","'[רגעי הכנסת הגדולים - דוח סיכום.xlsx]Sheet1'!$A$1:$F$4","2018-07-17 10:53:49","2018-07-30 06:02:16","Refreshed successfully by trigger 9ZrQqmp0v7Avlw5WuIxYTgbJvtoIVR","1.53291971764e+12","0","3.0","TABLE","","AW","last30daysinc","","","","","[\"6653827630`Z - Kniyot reshet\"]","[\"Impressions\",\"Clicks\",\"CPC\",\"CTR_perc\",\"Cost\"]","[\"Campaignname\"]","[]","[{\"field\":\"Impressions\",\"operator\":\">\",\"value\":\"1\",\"combineToPrev\":\";\"},{\"field\":\"Network\",\"operator\":\"=@\",\"value\":\"Display\",\"combineToPrev\":\";\"}]","[]","","1000000.0","10.0","[]","{}","","","","","","Sheet1'!A1:F4","","","","","7904050276.0",""],
    [3,"zxqGqymx5hd1cbHbMLZWV0y7C61yRy","","FACE","'[רגעי הכנסת הגדולים - דוח סיכום.xlsx]FACE'!$A$1:$M$3","2018-07-08 12:54:31","2018-07-30 06:02:05","Refreshed successfully by trigger 9ZrQqmp0v7Avlw5WuIxYTgbJvtoIVR","1.53291971764e+12","0","2.0","TABLE","","FA","last30daysinc","","","","","[\"act_948966018514806`fb_yehida@lapam.gov.il\"]","[\"impressions\",\"clicks\",\"link_clicks\",\"reach\",\"video_view\",\"video_10_sec_watched_actions\",\"video_p25_watched_actions\",\"video_p50_watched_actions\",\"video_p75_watched_actions\",\"video_p100_watched_actions\",\"like\",\"cost\"]","[\"campaign_group_name\"]","[]","[{\"field\":\"campaign_group_name\",\"operator\":\"=@\",\"value\":\"Madim Limudim\",\"combineToPrev\":\";\"}]","[]","","1000000.0","10.0","[]","{}","","","","","","FACE'!A1:M3","","","","","4.63877153797e+14",""],
    [4,"eqMSP76QXxhBJ1c2ZUv0EdWgiIohhc","","Sheet1","'[רגעי הכנסת הגדולים - דוח סיכום.xlsx]Sheet1'!$A$7:$M$10","2018-07-18 12:51:09","2018-07-30 06:02:14","Refreshed successfully by trigger 9ZrQqmp0v7Avlw5WuIxYTgbJvtoIVR","1.53291971764e+12","0","3.0","TABLE","","AW","last30daysinc","","","","","[\"6653827630`Z - Kniyot reshet\"]","[\"Impressions\",\"VideoViews\",\"VideoViewRate_perc\",\"CostPerInteraction\",\"Cost\",\"VideoQuartile25Rate_perc\",\"VideoQuartile50Rate_perc\",\"VideoQuartile75Rate_perc\",\"VideoQuartile100Rate_perc\",\"Clicks\",\"CPC\",\"VideoQuartile100Views\"]","[\"Campaignname\"]","[]","[{\"field\":\"Impressions\",\"operator\":\">\",\"value\":\"1\",\"combineToPrev\":\";\"},{\"field\":\"Network\",\"operator\":\"=@\",\"value\":\"Youtube\",\"combineToPrev\":\";\"}]","[]","","1000000.0","","[]","{}","","","","","","Sheet1'!A7:M10","","","","","7904050276.0",""],
    [5,"GMvTBJ78KeoXRCVCBjAq530w4MnyFM","","Sheet6","'[רגעי הכנסת הגדולים - דוח סיכום.xlsx]Sheet6'!$A$1:$L$5","2018-07-18 14:12:37","2018-07-30 06:02:13","Refreshed successfully by trigger 9ZrQqmp0v7Avlw5WuIxYTgbJvtoIVR","1.53291971764e+12","0","3.0","TABLE","","FA","thisyear","","","","","[\"act_244556249642320`Fb_kan@lapam.gov.il\"]","[\"impressions\",\"clicks\",\"reach\",\"video_view\",\"video_10_sec_watched_actions\",\"video_p25_watched_actions\",\"video_p50_watched_actions\",\"video_p75_watched_actions\",\"video_p100_watched_actions\",\"like\",\"cost\"]","[\"adgroup_name\"]","[]","[{\"field\":\"campaign_group_name\",\"operator\":\"=@\",\"value\":\"342969\",\"combineToPrev\":\";\"}]","[]","","1000000.0","10.0","[]","{}","","","","","","Sheet6'!A1:L5","","","","","4.63877153797e+14",""],
    [6,"iVbRG0xRD5jXO0GdHkuQGRBV3I5Mq9","","Sheet7","'[רגעי הכנסת הגדולים - דוח סיכום.xlsx]Sheet7'!$A$1:$AK$5","2018-07-19 08:40:44","2018-07-30 06:02:13","Refreshed successfully by trigger 9ZrQqmp0v7Avlw5WuIxYTgbJvtoIVR","1.53291972785e+12","0","8.0","TABLE","","FA","thismonth","","","","","[\"act_244556249642320`Fb_kan@lapam.gov.il\"]","[\"impressions\",\"clicks\",\"reach\",\"video_10_sec_watched_actions\",\"video_p25_watched_actions\",\"video_p50_watched_actions\",\"video_p75_watched_actions\",\"video_p100_watched_actions\",\"like\",\"video_view\",\"page_engagement\",\"cost\"]","[\"adgroup_name\"]","[\"publisher_platform\"]","[{\"field\":\"campaign_group_name\",\"operator\":\"=@\",\"value\":\"342969\",\"combineToPrev\":\";\"}]","[]","adgroup_name","1000000.0","20.0","[\"PIVOT_SORT_ALPHABETIC\"]","{}","","","","","","Sheet7'!A1:AK5","","","","","4.63877153797e+14",""]
]}
