From google-ads
Verify that offline conversion data is imported within 1-14 days of the lead event.
npx claudepluginhub trueclicks/claude-plugins --plugin google-adsThis skill is limited to using the following tools:
Verify that offline conversion data is imported timely. Stale offline data reduces its value for Smart Bidding optimization - fresh imports within 1-3 days maximize effectiveness.
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.
Verify that offline conversion data is imported timely. Stale offline data reduces its value for Smart Bidding optimization - fresh imports within 1-3 days maximize effectiveness.
Data Source: Custom GAQL Required
GAQL Query:
SELECT
segments.conversion_lag_bucket,
segments.conversion_action_name,
metrics.conversions,
metrics.conversions_value
FROM campaign
WHERE segments.date BETWEEN '{start_date}' AND '{end_date}'
Run via /google-ads:get-custom with query name offline_conversion_lag.
Standard Data:
data/account/conversion_actions.md - Identify offline conversion sources| Condition | Severity |
|---|---|
| Offline conversions >14 days after click | Critical |
| No automated import pipeline | Warning |
| All offline conversions import on same day (batched) | Warning |
| Import gaps or failures detected | Warning |
| Import lag 8-14 days | Info |
Short (default):
## Offline Conversion Freshness Audit
**Account:** [name] | **Offline Actions:** [count] | **Avg Lag:** [X days] | **Issues:** [count]
### Critical
- **[conversion] averaging [X] day import lag** - Smart Bidding signal degraded
### Warnings
- **Manual upload process** - Set up automated CRM sync
- **All imports on Mondays** - Batched, not real-time
### Recommendations
1. Implement daily automated import pipeline
2. Target 1-3 day import lag for maximum Smart Bidding value
3. Set up GCLID capture in CRM forms
Detailed adds: