Mai haɗin Google BigQuery

1. Me ya sa za a fitar da ɗanyen bayanai zuwa BigQuery?

Yayin da dashboard na MousePlayer yake ba da sake kunna zamuka nan take da taswirorin zafi na gani, ƙungiyoyin kimiyyar bayanai da Business Intelligence (BI) na kamfanoni suna buƙatar damar SQL kai tsaye ga ɗanyen kundin halayya. Daidaita bayanan MousePlayer da Google BigQuery yana ba da damar:

• Haɗa bayanan bin diddigi da bayanan bayan fage: Haɗa zamukan masu amfani a fuskar shafi da bayanan CRM, kundin hanyoyin biyan kuɗi da rumbunan biyan kuɗi ta buƙatun SQL na musamman.
• Horar da samfuran AI/ML na musamman: Amfani da cikakkun hanyoyin motsin manuni da tsarin dannawa cikin fushi don horar da hanyoyin hasashen rashin dawowa da gano zamba.
• Babu kuɗin ma’ajiya a MousePlayer: Ana fitar da bayanai kai tsaye cikin aikin GCP, don mallakar bayanai 100% da bin manufofin IAM na kamfani.

2. Damar shirin Business da shirin Enterprise

Mai haɗin BigQuery yana samuwa a shirye-shiryen Business da Enterprise kaɗai. Gwargwadon mataki, ana iya zaɓar datasets da za a haɗa cikin fitarwar dare ta kowace rana ta atomatik:

Jadawalin da ake fitarwa	Bayanan ciki & tsari	Shirin Business	Shirin Enterprise
visitor_sessions_YYYYMMDD	Cikakken metadata na zama (ID na zama, ID na baƙo, IP, ƙasa, na’ura, OS, burauza, tsawon lokaci, mai turawa, UTMs, custom_user_id).	An haɗa	An haɗa
visitor_custom_events_YYYYMMDD	Duk cikar manufa ta yau da kullum da abubuwan da suka faru na musamman (misali, purchase, rage_click, error_detected, aika fom) tare da sigogin EAV masu nau’i.	An haɗa	An haɗa
mouse_events_YYYYMMDD	Cikakken jerin matsayi (X, Y, timestamps, zurfin gungurawa, wuraren dannawa, CSS selectors na wurin) ga kowane kallon shafi da aka rikoda.	Ba ya samuwa	Na Enterprise kaɗai

3. Jagorar saitawa: asusun sabis na GCP & izinin IAM

MousePlayer ba ya taɓa neman bayanan shiga Google na mutum. Maimakon haka, ana ƙirƙirar asusun sabis na musamman a Google Cloud Console da mafi ƙarancin izini:

1. A Google Cloud Console, a je IAM & Admin → Service Accounts a danna Ƙirƙiri asusun sabis.
2. A ba asusun sabis suna (misali, mouseplayer-bq-writer).
3. A bayar da matsayin IAM guda biyu daidai: BigQuery Data Editor da BigQuery Job User.
4. A je shafin Mabuɗai na sabon asusun sabis, a danna Ƙara mabuɗi → Ƙirƙiri sabon mabuɗi, a zaɓi JSON.
5. A buɗe dashboard na MousePlayer, a je Gidajen yanar gizo → Saituna → BigQuery, a manna GCP Project ID, Dataset ID, imel na asusun sabis, da abin da ke cikin mabuɗin JSON.