creative_refresh_log_v2

Full reference: paidteam-data-warehouse.customer_ads_suse.creative_refresh_log_v2Type: Logging | Rows: 48 | Size: < 0.1 MB

Creative refresh script execution log. Tracks all staging-to-final creative MERGE operations including row counts for matched (updated), inserted (new), and total rows. Essential for monitoring creative pipeline health.

Schema

Column	Type	Nullable	Description
run_id	STRING	Yes	Unique identifier for the creative refresh run
run_timestamp	TIMESTAMP	Yes	Timestamp when the MERGE operation was executed
platform	STRING	Yes	Platform name (linkedin, reddit, etc.)
staging_rows	INTEGER	Yes	Number of rows in the creative staging table
rows_matched	INTEGER	Yes	Number of existing rows updated (WHEN MATCHED)
rows_inserted	INTEGER	Yes	Number of new rows inserted (WHEN NOT MATCHED)
final_total_rows	INTEGER	Yes	Total row count in the creative final table after MERGE
status	STRING	Yes	Execution status: SUCCESS or ERROR
details	STRING	Yes	Additional details or error message

Partitioning & Clustering

• Partitioned by: None
• Clustering: None

Usage

Check Recent Creative Refresh Status

SELECT *
FROM `paidteam-data-warehouse.customer_ads_suse.creative_refresh_log_v2`
WHERE run_timestamp >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 24 HOUR)
ORDER BY run_timestamp DESC;

Track Creative Growth Over Time

SELECT
  platform,
  run_timestamp,
  staging_rows,
  rows_matched,
  rows_inserted,
  final_total_rows
FROM `paidteam-data-warehouse.customer_ads_suse.creative_refresh_log_v2`
WHERE status = 'SUCCESS'
ORDER BY run_timestamp DESC
LIMIT 30;

Identify Creative Refresh Failures

SELECT
  run_timestamp,
  platform,
  status,
  details
FROM `paidteam-data-warehouse.customer_ads_suse.creative_refresh_log_v2`
WHERE status = 'ERROR'
ORDER BY run_timestamp DESC;

Notes

• Each execution of the creative refresh script generates one row per platform that has creative tables (currently LinkedIn and Reddit).
• rows_matched indicates how many existing creatives were updated with new metadata. A high match count with zero inserts means no new creatives were found.
• rows_inserted indicates truly new creatives that were not previously in the final table.
• final_total_rows is the total count after the MERGE completes. This number should only grow over time (or stay constant) since the MERGE does not delete rows.
• The creative refresh script is separate from the adlevel refresh script and runs on its own schedule.
• The run_id links all platform entries from the same script execution.