What is taxonomy-updater?

This Claude skill automates the generation of campaign-level taxonomy CSV files for Google Ads, specifically designed for accounts with mixed verticals. It streamlines budget attribution and vertical classification by identifying missing mappings and ensuring data consistency for marketing ingestion and reporting.

When should I use taxonomy-updater?

taxonomy-updater is useful in the following scenarios: • Identifying Google Ads campaigns that lack proper taxonomy mapping or have incorrect vertical attribution within marketing databases. • Detecting vertical mismatches in complex accounts containing multiple business lines such as buying, renting, or selling to ensure accurate budget tracking. • Generating standardized, headerless CSV files for bulk taxonomy updates, automating the transition from raw SQL campaign data to ingestion-ready formats. • Mapping Google Ads campaigns to specific media types and budget IDs (e.g., SEM, Brand Digital) based on campaign names and performance characteristics.

name	taxonomy-updater
description	Generate campaign taxonomy CSV updates for Google Ads campaigns. Use when identifying campaigns that need taxonomy mapping, detecting vertical mismatches in mixed-vertical accounts, or creating properly formatted taxonomy CSV files for ingestion. Triggers on requests involving campaign taxonomy, budget attribution, vertical classification, or taxonomy CSV generation.

Taxonomy Updater

Generate campaign-level taxonomy entries for Google Ads accounts with mixed verticals.

Workflow

Identify campaigns needing taxonomy - Query campaign data to find campaigns missing from taxonomy or with incorrect vertical attribution
Check for vertical mixing - Determine if account has campaigns across multiple verticals (buy, rent, sell, new_construction, etc.)
Generate taxonomy CSV - Create properly formatted CSV with all required fields

Key Tables

-- Taxonomy reference
SELECT * FROM rdc_marketing.team_digital_marketing.taxonomy_hist;

-- Google campaign data
SELECT * FROM fivetran_martech.raw_google_campaign.campaign;

Detecting Mixed-Vertical Accounts

-- Check if account has multiple verticals
SELECT 
    CASE 
        WHEN LOWER(NAME) LIKE '%_buy_%' OR LOWER(NAME) LIKE '%for sale%' THEN 'buy'
        WHEN LOWER(NAME) LIKE '%rental%' THEN 'rent'
        WHEN LOWER(NAME) LIKE '%newcon%' THEN 'new_construction'
        WHEN LOWER(NAME) LIKE '%sell%' THEN 'sell'
        ELSE 'unknown'
    END as inferred_vertical,
    COUNT(DISTINCT ID) as campaign_count
FROM fivetran_martech.raw_google_campaign.campaign
WHERE CUSTOMER_ID = <account_id>
  AND DATE >= DATEADD(month, -3, CURRENT_DATE)
GROUP BY 1;

If multiple verticals exist, campaign-level taxonomy entries are required.

Getting Campaign Start Dates

SELECT 
    CAST(ID AS VARCHAR) as campaign_id,
    NAME,
    MIN(DATE) as first_active_date
FROM fivetran_martech.raw_google_campaign.campaign
WHERE CUSTOMER_ID = <account_id>
GROUP BY ID, NAME;

CSV Output Format

Generate CSV without headers. Fields in order:

Field	Description
start_date	First active date of campaign (YYYY-MM-DD)
end_date	Leave empty for active campaigns
mapping_id	Format: `_<account_id>_<campaign_id>_`
account_id	Google Ads customer ID
campaign_id	Google Ads campaign ID
ad_group_id	Leave empty for campaign-level
channel	See allowed values
tactic	See allowed values
partner	See allowed values
media_type	See allowed values
budget_name	See allowed values
budget_id	See allowed values
target_platform	web or app
target_customer	b2c or b2b
target_audience	new, existing, or both
target_vertical	buy, rent, sell, new_construction, mortgage, mixed

Allowed Values Reference

See references/allowed-values.md for complete list of valid taxonomy field values.

Media Type Selection

PMax campaigns: Use mixed
Search/DSA campaigns: Use search
Display campaigns: Use display_static or display_video

Common Budget Mappings

budget_name	budget_id	Use for
sem	721000	Paid search campaigns
rentals	210	Rentals vertical campaigns
brand_digital	750001	Brand awareness campaigns
retargeting_display	720001	Retargeting campaigns

taxonomy-updater

When & Why to Use This Skill

Use Cases