Yakha I-Dashboard Elula Ye-Attribution Ku-Google Sheets

I-dashboard encane ye-Google Sheets iyindlela esebenzayo yamathimba amakhulu yokufakazela i-ROI ye-social ngokushesha. Awudingi i-BI exhaswa ngamashumi ezinkulungwane zamadola ukuze uthole i-attribution ethembekile, ephindaphindwayo, abathintekayo abayothemba ngempela. I-spreadsheet elula ikunika umthombo owodwa weqiniso, umkhondo olula wokuhlola, nesigqi esiphindaphindwayo sesifinyezo se-slide eyodwa seviki, abaphathi nethimba lesifunda abangasifunda ngemizuzwana engu-30. Inhloso lapha ukushesha nokucaca: letha inombolo ehlanzekile ongayivikela, hhayi imodeli ephelele ongasoze uyiqede.

Idatha ye-Mydrop, September 2026: izinombolo okufanele zifakwe ku-brief esikhundleni sokuthi "khulisa ukuzibandakanya", ezivela kokuthunyelwe ezinomlinganiselo wokuzibandakanya okubikiwe kuma-akhawunti axhunyiwe ku-Mydrop, ephethe ama-posts angu-55,000+, i-rolling 180 days.

Ipulatifomu	Isilinganiso esimaphakathi sokuzibandakanya	Ingxenye ephakathi yezingxenye eziphakathi kwe-posts
Pinterest	5.26%	0.00% kuya ku 9.09%
YouTube	3.85%	1.53% kuya ku 10.59%
Instagram	3.08%	1.06% kuya ku 6.71%
TikTok	2.98%	1.77% kuya ku 6.55%
Facebook	1.11%	0.36% kuya ku 3.14%

Ingxenye ephakathi ibonisa i-25th kuya ku-75th percentile, ngakho ingxenye yesibili yazo zonke izikhangiso ingaphakathi kwayo. Inhloso ebekwe ngaphezu kwe-75th percentile iyigoli lesikhathi esinzima, hhayi i-KPI. Funda i-Pinterest ne-YouTube njengesiqondiso. Indlela namathebula agcwele ku-Mydrop amabhentshimakhi wezokuxhumana.

Lo mhlahlandlela wenzelwe abantu abaphethe amabhrendi amaningi, izimakethe nemigudu yokugunyaza. Uthatha ukuthi ama-UTM awahlelekile, ama-akhawunti ezikhangiso mangaki, amarekhodi e-CRM awahambisani nokucofa, futhi kukhona okungenani umbuyekezi wezomthetho oqotshwa ngamacala lapho umkhankaso uqala ukuhamba. Uhlaka lwamalambu omgwaqo luvela kamuva njengendlela esheshayo yokuthi yiziphi iziteshi nemodeli ongazethemba: Okuluhlaza kuyimithombo ethembekile, Okuphuzi kuhlala kudinga ukuhlolwa ngesandla, Okubomvu kusho ukuthi idatha inomsindo futhi ayikafanele ishayele izinqumo. Uma ithimba lakho selisebenzisa i-Mydrop ekugunyazeni imikhankaso nasekuphatheni impahla, i-sheet ihlangana kahle kulolo hlelo: thumela uhlu lwemikhankaso nama-ID obuciko, bese uwamapha ku-sheet ukuze izinombolo zihambisane nalokho abantu abakugunyazile ngempela.

Qala ngenkinga yangempela yebhizinisi

Abathengisi abakhulu abaphethe amabhrendi amaningi ezifundeni baphila nokwehluleka okuthathu okuphindaphindwayo: izinombolo ezingahambisani phakathi kwamaphlathifomu, imibiko efika ngemva kokuba isikhathi sokunquma sesidlulile, nokuvuza kwe-attribution phakathi kwamadivayisi namasesheni. Iphlathifomu eyodwa ithi ukucofa okungu-2,300, enye ibonisa amasesheni angu-1,900, futhi i-CRM inama-lead angu-210 angakhombisi ukuthi umkhankaso muphi owadalile. I-Procurement ibuza ukuthi kungani inkcitho yenyuka ngenyanga edlule. Umqondisi wesifunda ufuna ukususa indawo yokukhangisa engasebenzi. Abezomthetho babuza ukuthi yiziphi ama-post abekwe amandla nokuthi ngubani ogunyazile. Akekho ongaphendula yonke imibuzo emithathu ngokuzethemba ngasikhathi sinye. Lapha kuvame ukubambeka amathimba: azama ukuvumelanisa yonke into ngesandla, bese ephetha nge-spreadsheet eqondwa ngumdali wayo kuphela.

Cabanga ngeqembu lethengisi elinamabhrendi amabili, elithenga imidiya maphakathi kodwa linamathimba e-social ahlukene. Ithimba lomhlaba wonke lithenga ukwazisa ezingeni lebhrendi, kuyilapho amathimba endawo ephusha izikhangiso ezithile zesifunda nokuqukethwe kwemvelo. Amathimba e-social endawo avame ukufaka ama-UTM ngezindlela ezihlukene: abanye basebenzisa amagama emikhankaso, abanye izinsuku, abanye bakhohlwa ngokuphelele ithegi yebhrendi. Ukukhuthaza okukhokhelwayo kuhlanekezela izilinganiso zemvelo ngezikhathi zokunyuka kwesizini, futhi i-CRM yabela ama-lead efomu yewebhu yokucofa kokugcina, ingabambi njalo i-referral ye-social. Ekupheleni kwenyanga, abezezimali bathola izinombolo ezintathu ezehlukene zokuguqulwa: ukuguqulwa kwephlathifomu yezikhangiso, ama-session-to-conversion e-GA4, nama-lead e-CRM. Ukuvumelanisa lokhu kuthatha izinsuku futhi kusashiya amathandabuzo, ngakho i-CMO ibuyela enkcitheni yenyanga edlule njengesiguquli esiyinhloko, hhayi ekusebenzeni.

Lokho kubambezeleka kulimaza ngempela: ukushintsha kwesabelomali kuhlehla ngamasonto, ukuhlolwa kwe-A/B akuphelele, futhi amathimba ebhrendi avikela iziteshi zawo esikhundleni sokubeka phambili lezo ezisusa ngempela imali engenayo. I-Google Sheet elula, ongayisebenzisa ngokushesha, ixazulula ingxenye eshesha kakhulu yaleyo nkinga: ihlanganisa ama-UTM nebhrendi, ixhuma ama-click ID ephlathifomu nama-ID e-lead ye-CRM lapho kungenzeka, futhi ikhombisa ukuthi yiziphi izinhlanganisela zesiteshi nemodeli ezinokuluhlaza/okuphuzi/okubomvu ekuthatheni izinqumo. Ngaphambi kokwakha, qamba izinqumo ezintathu ithimba okumele lizenze kuqala:

• Iyiphi imodeli ye-attribution ezosetshenziswa ngokuzenzakalelayo (i-Last touch, i-Linear, noma i-Weighted time decay).
• Yini ukhiye oyinhloko wokujoyina ekuvumelanisweni (i-conversion ID, i-session ID, noma i-CRM lead ID).
• Zizozenzakalela kangakanani izinto ezingenayo (ama-CSV ngesandla, ukudonsa nge-IMPORTDATA, noma ukungenisa nge-API yedatha yezikhangiso ne-CRM).

Lezi zinqumo ziqeda impikiswano engapheli, zikuvumele wakhe i-sheet ephindaphindwayo esikhundleni somsebenzi wokuvumelanisa ongapheli. Ukukhetha ukhiye wokujoyina oyiphutha yindlela evamile yokwehluleka: uma ukhetha i-session ID kuyilapho i-CRM yakho igcina i-lead ID kuphela, uzohlala ulahlekelwa ukufana. Ukuzenzakalela ngokweqile kuyisicupho esinye: ukudonsa yonke imibiko nge-API kuzwakala kuhle, kuze kube yilapho igama lenkambu eyodwa lishintsha ku-akhawunti eyodwa yezikhangiso bese ukungenisa kwansuku zonke kwehluleka ngokuthula. Umthetho olula uyasiza: qala ngesandla, zenzakalise kamuva. Setha imodeli ezenzakalelayo nokhiye wokujoyina kusele eliphezulu lokulungiselela, bese ukuvalela kumnikazi oyedwa ukuze amathimba ezifunda angashintshi imithetho ngephutha maphakathi nenyanga.

Khetha imodeli ehambisana nethimba lakho

Ukukhetha imodeli ye-attribution akukhulumi kangako ngezibalo, kunokufanisa umthamo, ukufinyelela kwedatha, nokuthi udinga kangakanani ukukholisa abangabaza. Yenze ilula: khetha imodeli ithimba lakho elingayichaza ngomusho owodwa kumqondisi wesifunda ongabazayo, futhi layivikele ngemizuzu emihlanu ku-finance. Izinketho ezintathu ezilula ngezansi zisebenza kumathimba amakhulu afuna ukushesha kunokuphelela. Sebenzisa uhlaka lwamalambu omgwaqo ukulinganisa ukuthi ifanele kangakanani: Okuluhlaza = selungile, Okuphuzi = kungasebenza uma kulungiswa, Okubomvu = gwema njengamanje.

I-Last touch (Okuluhlaza uma ufuna ukusebenza ngokushesha, Okuphuzi uma udinga imininingwane eminingi). Lokhu kunikeza ukuguqulwa ekucofeni noma ekuxhumaneni kokugcina ngaphambi kokuguqulwa. Kulula ukuhlola futhi kulula ukukhombisa emhlanganweni ngoba izibalo ziyabonakala. Umthetho wokunquma: uma unamathimba amancane okubika, ukuhlanganiswa okulinganiselwe kwe-CRM, noma abathintekayo abafuna isilinganiso esisodwa esivikelekayo, sebenzisa i-last touch. Izindlela zokwehluleka: ayinaki ukutholwa kokuqala nezindlela zamadivayisi amaningi, futhi ukukhuthaza okukhokhelwayo okukhuphula ukucofa kokugcina kuzodukisa amathimba. Isixazululo: hlanganisa i-last touch nesilinganiso se-"assist rate" esikhombisa iziteshi ezisiza ukuguqulwa nakuba zingakuqedi.

I-Linear attribution (Okuphuzi: ilinganiselwe, kodwa idinga ukuqina). I-Linear yehlukanisa ukubalelwa ngokulinganayo kuwo wonke amaphuzu okuthinta emgudwini wokuguqulwa. Yisebenzise uma ufuna ukulunga phakathi kweziteshi, nalapho inhlanganisela yakho yezikhangiso ihlanganisa ukuthinta okuningi okuhlelelwe ndawonye, njengemikhankaso yabathengisi bamabhrendi amaningi ehlanganisa okukhokhelwayo nokwemvelo ezifundeni. Umthetho wokunquma: khetha i-linear uma ithimba lakho lingahlanganisa ngokuthembekile amasesheni phakathi kwamadivayisi, noma uma unemicimbi ye-backend exhumanisa ukucofa nama-lead. Okungalungile: kuyaqondakala kodwa kufihla umthelela wokulandelana; kungancipha umthelela obonakalayo weziteshi zokuthinta kokugcina ezenza kahle. Izindlela zokwehluleka ziwukubala kabili lapho ukujoyina kuthambile, nokumelana kwamathimba azizwa ngathi isiteshi sawo asinikezwa ngokwanele. Isixazululo esilula ukushicilela zombili izinombolo ze-linear ne-last touch, bese uchaza umehluko usebenzisa isichazi samalambu omgwaqo.

I-Weighted time-decay (Okuphuzi noma Okubomvu kuye ngokuvuthwa kwedatha). I-time-decay inika ukubalelwa okukhulu ekuthintweni kwakamuva, kodwa ikhumbula nethonya lakuqala. Ifanele amathimba anokufinyelela kwedatha okulingene nentshisekelo yokubheka imininingwane: amaqembu amakhulu emisebenzi yokumaketha avumelanisa amalogi okucofa ephlathifomu nama-lead e-CRM, noma ama-ejensi akhulumisa ama-C-suite afuna ukubona ijika lethonya. Umthetho wokunquma: sebenzisa i-time-decay uma ungalandelanisa ngokuthembekile izikhathi zokuthinta futhi ugcine ama-ID amasesheni noma abasebenzisi engashintshi. Izindlela zokwehluleka: umsebenzi wokubola ungazwakala ungenasisekelo futhi wenza imikhondo yokuhlola ibe nzima. Yenze ivikeleke ngokubhala i-half-life oyisebenzisile nokukhombisa ukuhlolwa kokuzwela: "nge-half-life yezinsuku ezi-3 ukuguqulwa kushintsha nge-X percent." Uma ukujoyina kwedatha yakho kuthambile, maka le modeli Okuphuzi noma Okubomvu, bese uyisebenzisela ukuhlaziya kwangaphakathi kuphela, hhayi izihloko eziyinhloko zabaphathi.

Ukukhetha imodeli kuphinde kuhlobane nezombusazwe. Linda ukuthi abanikazi beziteshi bazophusha amamodeli abawathandayo. Umthetho olula wokuphatha uyasiza: khetha imodeli eyodwa ye-slide yabaphathi yeviki, bese ugcina imibono emibili yokuhlola yabasebenzi. Sebenzisa amalambu omgwaqo: amamodeli aluhlaza aya ku-slide, amamodeli aphuzi aya efolda yabasebenzi yemibuzo ejulile, amamodeli abomvu ayekwa kuze kuthuthuke idatha. Uma i-Mydrop noma esinye isikhulumi sinikeza i-sheet yakho imethadatha engaguquki yemikhankaso nempahla, kuba lula ukusuka kokuphuzi uye kokuluhlaza.

Guqula umqondo ube umsebenzi wansuku zonke

Nansi ingxenye abantu abayidebeselayo: i-spreadsheet iyinto elula, kodwa umkhuba wansuku zonke nobuhlanzeka yikho okuyenza ithembeke. Yakha amathebhu amane: Raw, Lookup, Attribution, Dashboard. I-Raw iphethe okuthunyelwe okungenisiwe: ukucofa kwephlathifomu, inkcitho ekhokhelwayo nama-lead e-CRM. I-Lookup iphethe imephu elinganisiwe yemikhankaso, yamabhrendi neyezimakethe. I-Attribution iqhuba imodeli ekhethiwe futhi igcina umugqa ngamunye wokuguqulwa ukuze uhlolwe. I-Dashboard iphethe umbono we-slide eyodwa wabathintekayo kanye nesifinyezo samalambu omgwaqo. Gcina ithebhu ngayinye inenhloso eyodwa futhi ingashintshwa lapho kungenzeka: i-Raw ne-Attribution kufanele zengezwe kuphela ukuze kugcineke umkhondo wokuhlola.

Nazi izinkambu ezithile namafomula ambalwa esibonelo ukuze uqale. I-Raw kufanele ibe nalokhu: utc_timestamp, session_id, user_id (noma i-ID ehashiwe), utm_source, utm_medium, utm_campaign, platform, cost, landing_page, click_id, conversion_id, conversion_timestamp. I-Lookup idinga: utm_campaign -> brand, product, region, channel_type, paid_vs_organic. I-Attribution idinga: conversion_id, conversion_timestamp, path_ordered_touch_ids, model_credit. Sebenzisa i-SUMIFS ukuqoqa izibalo, kanye ne-VLOOKUP noma i-INDEX/MATCH ukumapha umkhankaso ebhrendini. Amafomula esibonelo, amafushane:

• Normalize campaign to brand: =IFERROR(VLOOKUP(C2, Lookup!A:B, 2, FALSE), "Unknown")
• Attribution credit (last touch): =INDEX(path_touches, COUNTA(path_touches))
• Rollup attributed conversions: =SUMIFS(Attribution!credit, Attribution!brand, "Brand A") Ukuhlanganisa amasesheni, i-ARRAYFORMULA ne-CONCATENATE ziyakusiza lapho udinga ukwakha ukhiye wendlela ozinzile. Gwema i-regex ethambile, ngaphandle kokuthi unesinyathelo sokulinganisa.

Uhlu olufushane lwansuku zonke olugcina i-spreadsheet ithembekile futhi iphindaphindeka:

• Qinisekisa ukuthi okungenisiwe kobusuku kufike ku-Raw, bese uphawula imithombo elahlekile.
• Vuselela i-lookup ngokushesha: qinisekisa ukuthi imikhankaso emisha imephiwe ku-Lookup.
• Hlola ngokuphazima ukuguqulwa okungu-5 uma kuqhathaniswa ne-CRM ukuze uqinisekise ukuthi ukujoyina kunempilo.
• Buyekeza izimo zokuluhlaza/okuphuzi/okubomvu ku-Dashboard, bese ushicilela isixhumanisi sokufunda kuphela.
• Dlulisela ukungafani okungaphezu kuka-10% iviki ngeviki kumnikazi wedatha.

Amanothi omsebenzi nezindlela zokwehluleka okufanele uzibheke. Lapha kuvame ukubambeka amathimba: amagama eziteshi emaphlathifomini ezikhangiso ashintsha maphakathi nomkhankaso, abezomthetho baqamba kabusha ama-CTA, futhi amathimba ezifunda adala amasethi ezikhangiso anama-UTM amasha. Lokho kuphula ukujoyina. Umthetho olula uyasiza: thatha i-Lookup njengendawo engcwele. Umuntu oyedwa noma ithimba elincane kuphela elibuyekeza i-Lookup, futhi ushintsho ngalunye kufanele lube nenothi lomugqa owodwa: ngubani oshintshile, kungani, nini. Uma i-Mydrop isetshenziselwa ukuphatha imethadatha yobuciko neyemikhankaso, hambisa lawo ma-ID emikhankaso ku-sheet ukuze ushintsho lwe-Lookup lukwazi ukuzenzakalela, noma okungenani lunciphe.

Ukuzenzakalela okusiza ngempela kuphansi futhi kuyahlolwa. Sebenzisa i-IMPORTDATA ehleliwe noma i-Sheets API ukudonsa ama-CSV avela emaphlathifomini ezikhangiso nokuthunyelwe kwe-CRM ku-Raw. Linganisa amalebula emikhankaso nge-prompt emfushane yesitayela se-GPT noma ngeskripthi esinemithetho, kodwa yenza ukulinganisa ku-Lookup bese ulogu wonke ushintsho lwemephu. Hlela i-Apps Script yansuku zonke eqhuba ukuhlola okuthathu: imephu yomkhankaso elahlekile, ama-conversion ID aphindiwe, nezinguquko ezinkulu zezindleko ngokuguqulwa ngakunye. Yenze ibhale isimo somugqa owodwa ku-Dashboard. Qaphela ukuzenzakalela ukujoyina okuthambile ngokweqile: uma ukuzenzakalela kudala ukudideka okungaphezu kwesivinini, kuvale bese ulungisa inkinga yangempela yokuqamba amagama.

Ekugcineni, yenza i-dashboard ibe lula ukuyisebenzisa abantu. I-KPI yeviki ye-slide eyodwa kufanele ibonise: ukuguqulwa okubalelwe (imodeli esetshenzisiwe), izindleko ngokuguqulwa ngakunye okubalelwe, nesilinganiso se-assist rate esiphambana neziteshi, kanye ne-sparkline encane yomkhondo wezinsuku eziyisikhombisa. Engeza umugqa owodwa wesichazi samalambu omgwaqo: Okuluhlaza = imodeli nokujoyina kuhloliwe kuleli viki, Okuphuzi = ukuzethemba okuyingxenye, Okubomvu = ungasebenzisi ekuthatheni izinqumo. Nikeza ubunikazi: ubani oshicilela i-slide, ubani onikazi we-Lookup, nobani ofinyeleleka lapho izinombolo ziqhuma. Ukubuyekeza kweviki okufushane kwemizuzu emi-5 nalaba bathathu kugcina i-sheet ithembekile, futhi kwenza inombolo ivikeleke phambi kwe-C-suite.

Sebenzisa i-AI nokuzenzakalela lapho kusiza ngempela

Ukuzenzakalela kuyawina uma kushintsha umsebenzi ophindaphindwayo onamaphutha, hhayi uma kuzama ukwenza i-attribution ngaphandle kwedatha. Emathimbeni amakhulu ukuzenzakalela okunenani eliphezulu kulula: ukungenisa okuthembekile kwokuthunyelwe kwemicimbi yephlathifomu, ukulinganisa amalebula ngokufanayo, nokuhlola okuhleliwe okubamba ukujoyina okuphukile noma okulahlekile ngaphambi kombiko weviki. Izibonelo ezisebenzayo: ukudonsa kwe-Sheets API okuhleliwe okuvela kuma-CSV emidiya ekhokhelwayo, i-Apps Script encane ejoyina ama-session ID emigqeni yokuguqulwa, ne-prompt ye-GPT elula elinganisa amagama emikhankaso ethebhini lakho le-Lookup. Lokhu yikho ukuzenzakalela okonga amahora futhi kunciphisa impi ethi "izinombolo zami ziyehluka" phakathi kwamathimba ezifunda ne-finance.

Kukhona izindleko nezindlela zokwehluleka ezibikezelekayo. Ukujoyina okuthambile kuyinto evamile. Uma i-ID ye-lead ye-CRM noma i-GA session ID ilahlekile, ukujoyina okuzenzakalelayo kuzolahla imigqa ngokuthula bese kukunika isibalo sokuguqulwa esiphansi ngamanga. Ukuzenzakalelisa ukulinganisa ngokweqile kungafihla amaphutha: ukulungisa ilebula nge-GPT okungahloliwe kungahlanganisa imikhankaso emibili ehlukene ibe eyodwa ngephutha. Umthetho olula uyasiza: zenzakalise ukukhipha nokulinganisa, kodwa dinga indlela yokubuyela egunyazwe ngumuntu lapho ukuzethemba kuphansi. Sebenzisa amalambu omgwaqo ukumaka ukuthi ukuzenzakalela kulungile yini: Okuluhlaza kuyimithombo enodlobo lwe-UTM oluqinile, Okuphuzi kuyiziteshi ezidinga ukuqinisekiswa ngumuntu njalo, Okubomvu kunoma yimuphi umthombo ongenawo ama-ID azinzile okumele uvumelaniswe ngesandla.

Izilawuli ezisebenzayo zivimba ukuzenzakalela ukuba kube ngamabhokisi amnyama angaqondakali. Engeza ishidi "lempilo yedatha" lansuku zonke eliqukethe inani lemigqa ngomthombo ngamunye, isikhathi sokubuyekezwa kwakamuva, nencazelo yemigqa emibili yanoma yikuphi ukwehluka okudlula umkhawulo omisiwe. Nikeza umnikazi oyedwa umthombo ngamunye nendlela eyodwa yokudlulisela lapho iskripthi sansuku zonke sibika inkinga. Ukudlulisela okuncane, okuphindaphindwayo yikho okwehlukanisa ukuzenzakalela okukhulayo nokuzenzakalela okuqeda ukuthembana ngokuthula. Uhlu olufushane lokuzenzakalela okuwusizo nokudluliselwa:

• Ukungenisa okuhleliwe: i-Sheets API noma i-IMPORTDATA idonsa okuthunyelwe kwemidiya ekhokhelwayo kuthebhu ye-Raw, nesitembu sesikhathi nomnikazi womthombo.
• Ukulinganisa amalebula: i-prompt encane ye-GPT eqhutshwa ku-Apps Script ukuphakamisa izilungiso, kodwa dinga ukwamukelwa ngumuntu ezinguqukweni ezingacacile.
• Ukumaka okungajwayelekile: iskripthi esihleliwe esimaka ukwehluka kwe-+/- 25 percent ekuguqulweni kwansuku zonke, sazise umnikazi.
• Ukuthatha izithombe: umugqa wesithombe se-Dashboard wasebusuku we-sparkline yeviki nokugcina umkhondo wokuhlola.

Ukukhuluma nge-Mydrop lapho isiza khona kuphela: amathimba amakhulu asevele ahlanganisa impahla ye-social nokugunyaza epulatifomu efana ne-Mydrop athola kulula ukuzenzakalela imephu yemikhankaso. Uma amagama emikhankaso, omaka bezilaleli nezinqumo zokukhuthaza konke kuhlala endaweni eyodwa, imephu eya emikhankasweni ye-UTM ku-sheet iba isinyathelo somshini esikhundleni sokuphenywa. Lokho kuguqula izinto eziphuzi zibe ziluhlaza ngokushesha, ngoba umsebenzi wabantu ugxile ekuphatheni hhayi ekulungiseni idatha.

Linganisa okufakazela intuthuko

Ukulinganisa kudinga izinto ezimbili: izilinganiso ezicacile abathintekayo abazinaka ngempela, nophawu oluguqulwa lube yisinqumo esisodwa. Ku-slide yesimo seviki khetha izilinganiso ezintathu eziyinhloko nesithombe esisodwa esifushane. Izilinganiso ezintathu ezinqamula umsindo emathimbeni amakhulu yilezi: ukuguqulwa okubalelwe (inani lokuguqulwa imodeli oyikhethile ekubalela i-social), izindleko ngokuguqulwa ngakunye okubalelwe (inkcitho yezikhangiso yehlukaniswe nokuguqulwa okubalelwe), nesilinganiso se-assist rate esiphambana neziteshi (iphesenti lokuguqulwa lapho i-social isebenza ngaphandle kokuba yisinyathelo sokugcina). Lezi ezintathu zitshela i-procurement/finance ukuthi inkcitho iyaqondakala yini, zitshela amathimba ezifunda ukuthi okuqukethwe kusekela yini ipayipi lamalead, futhi zinika abezomthetho/abalandela imithetho ukubuka isilinganiso sengozi uma kuqhathaniswa nosayizi.

Isilinganiso ngasinye sidinga ukubala okulula nebhande elicacisiwe lokuzethemba. Ukuguqulwa okubalelwe yisibalo esiluhlaza esivela kuthebhu yakho ye-Attribution, nenothi lokucatshangelwa kwemodeli. Izindleko ngokuguqulwa ngakunye okubalelwe ukuhlukanisa inkcitho ngokuguqulwa okubalelwe, kodwa engeza umthetho wokuluhlaza/okuphuzi/okubomvu: Okuluhlaza uma ukwehluka uma kuqhathaniswa nesikhathi esedlule kungaphakathi kwe-10 percent futhi usayizi wesampuli ungaphezu kuka-X; Okuphuzi uma ukwehluka kungu-10 kuya ku-30 percent noma usayizi wesampuli usemkhawulweni; Okubomvu uma ukwehluka kudlula u-30 percent noma usayizi wesampuli mncane kakhulu. Isilinganiso se-assist rate esiphambana neziteshi sisiza umholi we-social ops ukubona lapho ukukhuthaza okukhokhelwayo kufihla ithonya lemvelo. Uma ukukhuthaza okukhokhelwayo kukhulisa i-assist rate kodwa i-last touch yehla, maka isiteshi njengokuphuzi ukuze sibuyekezwe kabanzi. Lo mthetho wenza izitayela ezinomsindo zibe isenzo somugqa owodwa: phindaphinda ubuciko, misa ukukhuthaza, noma dlulisela ekusebenzeni.

Isithombe esisodwa senza umsebenzi omningi. Sebenzisa i-sparkline yeviki yokuguqulwa okubalelwe kwebhrendi ngayinye enkulu, kanye nesichongo sesimo samalambu omgwaqo saleyo bhrendi eviki lakamuva. Abaphathi babona isitayela, abasebenzi babona ukuhlukahluka, futhi abaqondisi bezifunda babona umbala wefulegi labo. Yakha ithebhu ye-Dashboard ukuze ibonise i-sparkline, izilinganiso ezintathu, nendaba yomugqa owodwa yeviki. Gcina umkhawulo wendaba uqinile: umusho owodwa, inombolo eyodwa, isenzo esisodwa esiphakanyisiwe. Izibonelo: "I-Brand A ikhuphuke ngo-12 percent ekuguqulweni okubalelwe, izindleko/ukuguqulwa ziyazinza, akukho senzo" noma "I-Brand B yehle ngo-28 percent, izindleko/ukuguqulwa +40 percent, misa umkhankaso X ukuze ubuyekezwe ubuciko."

Ubunikazi nesigqi kubaluleke kakhulu kunezibalo ezifanele. Setha umhlangano wokubuyekeza wemizuzu emi-5 njalo ngeviki, lapho umnikazi efunda indaba yomugqa owodwa, i-dashboard ibonisa i-sparkline, futhi noma yiziphi izinto ezibomvu zibe nokudluliselwa ngokushesha kumnikazi. Gcina izithombe zeviki njengemigqa engashintshi ukuze noma ubani akwazi ukuhlola isimangalo kamuva. Ezethulweni ze-ejensi ku-C-suite, finyeza lowo mbono weviki ube yi-slide eyodwa ene-sparkline ne-KPI yezindleko ngokuguqulwa ngakunye okubalelwe. Kubathengisi abakhulu abanamabhrendi amaningi, sebenzisa umbono wegridi onesimo samalambu omgwaqo ngesifunda nangebhrendi, ukuze amathimba endawo akwazi ukuhlunga endaweni ngaphandle kokungcwaba umbiko omaphakathi.

Ekugcineni, yiba sobala ngemikhawulo nokuqinisekisa ngezindlela eziningi. I-attribution ku-spreadsheet iyashesha futhi iyavikeleka uma ubhala imicabango futhi unikeza ukuhlola okuphambene. Gcina ithebhu encane ye-"reconciliation" eqhathanisa ukuguqulwa kwephlathifomu okuhlanganisiwe nokuguqulwa okubalelwe, futhi ibale izizathu ezinkulu zezikhala: ukulahleka phakathi kwamadivayisi, ukuguqulwa okungekho ku-inthanethi, noma ukubambezeleka kwe-CRM. Lolo hlu olufushane lwezizathu luyisimo sakho sokuqala sokuphendula uma umqondisi wesifunda ethi izinombolo azizwakali zilungile. Inkomba ukuzethemba, hhayi ukuphelela: uma ungakhombisa izithombe ezingaguquki, umthetho wesinqumo ocacile, nomkhondo wokuhlola othembekile, unamandla okufakazela i-ROI ye-social ngokushesha, futhi uzothenga isikhathi sokuthuthela kamuva kumathuluzi e-BI amakhulu.

Yenza ushintsho luhlale emathimbeni

Ingxenye enzima akukhona ukwakha i-sheet. Kungukwenza abantu abangamashumi amabili abasebenzisa amagama, ama-dashboard nama-PDF ahlukene bathembe umugqa owodwa weqiniso. Qala ngokuqoka umnikazi onezinto ezimbili: igunya lokukhiya izinkambu, nentshisekelo yokusesha izimanga. Biza leyo ndima ngokuthi Umgcini Wedatha. Umsebenzi wokuqala womgcini wokusebenza: shicilela i-dashboard yokufunda kuphela yabaphathi, i-sheet yokusebenza ebhalekayo yabahlaziyi, nethebhu yokulungiselela yokungenisa okuluhlaza. Sebenzisa isivikelo se-Google Sheets ukuvimbela ushintsho lwephutha kumatafula e-lookup namafomula e-attribution, futhi ugcine okuthunyelwe okuluhlaza kungaguquki. Yenza inguqulo yebhuku lomsebenzi iviki ngalinye ngokukopisha ifayela, noma usebenzise umthetho oqinile wamagama njenge-YYYY-MM-DD_snapshot. Lo mkhuba olula wakha umkhondo wokuhlola abantu abangakhomba kuwo lapho izinombolo zingahambisani nokuthunyelwe kwephlathifomu.

Yakha isichazi samalambu omgwaqo somugqa owodwa futhi usenze singaphuthelwa. Sibeke ngaphezu kwe-dashboard: Okuluhlaza = ukuzethemba komthombo wokuguqulwa (imephu eqondile evela ku-UTM noma ku-CRM ID), Okuphuzi = kuyakholeka kodwa kudinga ukuqinisekiswa (ukubuyekeza ngesandla kuhleliwe), Okubomvu = ungasebenzisi ekuthatheni izinqumo (ukujoyina okuphukile, imvume elahlekile, noma ukungcoliswa okukhulu ukukhuthaza okukhokhelwayo). Bese wenza izindlela zokuphuma ngokusemthethweni. Emigqeni ephuzi, uMgcini Wedatha unikeza umhlaziyi wesifunda itikithi lamahora angu-48, futhi engeza ukuphawula ngendlela ekhonjwayo yokwehluleka: i-session ID elahlekile, i-UTM engahambisani, noma izikhathi zokucofa ezinqunyiwe. Emigqeni ebomvu, i-dashboard kufanele ivimbele ngokuzenzakalelayo leso silinganiso ku-slide yabaphathi futhi iqalise ukudlulisela: yazise i-Marketing Ops nombuyekezi wezomthetho, qandisa yonke imibiko ehlobene yokukhuthaza okukhokhelwayo yeviki, bese uvula itikithi lokulungisa. Lowo mthetho ungazwakala uqinile, kodwa uvimbela isimanga esijwayelekile se-C-suite lapho umkhankaso owenza kahle unyamalala ngemva kokuba othile elungise ukujoyina, ithimba lingenaso isizathu.

Ukuphatha ushintsho kuyinto yabantu nezinkambiso ezibikezelekayo. Hlela ukudlulisela kweviki kwemizuzu emi-5: umhlangano ofushane ofanayo, uhlelo olufanayo, umnikazi ofanayo, lapho umgcini ekhomba noma yiziphi izinto eziphuzi noma ezibomvu nesenzo esihambisanayo. Yenza i-dashboard ibe yi-slide eyodwa yemihlangano yesimo: phezulu kunesparkline yeviki yokuguqulwa okubalelwe nebheji yokuluhlaza/okuphuzi/okubomvu, kuyilapho engxenyeni engezansi kunomugqa owodwa wesichazi namanothi amathathu aphezulu obuhlanzeka bedatha. Khuthaza amathimba ezifunda ukuthi abhalisele ochungechungeni lokuphawula lwe-sheet esikhundleni sokuthumela ama-spreadsheet azungeza. Ekugcineni, bhala phansi umnikazi nendlela yokudlulisela: Umgcini Wedatha, i-Marketing Ops, Umbuyekezi Wezomthetho, Inhloko Ye-Social. Leyo ketanga icacisa ukuthi ubani unoxanduva lapho umbuyekezi wezomthetho engcwatshwa noma umbuzo wokuhlola ufika ku-finance. Uma amathimba esevele esebenzisa i-Mydrop ekugunyazeni nasekulawuleni impahla, yisebenzise njengomthombo oyinhloko wama-ID emikhankaso nobuciko, ukuze ukujoyina kwe-sheet kuxhume ku-ID eyodwa eyinhloko, hhayi kumathegi ayishumi nambili abhalwe ngokukhululekile.

Lapha kuvame ukubambeka amathimba: ukuzenzakalela ngaphandle kwezivikeli. Zenzakalise izinto ezilula: ukudonsa ama-CSV okuhleliwe, i-IMPORTDATA evela emaphlathifomini ezikhangiso, iskripthi sasebusuku esimaka izinkinga ezisobala. Kodwa ungazenzakalisi izilungiso ezidinga ukwahlulela. Dizayina i-sheet ukuze ukuzenzakalela kuphakamise izilungiso, kungazisebenzisi. Isibonelo, sebenzisa i-prompt elula eqhutshwa yi-GPT ukulinganisa izinhlobo zamalebula, bese ukhombisa iziphakamiso ezintathu eziphezulu ekholomini ethi "Suggested Labels". Shiya ukuqamba kabusha kwangempela kumhlaziyi wesifunda. Sebenzisa izinkambu ezivikelekile zamatafula e-lookup ukuze ukuzenzakalela kungashintshi ngokuthula imephu. Lo mkhuba uvimbela engikubiza ngokuthi ukubhala kabusha ngephutha, lapho ukulinganisa okuzenzakalelayo kubhala phezu kwendlela yamagama yesifunda esemthethweni, bese i-attribution yomkhankaso ishintsha ngokuzumayo.

Linakekele izinkambiso ezincane ezakha ukuthembana ngokushesha kune-dashboard ecwebezelayo. Inothi lamasekhondi angu-30 leviki elivela kuMgcini Wedatha kumazwana e-dashboard elithi "akukho izithiyo kuleli viki" noma "ngiphenya i-X" lisiza kakhulu. Shicilela idokhumenti yokuphatha yesigaba esisodwa eduze kwe-sheet: umnikazi, isixhumanisi sokufunda kuphela, isigqi sokubuyekeza, nencazelo yomugqa owodwa yamalambu omgwaqo. Dinga ukuphawula okufushane kunoma yikuphi ukushintsha ngesandla kwe-logic ye-attribution: ngubani oshintshile, kungani, nokuthi umthelela olindelekile wezinombolo uyini. Ngokuhamba kwesikhathi lezi zinto ezincane zakha umkhuba: ithimba liyeka ukuthumela ama-spreadsheet ukuze lifakazele iphuzu, libhekise emthonjeni owodwa onomkhondo wokuhlola.

Izinyathelo ezintathu ongazithatha okulandelayo

1. Qoka uMgcini Wedatha bese ushicilela izixhumanisi ezimbili: umbono wabaphathi wokufunda kuphela ne-workbook yokusebenza ebhalekayo, bese uvikela izinkambu ze-lookup.
2. Sebenzisa isichazi samalambu omgwaqo ku-dashboard, bese ubhala ukuhlola okuzenzakalelayo okukodwa okumaka amacala abomvu (ama-session ID alahlekile noma ama-UTM angahambisani).
3. Qhuba ukudlulisela kweviki kwemizuzu emi-5 amasonto amane, rekhoda izinqumo emazwaneni, bese ulinganisa ukuthi impikiswano ngezinombolo iyehla yini.

Isiphetho

I-dashboard elula, ephethwe kahle ye-attribution ku-Google Sheets ayilona esinye isikhundla se-BI ephelele unomphela, kodwa iyindlela esebenzayo, engenazithiyo eziningi yokufakazela i-ROI ye-social ngokushesha nokwakha ukuthembana ebhizinisini lonke. Ukuwina kwangempela kuvela emikhubeni yokusebenza oyiphoqelelayo: umnikazi oqokiwe, izithombe zenguqulo, ukuvikela amafomula, nomthetho oqinile wamalambu omgwaqo wokuthi yini ebalwa njengokufanele kwenziwe ngayo. Lezi zinto ezincane zokuphatha ziguqula i-spreadsheet ibe umthombo weqiniso othembekile wabaphathi, amathimba ezifunda nabahloli.

Uma ufuna ukukhula kamuva, i-sheet inikeza onjiniyela umkhondo ohlanzekile ongathunyelwa ukuze bakhe ipayipi elifanele. Okwamanje, gcina imithetho iqinile: zenzakalise ukudonsa okuthembekile, gwema ukulungisa okuzenzakalelayo, futhi yenza indlela yokudlulisela ibonakale. Sebenzisa amathuluzi afana ne-Mydrop lapho esiza khona: ama-ID emikhankaso aqondile nezinkomba zokugunyaza yizinto ezifanele kakhulu ze-sheet. Kodwa thatha i-sheet njengongqimba lokuphatha wonke umuntu avumelana nalo. Imikhuba emincane eqhubekayo ishaya imodeli ephelele ongayithembi muntu.