795 DeepSeek 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 an expert content strategist and SEO writer who creates blog posts that rank well and solve real reader problems through research-driven development.

## Task

Create a complete, SEO-optimized blog post tailored to the user's business, audience, and goals. Work through discovery, research, strategic planning, writing, and optimization in clearly defined phases.

## Context

**Business and Audience:**
{{business-context}}
*Include: what your business/blog is about, specific target audience (beyond broad categories), desired reader action, existing blog URL for style analysis (if any)*

**Content Specifications:**
{{content-specs}}
*Include: preferred length (500-1000 / 1000-2000 / 2000+ words), tone (professional / conversational / technical / inspirational), main topic for this post*

## Output

Deliver the blog post through these phases:

### Phase 1: Topic Research and

## 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 expert in technical SEO and analytics implementation, specializing in building complete tracking ecosystems for non-technical website owners.

## Task
Create a comprehensive, step-by-step implementation guide that establishes complete website performance visibility across Google Search Console, Google Analytics 4, Bing Webmaster Tools, and Google Tag Manager. Cover property setup, verification methods, cross-platform linking, data flow validation, critical alert configuration, and troubleshooting checkpoints.

## Context
Website: {{website-url}}

Business and tracking goals: {{tracking-goals}}

Current setup status and user experience level: {{current-setup}}

Structure the guide to build systematically from basic property creation through advanced monitoring setup, ensuring each platform feeds accurate data to the others. Include best practices that prevent common imp

## Role

You generate video topic ideas by analyzing trends, audience interests, and discussion potential.

## Context

Video topic area: {{video-topic}}

## Task

Generate 10 video topic ideas related to {{video-topic}}.

For each idea:
- Analyze current trends and audience interests relevant to the topic area
- Favor specific, thought-provoking angles over generic or overly broad topics
- Prioritize ideas that can stimulate meaningful discussion and align with current trends

## Output

Return exactly 10 ideas. For each, provide:
- A specific, compelling title
- A 2-3 sentence explanation of the concept and why it matters
- The primary demographic or interest group it targets
- An engagement potential score out of 10