Query Builder

The query builder is used across Logs Explorer, Traces Explorer, Metrics Explorer, Dashboards, and Alert rules. It provides a unified interface for all three si

CROAnalytics
bySamuelca6399729 words

What is Query Builder?

What this skill does

The Query Builder skill provides a unified interface for constructing complex queries across Logs Explorer, Traces Explorer, Metrics Explorer, Dashboards, and Alert rules. It enables precise filtering by attributes, applying aggregation functions like count, percentiles, and rates, and grouping results to segment data effectively. Users can manipulate results with sorting, time bucketing, and limiting, and combine multiple queries with formulas for advanced analysis.

This skill supports temporal and spatial aggregations, chaining mathematical transformations, and building alert conditions based on real-time metrics. It powers dashboards with various panel types including time series, bar charts, pie charts, and tables, facilitating data-driven decision-making on performance and reliability.

Who it's for

This skill is essential for performance marketers and growth leads who need to analyze user behavior and system performance across multiple data signals to optimize campaign effectiveness. SEO and PPC operators use it to monitor site health and response times, ensuring smooth user experiences that support ranking and conversion goals. Agency strategists benefit from its ability to correlate logs, traces, and metrics, enabling root cause analysis and fine-tuning of multi-channel marketing initiatives.

Key workflows

Practitioners start by defining filters to narrow down data sets based on attributes like service name, HTTP method, or status code. Next, they select aggregation functions such as count, percentile latency, or rate metrics to quantify key performance indicators. Grouping by attributes segments results to identify trends across services, hosts, or endpoints. Finally, they manipulate results through sorting, limiting, or applying formulas that combine multiple queries for ratio or difference calculations, enabling actionable insights and alert rule creation.

Common questions

How do I filter for multiple values in one attribute? Use the IN and NOT_IN operators to include or exclude lists of attribute values. Can I analyze latency distribution? Yes, percentile aggregations like P95 and P99 provide latency breakdowns for performance monitoring. How do I combine multiple queries? Execute separate queries labeled A, B, C, and use formulas such as A / B to calculate ratios or differences.

How to use in Metaflow

Attach the Query Builder skill to any Metaflow agent task that requires querying logs, traces, or metrics from SigNoz. Once connected, define filters, aggregations, and groupings to extract relevant insights directly within your workflows. Expect streamlined data exploration and alert configuration capabilities that integrate seamlessly with your marketing performance pipelines. This skill enhances your ability to monitor and optimize campaigns by providing granular visibility into system and user data.

For broader context, see our roundup of claude skills for marketing, and read Claude Code workflows for marketing agencies for related setup guidance.

Related skills

Paywall & Upgrade Flow Optimization

When the user wants to create or optimize in-app paywalls, upgrade screens, upsell modals, or feature gates. Also use when the user mentions "paywall," "upgrade screen," "upgrade modal," "upsell," "feature gate," "convert free to paid," "freemium conversion," "trial expiration screen," "limit reached screen," "plan upgrade prompt," "in-app pricing," "free users won't upgrade," "trial to paid conversion," or "how do I get users to pay." Use this for any in-product moment where you're asking users

View →

ROI Analyzer

Use when preparing executive reports, evaluating investments, or calculating ROI/break-even/payback period. 30-minute analysis (87.5% time saving). Includes scenario analysis.

View →

UTM Builder

Generate UTM-tagged URLs for campaign tracking. Create consistent, organized tracking links for Google Analytics, HubSpot, and other analytics platforms. Supports bulk generation, naming conventions, and campaign documentation. Use when creating tracking links, campaign URLs, or organizing marketing attribution.

View →

User Onboarding & Activation Optimization

When the user wants to optimize post-signup onboarding, user activation, first-run experience, or time-to-value. Also use when the user mentions "onboarding flow," "activation rate," "user activation," "first-run experience," "empty states," "onboarding checklist," "aha moment," "new user experience," "users aren't activating," "nobody completes setup," "low activation rate," "users sign up but don't use the product," "time to value," or "first session experience." Use this whenever users are si

View →

Signup Flow Optimization

When the user wants to optimize signup, registration, account creation, or trial activation flows. Also use when the user mentions "signup conversions," "registration friction," "signup form optimization," "free trial signup," "reduce signup dropoff," "account creation flow," "people aren't signing up," "signup abandonment," "trial conversion rate," "nobody completes registration," "too many steps to sign up," or "simplify our signup." Use this whenever the user has a signup or registration flow

View →

Landing Page Conversion Optimization

When the user wants to optimize, improve, or increase conversions on any marketing page — including homepage, landing pages, pricing pages, feature pages, or blog posts. Also use when the user says "CRO," "conversion rate optimization," "this page isn't converting," "improve conversions," "why isn't this page working," "my landing page sucks," "nobody's converting," "low conversion rate," "bounce rate is too high," "people leave without signing up," or "this page needs work." Use this even if th

View →