What's New

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.

Display dynamic versions of your PowerMetrics visualizations externally in a website or custom data app.

Admins can now view usage (and limits) for account assets, like metrics and users, and see the hourly data ingestion for data feeds.

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.

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.

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.

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!

When you create or edit metric visualizations, you can now choose the "Auto" setting (4 decimal places) or display up to 9 decimal places.

Simplify and add clarity to your visualizations with the new abbreviate long values setting.

It's now easier to apply filters on a per-metric basis for multi-metrics in Explorer and on dashboards.

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.

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.

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).

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.

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.

Working in PowerMetrics and have questions? Get answers with our new PowerMetrics Assistant!

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.

The option to change dimension names makes it easier than ever to compare and analyze visualizations on dashboards with shared filter controls.

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.

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).

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!

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!

We've added the option to wrap text in tabular charts and to define the number of wrapped rows in pivot tables.

Add context, align similar data sources, change the look and feel of your metrics – all with customized metric icons!

Select multiple metrics and share them all at once.

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.

When inviting users, you can also update their role and add them to a group, including the new "Default" group.

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.

Need help debugging and troubleshooting dbt and SQL queries? You can now view (and, optionally, copy) queries for all your dbt metric visualizations.

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.

Add certified status to the metrics you've verified and want to recommend for use by others in your organization.

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.

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.

Make better decisions by quickly identifying outliers in your data and predicting future metric performance.

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.

You can now queue one or more data feeds to refresh from your data feeds list page.

Don't want to display the date range for specific dashboards? We've added the flexibility to toggle its display on and off.

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.

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.

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.

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!

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.

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!

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.

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.

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.

We've added a key component in keeping your account secure - multi-factor authentication!

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.

Show off your unique brand and personality with customized dashboard background colours.

Personalize your PowerMetrics experience by applying a light or dark mode. Or, automatically use the mode that matches your current device settings.

Our new, more intuitive, vertical-scrolling calendar control makes it easier than ever to set metric and dashboard date ranges.

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".

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.

Now you can select multiple metrics and delete them all at once.

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.

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.

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!

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.

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.

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”.

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.

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.

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.

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.

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!

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.

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 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.

We've added a new style to line and stacked area charts so you can display your data as a smooth line.

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.

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.

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.

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.

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!

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.

You can now connect to and get data from a different account when you’re editing instant metrics.

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.

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.

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.

We've added the option to "Exclude data before row x" to the custom data source modeller for PowerMetrics.

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!

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.

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.

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.

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.

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!

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!

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.

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!

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.

You can now control colours for charts on metric dashboards. Choose from our pre-set colour assignment options or add your own custom colours.

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.

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!

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).