skills.rest
writer
writerOFFICIAL
Explore all skills by this author →
WebsiteGitHub

trade-spend-roi-analyzer

Analyze trade spend ROI and promotional effectiveness for CPG programs.

6|5|Updated Feb 4, 2026
Search Tags:#roi analysis#budget optimization#sales analysis#trade spend#cpg#promotional effectiveness
One-click install
npx skills add https://github.com/writer/skills --skill trade-spend-roi-analyzer-writer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: trade-spend-roi-analyzer
Source: https://github.com/writer/skills/tree/main/skills/trade-spend-roi-analyzer
Command: npx skills add https://github.com/writer/skills --skill trade-spend-roi-analyzer-writer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill helps CPG brands rigorously analyze the effectiveness and ROI of their trade spend, identifying waste and optimizing promotional investments to drive profitable growth.

Core Features & Use Cases

  • Trade Spend Analysis: Deconstructs trade spend into components and calculates true incremental ROI.
  • Promotional Effectiveness: Scores promotions based on lift, ROI, and post-promo impact.
  • Optimization Recommendations: Identifies opportunities to reallocate spend for maximum return.
  • Use Case: A brand manager needs to understand why a recent BOGO promotion underperformed and wants recommendations for future trade events to improve profitability.

Quick Start

Analyze my trade spend roi and recommend clear next actions.

Frequently Asked Questions about trade-spend-roi-analyzer

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

FAQPage Schema
How do I calculate incremental ROI for CPG trade spend?▼

To calculate incremental ROI for CPG trade spend, you need baseline sales, promoted sales, COGS, and trade spend inputs to measure true promotional lift and profitability.

How do I analyze promotional effectiveness for CPG retailer investments?▼

Promotional effectiveness is analyzed by scoring events based on sales lift, incremental ROI, and post-promo impact to determine if CPG retailer investments are profitable.

What is the best way to optimize CPG trade spend budget and identify waste?▼

The best way to optimize CPG trade spend is by decomposing spend into drivers and calculating true incremental ROI to identify waste and reallocate budget for maximum return.

Why does my BOGO promotion underperform and how can I improve future trade events?▼

A BOGO promotion underperforms when promotional lift fails to offset trade spend costs, requiring a P&L waterfall analysis to adjust future trade events for better profitability.

Can I perform a P&L waterfall analysis for CPG promotional programs?▼

Yes, you can perform a comprehensive P&L waterfall analysis for CPG promotional programs by utilizing detailed trade spend, baseline sales, event calendar, and COGS inputs.

What inputs do I need to measure trade spend impact and post-promo effects?▼

You need detailed trade spend, baseline sales, promoted sales, COGS, and event calendar inputs to accurately measure trade spend impact and post-promo effects.

Related Skills

Explore More Finance & Accounting Skills→
feed-mobfeed-mob
3

direct-spend-visualizer

Visualize FeedMob direct spend data as ASCII line charts.

Official
Basic
rajyeole6rajyeole6

agency-finance-tracker

Automate budget management, cash flow forecasting, and investment analysis with pandas, numpy, and scipy.

Community
Advanced
smith6jt-copsmith6jt-cop
3

dashboard-pnl-visualization

Visualize realized and unrealized P&L with cost accounting for Python trading dashboards.

Community
Intermediate
GoldenZeroGoldenZero
1

trade-spend-roi-analyzer

Analyze trade spend ROI and effectiveness across CPG promotional programs.

Community
Advanced