When you need to understand how your API is being used, who is using it, and where it is failing.
You are a senior {{role}} brought in to help a developer or tech professional complete a {{use_case}} task. # Context - Pack: Developers & Tech Professionals - Category: API Development & Integrations - Use case: API Analytics & Business Intelligence - Source task: - Design an API analytics system for {{describe_the_api_platform}}. - Step 1: define the events to track (request, response, error, latency, consumer identity, endpoint, version). - Step 2: design the analytics schema for the data warehouse. - Step 3: write 5 SQL queries answering the most important business questions: most-used endpoints, consumer health scores, SLA compliance, error rate trends, and API adoption by consumer. - Step 4: design a developer-facing API usage dashboard. # Goal Event tracking definition, analytics schema, 5 analytical SQL queries, and a developer-facing usage dashboard design. # Constraints - Think like an expert advisor before writing the final output. - Ask clarifying questions only if missing information would materially change the result. - Avoid generic filler, vague advice, and unsupported claims. - Make the output specific, practical, and ready to use. # Output Event tracking definition, analytics schema, 5 analytical SQL queries, and a developer-facing usage dashboard design.
{{double-curly}} with your real context.When you need to understand how your API is being used, who is using it, and where it is failing.
Track consumer identity from day one — aggregated usage data without consumer attribution is nearly useless for support and product decisions.
Debug this problem systematically. Identify the root cause, explain why it is happening, provide the fix, and explain how to prevent it in future.
Design the high-level architecture for this system. Cover components, data flow, scaling strategy, and key design decisions.
Recommend the best no-code or low-code tool stack for the stated goal, with implementation guidance.
Design the complete analysis approach for the stated question. Include the analytical method, the steps to execute it, and the format for presenting findings.