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