How to upload transaction data to Google BigQuery?

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

Fields highlighted in bold 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 Total transaction revenue including product price and additional services, excluding discounts
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?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.