{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Список кампаний","Сегменты"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Список кампаний","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["test1_msk_poisk_day","Символ разделения:","_"]
["test2_msk_poisk_day"]
["test2_msk_rsya_day"]
["test1_msk_rsya_day"]
["test1_spb_poisk_day"]
["test2_spb_poisk_day"]
["test2_spb_rsya_day"]
["test1_spb_rsya_day"]
["test1_msk_retargeting_day"]
["test1_spb_retargeting_day"]
["test1_rf_poisk_day"]
["test2_rf_poisk_day"]
["test1_rf_rsya_day"]
["test2_rf_rsya_day"]
["test1_msk_poisk_night"]
["test2_msk_poisk_night"]
["test1_msk_rsya_night"]
["test1_spb_poisk_night"]

{"sheet":"Сегменты","index":1,"n_rows":73,"n_cols":7,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["Общие названия","Вид сегмента","Метки в названиях кампаний","Метки для BI",null,"Вид сегмента","Остаточные метки"]
["Данные","Страница","test1_","Первая",null,"Страница","Неизвестно"]
["Кампания","Регионы","_msk_","Москва",null,"Регионы","Неизвестно"]
[null,"Сети","_poisk_","Поиск",null,"Сети","Неизвестно"]
["Результат:","Время суток","_day","День",null,"Время суток","Неизвестно"]
["Сегменты = SUMMARIZE('Данные';'Данные'[Кампания];\"Страница\";if(search(\"test1_\";'Данные'[Кампания];1;0)>0;\"Первая\";if(search(\"test2_\";'Данные'[Кампания];1;0)>0;\"Вторая\";\"Неизвестно\"));\"Регионы\";if(search(\"_msk_\";'Данные'[Кампания];1;0)>0;\"Москва\";if(search(\"_spb_\";'Данные'[Кампания];1;0)>0;\"Питер\";if(search(\"_rf_\";'Данные'[Кампания];1;0)>0;\"Россия\";\"Неизвестно\")));\"Сети\";if(search(\"_poisk_\";'Данные'[Кампания];1;0)>0;\"Поиск\";if(search(\"_rsya_\";'Данные'[Кампания];1;0)>0;\"РСЯ\";if(search(\"_retargeting\";'Данные'[Кампания];1;0)>0;\"Ретаргетинг\";if(search(\"_retargeting_\";'Данные'[Кампания];1;0)>0;\"Ретаргетинг\";\"Неизвестно\"))));\"Время суток\";if(search(\"_day\";'Данные'[Кампания];1;0)>0;\"День\";if(search(\"_night\";'Данные'[Кампания];1;0)>0;\"Ночь\";\"Неизвестно\")))","Страница","test2_","Вторая",null,"",""]
[null,"Сети","_rsya_","РСЯ",null,"",""]
[null,"Регионы","_spb_","Питер",null,"",""]
[null,"Сети","_retargeting","Ретаргетинг",null,"",""]
[null,"Сети","_retargeting_","Ретаргетинг",null,"",""]
[null,"Регионы","_rf_","Россия",null,"",""]
[null,"Время суток","_night","Ночь",null,"",""]
[null,"",null,"",null,"",""]
[null,"","","",null,"",""]
[null,"","","",null,"",""]
[null,"","","",null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"","","",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]
[null,"",null,"",null,"",""]