PPC & Ad Transformations

Format your data for Google Ads, Facebook Ads, and other advertising platforms.

PPC platforms have strict character limits. These transformations ensure your ad copy fits within platform requirements while maintaining readability.

Google Ads Character Limits

Headline

Description

Path Field

Sitelink Text

Headline (30 chars)#

Truncate text to 30 characters at the nearest word boundary for Google Ads headlines. Returns null if a single word exceeds the limit.

Before

Buy Premium Quality Products Now!
Free Shipping on All Orders Today
Sale
Supercalifragilisticexpialidocious

After

Buy Premium Quality Products
Free Shipping on All Orders
Sale
null (single word exceeds limit)

How It Works

If text is ≤ 30 characters → return as-is
Find the last space within the first 30 characters
If space found → truncate at that position (no mid-word cuts)
If no space found (single long word) → return null

Why null Instead of Cutting?

A hard-cut word like "Supercalifragilisticexpialido" is useless for ads—it looks unprofessional and would likely be rejected by Google anyway. Returning null flags these rows for human review.

Description (90 chars)#

Truncate text to 90 characters at the nearest word boundary for Google Ads descriptions. Same logic as headline—returns null for single words exceeding the limit.

Before (120 chars)

Shop our amazing selection of premium products. Free shipping on orders over $50. Limited time offer - don't miss out!

After (87 chars)

Shop our amazing selection of premium products. Free shipping on orders over $50.

Keyword Clean#

Clean and normalize keywords for PPC campaigns. Removes special characters, extra spaces, and converts to lowercase.

Before

Buy NOW!! Best Price $$$
  Shop   Online  Today
Men's T-Shirts (Large)
"Premium" Quality — Guaranteed!

After

buy now best price
shop online today
mens tshirts large
premium quality guaranteed

Use Case

Perfect for preparing keyword lists for Google Ads, negative keyword lists, or keyword research. Clean keywords match better and avoid duplicates caused by punctuation differences.

Practical Examples#

Here's how these transformations work on real product data:

Original Product Name	headline_30	description_90
Premium Wireless Bluetooth Headphones	Premium Wireless Bluetooth	Premium Wireless Bluetooth Headphones
iPhone 15 Pro Max 256GB Titanium Blue	iPhone 15 Pro Max 256GB	iPhone 15 Pro Max 256GB Titanium Blue
Sale	Sale	Sale
Antidisestablishmentarianism	null	Antidisestablishmentarianism

Bulk Processing Workflow#

Here's a typical workflow for preparing ad copy from a product feed:

Upload Product CSV

Upload your product feed with columns like name, description, price

Configure Column Rules

Set headline_30 for product names, description_90 for descriptions

Review Invalid Rows

Check rows where transformation returned null—these need manual attention

Export for Ads

Download the cleaned CSV or use the API to fetch formatted data for your campaigns

Facebook Ads Limits#

While our transformations are optimized for Google Ads, they work well for Facebook too:

Facebook Ad Element	Character Limit	Suggested Transformation
Primary Text	125 (recommended)	`description_90` or custom
Headline	40	`headline_30` (fits within limit)
Link Description	30	`headline_30`

API Usage#

Apply PPC transformations via the API when configuring your project columns.

API Example

// Set normalization rule for a column
PUT /api/projects/:id/columns/:columnId

{
  "normalization_rule": "ppc_headline_30"
}

// Available PPC rules:
// - ppc_headline_30   (Google Ads Headline)
// - ppc_description_90 (Google Ads Description)
// - ppc_keyword_clean  (Keyword normalization)

Bulk Processing

These transformations work on entire columns at once. Upload your product feed or ad copy spreadsheet and apply transformations to prepare data for your campaigns.

SEO Transformations Duplicate Detection