If you ever notice discrepancies in your metrics—such as missing values, zeros, or data that doesn’t align as expected—you can use Custom Tables in Polar to quickly investigate how your raw data is flowing into the app.
Custom Reports allow you to:
Drill into specific metrics
Apply filters to isolate relevant data
Add breakdowns to see how data is segmented
Compare results across different dimensions and data sources
This makes them a powerful tool for self-debugging before reaching out to support.
Common Causes of Metric Discrepancies
Before diving into the steps, here are a few reasons you might see unexpected results:
Misconfigured Views – A connector or data source may not be included in your View.
Filters or Breakdowns – Mismatched filters and breakdowns can cause differences between what you see in a report versus the Key Indicator section.
Unintegrated Connectors – If a connector hasn’t been fully set up or synced, its data won’t appear.
Differences Between Metrics or Aggregations: Metrics may be calculated differently depending on whether you view them in a Table, Graph, or Key Indicator Section.
Step-by-Step: Debug Metrics Using Custom Tables
Custom Tables are particularly useful for resolving specific data discrepancies, such as missing metrics or zero-value issues.
1. Create a Custom Table
Start by creating a new Custom Table from your Polar dashboard.
2. Add Metrics
Select the metric(s) you want to investigate from the sidebar.
👉 Example: Add Total Orders to review order data.
3. Add Breakdowns
Breakdowns add extra columns so you can see how data is segmented.
👉 Example: Add Purchase Type to separate New vs. Repeat Orders.
4. Apply Filters
Filters let you narrow the report to focus on specific segments.
Use filters to match the same dimension as your breakdown where possible.
Ensure you’re using a dimension compatible with the metric.
Examples:
Add a Purchase Type filter to only view repeat orders within your date range.
Add a Product Title filter to look at orders containing a certain product or keyword.
5. Use Custom Metrics (Optional)
If you want to apply different filters to multiple metrics at the same time, use Custom Metrics.
Custom Metrics let you create metric-specific filters and rules.
You can then pull these into your Custom Table for deeper analysis.
👉 Example: Create a Custom Metric for New Total Orders and add rules to further segment the data.
Tips for Successful Debugging
Double-check that all required connectors are active and included in your View.
Align filters and breakdowns using the same dimension versions to avoid mismatches.
Compare results between the report, Key Indicator section, and your original data source to pinpoint the source of discrepancies.
Start broad (e.g., Total Orders without filters) and narrow down step by step with filters and breakdowns.
Still Need Help?
If you’re unsure how your raw data is pulling into Polar, or if you’d like assistance with Custom Table, reach out via our in-app live chat—our Support Team will be happy to help.