Untitled
unknown
ruby
a year ago
36 kB
4
Indexable
Never
{ "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 }