Untitled
unknown
ruby
a year ago
36 kB
3
Indexable
{"result"=>{"taskId"=>"100115c6-f0d9-4b35-a70d-eb99e554f7f8", "state"=>"SUCCESS", "fields"=>["correct", "date", "accumulateImpressionsCommercial", "accumulateUniqueImpressionsCommercialCorrected", "incomeUniqueImpressionsCommercial", "frequencyAccumulateImpressionsCommercial", "accumulateClicksCommercial", "accumulateUniqueClicksCommercialCorrected", "incomeUniqueClicksCommercial", "ctrCommercial", "uniqueCtrCommercial"], "fieldsInfo"=>{"correct"=>{"deprecated"=>"", "groupby"=>"", "orderby"=>"", "purpose"=>"System", "totals"=>"", "type"=>"UInt8", "title"=>"Полнота данных"}, "date"=>{"deprecated"=>"", "groupby"=>"1", "orderby"=>"1", "purpose"=>"Key", "totals"=>"", "type"=>"Date", "title"=>"Дата"}, "accumulateImpressionsCommercial"=>{"deprecated"=>"", "groupby"=>"", "orderby"=>"1", "purpose"=>"Value", "totals"=>"", "type"=>"UInt64", "title"=>"Показы (нарастающим итогом)"}, "accumulateUniqueImpressionsCommercialCorrected"=>{"deprecated"=>"", "groupby"=>"", "orderby"=>"1", "purpose"=>"Value", "totals"=>"", "type"=>"UInt64", "title"=>"Уникальные показы (охват на дату)"}, "incomeUniqueImpressionsCommercial"=>{"deprecated"=>"", "groupby"=>"", "orderby"=>"1", "purpose"=>"Value", "totals"=>"", "type"=>"UInt64", "title"=>"Прирост показов за сутки"}, "frequencyAccumulateImpressionsCommercial"=>{"deprecated"=>"", "groupby"=>"", "orderby"=>"1", "purpose"=>"Value", "totals"=>"", "type"=>"Float32", "title"=>"Частота"}, "accumulateClicksCommercial"=>{"deprecated"=>"", "groupby"=>"", "orderby"=>"1", "purpose"=>"Value", "totals"=>"", "type"=>"UInt64", "title"=>"Переходы (нарастающим итогом)"}, "accumulateUniqueClicksCommercialCorrected"=>{"deprecated"=>"", "groupby"=>"", "orderby"=>"1", "purpose"=>"Value", "totals"=>"", "type"=>"UInt64", "title"=>"Уникальные переходы (охват на дату)"}, "incomeUniqueClicksCommercial"=>{"deprecated"=>"", "groupby"=>"", "orderby"=>"1", "purpose"=>"Value", "totals"=>"", "type"=>"UInt64", "title"=>"Прирост переходов за сутки"}, "ctrCommercial"=>{"deprecated"=>"", "groupby"=>"", "orderby"=>"1", "purpose"=>"Value", "totals"=>"", "type"=>"Percent", "title"=>"CTR"}, "uniqueCtrCommercial"=>{"deprecated"=>"", "groupby"=>"", "orderby"=>"1", "purpose"=>"Value", "totals"=>"", "type"=>"Percent", "title"=>"Уникальный CTR"}}, "table"=>[[1, "2020-07-25", 10725, 5850, 0, 1.8333333333333333, 22, 22, 0, 0.0020512820512820513, 0.0037606837606837607], [1, "2020-07-24", 22802, 13585, 7735, 1.678468899521531, 53, 53, 31, 0.002566862631448207, 0.0036025566531086577], [1, "2020-07-23", 34936, 20750, 7165, 1.6836626506024097, 83, 80, 27, 0.0024723916268336904, 0.0033613445378151263], [1, "2020-07-22", 47806, 27440, 6690, 1.742201166180758, 103, 100, 20, 0.001554001554001554, 0.002277904328018223], [1, "2020-07-21", 61057, 34335, 6895, 1.7782728993738168, 115, 115, 15, 0.000905592030790129, 0.0013121924548933845], [1, "2020-07-20", 72549, 39115, 4780, 1.8547616004090501, 125, 120, 5, 0.000870170553428472, 0.001358695652173913]], "progress"=>0, "eventHorizon"=>"2023-09-14 14:55:00"}, "error"=>nil}
2.5.7 :003 > c = Proj.find(930).adfox_banner_campaigns.last
=> #<AdfoxBannerCampaign id: 1048, proj_id: 930, name: "S1611 SPL МЮЗ 300х500 (desktop) + 990х250 (desktop...", adfox_id: 2548704, created_at: "2023-09-12 18:09:02", updated_at: "2023-09-12 18:28:45", clicks_plan: nil, uniq_impressions_plan: 180000, is_banners_hidden: true>
2.5.7 :004 > c = Proj.find(930).adfox_banner_campaigns.last
=> #<AdfoxBannerCampaign id: 1048, proj_id: 930, name: "S1611 SPL МЮЗ 300х500 (desktop) + 990х250 (desktop...", adfox_id: 2548704, created_at: "2023-09-12 18:09:02", updated_at: "2023-09-12 18:28:45", clicks_plan: nil, uniq_impressions_plan: 180000, is_banners_hidden: true>
2.5.7 :005 > => #<AdfoxBannerCampaign id: 1048, proj_id: 930, name: "S1611 SPL МЮЗ 300х500 (desktop) + 990х250 (desktop...", adfox_id: 2548704, created_at: "2023-09-12 18:09:02", updated_at: "2023-09-12 18:28:45", clicks_plan: nil, uniq_impressions_plan: 180000, is_banners_hidden: true>^C
2.5.7 :005 > YandexAdfox::Api.get("/list/owner")
=> #<HTTParty::Response:0x87d8338 parsed_response={"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}, @response=#<Net::HTTPOK 200 OK readbody=true>, @headers={"cache-control"=>["no-cache, private"], "connection"=>["Close"], "content-security-policy"=>["default-src 'none';img-src 'self' data: an.yandex.ru avatars.mds.yandex.net avatars.mdst.yandex.net banners.adfox.ru ads.adfox.ru yastatic.net mc.yandex.az mc.yandex.by mc.yandex.co.il mc.yandex.com mc.yandex.com.am mc.yandex.com.ge mc.yandex.com.tr mc.yandex.ee mc.yandex.fr mc.yandex.kg mc.yandex.kz mc.yandex.lt mc.yandex.lv mc.yandex.md mc.yandex.ru mc.yandex.tj mc.yandex.tm mc.yandex.ua mc.yandex.uz mc.webvisor.com mc.webvisor.org https://mc.yandex.ru preview-production.adfox.net api-maps.yandex.ru core-renderer-tiles.maps.yandex.net suggest-maps.yandex.ru;font-src 'self' data: chrome-extension: yastatic.net fonts.gstatic.com;child-src blob: mc.yandex.ru https://mc.yandex.ru;connect-src 'self' *.adfox.ru an.yandex.ru yandex.ru api.passport.yandex.ru mail.yandex.ru api.passport.yandex.com mail.yandex.com mc.yandex.az mc.yandex.by mc.yandex.co.il mc.yandex.com mc.yandex.com.am mc.yandex.com.ge mc.yandex.com.tr mc.yandex.ee mc.yandex.fr mc.yandex.kg mc.yandex.kz mc.yandex.lt mc.yandex.lv mc.yandex.md mc.yandex.ru mc.yandex.tj mc.yandex.tm mc.yandex.ua mc.yandex.uz mc.webvisor.com mc.webvisor.org sentry.iddqd.yandex.net https://mc.yandex.ru https://*.mc.yandex.ru yandexmetrica.com:* 127.0.0.1:* suggest-maps.yandex.ru;frame-src 'self' blob: yandex.ru mc.yandex.ru forms.yandex.ru preview.adfox.net https://mc.yandex.ru api-maps.yandex.ru suggest-maps.yandex.ru core-renderer-tiles.maps.yandex.net;style-src 'self' 'unsafe-inline';script-src 'self' 'unsafe-eval' yastatic.net yandex.ru mc.yandex.ru mc.yandex.az mc.yandex.by mc.yandex.co.il mc.yandex.com mc.yandex.com.am mc.yandex.com.ge mc.yandex.com.tr mc.yandex.ee mc.yandex.fr mc.yandex.kg mc.yandex.kz mc.yandex.lt mc.yandex.lv mc.yandex.md mc.yandex.tj mc.yandex.tm mc.yandex.ua mc.yandex.uz mc.webvisor.com mc.webvisor.org https://mc.yandex.ru https://yastatic.net api-maps.yandex.ru core-renderer-tiles.maps.yandex.net 'nonce-c4829b9a95727d37a443e1c1ea595f507905fee87839a15b7c1cc01d9fc77a85';base-uri 'none';report-uri https://csp.yandex.net/csp?from=adfox"], "content-type"=>["application/json"], "date"=>["Thu, 14 Sep 2023 13:33:53 GMT"], "set-cookie"=>["_yasc=1GKKBeVFvE31yn+6oMlzNYLY952OMOjg4uTyUSfhGcWXzURq1cKdgVcHHEqmCMWk; domain=.yandex.ru; path=/; expires=Sun, 11 Sep 2033 13:33:52 GMT; secure", "i=zA6rQ6lC0bdK+Mg+0erFjjLmPFpPeaLDhaycI+0BM4oI8R3oxFOvdM0wb/rt7vjaGCWmL0L7yfs9n/B1IJdesTj+ECs=; Expires=Sat, 13-Sep-2025 13:33:52 GMT; Domain=.yandex.ru; Path=/; Secure; HttpOnly", "yandexuid=5770318281694698432; Expires=Sat, 13-Sep-2025 13:33:52 GMT; Domain=.yandex.ru; Path=/; Secure"], "strict-transport-security"=>["max-age=31536000"], "transfer-encoding"=>["chunk