Faʻasalalauga TekonolosiSuʻesuʻega & SuʻegaMaketi aanoCRM ma Faʻamaumauga tulagaEcommerce ma FaleoloaEmail Maketi & OtometiMeafaigaluega MaketigaA'oa'oga Fa'atau ma MaketiFaʻatauga FaʻatauSaili MaketiFa'asalalauga Fa'aagafesootai & Fa'aosoina Maketi

Google Pepa: Fa'asoa Fa'atasi ma Fa'atauga Fa'asalalau Fa'atasi ma Fa'amaumauga Tu'ufa'atasi

O lo'o matou fa'aogaina pea laupepa!

O se mea lea e masani ona ou faalogo ai i kamupani e matamuli i le leai o se poto faatekonolosi a latou kamupani. Afai o le faatauina atu ma maketi moni leverage le malosi atoatoa o Google Sheets, e ui i lea, atonu latou te matuā mitamita i lo latou atamai.

Google Sheets ose mea faigaluega sili ona lelei mo fa'atauga ma maketi maketi, ofoina atu auala eseese e fa'aleleia atili ai le galulue fa'atasi ma fa'afaigofie galuega. O auala nei e sefulu e mafai ai e au 'au ona fa'aoga Google Sheets:

  • Galulue Fa'atasi: E mafai e tagata o le 'au ona galulue i luga o le pepa e tasi i le taimi e tasi, e mafai ai ona faʻafouina taimi moni ma galulue faʻatasi.
  • Faʻamaumauga tuʻufaʻatasia: Tuʻufaʻatasia o fua faʻatatau mai faʻasalalauga eseese i se tasi nofoaga tutotonu, faʻatagaina se vaʻaiga autasi o taumafaiga tau maketi.
  • Fa'asologa o Galuega: Fausia dashboards ma kalafi ma siata e faʻaalia ai faʻamatalaga tau maketi ma faiga.
  • Su'ega o le Tala o le Tupe: Mata'ituina o paketi ma le fa'aaluina i taimi tonu e pulea lelei ai tupe ma faia ai faaiuga taugofie.
  • Pulega o Poloketi: Fa'aaogā pepa e siaki ai fa'asologa o taimi, fa'asoa, ma vaega fa'atatau e fa'amautinoa ai o lo'o fa'atulaga fa'apolopolo.
  • Puleaina o Fa'asalalauga: Tausia faʻamau i luga o faʻasalalauga faʻatau, tufatufaina atu fa'asalalauga URL, ma i'uga o na fa'asalalauga.
  • Kalena i totonu: Fa'atulagaina o fuafuaga o mataupu e ala i le fa'atulagaina o pou, siaki aso fa'asalalau, ma le fa'amaopoopoina o mea i luga o fa'avae.
  • Su'ega Su'ega A/B: Faamauina faamatalaga ma taunuuga o A / B suʻega e fuafua ai fuafuaga tau maketi sili ona aoga.
  • Tagata Faʻafesoʻotaʻi Faʻatonutonu Pulega (CRM): Puleaina o faʻamaumauga a tagata faʻatau, fegalegaleaiga, ma tulitatao e faʻaleleia ai le va o tagata faʻatau ma le taofiofia.
  • Aoina o Manatu ma Iloiloga: Fa'apotopoto ma au'ili'ili fa'amatalaga a tagata fa'atau e ala i fomu e feso'ota'i sa'o ile Google Sheet e fa'ailoa ai fuafuaga ma le atina'eina o oloa.

O le autu i le tele o nei galuega e le o le gaioiga masani a tagata faʻaoga e lafo ai se laulau faʻamaumauga i Google Sheets ona amata loa lea ona galue i ai ... o le mafai lea e tuʻufaʻatasia faʻamaumauga e otometi ona faʻafouina pe faʻaulufale mai e ala i le tele o filifiliga.

Google Sheets Fa'atasiga Fa'amaumauga

Tele fa'alāpotopotoga latou te le'i va'aia le mamana o fa'amatalaga e maua ai fa'amatalaga o lo'o maua i totonu o Google Sheets. I tua atu o le faʻaogaina o faʻasalalauga faʻatasi, Google Sheets e ofoina atu le tele o meafaigaluega e le faʻaaogaina, pei ole IMPORT fua fa'atatau mo le su'eina o fa'amatalaga mai fafo, Google Apps Script mo le otometi ma fa'alautele galuega, ma le AppSheet mo le fa'atupuina o polokalame fa'amalosi e fa'atatau i fa'amaumauga o ripoti.

E le gata i lea, o macros e faamaumauina ma otometi galuega fai soo, ae o faʻaopoopoga faʻaopoopoga e faʻalauteleina ai le gafatia o le tulaga. O nei mea faigaluega e mafai ai e pisinisi ona faʻaogaina faʻamaumauga i taimi moni mo le faʻamalamalamaina o filifiliga ma tali vave i suiga o maketi.

Galuega Fa'aulufale i totonu

Ina ia tuʻufaʻatasia Google Sheets ma faʻamatalaga mai fafo poʻo API, e mafai ona e faʻaogaina galuega faʻapipiʻi Google Sheets pei o IMPORTDATA, IMPORTFEED, IMPORTHTML, ma IMPORTXML. O nei galuega e mafai ai e oe ona fa'aulufale mai fa'amatalaga mai ituaiga fa'amaumauga fa'atulagaina i lau Google Sheet, e aofia ai CSV, RSS, HTML, ma XML. O se fa'amatalaga auiliili lea mo vaega ta'itasi IMPORT galuega i Google Sheets:

  • FA'AMATALAGA: Fa'aulufale mai fa'amaumauga i se URL ile .csv po'o le .tsv fa'atulagaina. Fa'asalalauina fa'amaumauga i luga o le tele o sela, amata i le sela e te ulufale ai i le fua fa'atatau ma fa'alautele i lalo ma fa'asaga atu pe a mana'omia e fetaui ma laina ma koluma o le faila fa'amaumauga. E gata i le 50 IMPORTDATA vala'au i le laupepa ma le URL e tatau ona avea ma feso'ota'iga sa'o i se faila .csv po'o le .tsv. Faataitaiga:
=IMPORTDATA("https://example.com/data.csv")
  • FA'AMATALAGA: Fa'aulufaleina mai se fafaga RSS po'o ATOM lautele. O le mea lea e faaulufale mai ai le fafaga ma faasalalau atu i le tele o sela, faatasi ai ma filifiliga e faʻamaonia ai faʻamatalaga fafaga e toe aumai ma pe fia mea e faʻaalia. E fa'atapula'a lea i fafaga e le mana'omia le fa'amaoni, ma o le fausaga o le fafaga e a'afia ai le fa'aalia o fa'amaumauga.
=IMPORTFEED("http://example.com/feed", "items title", TRUE, 5)
  • IMPORTHTML: Fa'aulufale mai fa'amatalaga mai se laulau po'o se lisi i totonu o se itulau HTML. E maua mai ai le laulau po'o le lisi fa'apitoa mai le anotusi HTML ma tu'u i totonu o sela fetaui e amata mai i le mea e tu'u ai le fua. E aoga lenei mea i URL avanoa lautele; mana'omia le faasinoupu sa'o o le laulau po'o le lisi; faatapulaa i laulau or lisi fesili
=IMPORTHTML("http://example.com", "table", 1)
  • IMPORTXML: Fa'aulufale mai fa'amaumauga mai so'o se XML, HTML, po'o XHTML fa'aoga anotusi XPath fesili. E fa'avasegaina fa'amaumauga e fa'aaoga ai le XPath ua tu'uina atu ma fa'aulufale mai mea i totonu o le ripoti, fa'alautele mai le cell formula agai i lalo ma taumatau. E mana'omia le malamalama ile XPath ole gagana fesili; E tatau ona avanoa fa'alaua'itele le URL ma fa'atulaga lelei ile XML/HTML/XHTML.
=IMPORTXML("http://example.com/data", "//div[@class='example']")

taʻitasi IMPORT e fa'atatau tonu le galuega mo ituaiga fa'amatalaga ma puna'oa eseese, ma e iai uma i latou le avanoa e fa'aliliuina ai le Google Sheets i se meafaigaluega mamana mo le aoina ma le fa'atulagaina o fa'amatalaga mai le upega tafa'ilagi. O nei galuega e sili ona aoga mo gaioiga tau maketi e pei o suʻesuʻega faʻatauvaʻa, suʻesuʻega maketi, ma suʻesuʻega faʻatinoga o faʻasalalauga, lea e taua tele ai faʻamatalaga i fafo i le faia o filifiliga.

Google Apps Script

E mafai ona e tusia galuega fa'ale-aganu'u ile Google Apps Script e toso mai ai fa'amaumauga mai nofoaga po'o API mana'omia le fa'amaoni po'o le fa'alavelave fa'alavelave. O lenei gagana fa'avae JavaScript e mafai ona fegalegaleai ma isi au'aunaga a Google ma API i fafo e aumai ma lafo fa'amaumauga pe a mana'omia. O se auala masani e amata tu'ufa'atasia ai fa'amatalaga ola mai se API i Google Sheets e fa'apea:

  1. faaaoga Apps Script e tatala ai se fa'atonu tusitusiga fou ile Google Sheets.
  2. Tusi se galuega fa'asologa masani e vala'au ai le API mana'omia e fa'aaoga ai le URLFetchApp auaunaga.
  3. Fa'avasega le tali API ma seti fa'amatalaga talafeagai i lau Google Sheet fa'aaoga le setValues auala mo mea'ai lautele.

O lenei metotia e mafai ai mo le faʻaogaina o faʻamatalaga faʻaulufaleina mai, ma faʻatasi ai ma faʻaoso, e mafai ona e seti taimi mo faʻamaumauga e toe faʻafouina otometi. Mo se faʻataʻitaʻiga, o le auala lenei e mafai ai ona e talosagaina le URL Rank e faʻaaoga ai le SEMrush:

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"]];
  }
}

A mae'a ona fa'asaoina lenei fa'asologa o fa'asologa, e mafai ona e fa'aogaina le getUrlRankHistory galue i lau laupepa e pei o lenei:

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

Google Pepa Fa'aopoopo Fa'aopoopo

Google Sheets add-ons o isi vaega fa'apipi'i po'o fa'aopoopoga e mafai ona fa'apipi'i e fa'aopoopo ai galuega a Google Sheets. O nei faʻaopoopoga e tuʻuina atu ai faʻaopoopoga faʻapitoa e pei o suʻesuʻega faʻamatalaga faʻapitoa, mea faigaluega faʻatautaia galuega, faʻaogaina otometi, ma faʻatasi ma isi polokalama ma auaunaga.

O nisi nei o Google Sheets fa'aopoopo fa'aopoopo e mafai ona fa'apitoa mo tagata fa'atau ma maketi fa'apolofesa:

  1. IMPORTFROMWEB: O le ImportFromWeb fa'aopoopo e fa'aogaina se seti o tulafono ma tagata filifilia e tu'uina atu e le tagata fa'aoga e su'e fa'amaumauga mai le anotusi HTML o itulau uepi.
  2. Supermetrics: Supermetrics o se meafaigaluega mamana mo le tosoina o faʻamatalaga mai punaoa eseese pei Analytics Google, Facebook, X, LinkedIn, ma SEMrush i Google Sheets mo lipoti ma au'ili'iliga.
  3. E iai foi leisi meli tuʻufaʻatasia (YAMM): YAMM e aoga mo le lafoina o fa'asalalauga imeli fa'apitoa e fa'aoga ai Gmail ma su'e sa'o i'uga ile Google Sheets.
  4. Zapier: Zapier fa'atagaina oe e fa'afeso'ota'i le Google Sheets i le silia ma le afe isi 'au'aunaga i luga ole laiga e fa'autometi ai galuega. Mo se fa'ata'ita'iga, e mafai ona otometi ona e fa'asaoina mea fa'apipi'i imeli ile Google Sheets po'o fa'amaumauga o fa'atauga e ta'i sa'o mai a CRM.
  5. tulimanu: tulimanu fa'atagaina oe e su'e tuatusi imeli e feso'ota'i ma se 'upega tafa'ilagi ma fa'atulaga i totonu o se ripoti, lea e fesoasoani mo le fa'atupuina o le ta'ita'i ma le fa'alatalata atu.
  6. Fomu Miula: Fomu Miula fesoasoani fa'aopoopo fa'a-memeli imeli e lafo feso'ota'iga imeli e fa'atatau i fa'amaumauga i au ripoti. E manaia tele mo imeli tulitatao pe a uma se mea na tupu poʻo se telefoni faʻatau.
  7. DocuSign: O le DocuSign eSignature fa'aopoopo mo Google Sheets e mafai ai ona lafo ma saini pepa sa'o mai Google Sheets, fa'afaigofieina le fa'agasologa o konekarate mo 'au fa'atau.

O nei fa'aopoopo fa'aopoopo e fa'alautele ai le agava'a o Google Sheets i tua atu o fa'amaumauga faigofie, fa'atagaina au fa'atau ma maketi e fa'atino galuega sa'o lelei mai a latou ripoti. I le fa'aogaina o nei mea faigaluega, e mafai ai e 'au ona fa'autometi le aoina ma le lipotia o fa'amaumauga, fa'atautaia fa'asalalauga imeli, fa'afaigofie le a'apa atu, ma fa'atautaia le sainia o pepa, o mea uma ia e mafai ona fa'asaoina le taimi ma fa'aleleia le gaosiga.

Google AppSheet

Google AppSheet o se fa'avae e mafai ai e tagata fa'aoga ona fa'atupuina ni talosaga fe'avea'i mai fa'amaumauga i Google Sheets e aunoa ma le tusiaina o se code. Ose fa'avae fa'atupuina e leai ni fa'ailoga e mafai ona fa'aliliuina fa'amaumauga o lo'o teuina i totonu o fa'asalalauga e avea ma fa'aoga fa'apitoa. O le faʻaogaina faʻaogaina o le AppSheet e mafai ai ona faʻaopoopoina foliga e pei o faʻafanua, fomu, siata, ma isi mea. Ua mamanuina ina ia mafai ona maua e soʻo se tasi e iai faʻamatalaga latou te manaʻo e faʻatulagaina ma tuʻuina atu i se faʻasologa o polokalama, faʻaleleia le gaosiga ma faʻafaigofie le faʻaogaina o faʻamaumauga.

Fa'atasi ai ma le AppSheet, e mafai ona e fa'autometi fa'agasolo galuega pe fa'aliliu au fa'amatalaga i luga o upega tafa'ilagi ma telefoni feavea'i, uma mai fa'amaumauga e te pulea ile Google Sheets. E aoga mo pisinisi ma tagata taʻitoʻatasi o loʻo manaʻomia ni tusi faʻapitoa mo faʻamaumauga, faʻatonuga o galuega, poʻo le faʻatulagaina o mea e fai ae leai ni punaoa e atiaʻe ai polokalama masani.

Douglas Karr

Douglas Karr o CMO o OpenINSIGHTS ma le na faavaeina le Martech Zone. Ua fesoasoani Douglas i le tele o amataga manuia o MarTech, ua fesoasoani i le filiga tatau o le sili atu i le $ 5 piliona i le mauaina o le Martech ma tupe teufaafaigaluega, ma o loʻo faʻaauau pea ona fesoasoani i kamupani i le faʻatinoina ma le otometi a latou faʻatauga ma maketi. Douglas ose suiga fa'atekinolosi fa'avaomalo fa'avaomalo ma MarTech fa'apitoa ma failauga. O Douglas foi o se tusitala lolomi o le Dummie's guide ma se tusi taʻitaʻi pisinisi.

Faatatau Mataupu Faavae o

Toe i le pito i luga
lata

Ua maua le Adblock

Martech Zone e mafai ona tu'uina atu ia te oe lenei 'anotusi e aunoa ma se tau aua matou te fa'atupeina la matou 'upega tafa'ilagi e ala i tupe maua fa'asalalauga, so'oga fa'atasi, ma lagolago. Matou te fa'afetai pe a e aveese lau fa'asalalauga fa'asalalau a'o e va'ai i la matou saite.