BAPA02 Bronze to Silver Enrich Sentiment

☝️ CONFIGURE BIGQUERY by adding your credentials here. Creates a silver enrichment table with these columns, which supports multiple LLMs.

👈 ADD YOUR BRAND HERE by adding a simplified description of your brand search terms. This is for reporting only (not the exact search conditions in the prompt).

👇 CONFIGURE YOUR GEMINI CREDENTIALS HERE or swap for your preferred LLM to perform the enrichment.

👇 CONFIGURE BIGQUERY by adding your credentials here. Reads bronze rows that have not already been previously enriched by this workflow. Processes rows from multiple LLMs (if present).

☝️ CONFIGURE ENRICHMENT rules here by configuring it with your brand search terms. All enrichments like brand presence, ranking and sentiment are defined here.