{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Заготовка New","Adwords New","Список Плюс-слов"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"comments":2,"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":"Заготовка New","index":0,"n_rows":21,"n_cols":30,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"?utm_source=yandex&utm_medium=cpc&utm_campaign=cid|{campaign_id}|phrase_id|{phrase_id}|keyword|{keyword}&utm_content=gid|{gbid}|pos_type|{position_type}|pos_type|{position}&utm_term={keyword}&pm_source_type={source_type}&pm_block={position_type}&pm_position_type={position_type}&pm_position={position}$pm_keyword={keyword}&pm_source={source}&pm_campaign_id={campaign_id}&pm_ad_id={ad_id}&pmphrase_id={phrase_id}&mcpa=context&marketing=direct_{campaign_id}&roistat=direct1_{source_type}_{banner_id}_{keyword}&roistat_referrer={source}&roistat_pos={position_type}_{position}"," "]
["Номер группы","Ключевая фраза","Название группы","Фраза","Заголовок","Часть1 ","Часть 2","Текст","Расш.заг.(Макс 54)","URL","Ссылка","Отображаемая ссылка","Ставка","Ставка на тематич. пл.","БС1\nтекст","БС1\nБез метки","БС1\nссылка","БС2\nтекст","БС2\nБез метки","БС2\nссылка","БС3\nтекст","БС3\nБез метки","БС3\nссылка","БС4\nтекст","БС3\nБез метки2","БС4\nссылка","БС\nдлина\nmax 66","Заголовки быстрых ссылок","Адреса быстрых ссылок","Уточнения (max 66)"]
[1,"купить часы",{"$f":"TRIM(UPPER(MID(B3,1,1))&MID(B3,2,LEN(B3)-1))","v":"Купить часы"},"купить часы",{"$f":"REPLACE(LOWER(C3),1,1,LEFT(PROPER(C3)))&\"!\"","v":"Купить часы!"},"hjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhjk",null,{"$f":"REPLACE(LOWER(F3),1,1,LEFT(PROPER(F3)))&\"!\"","v":"Hjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhjk!"},{"$f":"LEN(E3&F3)","v":50},"http://www.site.ru/watch/?",{"$f":"CONCATENATE(J3,K$1)","v":"http://www.site.ru/watch/??utm_source=yandex&utm_medium=cpc&utm_campaign=cid|{campaign_id}|phrase_id|{phrase_id}|keyword|{keyword}&utm_content=gid|{gbid}|pos_type|{position_type}|pos_type|{position}&utm_term={keyword}&pm_source_type={source_type}&pm_block={position_type}&pm_position_type={position_type}&pm_position={position}$pm_keyword={keyword}&pm_source={source}&pm_campaign_id={campaign_id}&pm_ad_id={ad_id}&pmphrase_id={phrase_id}&mcpa=context&marketing=direct_{campaign_id}&roistat=direct1_{source_type}_{banner_id}_{keyword}&roistat_referrer={source}&roistat_pos={position_type}_{position}"},{"$f":"LOWER(B3)","v":"купить часы"},0.5,0.5,"Есплатно",null,{"$f":"P3&K$1","v":"?utm_source=yandex&utm_medium=cpc&utm_campaign=cid|{campaign_id}|phrase_id|{phrase_id}|keyword|{keyword}&utm_content=gid|{gbid}|pos_type|{position_type}|pos_type|{position}&utm_term={keyword}&pm_source_type={source_type}&pm_block={position_type}&pm_position_type={position_type}&pm_position={position}$pm_keyword={keyword}&pm_source={source}&pm_campaign_id={campaign_id}&pm_ad_id={ad_id}&pmphrase_id={phrase_id}&mcpa=context&marketing=direct_{campaign_id}&roistat=direct1_{source_type}_{banner_id}_{keyword}&roistat_referrer={source}&roistat_pos={position_type}_{position}"},"Удобно",null,{"$f":"S3&K$1","v":"?utm_source=yandex&utm_medium=cpc&utm_campaign=cid|{campaign_id}|phrase_id|{phrase_id}|keyword|{keyword}&utm_content=gid|{gbid}|pos_type|{position_type}|pos_type|{position}&utm_term={keyword}&pm_source_type={source_type}&pm_block={position_type}&pm_position_type={position_type}&pm_position={position}$pm_keyword={keyword}&pm_source={source}&pm_campaign_id={campaign_id}&pm_ad_id={ad_id}&pmphrase_id={phrase_id}&mcpa=context&marketing=direct_{campaign_id}&roistat=direct1_{source_type}_{banner_id}_{keyword}&roistat_referrer={source}&roistat_pos={position_type}_{position}"},null,null,{"$f":"V3&K$1","v":"?utm_source=yandex&utm_medium=cpc&utm_campaign=cid|{campaign_id}|phrase_id|{phrase_id}|keyword|{keyword}&utm_content=gid|{gbid}|pos_type|{position_type}|pos_type|{position}&utm_term={keyword}&pm_source_type={source_type}&pm_block={position_type}&pm_position_type={position_type}&pm_position={position}$pm_keyword={keyword}&pm_source={source}&pm_campaign_id={campaign_id}&pm_ad_id={ad_id}&pmphrase_id={phrase_id}&mcpa=context&marketing=direct_{campaign_id}&roistat=direct1_{source_type}_{banner_id}_{keyword}&roistat_referrer={source}&roistat_pos={position_type}_{position}"},null,null,{"$f":"Y3&K$1","v":"?utm_source=yandex&utm_medium=cpc&utm_campaign=cid|{campaign_id}|phrase_id|{phrase_id}|keyword|{keyword}&utm_content=gid|{gbid}|pos_type|{position_type}|pos_type|{position}&utm_term={keyword}&pm_source_type={source_type}&pm_block={position_type}&pm_position_type={position_type}&pm_position={position}$pm_keyword={keyword}&pm_source={source}&pm_campaign_id={campaign_id}&pm_ad_id={ad_id}&pmphrase_id={phrase_id}&mcpa=context&marketing=direct_{campaign_id}&roistat=direct1_{source_type}_{banner_id}_{keyword}&roistat_referrer={source}&roistat_pos={position_type}_{position}"},null,{"$f":"IF(O3<>\"\",O3,\"\")&IF(R3<>\"\",\"||\"&R3,\"\")&IF(U3<>\"\",\"||\"&U3,\"\")&IF(X3<>\"\",\"||\"&X3,\"\")","v":"Есплатно||Удобно"},{"$f":"IF(Q3<>\"\",Q3,\"\")&IF(T3<>\"\",\"||\"&T3,\"\")&IF(W3<>\"\",\"||\"&W3,\"\")&IF(Z3<>\"\",\"||\"&Z3,\"\")","v":"?utm_source=yandex&utm_medium=cpc&utm_campaign=cid|{campaign_id}|phrase_id|{phrase_id}|keyword|{keyword}&utm_content=gid|{gbid}|pos_type|{position_type}|pos_type|{position}&utm_term={keyword}&pm_source_type={source_type}&pm_block={position_type}&pm_position_type={position_type}&pm_position={position}$pm_keyword={keyword}&pm_source={source}&pm_campaign_id={campaign_id}&pm_ad_id={ad_id}&pmphrase_id={phrase_id}&mcpa=context&marketing=direct_{campaign_id}&roistat=direct1_{source_type}_{banner_id}_{keyword}&roistat_referrer={source}&roistat_pos={position_type}_{position}||?utm_source=yandex&utm_medium=cpc&utm_campaign=cid|{campaign_id}|phrase_id|{phrase_id}|keyword|{keyword}&utm_content=gid|{gbid}|pos_type|{position_type}|pos_type|{position}&utm_term={keyword}&pm_source_type={source_type}&pm_block={position_type}&pm_position_type={position_type}&pm_position={position}$pm_keyword={keyword}&pm_source={source}&pm_campaign_id={campaign_id}&pm_ad_id={ad_id}&pmphrase_id={phrase_id}&mcpa=context&marketing=direct_{campaign_id}&roistat=direct1_{source_type}_{banner_id}_{keyword}&roistat_referrer={source}&roistat_pos={position_type}_{position}||?utm_source=yandex&utm_medium=cpc&utm_campaign=cid|{campaign_id}|phrase_id|{phrase_id}|keyword|{keyword}&utm_content=gid|{gbid}|pos_type|{position_type}|pos_type|{position}&utm_term={keyword}&pm_source_type={source_type}&pm_block={position_type}&pm_position_type={position_type}&pm_position={position}$pm_keyword={keyword}&pm_source={source}&pm_campaign_id={campaign_id}&pm_ad_id={ad_id}&pmphrase_id={phrase_id}&mcpa=context&marketing=direct_{campaign_id}&roistat=direct1_{source_type}_{banner_id}_{keyword}&roistat_referrer={source}&roistat_pos={position_type}_{position}||?utm_source=yandex&utm_medium=cpc&utm_campaign=cid|{campaign_id}|phrase_id|{phrase_id}|keyword|{keyword}&utm_content=gid|{gbid}|pos_type|{position_type}|pos_type|{position}&utm_term={keyword}&pm_source_type={source_type}&pm_block={position_type}&pm_position_type={position_type}&pm_position={position}$pm_keyword={keyword}&pm_source={source}&pm_campaign_id={campaign_id}&pm_ad_id={ad_id}&pmphrase_id={phrase_id}&mcpa=context&marketing=direct_{campaign_id}&roistat=direct1_{source_type}_{banner_id}_{keyword}&roistat_referrer={source}&roistat_pos={position_type}_{position}"},"Официальная гарантия||Оригинальные бренды||Работаем более 16 лет"]
[2,"магазин   часов",{"$f":"TRIM(UPPER(MID(B4,1,1))&MID(B4,2,LEN(B4)-1))","v":"Магазин часов"},"магазин часов","Магазин часов!","hjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhjk",null,"Hjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhjk!",{"$f":"LEN(E4&F4)","v":52},"http://www.site.ru/watch/",{"$f":"CONCATENATE(J4,K$1)","v":"http://www.site.ru/watch/?utm_source=yandex&utm_medium=cpc&utm_campaign=cid|{campaign_id}|phrase_id|{phrase_id}|keyword|{keyword}&utm_content=gid|{gbid}|pos_type|{position_type}|pos_type|{position}&utm_term={keyword}&pm_source_type={source_type}&pm_block={position_type}&pm_position_type={position_type}&pm_position={position}$pm_keyword={keyword}&pm_source={source}&pm_campaign_id={campaign_id}&pm_ad_id={ad_id}&pmphrase_id={phrase_id}&mcpa=context&marketing=direct_{campaign_id}&roistat=direct1_{source_type}_{banner_id}_{keyword}&roistat_referrer={source}&roistat_pos={position_type}_{position}"},{"$f":"LOWER(B4)","v":"магазин   часов"},0.5,0.5]
[3,"  наручные Часы","наручные Часы","наручные Часы","Наручные часы!","hjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhjk",null,"Hjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhjk!",52,null,null,"  наручные часы"]
[4,"женские часы","Женские часы","женские часы -москва -розовые","Женские часы!","hjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhjk",null,"Hjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhjk!",null,null,null,"женские часы"]
[5,"мужские часы","Мужские часы","мужские часы","Мужские часы!","hjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhjk",null,"Hjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhjk!",null,null,null,"мужские часы"]
[6,"женские часы москва","Женские часы москва","женские часы москва -купить","Женские часы москва!",null,null,"!"]
[7,"женские часы москва купить","Женские часы москва купить","женские часы москва купить -розовые","Женские часы москва купить!",null,null,"!"]
[8,"женские часы розовые",{"$f":"TRIM(UPPER(MID(B10,1,1))&MID(B10,2,LEN(B10)-1))","v":"Женские часы розовые"},"женские часы розовые",{"$f":"REPLACE(LOWER(C10),1,1,LEFT(PROPER(C10)))&\"!\"","v":"Женские часы розовые!"},null,null,{"$f":"REPLACE(LOWER(F10),1,1,LEFT(PROPER(F10)))&\"!\"","v":"!"}]
[9,"купить часы в Москве",{"$f":"TRIM(UPPER(MID(B11,1,1))&MID(B11,2,LEN(B11)-1))","v":"Купить часы в Москве"},"женские часы розовые",{"$f":"REPLACE(LOWER(C11),1,1,LEFT(PROPER(C11)))&\"!\"","v":"Купить часы в москве!"},null,null,"!"]
[10,"купить часы в Туле",{"$f":"TRIM(UPPER(MID(B12,1,1))&MID(B12,2,LEN(B12)-1))","v":"Купить часы в Туле"},"женские часы розовые","Купить часы в туле!",null,null,{"$f":"REPLACE(LOWER(F12),1,1,LEFT(PROPER(F12)))&\"!\"","v":"!"}]
[11,"купить часы в Москве папе","Купить часы в Москве папе","женские часы розовые","Купить часы в москве папе!",null,null,"!"]
[12,"магазин часов в Москве",{"$f":"TRIM(UPPER(MID(B14,1,1))&MID(B14,2,LEN(B14)-1))","v":"Магазин часов в Москве"},"женские часы москва купить -розовые",{"$f":"REPLACE(LOWER(C14),1,1,LEFT(PROPER(C14)))&\"!\"","v":"Магазин часов в москве!"},null,null,{"$f":"REPLACE(LOWER(F14),1,1,LEFT(PROPER(F14)))&\"!\"","v":"!"}]
[13,"магазин часов в Туле",{"$f":"TRIM(UPPER(MID(B15,1,1))&MID(B15,2,LEN(B15)-1))","v":"Магазин часов в Туле"},"женские часы розовые",{"$f":"REPLACE(LOWER(C15),1,1,LEFT(PROPER(C15)))&\"!\"","v":"Магазин часов в туле!"},null,null,{"$f":"REPLACE(LOWER(F15),1,1,LEFT(PROPER(F15)))&\"!\"","v":"!"}]
[14,"магазин часов в Москве папе",{"$f":"TRIM(UPPER(MID(B16,1,1))&MID(B16,2,LEN(B16)-1))","v":"Магазин часов в Москве папе"},null,{"$f":"REPLACE(LOWER(C16),1,1,LEFT(PROPER(C16)))&\"!\"","v":"Магазин часов в москве папе!"},null,null,{"$f":"REPLACE(LOWER(F16),1,1,LEFT(PROPER(F16)))&\"!\"","v":"!"}]
[null,null,null,null,null,null,null,{"$f":"F17&G17","v":""}]
[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,""]

{"sheet":"Adwords New","index":1,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["Campaign","Ad group","Headline","Description 1","Description 2","Display URL","Final URL",null,"Campaign","Ad group","Keyword","Match Type"]
[null,{"$f":"[1]!ТРАНСЛИТ('Заготовка New'!C3)","v":{"$error":"#NAME?"}},{"$f":"'Заготовка New'!E3","v":"Купить часы!"},{"$f":"'Заготовка New'!F3","v":"hjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhkjhjk"},{"$f":"'Заготовка New'!G3","v":0},{"$f":"'Заготовка New'!J3","v":"http://www.site.ru/watch/?"},null,null,{"$f":"A3","v":0},{"$f":"B3","v":{"$error":"#NAME?"}},{"$f":"\"+\"&SUBSTITUTE('Заготовка New'!D3,\" \",\" +\")","v":"+купить +часы"}]

{"sheet":"Список Плюс-слов","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Доп слова","Города","Кому","Повод"]
["купить","в Москве","папе","на юбилей"]
["заказать","в Туле","маме","день рождения"]
["фото",null,"парню","др"]
["цена",null,"девушке","8 марта"]
["стоимость",null,"женщине","23 февраля"]
["скидки",null,"коллеге"]
["дешево",null,"любимому"]
["распродажа",null,"любимой"]
["недорого",null,"для парня"]
[null,null,"для девушки"]
[null,null,"для женщины"]
[null,null,"для коллеги"]