skills.rest
OliverOuyang
OliverOuyangCOMMUNITY
Explore all skills by this author →
GitHub

rta-exclude-strategy

Generate RTA exclusion strategies for V8 and V9RN cross-model datasets.

1|Updated Apr 1, 2026
Search Tags:#automation#excel-report#v8#heatmap#rta#exclusion-strategy#v9rn
One-click install
npx skills add https://github.com/OliverOuyang/shuhe-work-skills --skill rta-exclude-strategy
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: rta-exclude-strategy
Source: https://github.com/OliverOuyang/shuhe-work-skills/tree/main/skills/rta-exclude-strategy
Command: npx skills add https://github.com/OliverOuyang/shuhe-work-skills --skill rta-exclude-strategy

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, numpy, openpyxl, and includes scripts (resource) components.

What problem does it solve?

Automates the identification and generation of RTA (Real-Time Advertising) exclusion strategies by combining V8 and V9RN model cross-analysis so data teams can quickly remove low-quality segments while controlling business impact.

Core Features & Use Cases

  • End-to-end analysis pipeline: data loading, cleaning, model-group aggregation, and validation of required fields (V8/V9RN, group, expo_cnt, cost, t3_ato, t3_safe_adt, t3_loan_amt).
  • Intelligent place-in/place-out algorithm: initial selection by V9RN, rectangle-based place-in from the bottom-right, place-out from the top-right, constraint validation and threshold adjustment to respect max-exclude limits.
  • Enterprise reporting: generates Excel and interactive HTML reports with heatmaps, cross-tables, and comparison charts for strategy evaluation and operational handoff.

Quick Start

Run the rta-exclude-strategy skill to analyze experiment_data.csv using ctrl as the control group and save Excel and HTML reports to ./reports.

Frequently Asked Questions about rta-exclude-strategy

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate RTA exclusion strategy generation for V8 and V9RN cross-model datasets?▼

Automate RTA exclusion strategy generation by loading experiment and control group data to apply an intelligent place-in/place-out algorithm, producing Excel and HTML reports with heatmap visualizations for advertising optimization.

What input columns are required for V8 and V9RN cross-model advertising exclusion analysis?▼

V8 and V9RN cross-model advertising exclusion analysis requires CSV or Excel input files containing V8/V9RN, group, expo_cnt, cost, t3_ato, t3_safe_adt, and t3_loan_amt columns to validate data and aggregate model-group metrics.

How does the place-in and place-out algorithm handle max-exclude constraints for RTA strategies?▼

The place-in and place-out algorithm handles max-exclude constraints by selecting segments from bottom-right and top-right rectangles, then performing constraint validation and threshold adjustment to control business impact.

Can I generate Excel heatmap reports for periodic advertising strategy evaluation using Python?▼

You can generate Excel heatmap reports for periodic advertising strategy evaluation using Python with pandas and openpyxl, producing interactive HTML and Excel outputs containing cross-tables and comparison charts.

What is the best way to evaluate model upgrade impact using experiment and control group data?▼

Evaluate model upgrade impact by running cross-analysis on experiment and control group data to identify low-quality segments, enforcing SPR and max-exclude constraints to safely optimize advertising strategies.

Does the RTA exclusion analysis support both CSV and Excel input formats?▼

RTA exclusion analysis supports both CSV and Excel input formats for loading experiment and control group data, requiring pandas, numpy, and openpyxl dependencies to process and generate the final HTML and Excel reports.

Related Skills

Explore More Data & Analytics Skills→
aiyinluyaaiyinluya
2

category-filtering-and-difficulty-analysis

Analyzes Excel categories and computes multidimensional difficulty scores from text signals.

Community
Intermediate
aiyinluyaaiyinluya
2

pivot-table-cross-analysis

Clean merged-cell Excel data and generate pandas crosstabs with Seaborn heatmaps.

Community
Intermediate
MichaelYang-lyxMichaelYang-lyx
110

group-by-analysis

Group multi-sheet Excel data into styled summary reports with charts.

Community
Intermediate
georgekhananaevgeorgekhananaev
27

next-upgrade

Detect Next.js versions, apply codemods, and update dependencies for major upgrades.

Community
Advanced