Google Merchant Center -> BigQuery. Wrong quantity of products by custom label

Google Cloud Data Analytics
,
1

Hello, I have a problem with data in BigQuery.

I have counted how many products had custom label X yesterday, and there are huge differences in quantities between BigQuery and Merchant Center. For example in Merchant Center I have 500 products that has custom label 2 = X, but in BigQuery only 300 products. Could you please help me find a solution? I need the same data. That label updates every day in Merchant Center. Below is the SQL I use to count:

Select custom_labels.label_2, count(product_id) from Merchant.Products

Where

DATE(product_data_timestamp) = DATE_SUB(CURRENT_DATE(), INTERVAL 2 DAY)

group by custom_labels.label_2

2

Hi @Wladz ,

Welcome to Google Cloud Community!

Regarding your issue, there could be a delay in the data updates between Merchant Center and BigQuery. The data in the Merchant Center might not be immediately available in BigQuery. Allow some time for the data to synchronize between Merchant Center and BigQuery. Additionally, you can check specific timestamps and confirm that your query is targeting the intended day.

But if you have further questions about the behavior of the data, I suggest you contact Merchant Support.

I hope the above information is helpful.