Kutsatsa UkadauloKusanthula & KuyesaMarketing okhutiraCRM ndi Data PlatformZamalonda ndi ZogulitsaKutsatsa kwa Imelo & ZodzichitiraZida ZamalondaMaphunziro Ogulitsa ndi KutsatsaKulimbikitsa KugulitsaFufuzani MalondaSocial Media & Influencer Marketing

Google Mapepala: Zogulitsa Zogwirizana ndi Maspredishiti Otsatsa Okhala Ndi Zambiri Zanthawi Yeniyeni

Tikugwiritsabe ntchito maspredishiti!

Izi ndizomwe ndimamva nthawi zambiri kuchokera kwa makampani omwe amachita manyazi ndi kusowa kwaukadaulo kwa kampani yawo. Ngati malonda ndi kutsatsa zidathandiziradi mphamvu zonse za Masamba a Google, komabe, iwo anganyadire kwambiri ndi luso lawo.

Google Mapepala ndi chida chosinthika kwambiri pamadipatimenti ogulitsa ndi otsatsa, opereka njira zosiyanasiyana zolimbikitsira mgwirizano ndikuwongolera kayendetsedwe ka ntchito. Nazi njira khumi zomwe magulu anu angagwiritsire ntchito Google Sheets:

  • Kugwirizana Kwanthawi Yeniyeni: Mamembala amagulu amatha kugwira ntchito papepala lomwelo nthawi imodzi, kulola zosintha zenizeni ndi mgwirizano.
  • Kuphatikiza Kwazinthu: Kupanga ma metrics kuchokera kumakampeni osiyanasiyana pamalo amodzi, zomwe zimathandizira kuwona kogwirizana pakutsatsa.
  • Mawonekedwe Dashboards: Kupanga ma dashboard okhala ndi ma graph ndi ma chart kuti awonetsere zotsatsa ndi zomwe zikuchitika.
  • Kutsata Bajeti: Kuyang'anira bajeti ndikugwiritsa ntchito munthawi yeniyeni kuti musamalire bwino ndalama ndikupanga zisankho zotsika mtengo.
  • Mayang'aniridwe antchito: Kugwiritsa ntchito mapepala kutsata nthawi ya polojekiti, zomwe zingabweretsedwe, ndi maphwando odalirika kuwonetsetsa kuti kampeni ikukonzekera.
  • Kasamalidwe ka Kampeni: Kusunga ma tabu pamakampeni otsatsa, kugawa ma URL a kampeni, ndi zotsatira za makampeni amenewo.
  • Makalendala a Zinthu: Kukonza njira zopangira zinthu pokonza zolemba, kutsatira masiku ofalitsidwa, ndikugwirizanitsa zomwe zili pamapulatifomu.
  • Kutsata Mayeso a A/B: Kulemba tsatanetsatane ndi zotsatira za Mayeso a A/B kudziwa njira zogulitsira zogwira mtima kwambiri.
  • Kusamalira Maubwenzi Amakasitomala (CRM): Kuwongolera deta yamakasitomala, kuyanjana, ndi kutsata kupititsa patsogolo ubale wamakasitomala ndi kusunga.
  • Kusonkhanitsa Ndemanga ndi Kusanthula: Sonkhanitsani ndi kusanthula mayankho amakasitomala kudzera m'mafomu olumikizidwa mwachindunji ndi Google Sheet kuti mudziwe njira ndi kakulidwe kazinthu.

Chofunika kwambiri pa ntchitoyi sizomwe zimachitika anthu ogwiritsa ntchito kutaya tebulo la data mu Google Sheets ndikuyamba kuyesetsa ... ndikutha kuphatikizira deta yomwe imasinthidwa kapena kutumizidwa kunja kudzera muzosankha zingapo.

Google Sheets Data Integrations

Mabungwe ambiri amanyalanyaza zamphamvu zopezera deta zomwe zimapezeka mu Google Sheets. Kupitilira kusavuta kwamaspredishiti ogwirizana, Google Sheets imapereka zida zingapo zomwe sizimagwiritsidwa ntchito mocheperako, monga IMPORT mafomula otha kutengera data kunja, Google Apps Script yodzipangira zokha ndi kuwonjezera magwiridwe antchito, komanso AppSheet yopangira mapulogalamu osinthika potengera data ya spreadsheet.

Kuphatikiza apo, ma macros amalemba ndikusinthiratu ntchito zobwerezabwereza, pomwe zowonjezera zimakulitsa luso la nsanja. Zida izi zimalola mabizinesi kugwiritsa ntchito nthawi yeniyeni popanga zisankho zodziwitsidwa komanso mayankho achangu pakusintha kwa msika.

Ntchito Zomanga-Mu IMPORT

Kuti muphatikize Mapepala a Google ndi magwero akunja a data kapena ma API, mutha kugwiritsa ntchito ma Google Sheets opangidwa ngati IMPORTDATA, IMPORTFEED, IMPORTHTMLndipo IMPORTXML. Ntchitozi zimakulolani kuti mulowetse deta kuchokera kumitundu yosiyanasiyana ya data mu Google Sheet yanu, kuphatikizapo CSV, RSS, HTMLndipo XML. Nawa kufotokozera mwatsatanetsatane aliyense wa IMPORT ntchito mu Google Mapepala:

  • IMPORTDATA: Imalowetsa data mu ulalo wamtundu wa .csv kapena .tsv. Imafalira ma cell angapo, kuyambira pa cell pomwe mumalowetsa fomula ndikupita pansi ndi kudutsa momwe zingafunikire kuti zigwirizane ndi mizere ndi mizere ya fayilo ya data. Imangokhala 50 IMPORTDATA mafoni pa spreadsheet ndipo ulalo uyenera kukhala ulalo wachindunji ku fayilo ya .csv kapena .tsv. Chitsanzo:
=IMPORTDATA("https://example.com/data.csv")
  • IMPORTFEED: Ikulowetsani chakudya chapagulu cha RSS kapena ATOM. Izi zimalowetsa chakudya ndikuchifalitsa m'maselo angapo, ndi zosankha zofotokozera zomwe zingapezeke ndi zinthu zingati zomwe zingasonyeze. Izi zimangokhudza ma feed omwe safuna kutsimikizika, komanso momwe ma feed amakhudzira momwe deta imawonekera.
=IMPORTFEED("http://example.com/feed", "items title", TRUE, 5)
  • IMPORTHTML: Imalowetsa data kuchokera patebulo kapena mndandanda watsamba la HTML. Izi zimatenga tebulo kapena mndandanda wazomwe zafotokozedwa mu HTML ndikuziyika m'maselo ofananira kuyambira pomwe fomula yalowetsedwa. Izi zimagwira ntchito ndi ma URL omwe amafikiridwa ndi anthu; imafuna index yolondola ya tebulo kapena mndandanda; malire ku gome or mndandanda mafunso.
=IMPORTHTML("http://example.com", "table", 1)
  • IMPORTXML: Imalowetsa data kuchokera ku XML, HTML, kapena XHTML zomwe zimagwiritsidwa ntchito XPath mafunso. Izi zimasanthula deta pogwiritsa ntchito XPath yoperekedwa ndikulowetsa zomwe zili mu spreadsheet, kufalikira kuchokera ku fomula kutsika ndi kumanja. Zimafunika kudziwa chilankhulo cha funso la XPath; Ulalo uyenera kupezeka ndi anthu onse komanso kusanjidwa bwino mu XML/HTML/XHTML.
=IMPORTXML("http://example.com/data", "//div[@class='example']")

aliyense IMPORT ntchito imapangidwira mitundu yosiyanasiyana ya data ndi magwero, ndipo onse ali ndi kuthekera kosintha Mapepala a Google kukhala chida champhamvu chosonkhanitsira ndi kukonza zambiri kuchokera pa intaneti. Ntchitozi ndizofunika kwambiri pazamalonda monga kusanthula kwa mpikisano, kafukufuku wamsika, ndi kutsatira kachitidwe ka kampeni, pomwe deta yakunja imagwira ntchito yofunika kwambiri popanga zisankho.

Google App Script

Mutha kulemba machitidwe anu mu Google Apps Script kuti mukoke deta kuchokera kumasamba kapena APIs kufuna kutsimikizika kapena kuyanjana kovutirapo. Chiyankhulo chochokera ku JavaScriptchi chimatha kulumikizana ndi masevisi ena a Google ndi ma API akunja kuti mutenge ndi kutumiza data pakufunika. Njira yoyambira kuphatikizira deta yamoyo kuchokera ku API kupita ku Google Sheets ndi motere:

  1. ntchito Apps Script kuti mutsegule chosintha chatsopano mu Google Sheets.
  2. Lembani ntchito yolemba makonda kuti muyitane API yomwe mukufuna kugwiritsa ntchito URLFetchApp utumiki.
  3. Onani mayankho a API ndikuyika data yoyenera mu Google Sheet yanu pogwiritsa ntchito setValues njira yopangira zinthu zosiyanasiyana.

Njirayi imalola kuti kulowetsedwa kwa deta, ndi zoyambitsa, mukhoza kukhazikitsa nthawi kuti deta itsitsimutse yokha. Mwachitsanzo, nayi momwe mungapemphe Ulalo wa URL pogwiritsa ntchito Srrush:

function getUrlRankHistory(url) {
  var apiKey = 'YOUR_API_KEY'; // Replace with your actual SEMrush API key.
  var database = 'us'; // Example: use 'us' for the US database.
  var apiEndPoint = 'https://api.semrush.com/';
  var requestUrl = apiEndPoint + 
                   '?type=url_rank_history&key=' + apiKey + 
                   '&display_limit=10&export_columns=Or,Ot,Oc,Ad,At,Ac,Dt&url=' + 
                   encodeURIComponent(url) + 
                   '&database=' + database;
  
  try {
    var response = UrlFetchApp.fetch(requestUrl);
    var jsonResponse = response.getContentText();
    var lines = jsonResponse.split("\n");
    var historyData = [];
  
    for (var i = 1; i < lines.length; i++) {
      if (lines[i].length > 0) {
        var columns = lines[i].split(';');
        var record = [
          columns[0], // Organic Keywords
          columns[1], // Organic Traffic
          columns[2], // Organic Cost
          columns[3], // Adwords Keywords
          columns[4], // Adwords Traffic
          columns[5], // Adwords Cost
          columns[6]  // Date
        ];
        historyData.push(record);
      }
    }

    return historyData;
  } catch (e) {
    // If an error occurs, log it and return a message.
    Logger.log(e.toString());
    return [["Error fetching data"]];
  }
}

Mukasunga script yosinthidwayi, mutha kugwiritsa ntchito getUrlRankHistory ntchito mu pepala lanu monga chonchi:

=getUrlRankHistory("https://www.example.com")

Zowonjezera Mapepala a Google

Zowonjezera za Google Sheets ndi mapulagini a chipani chachitatu kapena zowonjezera zomwe zitha kukhazikitsidwa kuti ziwonjezere magwiridwe antchito a Google Mapepala. Zowonjezera izi zimapereka zina zowonjezera monga kusanthula kwapamwamba kwa deta, zida zoyendetsera polojekiti, makina opangira ntchito, ndi kuphatikiza ndi mapulogalamu ndi mautumiki ena.

Nazi zina zowonjezera za Google Sheets zomwe zingakhale zothandiza makamaka kwa akatswiri ogulitsa ndi malonda:

  1. Malingaliro a kampani IMPORTFROMWEB: The ImportFromWeb zowonjezera zimagwiritsa ntchito malamulo ndi zosankha zomwe wogwiritsa ntchito amapereka kuti afufuze deta kuchokera ku HTML zomwe zili pamasamba.
  2. Ma supermetrics: Ma supermetrics ndi chida champhamvu kukoka deta ku magwero osiyanasiyana monga Analytics Google, Facebook, X, LinkedInndipo Srrush mu Google Mapepala kuti mupereke lipoti ndi kusanthula.
  3. Kuphatikizanso Kwina Makalata (YAMM): YAMM ndizothandiza potumiza makampeni a imelo amunthu payekha pogwiritsa ntchito Gmail ndikutsata zotsatira mwachindunji mu Google Mapepala.
  4. Zapier: Zapier amakulolani kuti mulumikize Mapepala a Google ku mawebusayiti ena opitilira chikwi kuti mugwiritse ntchito makina anu. Mwachitsanzo, mutha kungosunga zomata za imelo ku Google Sheets kapena kutsatsa malonda mwachindunji kuchokera ku a CRM.
  5. msaki: msaki amakulolani kuti mupeze ma adilesi a imelo okhudzana ndi tsamba la webusayiti ndikuwapanga kukhala spreadsheet, zomwe ndizothandiza pakupanga kutsogolera komanso kufalitsa.
  6. Fomu Mule: Fomu Mule imelo automation add-on imathandizira kutumiza mauthenga a imelo kutengera zomwe zili mumasamba anu. Ndibwino kuti muzitsatira maimelo pambuyo pa chochitika kapena foni yogulitsa.
  7. DocuSign: The DocuSign Zowonjezera za eSignature za Google Sheets zimapangitsa kuti zitheke kutumiza ndi kusaina zikalata kuchokera ku Google Sheets, kuwongolera njira zamakontrakiti amagulu ogulitsa.

Zowonjezera izi zimakulitsa luso la Google Sheets kupitilira kuyang'anira kosavuta kwa data, kulola magulu ogulitsa ndi otsatsa kuti azichita ntchito moyenera mwachindunji kuchokera pamasamba awo. Pogwiritsa ntchito zidazi, magulu amatha kusonkhanitsa deta ndi kupereka malipoti, kuyang'anira makampeni a imelo, kuwongolera zofalitsa, ndi kusaina zikalata, zonse zomwe zingapulumutse nthawi ndikuchita bwino.

Google AppSheet

Google AppSheet ndi nsanja yomwe imathandiza ogwiritsa ntchito kupanga mapulogalamu am'manja kuchokera pa data mu Google Sheets popanda kulemba khodi. Ndi nsanja yotukula yopanda ma code yomwe ingasinthe deta yosungidwa m'maspredishiti kukhala mapulogalamu olemera. Mawonekedwe mwachilengedwe a AppSheet amalola kuwonjezera zinthu monga mamapu, mafomu, ma chart, ndi zina zambiri. Lapangidwa kuti lipangitse chitukuko cha mapulogalamu kuti aliyense ali ndi data yomwe angafune kulinganiza ndikuiwonetsa mumtundu wa pulogalamu, kupititsa patsogolo zokolola komanso kuwongolera data.

Ndi AppSheet, mutha kusintha kayendedwe ka ntchito kapena kusandutsa deta yanu kukhala mapulogalamu amphamvu apa intaneti ndi mafoni, zonse kuchokera mu data yomwe mumawongolera mu Google Sheets. Ndiwothandiza kwa mabizinesi ndi anthu omwe amafunikira kugwiritsa ntchito makonda kuti alowetse deta, kasamalidwe ka ntchito, kapena kukonza zochitika koma alibe zothandizira kupanga mapulogalamu achikhalidwe.

Douglas Karr

Douglas Karr ndi CMO OpenINSIGHTS ndi woyambitsa wa Martech Zone. Douglas wathandizira oyambitsa ambiri opambana a MarTech, wathandizira kulimbikira kopitilira $ 5 bil pakugula ndi kuyika kwa Martech, ndipo akupitiliza kuthandiza makampani kukhazikitsa ndikusintha njira zawo zogulitsa ndi zotsatsa. Douglas ndi katswiri wodziwika padziko lonse lapansi wosinthira digito komanso katswiri komanso wokamba nkhani wa MarTech. Douglas ndi mlembi wofalitsidwa wa kalozera wa Dummie komanso buku la utsogoleri wabizinesi.

Nkhani

Bwererani pamwamba
Close

Adblock yapezeka

Martech Zone imatha kukupatsirani izi popanda mtengo chifukwa timapanga ndalama patsamba lathu kudzera muzotsatsa, maulalo ogwirizana, komanso kuthandizira. Tingayamikire ngati mungachotse choletsa ad mukamawona tsamba lathu.