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

How to upload transaction data to Google BigQuery?

As a CRM data source, you need to use a Google BigQuery data table.

Fields marked with * are required to be filled in.

All other fields must be present in the table, but you can leave them empty.

Field Data type Description
user_id* STRING User ID
client_id STRING Online visitor ID
user_phone STRING User phone number
user_email STRING User email address
transaction_id* STRING Transaction ID
transaction_status* STRING Transaction status: completed, refunded, canceled, pending, in_process, awaiting_fulfillment, awaiting_shipment or awaiting_pickup.
*In an attribution model, only the transactions with the completed status will count.
transaction_responsible STRING ID of a manager or operator who processes the transaction
transaction_coupon STRING Promo code
transaction_discount FLOAT Discount in currency 
transaction_revenue* FLOAT Transaction revenue for an individual product, excluding discounts.
Calculated by the formula product_price*product_quantity
transaction_currency STRING Currency
transaction_payment_type STRING Payment method
transaction_delivery_type STRING Delivery method
transaction_delivery_service STRING Delivery service used
transaction_delivery_time INTEGER Delivery time in days
transaction_touchpoint STRING Transaction source. For example, a website, a call center, or an offline store
transaction_store_id STRING Store ID
transaction_city STRING City
transaction_region STRING Region
transaction_country STRING Country
transaction_created* TIMESTAMP The time when the transaction was created
transaction_changed TIMESTAMP The time of last transaction update
product_id STRING Product ID
product_name STRING Product name
product_category STRING Product category
product_groupcategory1 STRING Level 1 category
product_groupcategory2 STRING Level 2 category
product_groupcategory3 STRING Level 3 category
product_brand STRING Product brand
product_cogs FLOAT Product COGS in the % of its price. For example, 0.4 or 0.15
product_quantity INTEGER The quantity of products in the transaction
product_price FLOAT Product price
promo_name STRING Promotion name
promo_start TIMESTAMP Promotion start time
promo_end TIMESTAMP Promotion end time


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


Please sign in to leave a comment.