Shelf Analysis with SWOT for a New Product Launch

(ChatGPT 5 Thinking + Photo Attached)

Copy/Paste the Below and Add in Brand and Retailer

Act as the Sales VP for XYZ Brand launching a new lineup of ABC products into the XYZ Retailer category section. The attached photo is the most recent planogram. Create a SWOT Analysis of the XYZ Brand category positioning and how best to leverage the incrementality of the brand in this Category. Be specific in your analysis. After completing the analysis, create a feasibility table that outlines the priorities, feasibility, revenue potential for the brand at XYZ Retailer for the XYZ Retailer Buyers benefit.

Negotiation Practice using Harvard Negotiation - Win/Win with objective metrics

(ChatGPT 5 Thinking Mode)

Copy/Paste the below and add in Brand and Retailer

I want to do deliberate practice about how to conduct negotiations. You will be my negotiation teacher.

Simulation Setup

You will simulate a detailed retailer buyer at XYZ Retailer HQ and seller from ABC  Corporation scenario in which I have to engage as Seller in a negotiation aimed at teaching me Harvard Negotiation Model. You will fill the role of the buyer, I will fill the role of the seller.

Process

You will ask for my response to in each step of the scenario and wait until you receive it. After getting my response, you will respond in character trying to make sure to focus on the learning objective.

Grading

When I say Give me a Grade you will provide a letter grade to my response so far and give me detailed feedback about what to do better using the science of negotiation.

Getting Started

To start you will say Ready and wait for me. When I say go you will start the negotiation. Describe the scenario and afterwards just speak in the role of the character until I say grade, provide a letter grade. Remember to wait for me to reply in each round. Don't expect me to make up details outside the scenario. Tell me what I need to know.

Social Listening for the latest four weeks on a Brand to inform Innovation and Marketing insights

(Perplexity.AI Pro – paid version with LABS Mode)

The AI summary information presented will be inferred and directionally helpful. 

Copy/Paste the below and enter the brand and Social Listening timeframe needed.

Act as the Innovation VP for the XYZ brand in the US Market. You are charged with developing the next level retail innovations to explode the brand growth. In scope are new product categories, new retail channels and ecommerce breakthroughs to be launched in the next 12-24 months. Create this innovation pipeline by doing social listening across X, Reddit, Instagram and Product Hunt from the latest four weeks. After studying these insights create 10 new growth concepts that blend product launch categories and new retail experiences in both physical and digital arenas. Put these concepts into a table with concept description, detailed execution, feasibility difficulty, size of revenue potential.

Social Media Creative for a Brand based on Social listening latest two weeks. Creation of X/Twitter and Tik Toc creative to post this week based on these insights

(Use ChatGPT 5 Thinking + Search tool on)

Copy/Paste the below into ChatGPT 5 Thinking and turn on the “Search” mode in the chatbar. Replace Example Brand with your brand and website and other elements between the [Abc].

As a creative AI, reference Example Brand's website at [brand website domain], showcasing innovative [product category] concepts like [example product 1] and [example product 2], emphasizing customer experiences and global expansion. Use social listening from the last two weeks, noting trends in video dominance, cultural fluency, and micro-virality on TikTok and X/Twitter, with spikes in [relevant category]-related content like #globalpicks and seasonal [theme] crossovers (e.g., summer vibes in #lovemyhome). Generate two 100-word social media posts: one for TikTok (dynamic, trend-jacking with fun visuals and sounds) highlighting innovative product pairings for [current season], and one for X/Twitter (informative threads or polls for engagement) discussing seasonal trends and consumer insights. Keep posts relatable, promotional, and tailored to CPG strategies for boosting brand loyalty in [brand sector].

Creating a Infographic of Weekly Sales

(ChatGPT 5 + Image Creation tool selected)

Copy/Paste the below with your data and colors replacing those in the Prompt:

As an alternative, you could “attach” a dashboard worksheet from Excel and ChatGPT will read that as well.

Create a vibrant infographic for a retailer's email from a CPG brand, using a colorful comparative layout with pie charts in shades of orange, yellow, and purple. Visualize data from the weekly sales dashboard: Overall sales reached $150,000 with 12% weekly growth and 8% YoY increase; breakdown by category with Beverages at 40%, Snacks at 30%, Supplements at 20%, and Others at 10%. Include pie charts for category shares, icon illustrations for each product type (like a soda can for beverages), a donut chart for growth metrics, and motivational callouts like 'Strong Growth Ahead!'. Title it 'Exciting Weekly Sales Update - August 2025' at the top, with space for a brand tagline at the bottom. Ensure it's square-shaped, engaging, and optimized for quick viewing.

Analysis:  Regression Analysis on a Brands Sales and Promotion impact  from the prior week

(ChatGPT 5 + Agent Mode)

This is effective with simple spreadsheets.  Not with imbedded pivot tables in the spreadsheet.

Copy/Paste the below and attach your worksheet under 15 Meg in size with Sales, ACV, Promotion Pricing.

TASK: Perform regression analysis on Excel data and create updated worksheets with results

INSTRUCTIONS:

1. Load the Excel file and identify all numeric columns suitable for regression analysis

2. Perform multiple regression analyses between key variables:

   - Sales vs Units Sold

   - ACV Reach vs Number of Stores

   - Average Unit Price vs Sales Performance

   - Promotional Activity vs Sales Growth

3. Create new Excel worksheets with:

   - Sheet 1: "Original_Data" - cleaned and formatted original data

   - Sheet 2: "Regression_Results" - table with equations, R², slopes, intercepts

   - Sheet 3: "Predicted_Values" - original data + predicted values for each regression

   - Sheet 4: "Residual_Analysis" - residuals and statistical diagnostics

4. Format all worksheets with:

   - Professional headers and styling

   - Conditional formatting for significant correlations (R² > 0.5)

   - Color-coded cells (green for positive trends, red for negative)

   - Auto-fit columns and freeze header rows

OUTPUT: Return the file path of the new Excel workbook with all analysis sheets

Meeting Summary from MS Teams or Zoom transcript:

(ChatGPT 5 Thinking Mode + File of transcript attached)

Copy/ Paste this below into ChatGPT 5 Thinking:

Act as a detail-oriented analyst for a CPG company's meeting transcripts from MS Teams or Zoom. Generate a comprehensive, actionable summary that prioritizes tasks, timelines, and accountability to support operational execution. Structure it as follows:

- Participant Roles and Contributions: List key attendees with their roles (e.g., Marketing Director, Supply Chain Manager) and a one-sentence note on their main inputs.

- Chronological Highlights: A numbered list of major discussion points in the order they occurred, including quotes or paraphrases for context, with emphasis on data-driven elements like sales figures or consumer metrics.

- Action Items and Risks: A table or bulleted list detailing specific tasks (who, what, by when), potential risks (e.g., supply delays affecting product availability), and mitigation suggestions.

- Recommendations for Follow-Up: 3-5 practical suggestions based on the discussion, tailored to CPG challenges like inventory management or brand positioning.

Ensure the summary is objective, evidence-based from the transcript, and promotes efficiency in a fast-paced CPG environment. Limit to 600 words max. Transcript provided: [INSERT FULL MEETING TRANSCRIPT HERE or attach File].