[{"@context":"https:\/\/schema.org\/","@type":"Article","@id":"https:\/\/www.id2.cz\/e-komercni-firmy-sledujte-efektivitu-nakladu-s-google-ads-script\/#Article","mainEntityOfPage":"https:\/\/www.id2.cz\/e-komercni-firmy-sledujte-efektivitu-nakladu-s-google-ads-script\/","headline":"E-komer\u010dn\u00ed firmy: Sledujte efektivitu n\u00e1klad\u016f s Google Ads Script","name":"E-komer\u010dn\u00ed firmy: Sledujte efektivitu n\u00e1klad\u016f s Google Ads Script","description":"Ur\u010dit\u011b nemus\u00edm \u0159\u00edkat, \u017ee sledov\u00e1n\u00ed ROAS je naprosto kritick\u00e9 pro e-komer\u010dn\u00ed firmy, kter\u00e9 pou\u017e\u00edvaj\u00ed Google Ads, nebo\u0165 je tohle zp\u016fsob, jak\u00fdm v\u011bt\u0161ina z\u00a0nich sleduje ziskovost jejich vlastn\u00edch kampan\u00ed. \u00a0 I kdy\u017e Google poskytuje p\u0159esn\u00e1 \u010d\u00edsla pro ROAS, je velice t\u011b\u017ek\u00e9 vid\u011bt zdrav\u00ed va\u0161eho \u00fa\u010dtu na \u00farovni kl\u00ed\u010dov\u00fdch slov a identifikovat tak rychl\u00e9 v\u00fdhry. \u00a0 \u010cten\u00e1\u0159","datePublished":"2020-02-18","dateModified":"2020-02-18","author":{"@type":"Person","@id":"https:\/\/www.id2.cz\/author\/#Person","name":"","url":"https:\/\/www.id2.cz\/author\/","identifier":1,"image":{"@type":"ImageObject","@id":"https:\/\/secure.gravatar.com\/avatar\/4e6a74466e4227c12d5306875d08720cdfce3572213740db6f4a2e5e46e710ff?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4e6a74466e4227c12d5306875d08720cdfce3572213740db6f4a2e5e46e710ff?s=96&d=mm&r=g","height":96,"width":96}},"publisher":{"@type":"Organization","name":"id2.cz","logo":{"@type":"ImageObject","@id":"\/logo.png","url":"\/logo.png","width":600,"height":60}},"url":"https:\/\/www.id2.cz\/e-komercni-firmy-sledujte-efektivitu-nakladu-s-google-ads-script\/","wordCount":456,"articleBody":"Ur\u010dit\u011b nemus\u00edm \u0159\u00edkat, \u017ee sledov\u00e1n\u00ed ROAS je naprosto kritick\u00e9 pro e-komer\u010dn\u00ed firmy, kter\u00e9 pou\u017e\u00edvaj\u00ed Google Ads, nebo\u0165 je tohle zp\u016fsob, jak\u00fdm v\u011bt\u0161ina z\u00a0nich sleduje ziskovost jejich vlastn\u00edch kampan\u00ed.\u00a0I kdy\u017e Google poskytuje p\u0159esn\u00e1 \u010d\u00edsla pro ROAS, je velice t\u011b\u017ek\u00e9 vid\u011bt zdrav\u00ed va\u0161eho \u00fa\u010dtu na \u00farovni kl\u00ed\u010dov\u00fdch slov a identifikovat tak rychl\u00e9 v\u00fdhry.\u00a0\u010cten\u00e1\u0159 mi ned\u00e1vno napsal velice chytr\u00fd zp\u016fsob, jak tohle ud\u011blat, za pou\u017eit\u00ed tabulkov\u00fdch graf\u016f, kter\u00e9 pomohou vizualizovat ROAS v\u00fdkon kl\u00ed\u010dov\u00fdch slov nap\u0159\u00ed\u010d cel\u00fdm \u00fa\u010dtem t\u00fdden po t\u00fddnu.\u00a0Av\u0161ak oni to st\u00e1le d\u011blali manu\u00e1ln\u011b v\u00a0Excelu.\u00a0Tak\u017ee v\u00fdvoj\u00e1\u0159i m\u00e9ho zam\u011bstnavatele navrhli tento Google Ads skript k\u00a0automatizaci tohoto procesu a vytvo\u0159ili tak vizu\u00e1ln\u00ed reprezentaci, kter\u00e1 ukazovala v\u00fdkon na \u00farovni kl\u00ed\u010dov\u00fdch slov.\u00a0\tJak tento skript vlastn\u011b funguje?\t\u00a0\tSkript stahuje v\u0161echna kl\u00ed\u010dov\u00e1 slova va\u0161eho \u00fa\u010dtu a jejich ur\u010dit\u00e9 ROAS.\t\u00a0\tPot\u00e9 vezme tato data a p\u0159evede je do dvou tabulek, kter\u00e9 v\u00e1m dovol\u00ed nejprve vizualizovat procento kl\u00ed\u010dov\u00fdch slov, kter\u00e9 maj\u00ed specifick\u00e9 ROAS a zadruh\u00e9 v\u00e1m dovol\u00ed porovnat jednotliv\u00e9 kl\u00ed\u010dov\u00e9 slova t\u00fdden po t\u00fddnu, abyste tak mohli vid\u011bt, jestli se va\u0161e ROAS zlep\u0161uje nap\u0159\u00ed\u010d cel\u00fdm \u00fa\u010dtem.\t\u00a0\tV\u00a0r\u00e1mci skriptu m\u016f\u017eete definovat va\u0161e ROAS skupiny. Prvn\u00ed graf v\u00e1m pot\u00e9 uk\u00e1\u017ee po\u010det kl\u00ed\u010dov\u00fdch slov v\u00a0t\u00e9to skupin\u011b, jako nap\u0159\u00edklad je to uvedeno n\u00ed\u017ee v\u00a0grafu.\t\u00a0\tDruh\u00fd graf v\u00e1m uk\u00e1\u017ee po\u010det kl\u00ed\u010dov\u00fdch slov v\u00a0odli\u0161n\u00fdch ROAS skupin\u00e1ch, av\u0161ak tentokr\u00e1t je to v\u0161e zv\u00e1\u017eeno tak\u00e9 n\u00e1klady, aby v\u00e1m tento graf dal daleko v\u00edce re\u00e1ln\u011bj\u0161\u00ed pohled na to, co se pr\u00e1v\u011b d\u011bje.\t\u00a0\tNastavov\u00e1n\u00ed skriptu\t\u00a0\tJe\u0161t\u011b p\u0159edt\u00edm, ne\u017e dan\u00fd skript pust\u00edte, pravd\u011bpodobn\u011b budete pot\u0159ebovat zm\u011bnit n\u00e1sleduj\u00edc\u00ed nastaven\u00ed:\t\u00a0\tNastavte va\u0161e prahy ROAS. Obecn\u011b navrhujeme, abyste tohle u\u010dinili v\u00a0r\u00e1mci stovek (sto, dv\u011b st\u011b, t\u0159i sta). Tyto prahy by m\u011bly b\u00fdt definov\u00e1ny na sedmn\u00e1ct\u00e9m \u0159\u00e1dku skriptu, mezi jednotliv\u00fdmi z\u00e1vorkami. Ka\u017ed\u00e1 stovka by m\u011bla b\u00fdt odd\u011blena tak\u00e9 \u010d\u00e1rkou.\t\u00a0\tJd\u011bte tedy do Google Sheets a vytvo\u0159te nov\u00fd dokument. Zkop\u00edrujte URL adresu tohoto dokumentu a pot\u00e9 jej nakop\u00edrujte do \u0159\u00e1dku dvacet jedna skriptu mezi otazn\u00edky.\t\u00a0\tA kone\u010dn\u011b, pot\u0159ebujete nastavit lookback ok\u00e9nko na \u0159\u00e1dku dvacet \u010dty\u0159i. Tohle je \u010dasov\u00fd \u00fasek, ze kter\u00e9ho bude skript br\u00e1t data.\t\u00a0                                                                                                                                                                                                                                                                                                                                                                                                "},{"@context":"https:\/\/schema.org\/","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"E-komer\u010dn\u00ed firmy: Sledujte efektivitu n\u00e1klad\u016f s Google Ads Script","item":"https:\/\/www.id2.cz\/e-komercni-firmy-sledujte-efektivitu-nakladu-s-google-ads-script\/#breadcrumbitem"}]}]