From google-ads
Track product returns and refunds to measure true ROAS.
npx claudepluginhub trueclicks/claude-plugins --plugin google-adsThis skill is limited to using the following tools:
Track product returns and refunds to measure true ROAS. Without return data, reported ROAS overstates actual business performance by 10-30% depending on return rates.
Guides Payload CMS config (payload.config.ts), collections, fields, hooks, access control, APIs. Debugs validation errors, security, relationships, queries, transactions, hook behavior.
Builds scalable data pipelines, modern data warehouses, and real-time streaming architectures using Spark, dbt, Airflow, Kafka, and cloud platforms like Snowflake, BigQuery.
Builds production Apache Airflow DAGs with best practices for operators, sensors, testing, and deployment. For data pipelines, workflow orchestration, and batch job scheduling.
Track product returns and refunds to measure true ROAS. Without return data, reported ROAS overstates actual business performance by 10-30% depending on return rates.
Data Source: Custom GAQL Required
GAQL Query:
SELECT
conversion_action.name,
conversion_action.type,
conversion_action.category,
conversion_action.status,
conversion_action.value_settings.default_value,
conversion_action.value_settings.always_use_default_value
FROM conversion_action
WHERE conversion_action.status = 'ENABLED'
AND conversion_action.category IN ('PURCHASE', 'CONVERTED_LEAD')
Run via /google-ads:get-custom to analyze conversion value patterns.
Note: Return tracking requires e-commerce system integration - full audit needs access to OMS/CRM.
| Condition | Severity |
|---|---|
| E-commerce with no return tracking | Critical |
| High return rate industry (apparel) without adjustment | Critical |
| Return data not synced to Google Ads | Warning |
| GCLID not captured for return attribution | Warning |
Short (default):
## Return/Refund Tracking Audit
**Account:** [name] | **Industry Return Rate:** ~[X]% | **Return Tracking:** [Yes/No]
### Critical
- **No return tracking implemented** - Reported ROAS ~[X]% overstated
### Warnings
- **GCLID not captured** - Cannot attribute returns to campaigns
### Recommendations
1. Capture GCLID with order in CRM/OMS
2. Implement conversion value adjustments for returns
3. Or apply [X]% return rate reduction to values immediately
Detailed adds: