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 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 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

0 Comments

Please sign in to leave a comment.