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