What's New
December 2024
New and improved filtering
We’ve made it easier than ever to see and modify the filters applied to visualizations in metric homepages, Explorer, and on dashboards!
Date offsets in calculated metrics
You can now use metric data from other time periods in your calculations.
Learn moreNovember 2024
Conditional filtering
Introducing a new, intuitive design that lets you filter dimensional data by member or by condition.
Enhanced metric configuration
When creating and editing metrics, you can now pre-filter which data to include and choose how dimensions can be used. You can also control which dimensions are included for calculated and dbt Semantic Layer metrics.
October 2024
Live embedding
Display dynamic versions of your PowerMetrics visualizations externally in a website or custom data app.
Learn moreAccount usage
Admins can now view usage (and limits) for account assets, like metrics and users, and see the hourly data ingestion for data feeds.
Learn moreAdd precision to your duration metrics
Sample metrics
Want a risk-free way to explore PowerMetrics before diving in and connecting to your data? Check out our sample metrics! Managed by Klipfolio, they behave the same way as metrics you create using your own data.
Learn moreAnnouncing support for Amazon Aurora
The most recent addition to our ever growing list of data warehouse integrations! Get secure data storage (in your Aurora warehouse), data governance, single source of truth data, and high scalability.
Learn moreMicrosoft Azure Synapse Analytics integration
A new addition to our expansive list of data warehouse integrations - Microsoft Azure Synapse Analytics! As with all our warehouse services, you’ll benefit from secure data storage, data governance, single source of truth data, and high scalability.
Learn morePowerMetrics Query Language
With PowerMetrics Query Language (PMQL) you can extend the value of metrics to external applications, like Enterprise BI, data apps, data orchestration tools, notebooks, and analysis tools - no deep integration or plug-in required!
Learn moreSeptember 2024
Decimal places setting
When you create or edit metric visualizations, you can now choose the "Auto" setting (4 decimal places) or display up to 9 decimal places.
Shorten long numeric values
Simplify and add clarity to your visualizations with the new abbreviate long values setting.
August 2024
Multi-metric filtering
It's now easier to apply filters on a per-metric basis for multi-metrics in Explorer and on dashboards.
Learn moreJuly 2024
Announcing support for Microsoft Azure SQL
The most recent addition to our ever growing list of data warehouse integrations! Get secure data storage (in your Azure SQL warehouse), data governance, single source of truth data, and high scalability.
Learn moreJune 2024
Have a conversation with your data!
PowerMetrics AI brings self-sufficient data analysis to business users. Our new AI chat experience, with its intuitive design and natural language interface, helps you explore your data, generate visualizations and get contextual, accurate answers.
Learn moreSummary values for tables
We've added a new "show totals" option to list and pivot tables. On by default, when enabled this setting displays summary values for columns and rows (in pivot tables) and columns (in list tables).
Great news for our data warehouse customers!
Announcing direct to warehouse integrations for six popular services: BigQuery, Snowflake, Databricks, Redshift, PostgreSQL, and MariaDB. These new integrations give you secure data storage (in your warehouse), data governance, single source of truth data, and high scalability.
Announcing our Cube integration
Connect to data in your Cube semantic layer and add custom metrics to your catalog in PowerMetrics. Defined metrics, security, and governance for data teams - self-serve, single source of truth data for business users.
Learn moreApril 2024
Introducing PowerMetrics Assistant
Working in PowerMetrics and have questions? Get answers with our new PowerMetrics Assistant!
Learn moreNew role for dashboard builders
The PowerMetrics Contributor role is designed for those who work almost exclusively with dashboards. Use it to view and share metrics and view, create, edit, share, and delete dashboards.
Learn moreChange metric dimension names
The option to change dimension names makes it easier than ever to compare and analyze visualizations on dashboards with shared filter controls.
Learn moreSet the first day of the week.
You can now select which day to use as the first day of the week for your account. Your selection applies to metric visualizations with a weekly periodicity.
Learn moreSelect a theme for published views
When sharing a dashboard as a published view, select the theme you want it to be viewed in (Dashboard theme, Dark theme, or Light theme).
Learn moreFebruary 2024
Custom metrics for Zuora
We've added support for Zuora in PowerMetrics. Start tracking your Zuora subscription payment data with custom metrics, built by you using our visual (and powerful) query builder!
Learn moreCustom metrics for Smartsheet
We've added support for Smartsheet in PowerMetrics. Start tracking your Smartsheet project management data with custom metrics, built by you using our visual (and powerful) query builder!
Learn moreTable visualizations
We've added the option to wrap text in tabular charts and to define the number of wrapped rows in pivot tables.
Customized metric icons
Add context, align similar data sources, change the look and feel of your metrics – all with customized metric icons!
Learn moreFaster sharing!
Select multiple metrics and share them all at once.
Learn moreGood news Account Admins!
You can now invite new users while sharing. For management purposes, we've also made it easier to find metrics that aren't shared with you.
Learn moreJanuary 2024
Improved user and group management
When inviting users, you can also update their role and add them to a group, including the new "Default" group.
Learn moreDecember 2023
dbt™ Semantic Layer integration
Deliver a streamlined metrics catalog to your business users so they can access data from your dbt Semantic Layer metrics for visualization, discovery, and dashboarding.
Accessing dbt queries for your metrics
Need help debugging and troubleshooting dbt and SQL queries? You can now view (and, optionally, copy) queries for all your dbt metric visualizations.
Learn morePreventing or allowing aggregation overrides
Previously, anyone with edit access to a custom metric could change its default aggregation. Given that changing the aggregation for a metric visualization also changes the meaning of the data being shown, we've added a new setting that lets you disable or enable aggregation overrides on a per-metric basis.
Learn moreOctober 2023
Metric certification
Add certified status to the metrics you've verified and want to recommend for use by others in your organization.
Learn moreRedesign for data feed refresh
With new options for investigating and resolving data feed refresh issues, it's easier than ever to ensure your data feeds (and metrics) are always up to date.
Learn moreDownload data feeds as csv files
A new way to look at your data. Among other options, you can download data feeds as csv files when troubleshooting or to get a csv-formatted version of JSON data.
Learn moreSeptember 2023
Advanced analysis
Make better decisions by quickly identifying outliers in your data and predicting future metric performance.
Learn moreShare dashboard styles
Perfected a dashboard style and want to reuse it? You can now copy and share a dashboard style's settings and apply them to your (and your team's) dashboards.
Learn moreA new way to refresh data feeds
You can now queue one or more data feeds to refresh from your data feeds list page.
Learn moreHide the dashboard date range
Don't want to display the date range for specific dashboards? We've added the flexibility to toggle its display on and off.
Learn moreViewing segmented data in charts
When hovering over data points in segmented bar, line, area, and pie charts it's now easier to see the data that's specific to each segment. It's indicated with darker text in the tooltip and a deeper colour in the chart component (bar, column, line, area, or pie slice) across the entire date range.
August 2023
Get ready to personalize your dashboards!
Dashboards just got a lot more exciting. With new background colours and image options, it's easier (and more fun) than ever to tell your data story and show off your unique brand. Learn more.
Fullscreen mode - A new way to see your dashboards
We've added the ability to open dashboards in fullscreen mode. It's a great way to preview how the dashboard will look in your presentations. Learn more.
June 2023
A simpler path to custom metrics
With streamlined steps, a helpful in-app guide, and a live preview of every choice you make, you'll be building custom metrics in no time!
Quick access to your favourite dashboards
Add the dashboards you refer to most to your "Starred" list. They'll display in the left sidebar along with your 5 most recently opened, unstarred dashboards. Learn more.
May 2023
Sorting for metric visualizations
Organize and display your metric data the way you want to see it - on dashboards, metric homepages, and in Explorer. Depending on the chart type and style, you can now sort data by x-axis, legend, rows, columns, and more!
Custom metrics for Airtable!
We've added Airtable to our ever-growing list of supported services in PowerMetrics. Start tracking your Airtable data with custom metrics, built by you using our visual (and powerful) query builder! Learn more.
April 2023
Share dashboards with published views
Share internally or externally with either public or passcode access. Whether consumed on mobile phones, tablets, or desktop computers, or displayed on large TVs throughout the office, published views are a convenient, secure way to share snapshot views of your metric dashboards. Learn more.
Editing data feeds with formulas and functions just got a lot easier!
A more intuitive formula bar design and the ability to hide and display columns makes it easier (and faster) than ever to create data feeds (and custom metrics) for our most popular services.
Learn moreMulti-factor authentication
We've added a key component in keeping your account secure - multi-factor authentication!
Learn moreGet the metric type you need
Our new, more intuitive menu makes it easier than ever to add specific metric types. Browse (and add) instant metrics, add a new custom or calculated metric, or see all your options at once by browsing all services.
March 2023
Add more colour to your dashboards
Show off your unique brand and personality with customized dashboard background colours.
Learn moreFebruary 2023
Light and Dark Mode
Personalize your PowerMetrics experience by applying a light or dark mode. Or, automatically use the mode that matches your current device settings.
Learn moreNew calendar design
Our new, more intuitive, vertical-scrolling calendar control makes it easier than ever to set metric and dashboard date ranges.
More date range options
We've added "Month to date" and "Year to date" to our extensive list of pre-set date range options. You'll get these options and "Week to date" for your custom date ranges too, along with another new option – "Since".
Get notified if your token's about to expire
Tokens for some services expire after a set period of time. To help keep your data collection rolling, we'll email you 7 and 2 days before your QuickBooks, Xero, Facebook, Microsoft SharePoint, or Microsoft OneDrive token expires. Notification support for more services is coming soon! Learn more.
December 2022
Deleting multiple metrics
Now you can select multiple metrics and delete them all at once.
Learn moreMetric dashboard filtering
We've added an option to automatically display all available filters for all metric visualizations on a dashboard. This feature is turned on for all new dashboards but can be turned off for any dashboard when you want to manually select filters instead.
Learn moreMore intuitive date ranges
We've redesigned the date range UI to more clearly indicate whether the selected range includes today. We've also updated some of our pre-set options. "Last 7 days" and "Last 30 days" now include today and "Last 6 months" and "Last 12 months" now include this month - even if you're part way through the month.
October 2022
Discover data insights with Explorer
Bring one or more metrics into Explorer - an intuitive, free-form environment where you can experiment with and analyze your data for answers and inspiration. A multitude of options means you can customize to your heart's desire or reset to start over with a click of a button. Make Explorer your personal data laboratory… or maybe your playground!
Learn moreA new way to see your data
The metric homepage presents each metric from multiple perspectives. No more guessing which chart types are best for your data - the homepage is auto-generated using a curated template based on your metric. Fully customizable, you can retain the auto-settings or use them as a starting point for further discovery and personalization.
Learn moreSeptember 2022
Metric dashboard templates
Looking for inspiration? Check out our new dashboard templates. We’ve added 20+ templates for 11 services, including Facebook, Google Ads, Google Analytics and Google Analytics v4, HubSpot (v2 and v3), Instagram Business, QuickBooks, Shopify, Stripe, and Xero. Designed and curated by Klipfolio experts, they’re a fast path to powerful and professional dashboards.
Learn moreDynamic metric naming
When you add a metric to a dashboard, we’ll apply a default metric name that includes a reference to the metric visualization’s segmentation and over properties. For example, a metric named “Hits”, that includes the segments “Channel”, “Media”, and “User Type” and a date column, will auto-update to “Hits by Channel Over Time”.
Learn moreQuarterly time periods for metrics
When exploring your metrics, you can now select quarterly time periods as an option under “Over”. Quarterly time periods are designated as follows: Q1 starts Jan 1st, Q2 starts Apr 1st, Q2 starts Jul 1st, and Q4 starts Oct 1st.
Custom time zones for PowerMetrics
In PowerMetrics, you can now either use the account-wide time zone setting or apply custom time zones to metrics, dashboards, and your metric list.
New sign in options - Xero and Intuit
In addition to signing in to Klipfolio with Google or a Klipfolio email and password, you can now also sign in using your Xero or Intuit credentials.
Learn moreMore metric goal options
When setting recurring goals for your metrics, you can now choose between being notified immediately when your target is reached or being notified at the end of a set time period.
Learn moreAugust 2022
Instant and custom metrics for Shopify!
Start tracking your Average Order Value, Net Sales, Payouts, and more with just a few clicks using our Shopify instant metrics. Our new Shopify instant metrics use the Shopify API and support automatic backfill (up to 6 months of data history). Feeling creative? With access to 60+ data views in our query builder, the sky's the limit when it comes to creating custom Shopify metrics!
July 2022
Now available - Klipfolio PowerMetrics for Stripe!
We're excited to announce the release of our PowerMetrics for Stripe app. Now you can get the best of both worlds – online payment processing and subscription management with Stripe and in-depth business analytics with PowerMetrics.
Learn moreNow you can display metric goals in summary charts too!
We recently introduced metric goals for bar, line, and area charts. Now, you can also display goals on summary (single value) charts. Set goals and track your metric values as they move above and below a threshold or watch your metric progress, starting at the beginning and moving toward a target.
Adding instant metrics just got faster!
Adding instant metrics has always been fast but now it's even faster! That's because we've streamlined the account connection process. The first time you add an instant metric for a service you'll be prompted to enter your account credentials. The next time, we'll assume you want to use the same account and skip this step. Want to use a different account? No problem! Simply click the account connection at the top of the page and enter your credentials.
June 2022
New style for line and area chart metrics
We've added a new style to line and stacked area charts so you can display your data as a smooth line.
Learn moreChoose from multiple currency symbols
Now, when creating custom and calculated metrics and editing instant, custom, and calculated metrics, you can replace the default currency symbol with an alternate one (our default currency display symbol is USD $). Note that this is a display option only. Currency is not converted. Learn more here, here, and here.
Looking for more in PowerMetrics?
We just made that easier with our new PowerMetrics Top-Ups! Available with Plus and Pro plans, you can now get additional data services, an extended date range window, and additional editor users, without moving to a higher-priced plan. Need some extra help? Check out our Data Hero Services Power-Up option. Learn more in this article or go to your Plan page by clicking the button in the left navigation sidebar in PowerMetrics and selecting Plan.
Goals for area charts
We recently released our goals and notifications feature but are working hard to make it even better! Besides being able to display goals in bar and line charts, you can now also display them in area charts.
Learn moreMay 2022
Downloading metric visualizations as CSV files
You can now download CSV file versions of your metric visualizations that can be used in many ways: In spreadsheets, for record-keeping, when debugging issues, to preserve a snapshot in time, to help you do comparisons, and for use in presentations.
Learn moreMarch 2022
Instant metrics for Google Ads
Start tracking your ad engagements, ad impressions, ad interactions, and more with just a few clicks using our Google Ads instant metrics. Our new Google Ads instant metrics use the Google Ads API and support automatic backfill (up to 6 months of data history). Feeling creative? Use the query builder in PowerMetrics to add Google Ads custom metrics too!
Learn moreNew metric reconciliation strategy
When you make fundamental changes to a data source, for example, updating a value for a past date or removing columns in a spreadsheet, our new strategy ensures your instant and custom metrics automatically update to align with the data source changes.
February 2022
Edit your account connection for instant metrics
You can now connect to and get data from a different account when you’re editing instant metrics.
January 2022
See how much metric data history is being stored
We've made it easier for you to see the number of days of stored data for each of your metrics. Check the upper-right corner of the top navigation bar to see metric data history storage and refresh details.
Automatically get more data history for Google Analytics and Google Analytics 4 instant metrics
We now support data history backfilling for all of our Google Analytics and Google Analytics 4 instant metrics. When you add these metrics, they'll instantly include your most recent 2 weeks of data. After auto-backfilling is complete, they'll include up to 6 months of historical data.
Choose auto or custom names for columns in the modeller
You can now choose to either automatically set column names, based on the column in the original data source, or enter your own custom column names. In addition, the new "Use text in row" option enables you to name a column heading based on text from a specific row in the model.
Optionally exclude rows in your custom metric data
We've added the option to "Exclude data before row x" to the custom data source modeller for PowerMetrics.
December 2021
New PowerMetrics top-ups
Need more data services or a longer date range window but aren't ready to upgrade to a higher plan? If you're on the Pro or Plus plan, contact success@klipfolio.com to ask about our new top-ups!
Learn moreNew bar and column chart style
The new colour by category style can be applied to bar and column charts to assign colours based on the category you want to display in your metric.
Learn moreData source management
The modelled data sources that are created for you when you add instant metrics are managed by Klipfolio PowerMetrics. If you want to display this data source type in your Data Source List, click the 3-dot menu in the top right of the page and adjust the toggle to Show data sources managed by PowerMetrics. Learn more here.
More instant metric editing options
We've added more editing options to instant metrics. You can now rename, change the refresh rate, and go to the associated modelled data source details page. Learn more here.
Reset metric data
Reset data for an instant metric by deleting its stored historical data and re-downloading new data. There are several reasons you may want to do this, for example, if you made changes to the service, decided to connect using a different account, or there was an API disruption. Learn more here.
Replace metric data
Want to focus on a different measure than the one you originally chose? Added a column of data to your modelled data source that you now want to include in your custom metric? Instead of starting over, you can delete the stored historical data for a custom metric and replace it with different data from your modelled data source. Learn more here.
Access more metric details
Want to learn more about a metric? Click its 3-dot menu and select About to see information such as: metric and source metric names, metric owner, the amount of data history that's being stored, when the metric was last edited and last refreshed … plus lots more! Learn more here.
New metric info icons
We've added an error overlay icon to the metric list and explore pages to indicate if the data source for the metric has been deleted.
Learn moreManage your sample metrics
When you begin with PowerMetrics, you get immediate access to a sample metric dashboard and sample metrics. We just added the ability to delete these sample metrics if you no longer require them. Note that once they're deleted, they cannot be re-enabled.
Learn moreNovember 2021
Instant metrics for HubSpot v3
Start tracking your leads, opportunities, customers, and more with just a few clicks using our HubSpot v3 instant metrics. Feeling creative? Use the query builder in PowerMetrics to add HubSpot v3 custom metrics too!
Learn moreInstant metrics for YouTube
Start tracking your video views, subscribers, impressions, and more with just a few clicks using our YouTube instant metrics. Feeling creative? Use the query builder in PowerMetrics to add YouTube custom metrics too!
Learn moreOctober 2021
Table visualization enhancement
For list and pivot tables that include a date/time column, you can now choose to hide or display blank time periods.
Service icons for calculated metric formulas
In the past, when building calculated metrics, it could be difficult to tell which service each metric was associated with. We now display a service icon for each metric when building calculated metric formulas.
Instant metrics for Zendesk
Start tracking your tickets, contact resolution rates, response times, and more with just a few clicks using our Zendesk instant metrics. Feeling creative? Use the query builder in PowerMetrics to add Zendesk custom metrics too!
Learn moreDownload and print as PDF
You can now download and print your favourite dashboards as PDFs. Keep everyone informed with access to a digital or printed copy of your data. This feature is available to Plus, Pro, and Custom plans.
Learn moreModify chart colours on metric dashboards
You can now control colours for charts on metric dashboards. Choose from our pre-set colour assignment options or add your own custom colours.
Learn moreAuto date range
We've added a new option called "Auto" to our list of pre-set date range filters. When selected, the auto option filters to display data for today minus the number of days included in your plan. For example, if you're signed up with the free PowerMetrics plan, you'll see data for today minus 62 days. The Auto option is especially well-suited for comparing metrics on a dashboard, potentially providing a more contextual perspective. This option ensures your dashboard displays as much historical data as possible, while keeping the dashboard date range and charts' x-axis in alignment to support easier comparisons between metrics.
Learn moreInstant metrics for Salesforce
Start tracking your leads, customers, and opportunities with just a few clicks using our Salesforce instant metrics. Feeling creative? Use the query builder in PowerMetrics to add Salesforce custom metrics too!
Learn moreDuration - new data format type
In addition to Text, Number, Percentage, Currency, and Date, you can now assign Duration as a format type to columns in the modeller and select it as a value when building custom metrics. We've also simplified the way duration is handled in the Klip Editor. You no longer have to write a formula to convert duration data into seconds - we do it automatically for you. (This feature applies to newer Klips accounts - signups post-October 2020).
Learn more