Isku-xiraha Google BigQuery

Telemetry-gaaga falanqaynta ceeriin ah si toos ah ugu dhoofi bakhaarkaaga xogta Google Cloud Platform adigoo adeegsanaya rarista xidhmooyinka NDJSON ee habeenkii otomaatigga ah.

1. Maxaa telemetry ceeriin ah loogu dhoofiyaa BigQuery?

Inkasta oo dashboard-ka MousePlayer bixiyo dib-u-ciyaarisyo fadhi oo degdeg ah iyo khariidado kulayl oo muuqaal ah, kooxaha cilmiga xogta iyo Business Intelligence (BI) ee shirkaduhu waxay u baahan yihiin gelitaan SQL oo toos ah oo diiwaannada habdhaqanka ceeriin ah. Markaad xogta MousePlayer ku waafajiso Google BigQuery, waxaad:

  • Telemetry ku dari kartaa xogta backend: Ku dar fadhiyada isticmaalaha ee front-end diiwaannada CRM, diiwaannada marinnada lacag-bixinta iyo kaydadka biilasha adigoo adeegsanaya SQL queries gaar ah.
  • Tababari kartaa moodello AI/ML oo gaar ah: Adeegso waddooyinka dhaqdhaqaaqa jiirka ee faahfaahsan iyo qaababka gujinta caro leh si aad u tababarto algorithms saadaaliya soo-noqosho la'aanta iyo ogaanshaha khiyaanada.
  • Kharash kaydin ma jiro dhinaca MousePlayer: Xogta waxaa si toos ah loogu dhoofiyaa mashruucaaga GCP, taas oo ku siinaysa lahaanshaha xogta 100% iyo waafaqsanaanta siyaasadaha IAM ee shirkadda.

2. Awoodaha qorshaha Business iyo qorshaha Enterprise

Isku-xiraha BigQuery waxaa si gaar ah looga helaa qorshayaasha Business iyo Enterprise . Iyadoo ku xiran heerkaaga, waxaad dooran kartaa datasets-ka ku jira dhoofinta maalinlaha ah ee habeenkii otomaatigga ah:

Jadwalka la dhoofiyo Nuxurka xogta & schema Qorshaha Business Qorshaha Enterprise
visitor_sessions_YYYYMMDD Metadata fadhiga oo buuxa (Session ID, Visitor ID, IP, Country, Device, OS, Browser, Duration, Referrer, UTMs, custom_user_id). Ku jira Ku jira
visitor_custom_events_YYYYMMDD Dhammaan beddelashooyinka caadiga ah iyo dhacdooyinka gaarka ah (tusaale, purchase, rage_click, error_detected, dirista foomamka) oo wata halbeegyada EAV ee noocaysan. Ku jira Ku jira
mouse_events_YYYYMMDD Qulqul isku-duwayaal faahfaahsan (X, Y, waqtiyada, qotada rogista, bartilmaameedyada gujinta, CSS selectors-ka bartilmaameedka) ee daawasho bog kasta oo la duubay. Lama heli karo Enterprise oo keliya

Maxaa mouse_events loogu xaddiday Enterprise? Hal websayt oo taraafik badan ayaa maalintii soo saari kara tobannaan milyan oo saf isku-duwayaal ah. Habaynta iyo dhoofinta telemetry-ga isku-duwayaasha ceeriin ah waxay u baahan yihiin workers gaar ah oo waxqabad sare leh iyo dammaanado SLA oo dheeraad ah oo laga helo heshiisyada Enterprise oo keliya.

3. Hagaha dejinta: GCP Service Account & oggolaanshaha IAM

MousePlayer waligiis ma weydiiyo gelitaankaaga shakhsiyeed ee Google. Halkii, waxaad ka abuurtaa Service Account gaar ah Google Cloud Console-kaaga oo leh oggolaanshaha ugu yar:

  1. Google Cloud Console, tag IAM & Maamul → Akoonnada Adeegga oo guji Abuur akoon adeeg.
  2. Magac u yeel akoonka adeegga (tusaale, mouseplayer-bq-writer).
  3. U qoondee laba door oo IAM ah oo keliya: BigQuery Data Editor iyo BigQuery Job User.
  4. Tag taabka Furayaasha ee akoonkaaga adeegga cusub, guji Ku dar fure → Abuur fure cusub oo dooro JSON.
  5. Fur Dashboard-kaaga MousePlayer, tag Websaytyadaada → Dejimaha → BigQuery oo ku dheji ID-ga mashruucaaga GCP, Dataset ID, iimaylka akoonka adeegga iyo nuxurka furaha JSON.

Amniga & sirgelinta: Furahaaga JSON ee gaarka ah waxaa lagu siraa sirgelin heer militari ah oo AES-256-GCM ah ka hor inta aan lagu qorin kaydka xogtayada. Furayaasha ceeriin ah waligood laguma kaydiyo qoraal cad, dibna loogama akhrin karo muuqaalka HTML.

Dhammaan calaamadaha ganacsi ee halkan lagu magacaabay waxaa leh milkiilayaashooda. MousePlayer xiriir ganacsi lama laha bixiyeyaashan.