Use cases: analyze a tool's CSV export

Which GA4 or Search Console question do I have?

Choose traffic sources, landing-page performance, content decay, channel return or search-query CTR.

• Build a GA4 Landing Page Conversion Funnel from a CSV Export
  Drop your GA4 Landing page CSV export into xmetric to chart session-to-conversion rates by page in your browser, with no API quotas.
• Find Decaying Articles from a GA4 Pages and Screens Export
  Drop your GA4 Pages and screens CSV export into xmetric to flag articles losing organic views from their peak month using FIXED LOD expressions.
• Find the landing pages that waste traffic, from a GA4 export
  Drop the GA4 Landing page report CSV to rank pages by key events missed against your site rate and roll pages up by site section. Tableau formula and SQL included.
• Join GA4 Traffic Acquisition CSVs with Ad Spend to Measure ROAS
  Analyze a GA4 Traffic acquisition CSV with cost data in your browser. Compute CAC, ROAS and cost per engaged session with LOD expressions.
• Plot Your GA4 Google Organic Search Queries CTR Curve by Position
  Drop your GA4 Google organic search queries CSV into xmetric to plot CTR by average position and find high-impression pages with weak click rates.
• Which traffic sources pull their weight, from a GA4 Traffic acquisition export
  Roll a GA4 Traffic acquisition export up by medium and see which sources bring more than their share of key events, with rates recomputed from counts. Tableau formula and SQL.

Where do I investigate paid-ad performance?

Start with the export for Google Ads search terms or Meta Ads creative performance.

• Find wasted spend in a Google Ads search terms export
  Total each search term across every campaign and ad group, flag terms that never converted, and compare cost per conversion by match type, on your export.
• Spot Meta Ads Creative Fatigue and ROAS Decay from Ads Manager CSV
  Drop your Meta Ads Manager CSV export into xmetric to plot CPA and ROAS against ad frequency and daily spend without paying for spreadsheet connectors.

Which HubSpot pipeline question do I need to answer?

Choose deal-stage timing, lead-source revenue, pipeline movement or win rate.

• Analyze HubSpot Deal Stage Velocity and Bottlenecks from CSV
  Drop your HubSpot Deals or stage history CSV into xmetric to measure median days in each stage, spot stalled deals, and compare cycle time by owner.
• Build a HubSpot Pipeline Waterfall Chart from a Deals Export
  Drop your HubSpot Deals CSV export into xmetric to build a period-over-period pipeline bridge showing new, expanded, pushed, won, and lost deal value.
• Calculate True Cohort Win Rates from a HubSpot Deals CSV Export
  Drop your HubSpot Deals CSV into xmetric to calculate count and dollar win rates by creation cohort, deal size band, and owner in your browser.
• Track HubSpot Original Source to Closed Revenue from CSV Exports
  Drop your HubSpot Contacts or Deals CSV into xmetric to chart lead-to-customer rate, pipeline generated, and closed revenue by Original Source.

Which Shopify sales or customer question do I have?

Choose order value, retention, discounts, product mix or repeat purchasing.

• Analyze Shopify Discount Code Usage and Revenue Leakage from CSV
  Compare discounted vs full-price AOV, repeat buyer rates and promo code leakage from your Shopify orders CSV, in your browser.
• Analyze Shopify Product Mix and 80/20 SKU Concentration from CSV
  Rank Shopify SKUs by net sales, build an 80/20 Pareto curve and spot first-order hero products from your orders CSV, in your browser.
• Build a Shopify Customer Cohort Retention Table from an Orders CSV
  Group Shopify buyers by first order month and chart monthly buyer and revenue retention from your orders CSV, in your browser.
• Calculate Shopify Repeat Purchase Rate and Customer LTV from CSV
  Deduplicate Shopify order line items, measure 30/60/90-day repeat purchase rates and chart customer LTV from your orders CSV, in your browser.
• Track Shopify Average Order Value (AOV) and Units per Order from CSV
  Split Shopify AOV trends into units per transaction and average item price from your orders CSV, without line-item double counting.

Which Stripe subscription or payment question do I have?

Choose retention, failed-payment recovery, lifetime value, MRR or net revenue retention.

• Analyze Stripe Failed Payments and Dunning Recovery from CSV
  Measure involuntary churn, decline codes and retry recovery rates from your Stripe payments or invoices CSV, with xmetric in your browser.
• Calculate Stripe Customer LTV by Subscription Plan from CSV
  Compare realized and formula LTV across Stripe pricing tiers and billing intervals from your subscriptions or invoices CSV, in the browser.
• Calculate Stripe Net Revenue Retention (NRR) from an Invoices CSV
  Compute trailing 12-month Net Revenue Retention (NRR) and Gross Revenue Retention (GRR) from your Stripe invoices CSV, in your browser.
• Cohort retention from a Stripe payments export
  Build a monthly cohort retention table from the Stripe Dashboard payments CSV. Drop your export to get it in the browser, or copy the Tableau formula, the DuckDB SQL or an agent prompt.
• MRR and churned MRR from a Stripe subscriptions export
  Compute MRR by product, new MRR by start month and churned MRR by cancellation month from a Stripe subscriptions export, annual plans normalized. Tableau formula and SQL, run on your file.

Which QuickBooks finance export should I analyze?

Choose receivables aging, vendor spending or budget-to-actual variance.

• Analyze QuickBooks Accounts Receivable (AR) Aging and Overdue Invoices from CSV
  Chart 1-30, 31-60, 61-90 and 90+ day overdue balances from your QuickBooks A/R Aging Detail or Open Invoices export, in your browser.
• Analyze QuickBooks Expense Trends and Vendor Creep from CSV
  Spot month-over-month spend spikes and vendor concentration from your QuickBooks Transaction Detail or Expenses by Vendor export, in your browser.
• Build a QuickBooks P&L Budget vs. Actual Variance Bridge from CSV
  Build a waterfall variance bridge from your QuickBooks Profit and Loss or Budget vs. Actuals export, in your browser with xmetric.

Where do I analyze delivery or support operations?

Choose Jira cycle time or Zendesk response and resolution performance.

• Analyze Jira Issue Cycle Time and Sprint Throughput from a CSV Export
  Drop your Jira Issues CSV export into xmetric to chart lead time percentiles, sprint velocity, and bug escape rates locally in your browser.
• Audit Zendesk Ticket SLA Breaches and Resolution Time from CSV
  Drop your Zendesk Tickets CSV export into xmetric to analyze first reply time, full resolution percentiles, and backlog aging by channel and group.

How are the export guides grouped?

The groups match the service that produced the export, with delivery and support tools together.