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