Tables
Streamed data is separated into tables by days, according to your Competera scans settings.
Tables naming is 'Competera.products_scans_YYYYMMDD'.
Rows
Each product is written to a separate row.
Columns
The columns within the table are listed below.
Google BigQuery alias | Google BigQuery data type | Description |
---|---|---|
competera | RECORD | |
competera.product_id | INTEGER | |
competera.target_id | INTEGER | |
competera.target_tracking_id | INTEGER | |
competera.campaign_id | INTEGER | |
competera.category_id | INTEGER | |
competera.product_tracking_id | INTEGER | |
product | RECORD | |
product.sku | STRING | |
product.category | STRING | |
product.tags | STRING | |
product.variant | STRING | |
product.title | STRING | |
product.scan | RECORD | |
product.scan.in_stock | BOOLEAN | |
product.scan.promotion | BOOLEAN | |
product.scan.title | STRING | |
product.scan.url | STRING | |
product.scan.timestamp | TIMESTAMP | |
product.scan.price | FLOAT | |
product.scan.availability | STRING | |
product.scan.promotion_text | STRING | |
target | RECORD | |
target.name | STRING | |
target.scan | RECORD | |
target.scan.in_stock | BOOLEAN | |
target.scan.warning | STRING | |
target.scan.title | STRING | |
target.scan.url | STRING | |
target.scan.timestamp | TIMESTAMP | |
target.scan.price | FLOAT | |
target.scan.error | STRING | |
target.scan.availability | STRING | |
target.scan.promotion | BOOLEAN | |
target.scan.promotion_text | STRING |
0 Comments