| Table of Contents |
|---|
...
Click on the Create DataSet button. This is like creating a server within BigQuery to hold all the tables within your overall database.
...
If your screenshot looks like the one below, stop and go assign a billing account to the Google project so that you exist sandbox mode.
...
Configure the data set ID, configure it to never expire, and then click create dataset.
...
This query will show which experiment and variation each order went through (this requires screen recordings).
Orders For Specific Items Shipped By a User on a Specific Date
| Code Block |
|---|
SELECT distinct order_id
FROM `my-data-warehouse.my_dataset.ultracart_orders`
CROSS JOIN UNNEST(items) as i
WHERE DATE(TIMESTAMP(shipping.shipping_date), "America/New_York") = "2021-12-09"
and i.shipped_by_user = 'bob'
and i.merchant_item_id in (
'PRODUCT-A',
'PRODUCT-B'
) order by order_id |