Try out all OWOX BI features with a trial period Start for free

Read also: How to upload your data to Google BigQuery

Custom events are events from CRM, call tracking systems, and any other online and offline sources you have gathered in a Google BigQuery table yourself.

To add custom events to your reports, you need to connect to your Smart Data source set a table with the following structure:

Field name Data type Description
name STRING Event name (user action)
category STRING Event category
time TIMESTAMP Event time
user_id STRING User ID of the user who initiated the event
client_id STRING Client ID from Google Analytics
transaction_id STRING Transaction identifier
revenue FLOAT Revenue from the event that led to the conversion
cost FLOAT Event cost
utm_source STRING Event source
utm_medium STRING Event medium
utm_campaign STRING Event campaign
utm_term STRING The search term that led to the event
utm_content STRING Content of the link that led to the event
geo_region STRING The region where the event happened

 

The fields highlighted in bold are required to fill in. The utm_term and utm_content fields are optional, so you may add them to the table if you need to consider these utm tags. The rest of the fields must be present in the schema, but you can leave them empty.

Note:In a Smart Data source set, you can unite the data from BigQuery datasets located in a single multi-regional location only.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.