Untitled
unknown
ruby
a year ago
36 kB
5
Indexable
{
"result" => {
"samplingSettings" => {
"campaigns" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "days" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "events" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "banners" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "daysHours" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "dayDatehours" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "weekDays" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "sites" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "sections" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "places" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "advertises" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "webmasterAssistantCampaigns" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "mrcReport" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "criteria" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "categories" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "bannertypes" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "browsers" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "devicesTypes" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "devicesManufacturers" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "operatingSystems" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "geo" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "audienceUsageYa" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "audienceUsageDmp" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "turboLoads" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "sectors" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "webmasterCampaigns" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "uniqueUl" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "unique1d" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "predictorStats" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "headerBiddingStats" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "headerBiddingSites" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "headerBiddingSections" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "headerBiddingPlaces" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "socdemSexesAgesLoadsTotal" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "socdemUsageCampaigns" => {
"isAllowed" => "", "isUsedByDefault" => "", "precision" => "normal"
}, "requestSession" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "planCommon" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "planSumms" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "planCountries" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "planCitiesRussia" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "revenueMonetizers" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "revenueSiteMonetizers" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "revenueSitePlaceMonetizers" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}, "revenueRsyaBlockPlace" => {
"isAllowed" => "1", "isUsedByDefault" => "", "precision" => "normal"
}
}, "reports" => [{
"id" => 34,
"name" => "campaigns",
"title" => "По кампаниям",
"group" => "main",
"graph" => "{\"type\": \"pie\",\"x\": \"campaignName\",\"y\": [\"loadsCommercial\",\"impressionsCommercial\",\"clicksCommercial\"]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"links\":{\"campaignId\":{\"linkType\":\"url\",\"url\":\"\\/modifyCampaignForm.php?campaignID=%campaignId%\"},\"campaignName\":{\"linkType\":\"report\",\"report\":{\"name\":\"banners\",\"campaignId\":\"%campaignId%\"}}}}",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "campaignId", "campaignName", "loadsCommercial", "impressionsCommercial", "clicksCommercial", "ctrCommercial"], "where" => {
"isCommercial" => 1
}, "orderby" => ["impressionsCommercial DESC"]
},
"isCustom" => 0
}, {
"id" => 35,
"name" => "days",
"title" => "По дням",
"group" => "main",
"graph" => "{\"type\": \"line\",\"x\": \"date\",\"y\": [[\"loadsCommercial\"], [\"loadsTotal\",\"loadsDefault\"], [\"impressionsCommercial\", \"loadsDefault\"],[\"clicksCommercial\"]]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"links\":{\"date\":{\"linkType\":\"report\",\"report\":{\"name\":\"dayDatehours\",\"date\":\"%date%\"}}}}",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "date", "loadsCommercial", "impressionsCommercial", "loadsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal"], "orderby" => ["date ASC"]
},
"isCustom" => 0
}, {
"id" => 39,
"name" => "events",
"title" => "По событиям",
"group" => "main",
"graph" => "{\"type\":\"bar\",\"x\":\"eventId\",\"y\":[[\"count\"]]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "eventId", "count"], "orderby" => ["eventId"], "where" => {
"isEvent" => 1
}
},
"isCustom" => 0
}, {
"id" => 40,
"name" => "banners",
"title" => "По баннерам",
"group" => "main",
"graph" => "{\"type\": \"pie\",\"x\": \"bannerName\",\"y\": [\"loadsCommercial\",\"impressionsCommercial\",\"clicksCommercial\"]}",
"flags" => ["production", "hidden"],
"dateRange" => "days",
"tableDisplayParams" => "{\"links\":{\"bannerId\":{\"linkType\":\"url\",\"url\":\"\\/modifyBannerForm.php?bannerID=%bannerId%\"}}}",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => "",
"isCustom" => 0
}, {
"id" => 46,
"name" => "daysHours",
"title" => "По времени суток",
"group" => "main",
"graph" => "{\"type\":\"line\",\"x\":\"hour\",\"y\":[[\"loadsCommercial\"],[\"loadsTotal\",\"loadsDefault\"],[\"impressionsCommercial\",\"loadsDefault\"],[\"clicksCommercial\"]]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "hour", "loadsCommercial", "impressionsCommercial", "loadsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal", "loadsTotalAvg"], "orderby" => ["hour"]
},
"isCustom" => 0
}, {
"id" => 47,
"name" => "dayDatehours",
"title" => "По часам",
"group" => "main",
"graph" => "{\"type\":\"line\",\"x\":\"hour\",\"y\":[[\"loadsCommercial\"],[\"loadsTotal\",\"loadsDefault\"],[\"impressionsCommercial\",\"loadsDefault\"],[\"clicksCommercial\"]]}",
"flags" => ["hidden", "production"],
"dateRange" => "day",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "date", "hour", "loadsCommercial", "impressionsCommercial", "loadsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal"], "orderby" => ["hour"]
},
"isCustom" => 0
}, {
"id" => 48,
"name" => "weekDays",
"title" => "По дням недели",
"group" => "main",
"graph" => "{\"type\":\"line\",\"x\":\"weekDayName\",\"y\":[[\"loadsCommercial\"],[\"loadsTotal\",\"loadsDefault\"],[\"impressionsCommercial\",\"loadsDefault\"],[\"clicksCommercial\"]]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "weekDayId", "weekDayName", "loadsCommercial", "impressionsCommercial", "loadsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal", "loadsTotalAvg"], "orderby" => ["weekDayId"]
},
"isCustom" => 0
}, {
"id" => 55,
"name" => "sites",
"title" => "По сайтам",
"group" => "main",
"graph" => "{\"type\": \"pie\",\"x\": \"siteName\",\"y\": [\"loadsCommercial\",\"impressionsCommercial\",\"loadsDefault\",\"clicksCommercial\",\"loadsTotal\"]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"links\":{\"siteName\":{\"linkType\":\"report\",\"report\":{\"name\":\"sections\",\"siteId\":\"%siteId%\",\"level\":\"site\"}}}}",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "siteId", "siteName", "loadsCommercial", "impressionsCommercial", "loadsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal"], "where" => {
"isTp" => 0
}, "orderby" => ["impressionsCommercial DESC"]
},
"isCustom" => 0
}, {
"id" => 56,
"name" => "sections",
"title" => "По разделам",
"group" => "main",
"graph" => "{\"type\":\"pie\",\"x\":\"sectionName\",\"y\":[\"loadsCommercial\",\"impressionsCommercial\",\"clicksCommercial\"]}",
"flags" => ["production", "hidden"],
"dateRange" => "days",
"tableDisplayParams" => "{\"links\":{\"sectionName\":{\"linkType\":\"report\",\"report\":{\"name\":\"places\",\"sectionId\":\"%sectionId%\"}}}}",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => "",
"isCustom" => 0
}, {
"id" => 57,
"name" => "places",
"title" => "По площадкам",
"group" => "main",
"graph" => "{\"type\":\"pie\",\"x\":\"placeName\",\"y\":[\"loadsCommercial\",\"impressionsCommercial\",\"loadsDefault\",\"clicksCommercial\",\"loadsTotal\"]}",
"flags" => ["production", "hidden"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "placeId", "placeName", "loadsCommercial", "impressionsCommercial", "loadsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal"], "where" => {
"sectionId" => "%sectionId%"
}, "orderby" => ["impressionsCommercial DESC"]
},
"isCustom" => 0
}, {
"id" => 76,
"name" => "advertises",
"title" => "По рекламодателям",
"group" => "main",
"graph" => "{\"type\":\"pie\",\"x\":\"advertiserName\",\"y\":[\"loadsCommercial\",\"impressionsCommercial\",\"clicksCommercial\"]}",
"flags" => ["ownerAccess", "assistantAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "advertiserId", "advertiserName", "loadsCommercial", "impressionsCommercial", "clicksCommercial"], "orderby" => ["impressionsCommercial DESC"], "where" => {
"isAdvertiser" => 1
}
},
"isCustom" => 0
}, {
"id" => 191,
"name" => "webmasterAssistantCampaigns",
"title" => "По сверке ассистенты/рекламные кампании",
"group" => "main",
"graph" => "",
"flags" => ["ownerAccess", "webmasterAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"hierarchyType\":\"sparse\",\"sparseHierarchy\":[{\"id\":\"campaignAssistantId\",\"title\":\"campaignAssistantName\"}]}",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "campaignAssistantId", "campaignAssistantName", "campaignId", "campaignName", "loadsCommercial", "impressionsTotal", "clicksTotal"], "where" => {
"isCommercial" => 1
}, "whereNot" => {
"campaignAssistantId" => 0
}, "orderby" => ["campaignAssistantName", "loadsCommercial DESC"]
},
"isCustom" => 0
}, {
"id" => 243,
"name" => "mrcReport",
"title" => "Отчет по рекламным кампаниям с учетом \"IMS\"",
"group" => "main",
"graph" => "",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"links\":{\"campaignId\":{\"linkType\":\"url\",\"url\":\"\\/modifyCampaignForm.php?campaignID=%campaignId%\"}}}",
"availableFrom" => "",
"yuql" => {
"select" => ["date", "campaignId", "campaignName", "loadsCommercial", "impressionsCommercial", "mrc2001Count", "mrc2002Count", "mrcNonViewableAdImpressions", "mrc2003Count", "mrcClick", "fraudGivt2001", "fraudSivt2001", "fraudGivt2002", "fraudSivt2002", "fraudGivtClicks", "fraudSivtClicks"], "where" => {
"isNonRsya" => 1, "isCommercial" => 1, "campaignSystemType" => ["typeNormal"]
}, "orderby" => ["date ASC"]
},
"isCustom" => 0
}, {
"id" => 33,
"name" => "criteria",
"title" => "По пользовательским характеристикам",
"group" => "advanced",
"graph" => "{\"type\":\"pie\",\"x\":\"oc%criteriaId%OldName\",\"y\":[\"loadsCommercial\",\"loadsTotal\",\"impressionsCommercial\",\"clicksCommercial\"]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "",
"yuql" => {
"select" => ["oc%criteriaId%Old", "oc%criteriaId%OldName", "loadsCommercial", "impressionsCommercial", "loadsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal"], "orderby" => ["oc%criteriaId%OldName", "loadsTotal DESC"]
},
"isCustom" => 0
}, {
"id" => 42,
"name" => "categories",
"title" => "По категориям",
"group" => "advanced",
"graph" => "{\"type\":\"pie\",\"x\":\"categoryName\",\"y\":[\"loadsTotal\",\"impressionsCommercial\",\"clicksCommercial\"]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "categoryId", "categoryName", "loadsCommercial", "impressionsCommercial", "loadsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal"], "orderby" => ["impressionsCommercial DESC"]
},
"isCustom" => 0
}, {
"id" => 43,
"name" => "bannertypes",
"title" => "По типам баннеров",
"group" => "advanced",
"graph" => "{\"type\":\"pie\",\"x\":\"bannertypeName\",\"y\":[\"loadsCommercial\",\"impressionsCommercial\",\"clicksCommercial\"]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "bannertypeId", "bannertypeName", "loadsCommercial", "impressionsCommercial", "loadsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal"], "orderby" => ["impressionsCommercial DESC"]
},
"isCustom" => 0
}, {
"id" => 45,
"name" => "browsers",
"title" => "По браузерам",
"group" => "advanced",
"graph" => "{\"type\":\"pie\",\"x\":\"adfBrowserName\",\"y\":[\"loadsCommercial\",\"loadsTotal\",\"impressionsCommercial\",\"clicksCommercial\"]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "adfBrowserId", "adfBrowserName", "loadsCommercial", "impressionsCommercial", "loadsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal"], "orderby" => ["impressionsCommercial DESC"]
},
"isCustom" => 0
}, {
"id" => 49,
"name" => "devicesTypes",
"title" => "По типам устройств",
"group" => "advanced",
"graph" => "{\"type\":\"pie\",\"x\":\"yaDeviceTypeName\",\"y\":[\"impressionsCommercial\",\"loadsDefault\",\"clicksCommercial\",\"clicksDefault\",\"loadsTotal\"]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "yaDeviceTypeName", "loadsCommercial", "impressionsCommercial", "loadsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal"], "orderby" => ["impressionsCommercial DESC"]
},
"isCustom" => 0
}, {
"id" => 51,
"name" => "devicesManufacturers",
"title" => "По производителям устройств",
"group" => "advanced",
"graph" => "{\"type\":\"pie\",\"x\":\"adfManufacturerName\",\"y\":[\"loadsCommercial\",\"loadsTotal\",\"impressionsCommercial\",\"clicksCommercial\"]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "adfManufacturerId", "adfManufacturerName", "loadsCommercial", "impressionsCommercial", "impressionsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal"], "orderby" => ["impressionsCommercial DESC"]
},
"isCustom" => 0
}, {
"id" => 53,
"name" => "operatingSystems",
"title" => "По операционным системам",
"group" => "advanced",
"graph" => "{\"type\":\"pie\",\"x\":\"adfOsName\",\"y\":[\"loadsCommercial\",\"loadsTotal\",\"impressionsCommercial\",\"clicksCommercial\"]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "adfOsId", "adfOsName", "loadsCommercial", "impressionsCommercial", "loadsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal"], "orderby" => ["impressionsCommercial DESC"]
},
"isCustom" => 0
}, {
"id" => 84,
"name" => "geo",
"title" => "По географии",
"group" => "advanced",
"graph" => "",
"flags" => ["hideTotals", "production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"hierarchyType\":\"tree\",\"treeId\":\"yaGeoHierarchyId\",\"treeParent\":\"yaGeoHierarchyParentId\"}",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "yaGeoHierarchyParentId", "yaGeoHierarchyId", "yaGeoHierarchyName", "loadsCommercial", "impressionsCommercial", "loadsDefault", "clicksCommercial", "clicksDefault", "ctrCommercial", "loadsTotal"], "orderby" => ["impressionsCommercial DESC"]
},
"isCustom" => 0
}, {
"id" => 88,
"name" => "audienceUsageYa",
"title" => "По использованию (сегменты Яндекс.Аудиторий)",
"group" => "advanced",
"graph" => "",
"flags" => ["ownerAccess", "assistantAccess", "advertiserAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-10-14 00:00:00",
"yuql" => "",
"isCustom" => 0
}, {
"id" => 109,
"name" => "audienceUsageDmp",
"title" => "По использованию (сегменты DMP)",
"group" => "advanced",
"graph" => "",
"flags" => ["ownerAccess", "assistantAccess", "advertiserAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-10-14 00:00:00",
"yuql" => "",
"isCustom" => 0
}, {
"id" => 150,
"name" => "turboLoads",
"title" => "По типам баннеров Turbo",
"group" => "advanced",
"graph" => "",
"flags" => ["ownerAccess", "assistantAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-12-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "bannertypeId", "bannertypeName", "loadsCommercialNonRsya", "loadsCommercialRsya", "loadsDefault", "loadsTotal"], "where" => {
"isTurbo" => 1
}, "orderby" => ["loadsTotal DESC"]
},
"isCustom" => 0
}, {
"id" => 154,
"name" => "sectors",
"title" => "По отраслям",
"group" => "advanced",
"graph" => "",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "sectorId", "sectorName", "loadsCommercial", "impressionsCommercial", "ctrCommercial"], "orderby" => ["loadsCommercial"]
},
"isCustom" => 0
}, {
"id" => 226,
"name" => "webmasterCampaigns",
"title" => "По сверке владельцы сайта/рекламные кампании",
"group" => "advanced",
"graph" => "",
"flags" => ["ownerAccess", "assistantAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"hierarchyType\":\"sparse\",\"sparseHierarchy\":[{\"id\":\"webmasterId\",\"title\":\"webmasterName\"}]}",
"availableFrom" => "2016-04-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "webmasterId", "webmasterName", "campaignId", "campaignName", "loadsCommercial", "impressionsTotal", "clicksTotal", "ctrCommercial", "clicksCommercial", "impressionsCommercial"], "where" => {
"isCommercial" => 1
}, "whereNot" => {
"webmasterId" => 0
}, "orderby" => ["webmasterName", "loadsCommercial DESC"]
},
"isCustom" => 0
}, {
"id" => 4,
"name" => "uniqueUl",
"title" => "Накопительные",
"group" => "uniques",
"graph" => "{\"type\": \"line\",\"x\": \"date\",\"y\": [[\"accumulateLoadsTotal\",\"accumulateUniqueLoadsTotalCorrected\"],[\"accumulateClicksTotal\",\"accumulateUniqueClicksTotalCorrected\"],[\"incomeUniqueLoadsTotal\"],[\"incomeUniqueClicksTotal\"],[\"frequencyAccumulateLoadsTotal\"]]}",
"flags" => ["hideTotals", "production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["date", "accumulateLoadsTotal", "accumulateUniqueLoadsTotalCorrected", "incomeUniqueLoadsTotal", "frequencyAccumulateLoadsTotal", "accumulateClicksTotal", "accumulateUniqueClicksTotalCorrected", "incomeUniqueClicksTotal", "ctrCommercial", "uniqueCtrCommercial"], "orderby" => ["date"]
},
"isCustom" => 0
}, {
"id" => 143,
"name" => "unique1d",
"title" => "Cуточные",
"group" => "uniques",
"graph" => "{\"type\": \"line\",\"x\": \"date\",\"y\": [[\"loadsTotal\",\"uniqueLoadsTotal\"],[\"clicksTotal\",\"uniqueClicksTotal\"],[\"frequencyLoadsTotal\"]]}",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "date", "loadsTotal", "uniqueLoadsTotal", "clicksTotal", "uniqueClicksTotal", "frequencyLoadsTotal"], "orderby" => ["date DESC"]
},
"isCustom" => 0
}, {
"id" => 164,
"name" => "predictorStats",
"title" => "По монетизации Google",
"group" => "monetization",
"graph" => "",
"flags" => ["ownerAccess", "assistantAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "",
"yuql" => "",
"isCustom" => 0
}, {
"id" => 168,
"name" => "headerBiddingStats",
"title" => "По Header Bidding по монетизаторам",
"group" => "monetization",
"graph" => "",
"flags" => ["ownerAccess", "assistantAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "",
"yuql" => "",
"isCustom" => 0
}, {
"id" => 172,
"name" => "headerBiddingSites",
"title" => "По Header Bidding по монетизаторам (по сайтам)",
"group" => "monetization",
"graph" => "",
"flags" => ["ownerAccess", "assistantAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "",
"yuql" => "",
"isCustom" => 0
}, {
"id" => 173,
"name" => "headerBiddingSections",
"title" => "По Header Bidding по разделам",
"group" => "monetization",
"graph" => "",
"flags" => ["hidden", "ownerAccess", "assistantAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"hierarchyType\":\"sparse\",\"sparseHierarchy\":[{\"id\":\"siteId\",\"title\":\"siteName\"},{\"id\":\"sectionId\",\"title\":\"sectionName\"}],\"links\":{\"sectionName\":{\"linkType\":\"report\",\"report\":{\"sectionId\":\"%sectionId%\",\"name\":\"headerBiddingPlaces\"}}}}",
"availableFrom" => "",
"yuql" => "",
"isCustom" => 0
}, {
"id" => 175,
"name" => "headerBiddingPlaces",
"title" => "По Header Bidding по площадкам",
"group" => "monetization",
"graph" => "",
"flags" => ["hidden", "ownerAccess", "assistantAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"hierarchyType\":\"sparse\",\"sparseHierarchy\":[{\"id\":\"siteId\",\"title\":\"siteName\"},{\"id\":\"sectionId\",\"title\":\"sectionName\"},{\"id\":\"placeId\",\"title\":\"placeName\"}]}",
"availableFrom" => "",
"yuql" => "",
"isCustom" => 0
}, {
"id" => 113,
"name" => "socdemSexesAgesLoadsTotal",
"title" => "Запросы кода и показы по пересечению пола/возраста",
"group" => "socdem",
"graph" => "",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"hierarchyType\":\"split\",\"splitId\":\"kryptaAge\",\"splitTitle\":\"kryptaAgeName\"}",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "kryptaSex", "kryptaSexName", "kryptaAge", "kryptaAgeName", "loadsTotal", "uniqueLoadsTotal", "impressionsCommercial"]
},
"isCustom" => 0
}, {
"id" => 119,
"name" => "socdemUsageCampaigns",
"title" => "Показы и загрузки баннеров по кампаниям с использованием таргетирования по соцдему",
"group" => "socdem",
"graph" => "",
"flags" => ["ownerAccess", "assistantAccess", "advertiserAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"hierarchyType\":\"split\",\"splitId\":\"targetingTarificatedId\",\"splitTitle\":\"targetingTarificatedName\"}",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => {
"select" => ["ownerId", "campaignId", "campaignName", "targetingTarificatedId", "targetingTarificatedName", "loadsCommercial", "impressionsCommercial"], "where" => {
"isCommercial" => 1, "targetingTarificatedId" => [15, 16, 17]
}, "orderby" => ["campaignId DESC"]
},
"isCustom" => 0
}, {
"id" => 149,
"name" => "requestSession",
"title" => "По инвентарю Google без возвратов",
"group" => "traffic",
"graph" => "",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"links\":{\"siteName\":{\"linkType\":\"report\",\"report\":{\"name\":\"requestSession\",\"siteId\":\"%siteId%\",\"level\":\"site\"}}}}",
"availableFrom" => "2017-01-01 00:00:00",
"yuql" => "",
"isCustom" => 0
}, {
"id" => 237,
"name" => "planCommon",
"title" => "По инвентарю",
"group" => "plan",
"graph" => "",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "",
"yuql" => {
"select" => ["siteName", "sectionName", "placeName", "bannertypeName", "loadsCommercial", "impressionsCommercial", "loadsTotal", "loadsDefault", "fillFactor"]
},
"isCustom" => 0
}, {
"id" => 238,
"name" => "planSumms",
"title" => "Только суммы",
"group" => "plan",
"graph" => "",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "",
"yuql" => {
"select" => ["loadsCommercial", "impressionsCommercial", "loadsTotal", "loadsDefault", "fillFactor"]
},
"isCustom" => 0
}, {
"id" => 239,
"name" => "planCountries",
"title" => "По странам",
"group" => "plan",
"graph" => "",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "",
"yuql" => {
"select" => ["siteName", "sectionName", "placeName", "bannertypeName", "yaGeoCountryName", "loadsCommercial", "impressionsCommercial", "loadsTotal", "loadsDefault", "fillFactor"]
},
"isCustom" => 0
}, {
"id" => 240,
"name" => "planCitiesRussia",
"title" => "По городам России",
"group" => "plan",
"graph" => "",
"flags" => ["production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "",
"yuql" => {
"select" => ["siteName", "sectionName", "placeName", "bannertypeName", "yaGeoCityName", "loadsCommercial", "impressionsCommercial", "loadsTotal", "loadsDefault", "fillFactor"], "where" => {
"yaGeoHierarchyId" => ["225"]
}
},
"isCustom" => 0
}, {
"id" => 249,
"name" => "revenueMonetizers",
"title" => "По монетизаторам",
"group" => "revenue",
"graph" => "",
"flags" => ["ownerAccess", "assistantAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "null",
"availableFrom" => "",
"yuql" => {
"orderby" => ["revenue desc"]
},
"isCustom" => 0
}, {
"id" => 250,
"name" => "revenueSiteMonetizers",
"title" => "По сайтам, монетизаторам",
"group" => "revenue",
"graph" => "",
"flags" => ["ownerAccess", "assistantAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"hierarchyType\":\"true\"}",
"availableFrom" => "",
"yuql" => "",
"isCustom" => 0
}, {
"id" => 251,
"name" => "revenueSitePlaceMonetizers",
"title" => "По сайтам, площадкам, монетизаторам",
"group" => "revenue",
"graph" => "",
"flags" => ["ownerAccess", "assistantAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"hierarchyType\":\"true\"}",
"availableFrom" => "",
"yuql" => "",
"isCustom" => 0
}, {
"id" => 253,
"name" => "revenueRsyaBlockPlace",
"title" => "РСЯ по сайтам, разделам, блокам и площадкам",
"group" => "revenue",
"graph" => "",
"flags" => ["ownerAccess", "assistantAccess", "production"],
"dateRange" => "days",
"tableDisplayParams" => "{\"hierarchyType\":\"true\"}",
"availableFrom" => "",
"yuql" => "",
"isCustom" => 0
}, {
"id" => 744,
"name" => "custom_744",
"title" => "типы баннеров без возвратов 2",
"isCustom" => 1,
"dateRange" => "days",
"availableFrom" => "2021-04-01 00:00:00",
"group" => "main",
"graph" => "{}",
"flags" => ["hidden"],
"tableDisplayParams" => "{}",
"yuql" => []
}, {
"id" => 1707,
"name" => "custom_1707",
"title" => "Inlab impressions",
"isCustom" => 1,
"dateRange" => "days",
"availableFrom" => "2022-03-05 00:00:00",
"group" => "main",
"graph" => "{}",
"flags" => ["hidden"],
"tableDisplayParams" => "{}",
"yuql" => []
}, {
"id" => 2149,
"name" => "custom_2149",
"title" => "возраст",
"isCustom" => 1,
"dateRange" => "days",
"availableFrom" => "2022-05-19 00:00:00",
"group" => "main",
"graph" => "{}",
"flags" => ["hidden"],
"tableDisplayParams" => "{}",
"yuql" => []
}, {
"id" => 3291,
"name" => "custom_3291",
"title" => "skins",
"isCustom" => 1,
"dateRange" => "days",
"availableFrom" => "2022-12-01 00:00:00",
"group" => "main",
"graph" => "{}",
"flags" => ["hidden"],
"tableDisplayParams" => "{}",
"yuql" => []
}, {
"id" => 3452,
"name" => "custom_3452",
"title" => "spl_revenue_advertisers",
"isCustom" => 1,
"dateRange" => "days",
"availableFrom" => "2022-12-19 00:00:00",
"group" => "main",
"graph" => "{}",
"flags" => ["hidden"],
"tableDisplayParams" => "{}",
"yuql" => []
}], "groups" => {
"criteria" => {
"name" => "criteria", "title" => "По пользовательским характеристикам"
}, "uniques" => {
"name" => "uniques", "title" => "Аудиторные показатели"
}, "advanced" => {
"name" => "advanced", "title" => "Дополнительные"
}, "main" => {
"name" => "main", "title" => "Основные"
}, "socdem" => {
"name" => "socdem", "title" => "По полу и возрасту"
}, "traffic" => {
"name" => "traffic", "title" => "По трафику"
}, "monetization" => {
"name" => "monetization", "title" => "Монетизация"
}, "plan" => {
"name" => "plan", "title" => "Для планирования"
}, "revenue" => {
"name" => "revenue", "title" => "Вознаграждение по монетизации"
}
}
}, "error" => nil
}