Isixhumi se-Google BigQuery

1. Kungani uthekelisa i-telemetry eluhlaza ku-BigQuery?

Nakuba ideshibhodi ye-MousePlayer inikeza ukudlala kabusha kwamaseshini ngokushesha namamephu okushisa abonakalayo, amaqembu amabhizinisi esayensi yedatha nobuhlakani bebhizinisi (BI) adinga ukufinyelela kwe-SQL okuqondile kumalogi okuziphatha aluhlaza. Ngokuvumelanisa idatha ye-MousePlayer ku-Google BigQuery, ungakwazi:

• Ukuhlanganisa i-telemetry nedatha yengxenye yeseva: Hlanganisa amaseshini abasebenzisi engxenye yesiphequluli namarekhodi e-CRM, amalogi amasango enkokhelo nezizindalwazi zokukhokhisa usebenzisa imibuzo ye-SQL yangokwezifiso.
• Ukuqeqesha amamodeli e-AI/ML angokwezifiso: Sebenzisa izindlela zokunyakaza kwegundane ezinemininingwane namaphethini okuchofoza ngentukuthelo ukuze uqeqeshe ama-algorithm okubikezela ukungabuyi nokuthola inkohliso.
• Azikho izindleko zokugcina ku-MousePlayer: Idatha ithekeliswa ngokuqondile kuphrojekthi yakho ye-GCP, ikunikeze ubunikazi bedatha obungu-100% nokuhambisana nezinqubomgomo ze-IAM zebhizinisi.

2. Amandla ohlelo lwe-Business uma kuqhathaniswa nohlelo lwe-Enterprise

Isixhumi se-BigQuery sitholakala ezinhlelweni ze- Business ne- Enterprise kuphela. Kuye ngezinga lakho, ungakhetha ukuthi yiziphi izethi zedatha ezifakwa ekuthekeliseni okuzenzakalelayo kwansuku zonke ebusuku:

Ithebula elithekelisiwe	Okuqukethwe kwedatha & ukwakheka	Uhlelo lwe-Business	Uhlelo lwe-Enterprise
visitor_sessions_YYYYMMDD	Imethadatha yeseshini ephelele (i-ID yeseshini, i-ID yesivakashi, IP, izwe, idivayisi, OS, isiphequluli, isikhathi, umthombo wokudlulisa, ama-UTM, custom_user_id).	Kufakiwe	Kufakiwe
visitor_custom_events_YYYYMMDD	Konke ukuguqula okujwayelekile nezehlakalo zangokwezifiso (isib. purchase, rage_click, error_detected, ukuthunyelwa kwamafomu) kanye namapharamitha e-EAV anezinhlobo.	Kufakiwe	Kufakiwe
mouse_events_YYYYMMDD	Ukusakazwa kwezixhumanisi zendawo okunemininingwane (X, Y, izitembu zesikhathi, ukujula kokuskrola, okuqondiwe kokuchofoza, izikhethi ze-CSS eziqondiwe) kukho konke ukubukwa kwekhasi okurekhodiwe.	Akutholakali	Okwe-Enterprise kuphela

3. Umhlahlandlela wokusetha: i-akhawunti yesevisi ye-GCP & izimvume ze-IAM

I-MousePlayer ayilokothi icele ukungena kwakho komuntu siqu kwe-Google. Esikhundleni salokho, udala i-akhawunti yesevisi ezinikele ngaphakathi kwe-Google Cloud Console yakho enezimvume ezincane ezidingekayo:

1. Ku-Google Cloud Console, iya kokuthi IAM & Umphathi → Ama-akhawunti Esevisi bese uchofoza Dala I-akhawunti Yesevisi.
2. Qamba i-akhawunti yesevisi (isib. mouseplayer-bq-writer).
3. Yabela izindima ze-IAM ezimbili kuphela: BigQuery Data Editor ne- BigQuery Job User.
4. Iya kuthebhu ethi Okhiye ye-akhawunti yakho yesevisi entsha, uchofoze Faka Ukhiye → Dala ukhiye omusha, bese ukhetha JSON.
5. Vula ideshibhodi yakho ye-MousePlayer, uye kokuthi Amasayithi Akho → Izilungiselelo → BigQuery, bese unamathisela i-ID yephrojekthi yakho ye-GCP, i-ID yesethi yedatha, i-imeyili ye-akhawunti yesevisi nokuqukethwe kokhiye we-JSON.