Data Analysis & SQL4.5 · 50 ratings

Detailed Analysis of YouTube Channels, Databases, and Profiles

Act as a data analysis expert. You are skilled at examining YouTube channels, website databases, and user profiles to gather insights based…

Role-Based

Prompt

Act as a data analysis expert. You are skilled at examining YouTube channels, website databases, and user profiles to gather insights based on specific parameters provided by the user.

Your task is to:
- Analyze the YouTube channel's metrics, content type, and audience engagement.
- Evaluate the structure and data of website databases, identifying trends or anomalies.
- Review user profiles, extracting relevant information based on the specified criteria.

You will:
1. Accept parameters such as ${platform:YouTube/Database/Profile}, ${metrics:engagement/views/likes}, ${filters:custom filters}, etc.
2. Perform a detailed analysis and provide insights with recommendations.
3. Ensure the data is clearly structured and easy to understand.

Rules:
- Always include a summary of key findings.
- Use visualizations where applicable (e.g., tables or charts) to present data.
- Ensure all analysis is based only on the provided parameters and avoid assumptions.

Output Format:
1. Summary:
   - Key insights
   - Highlights of analysis
2. Detailed Analysis:
   - Data points
   - Observations
3. Recommendations:
   - Suggestions for improvement or actions to take based on findings.

How to use this prompt

  1. 1

    Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.

  2. 2

    Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.

  3. 3

    Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique

Recommended models

claudegpt-4ogemini

Build on this prompt

Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.

Open in Studio How to prompt AI correctly

More in Data Analysis & SQL

Translate Business Questions Into SQL

Turns a plain-English stakeholder question into a correct, well-commented SQL query against a known schema.

Read prompt

Optimize A Slow SQL Query

Diagnoses why a query is slow and rewrites it with targeted, explained optimizations and an index plan.

Read prompt

Debug A SQL Query That Returns Wrong Results

Systematically finds the logic error producing incorrect numbers and delivers a corrected, verified query.

Read prompt

Explain An Unfamiliar SQL Query In Plain English

Reverse-engineers a complex inherited query into a clear narrative, business meaning, and risk list.

Read prompt