- Home
- Skills
- Marketing & SEO
- Yandex Direct placement CSV audit
Yandex Direct placement CSV audit
Audit a local placement CSV with an offline Python calculator. Reconcile spend, CPC and CPA; explain manual-review candidates without changing campaigns.
Free
Works with the AI Agents you already use
Yandex Direct placement CSV audit
Example session with this skill installed
Read this skill's SKILL.md. Run its offline doctor and synthetic placement audit with max CPA 1000. Reconcile the totals and explain each manual-review reason. Do not connect an ad account, change a campaign or call educational conversions real leads. If you cannot execute the Python files locally, report that requirement instead of guessing output.
- Read your context and instructions
- Compiled the yandex direct placement
Executed local example — synthetic data
The bundled calculator ran locally. The synthetic CSV is an included input fixture, not a generated deliverable. No advertising account was connected or changed.
python3 -B direct_report_audit.py --json doctor
{"ok":true,"command":"doctor","result":{"version":"0.1.0","python":"3.9.6","offline":true,"auth_required":false,"network":false,"runtime_dependencies":"Python standard library only"}}
The audit used the bundled synthetic placement fixture with max CPA set to 1000 and the other default thresholds. The exact command is in the included SKILL.md.
Complete calculator output, formatted for readability:
{
"ok": true,
"command": "audit",
"result": {
"schema_version": 1,
"input": {"rows": 5, "placements": 4, "delimiter": "semicolon", "synthetic": true},
"currency": "RUB",
"thresholds": {"min_clicks": 20, "min_cost": "1000", "max_cpa": "1000", "min_conversions": "1"},
"totals": {"impressions": 4550, "clicks": 97, "cost": "6000", "conversions": "5", "cpc": "61.86", "cpa": "1200.00"},
"placements": [
{"placement": "costly.example.invalid", "source_rows": 1, "impressions": 1000, "clicks": 25, "cost": "2500", "conversions": "1", "cpc": "100.00", "cpa": "2500.00", "manual_review": true, "reasons": ["cpa_above_threshold"]},
{"placement": "example.invalid", "source_rows": 2, "impressions": 1500, "clicks": 30, "cost": "1800", "conversions": "0", "cpc": "60.00", "cpa": null, "manual_review": true, "reasons": ["zero_conversion_spend"]},
{"placement": "quality.example.invalid", "source_rows": 1, "impressions": 2000, "clicks": 40, "cost": "1600", "conversions": "4", "cpc": "40.00", "cpa": "400.00", "manual_review": false, "reasons": []},
{"placement": "small.example.invalid", "source_rows": 1, "impressions": 50, "clicks": 2, "cost": "100", "conversions": "0", "cpc": "50.00", "cpa": null, "manual_review": false, "reasons": []}
],
"candidate_count": 2,
"limitations": [
"Candidates are for manual review, not a blocklist or evidence of waste.",
"Check attribution lag, tracking, report period, conversions, and downstream lead quality.",
"No API calls, campaign changes, automatic exclusions, or savings estimates."
]
}
}
The repeated rows for example.invalid aggregate before threshold checks. It and costly.example.invalid are review candidates; the tool has not established waste or a ready exclusion list. Before using an authorized real report, check its period, currency, chosen goal, attribution lag and downstream lead quality. Every record above is invented educational data.
Connects securely to your tools. The creator never sees your data.
About this skill
This free skill helps a coding agent audit a normalized Yandex Direct placement CSV/TSV using a bundled Python CLI. It aggregates repeated placement rows before threshold checks, computes totals with decimal arithmetic and explains why a placement needs manual review.
Start without an ad account: the included synthetic CSV produces cost 6,000 RUB, 97 clicks, five conversions and two review candidates under the example thresholds. The package includes the calculator, exact input contract and 25 original tests. These are educational records, not advertiser results.
Use your own authorized local report only after checking its period, currency units and conversion definition. CPC and CPA use summed values; a zero denominator returns null. Invalid rows and total/summary rows fail rather than silently changing the result.
Requires Python 3.9+ and an agent that can read local skill files and execute commands. Chat-only agents cannot run the calculator. No credentials, API connection, network calls, telemetry, campaign edits or automatic exclusions. Review flags are not a blocklist, proof of waste or savings estimates.
Author: Дмитрий Лукашов (Dmitry Lukashov). Free public source: https://github.com/ilookatshow-gif/direct-report-audit Website: https://lookatshow.ru/ Author's channel: https://t.me/lookatsoul
MIT-licensed standalone package. This Agensi adaptation preserves the public calculator's arithmetic and tests, adds a root SKILL.md and uses neutral optional author attribution. It is not an MCP server, a live advertising connector or an official Yandex product. Autonomous AI agents prepared and tested this adaptation.
Normalized five-column UTF-8 CSV/TSV only, maximum 25 MB and 100,000 data rows. Confirm period, currency and conversion definition; cost is currency units, not API micros. Explicit thresholds flag manual-review candidates, not waste or automatic exclusions. Attribution lag and lead quality remain unknown. Requires local Python execution; not a chat-only skill or MCP server. Synthetic examples are not advertiser outcomes.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
1 use
Times used to date
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed 1 month ago
- Free with an Agensi account
Permissions
Read only bundled files and the exact report supplied by the user; execute local Python 3.9+. Optional file writes only: selected project-local installation or one-time onboarding marker. Audit itself does not write. No network services, account credentials, uploads, telemetry, campaign edits or outgoing messages.