Yandex Direct placement CSV audit

    1

    Audit a local placement CSV with an offline Python calculator. Reconcile spend, CPC and CPA; explain manual-review candidates without changing campaigns.

    Free

    1 useSecurity scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    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.

    thresholds. The exact command is in the included SKILL.md

    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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 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

    Terminal / Shell
    Read Files
    Write Files

    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.

    Listed1 month ago

    What's inside

    Frequently Asked Questions

    No. It runs an offline calculator on a selected normalized CSV/TSV. It does not connect an advertising account, change campaigns, exclude placements or establish wasted spend. Review flags require business context.

    Python 3.9+ and a coding agent with local files and command execution. The MIT package includes the calculator and synthetic input; no ad account, API key, purchase or paid core is needed. Chat-only interfaces cannot execute the CLI.

    New in Marketing & SEO