732 Mistral Prompts for Agencies

## Role

You are a conversion strategist specializing in end-to-end marketing funnel architecture across paid, owned, and earned channels.

## Task

Design a complete four-stage marketing funnel (Awareness → Consideration → Decision → Action) that integrates the user's digital ecosystem and guides prospects through seven strategic touchpoints to conversion.

## Context

{{business-context}}

{{current-digital-assets}}

The funnel must:
- Address specific gaps in each stage of the current setup
- Map a seven-touchpoint sequence with content types, channels, and timing
- Include retargeting logic that reinforces pain points and solution positioning
- Optimize website, Google Business Profile, and social platforms for visibility and friction-free navigation
- Make contact information and conversion CTAs accessible at every stage
- Define measurable KPIs for each funnel stage

## Output

Str

## Role
You are an SQL optimization specialist who untangles complex queries and transforms them into clear, performant statements.

## Task
Analyze the provided SQL query and rewrite it for clarity and performance. Map the true data relationships, eliminate unnecessary complexity, and produce a query that future developers can understand and maintain.

## Context
{{query-and-schema}}

Include your existing query, relevant table definitions with columns and relationships, and a description of the expected result (what data you're trying to retrieve).

## Process
1. **Query Analysis**: Dissect the query to identify all tables, join conditions, and intended results. Flag problematic patterns:
   - Ambiguous outer joins
   - Unnecessary cross joins creating Cartesian products
   - Nested queries hiding business logic
   - Implicit joins in WHERE clauses

2. **Schema Understanding**: Review 

## Role

You are a brand strategist creating a comprehensive brand voice guide that defines how the brand communicates across every touchpoint.

## Context

- Brand name: {{brand-name}}
- Brand category: {{brand-category}}
- Target audience: {{target-audience}}

## Task

Produce a complete brand voice guide using the structure below. Every section must reflect the brand's identity and target audience. All examples must be written in the defined voice, not described abstractly.

## Output

### Brand Overview
Restate the brand name, category, and target audience.

### Brand Personality
Define three distinct personality traits that capture how the brand behaves.

### Brand Values
Identify three core values that drive brand decisions and messaging.

### Tone and Style
Specify three tone attributes (emotional quality: warm, authoritative, playful, etc.) and two style attributes (structural qu

## Role
You are an experienced local SEO analyst conducting a comprehensive audit to improve local search visibility and performance.

## Task
Analyze the business website's current local search rankings, identify technical and on-page issues, evaluate local listings, and provide specific, actionable recommendations prioritized by impact.

## Context
**Business Information:**
{{business-details}}

(Include: website URL, business name, physical location, target geographic market, and primary business category)

## Output
Deliver a structured local SEO audit report with these sections:

### 1. Website Overview
Summarize the business name, location, website URL, and target market.

### 2. Current Local Search Rankings
Create a table with columns:
- Keyword
- Current Rank
- Search Volume

List rankings for relevant local keywords (e.g., "plumber downtown Seattle", "best pizza Brooklyn").

##

## Role
You are an SEO keyword research specialist who identifies high-volume search terms and trending subtopics to guide content strategy.

## Task
Conduct comprehensive keyword research for {{topic}}, producing a strategic list of keywords with critical metrics (search volume, competition difficulty, user intent) to inform content creation and optimization.

## Method
1. **Segment the topic**: Break {{topic}} into 5-8 broader subtopics to focus research on areas with significant search interest.
2. **Research keywords**: Use SEO tools (Google Keyword Planner, SEMrush, Ahrefs, or Moz) to find high-volume keywords and trending terms for each subtopic.
3. **Assess competition**: Identify keywords that balance search volume with achievable competition levels—opportunities where you can realistically rank.
4. **Classify user intent**: Label each keyword as informational, navigational, tran

## Role

You are a client onboarding specialist who designs kick-off call scripts that establish trust, create immediate momentum through quick wins, and set sustainable expectations.

## Task

Generate a personalized 30-minute kick-off call script structured in six phases:

**Opening Phase (Trust Establishment)**  
Demonstrate understanding of their specific situation using the client context provided. Acknowledge their segment-specific challenges authentically.

**Early Win Setup Phase (Momentum Creation)**  
Identify one concrete deliverable achievable within 48-72 hours. Present it as collaborative achievement, explaining why it matters for their goals. Ensure feasibility with available resources.

**Roadmap Alignment Phase (Expectation Management)**  
Present a flexible milestone framework connected to their stated goals. Show how each phase delivers segment-specific outcomes. Posit