Extracts CreativeX score and URL from DAM master metadata during the B1→B2 download, persists to creativex_scores with new status 'b1-master-cx-score' (dedup by tracking_id), and surfaces the score in the b1_to_b2_complete and b1_to_b2_partial emails — falling back to "No CreativeX Score" when the master has no score yet. Skipped already-downloaded assets backfill from full_metadata JSONB on next pass. Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com> |
||
|---|---|---|
| .. | ||
| 002_add_campaign_status_table.sql | ||
| 003_add_a1_retry_tracking.sql | ||
| 004_add_global_master_tracking_id.sql | ||
| 005_document_b1_master_cx_score_status.sql | ||