# Executive Insights

> Transform raw data into actionable narrative summaries with color-coded badges highlighting key metrics, trends, and opportunities.

Transform raw data into actionable narrative summaries with color-coded badges highlighting key metrics, trends, and opportunities.

**Best for**: Executive dashboards, funnel analysis, performance reviews

**Key techniques**: Row indexing (`rows[0]`, `rows[-1]`), conditional badge styling, narrative text generation

## Template Code

```html
<style>
  .insights-badge {
    display: inline-block;
    background: #EFF6FF;
    color: #1E40AF;
    padding: 0.08rem 0.5rem;
    border-radius: 4px;
    font-weight: 600;
    font-size: 0.85rem;
    white-space: nowrap;
  }

  .insights-badge.red {
    background: #FEF2F2;
    color: #DC2626;
  }

  .insights-badge.green {
    background: #F0FDF4;
    color: #16A34A;
  }

  .insights-container {
    padding: 1.5rem;
    max-width: 800px;
    font-size: 0.9rem;
    line-height: 1.6;
    color: #374151;
    background: #FFFFFF;
    border-radius: 8px;
    margin-bottom: 1.5rem;
  }

  .insights-container ul {
    margin-top: 0.5rem;
    padding-left: 1.5rem;
    list-style: none;
  }

  .insights-container li {
    margin-bottom: 0.75rem;
  }

  .insights-container li:last-child {
    margin-bottom: 0;
  }
</style>

  
  
    Top Performers:
    {{ rows[0].`Product name` }} ({{ rows[0].`Purchased` }}),
    {{ rows[1].`Product name` }} ({{ rows[1].`Purchased` }}),
    and {{ rows[2].`Product name` }} ({{ rows[2].`Purchased` }}) lead in actual sales conversions.
  
  
    Largest Cart Abandonment:
    {{ rows[-1].`Product name` }} shows the biggest gap with {{ rows[-1].`Cart abandonment` }}  abandoned
    ({{ rows[-1].`Added to cart` }} added vs. {{ rows[-1].`Purchased` }} purchased),
    followed by {{ rows[-2].`Product name` }} ({{ rows[-2].`Cart abandonment` }})
    and {{ rows[-3].`Product name` }} ({{ rows[-3].`Cart abandonment` }} gap).
  
  
    High Conversion Rate:
    {{ rows[0].`Product name` }} demonstrates the strongest purchase intent with only a {{ rows[0].`Cart abandonment` }} unit gap,
    while {{ rows[1].`Product name` }} ({{ rows[1].`Cart abandonment` }})
    and {{ rows[2].`Product name` }} ({{ rows[2].`Cart abandonment` }} gap) also show relatively strong conversion.
  
  
    Opportunity Area: Products with &ge;{{ rows[-3].`Cart abandonment` }} gap suggest potential for targeted remarketing campaigns or checkout optimization.
  
  

```

## Required Data Fields

| Field | Type | Description |
|-------|------|-------------|
| `Product name` | Dimension | Product or item name |
| `Purchased` | Measure | Number of completed purchases |
| `Added to cart` | Measure | Number of cart additions |
| `Cart abandonment` | Measure | Gap between cart and purchase |

## Sample Data

Import this data into Holistics to use: [sample-data-insights.csv](https://media.holistics.io/1ce02666-sample-data-insights.csv)

```csv
Product name,Added to cart,Purchased,Cart abandonment
Dumbbells,520,500,20
Fitness Tracker,500,450,50
Jump Rope,480,420,60
Wireless Headphones,500,420,80
Running Shoes,480,380,100
Water Bottle,520,350,170
Protein Powder,490,310,180
Yoga Mat,500,290,210
Resistance Bands,500,260,240
Exercise Bike,500,180,320
```

## Customization Tips

- Adjust the badge colors (`.insights-badge.red`, `.insights-badge.green`) to match your brand
- Modify the narrative text to fit your specific use case
- Add more rows by referencing `rows[3]`, `rows[4]`, etc.
- Use negative indexing (`rows[-1]`) to always reference the last items regardless of data size