mass-update-pear-pixels

What problem does it solve?

Manually updating tracking pixels across hundreds of Pear offers is time-consuming, error-prone, and risky for live production data, with high potential for duplicate entries, incorrect scoping, or broken tracking for active campaigns.

Core Features & Use Cases

• Idempotent Bulk Pixel Updates: Safely add, append, replace, or remove Meta, GTM, TikTok, Trade Desk and other tracking pixels across offers scoped by vendor ID and offer type, with exact-token guards to prevent duplicate entries.
• Production-Grade Guardrails: Built-in protections against common pitfalls including unreliable OfferDOMInsertions.vendorId fields, delayed Metabase replica data, duplicate DOM rows, and JSP compiler limitations.
• Full Audit & Verification: Generates S3-backed change logs of all updated offer IDs and sections changed, with mandatory verification against live primary production data post-run to confirm updates took effect.
• Use Case: A marketing operations user needs to roll out a new Meta conversion pixel to all US retail offers for a specific brand, and can use this skill to preview the exact target offer list, get stakeholder approval, and execute the update with zero risk of duplicate pixels or incorrect scoping.

Quick Start

Use this skill by asking the AI to mass-update tracking pixels for a specific brand's offers, confirm the preview of exact target offer IDs, and approve the production write operation.