Creating a PowerMetric

PowerMetrics offer a wealth of opportunity for you to visualize, learn from, and share your data. As with all PowerMetric features, the creation process is highly flexible, with multiple options for configuration and exploration to help you envision your most essential data and track your business metrics meaningfully.

Note: If you signed up for a trial account on or after May 16th, 2019 and you want to create PowerMetrics, please see this article.

This article contains the following sections:

Before I start, what should I know about PowerMetrics?

PowerMetrics are created from modelled data sources so, when creating a PowerMetric you must have access to at least one modelled data source. You might ask - Should I model the data source first? The answer depends on whether you want to create a PowerMetric using one of your existing data sources or a new data source:

  • If you already have a data source that you want to use for your PowerMetric, you must model it before building the metric. After you've modelled the data source, you will be able to select it during the PowerMetric creation process and then quickly advance to creating a PowerMetric.
  • If you want to create a new data source for your PowerMetric, you can build your data source, model it, and create a PowerMetric, all within the PowerMetric creation flow.

If you need help when connecting to a service, refer to this section in our Knowledge Base.

For more information specific to modelled data sources, see:

Creating a PowerMetric

Before creating a PowerMetric, you need to decide which data you want to connect to and visualize and what metric you want to measure. For example, if you want to track customer interaction with your company’s website, you could connect to your data in Google Analytics and track interactions using the Sessions metric.

You can create a PowerMetric using our pre-built or custom-built options. Our pre-built options enable you to get to your PowerMetric quickly without the need for further configuration. When you custom-build, you personalize your PowerMetric properties according to these configuration steps.

Pre-built options

If you know what you’re looking for and want to get to your data as quickly as possible, use our pre-built connections to services and pre-built PowerMetrics.

Here is an example of how you might use our pre-built options to create your ideal PowerMetric:

  • You want to track the number of followers for your company’s Twitter account. Under Metrics by service, choose Twitter and, under Choose a PowerMetric, choose Follower Count.

When building a PowerMetric, you can start with either a pre-built connection to a service or with a pre-built PowerMetric.

To add a PowerMetric using our pre-built options:

  1. At the top of the side navigation bar, select PowerMetrics from the drop-down menu.
  2. Click the + beside PowerMetrics.
  • To start with a pre-built connection to a service: Choose a pre-built connection to a service, displayed under Metrics by service (see some examples below).

  • Next, pick a pre-built PowerMetric under Choose a PowerMetric > Instantly get data.

After selecting a service and a metric, you may be prompted to enter information, such as your account ID, but other than that, the connection is automatic and fast!

  • To start with a pre-built metric: Choose a pre-built metric, displayed under Featured metrics (see some examples below). When you choose a pre-built metric and a connection to a service, parameters are applied invisibly, populating the PowerMetric automatically.

  • Next, pick a pre-built connection to a service under Instantly get data.

After selecting a metric and a service, you may be prompted to enter information, such as your account ID, but other than that, the connection is automatic and fast!

When you create a PowerMetric using our pre-built options, no further configuration is needed. You're ready to explore your PowerMetric by personalizing and experimenting with your data! To learn more about exploring your data, go here.

Custom-built options

Get creative with your data with our custom-built options.

There are many custom paths you can take when creating a PowerMetric. Here are just a few examples of how you might use our custom options to create your ideal PowerMetric:

 

  • You want to build a custom PowerMetric based on one of your existing data sources that has already been modelled. At the top-right of the Metric HQ page, click Create a custom PowerMetric > Use a data source. Click Use a saved data source. Select the existing, modelled data source from your list. Follow the wizard to configure your PowerMetric. (See detailed configuration instructions here).

 

  • You want to connect to a service but don’t see it in our list of pre-built options. If you know what metric you want to track, under Featured metrics, either select a pre-built metric from the list or, under More... > More PowerMetrics, choose from our list of defined metrics. Then, under Get data via a service connector, choose from the list of supported services. Create and model your data source and then configure your PowerMetric.

 

  • You want to create a PowerMetric using data from a .csv file that’s saved on your desktop. At Metrics by service, click More . Under Get data via a core connector, click Upload a file. Create and model your data source and then configure your PowerMetric.

 

To add a PowerMetric using our custom-built options:

  1. At the top of the side navigation bar, select PowerMetrics from the drop-down menu.
  2. Click the + beside PowerMetrics.
  3. Select options and navigate through your chosen workflow until you arrive at the in-app PowerMetric configuration wizard, where you choose properties for your customized PowerMetric. See the following section for configuration instructions.

Configuring a custom-built PowerMetric

This section walks you through our in-app PowerMetric configuration wizard. Note that you can move backward and forward through the wizard by clicking “Back”, “Next”, or selecting from the left-side options in the configuration tree.

To configure a custom-built PowerMetric:

  1. Connect to your data by either selecting an existing, modelled data source or by creating a new data source.
  2. If you clicked Use a saved data source, on the Saved data sources page, select one of your modelled data sources.
  • If you want to see details for (or edit) the modelled data source, click Modify data.

You also have the option to modify your data source at other points in the configuration wizard.

  • If you want to choose a different, existing modelled data source, click Use a different data connection.
  1. If you clicked Create a new data source, choose to Get data via a core connector (select from Upload a file, REST/URL, SQL query, or FTP & SFTP) or choose to Get data via a service connector (select from our list of supported service connections).

If you need help connecting to your data, refer to this section in our Knowledge Base.

When modelling your data source, in the Verify your data page, either click Continue (to accept the auto-selected choices for modelling your data source) or, if you want to make modifications to the modelled data source, click the Edit button, make changes, and then click Save.

  1. Now that you’ve connected to your modelled data source, click Select a metric value and choose which column of data you want to track in your PowerMetric.

Once you've chosen a metric value, its default aggregation type displays. The default aggregation type will be used wherever there are no configuration options available. For example, on the PowerMetric List page, PowerMetrics will display using a default aggregation type based on your selection here.

  1. Click Segment metric value by category, to select the categories by which you want to filter your data.

Each selection brings a different perspective to your data and shows a unique view of your business, for example, you might choose to segment your sales data based on region, sales rep, or product type.

If you want to create a PowerMetric without segmentation, click the toggle button at Segment values for this PowerMetric to turn off this step in the configuration wizard.

If the modelled data source for your PowerMetric doesn’t include any text columns (or has only one text column) there will be no available categories by which to segment. This step will be marked as complete and you will move on to the next step in the wizard. If you want to add columns to your modelled data source to enable segmentation, click Modify data.

  1. Click Select a date column. Either select a timestamp column from your modelled data source or Use the current date and time (if your modelled data source doesn’t include a timestamp column).
  2. If you chose to Use the current date and time, select an appropriate aggregation method: All values, The latest values, or The latest values of each. Your choice determines the data points your PowerMetric will use when calculating the PowerMetric's value for a time period:
  • All values: Select this option if you want to include every value for a time period to create the total of values. For example, you may have a spreadsheet that includes all sales transactions for the month of January. In this case, you want to sum all values to get the total values for the month.
  • The latest values: Select this option if your data includes current value totals for specific points in time. In such cases, the latest value represents the metric's value for a time period. For example, if you are tracking Twitter followers, looking at the latest values will give you the total of values for the time period.
  • The latest values for each: (Hour, Day, Week, Month, Year)  Select this option if each value in your data is a summary of a time period. For example, with Google Analytics "sessions by day" data, the last value of the day is a summary for that day. Your data is collected again on the following day, beginning at zero. In such cases, the last value is the complete summary of the day. To calculate the metric's value for a month, you sum the last value for each day in the month. When you select this option, you also select a time period from the drop-down list below it (Hour, Day, Week, Month, or Year).
  1. Click Options:
  • To enter a Name for the PowerMetric.
  • To choose a data format: Numeric, Currency, or Percentage.
  • To set your data to Show as cumulative by default for all of the PowerMetric's view modes.
  • To set the Favourable trend for your PowerMetric. Choose whether you want ascending or descending values to indicate a positive trend. For example, if your PowerMetric includes sales totals, a higher (ascending) number demonstrates a positive trend but, if your PowerMetric includes cost to acquire customers, a lower (descending) number indicates a positive trend. This option only applies to scorecard (single value) visualizations. Favourable trends are indicated by a green arrow.
  1. Click Save.

Now you're ready to explore your PowerMetric and learn more about your data: See Exploring a PowerMetric.

Learn more

Have more questions? Submit a request