Our recent redesign simplifies the data transfer experience by combining raw and modelled data sources into a single object - data feeds. We’re gradually releasing this new feature to our customers.
If you see Data Feeds in the left navigation sidebar, you’ll learn how to add YouTube instant and custom metrics in this article. If not, go here.
Visualize, discover, and act on your YouTube video data with metrics and metric dashboards!
Get started by connecting to your YouTube data and adding some instant or custom metrics.
This article includes:
Connecting to your YouTube data
Whether you’re creating instant or custom metrics, one of your first steps is connecting PowerMetrics to your YouTube data. Here are a couple things to note about connecting:
Your data is safe with us. The first time you connect your YouTube data to PowerMetrics, you'll be prompted to enter your Google login credentials and give permission to allow access to the data within your YouTube account. We are serious about protecting your data privacy.
Managing your connections. By default, your connection name looks like this: yourname<date and time created>. You can rename connections from your list of connections (accessed by clicking the 
in the left navigation sidebar and selecting Connections) or within the application as you add metrics. Go here for more information on managing your account connections. You can use the same account connection every time you connect to YouTube. If you have trouble accessing an existing connection, your OAuth token may have expired. If that happens to you, check out these troubleshooting tips.
Google account credentials. When connecting your YouTube data to PowerMetrics, you'll be prompted to connect your YouTube account by entering your username and password. Make sure you enter the username and password for the Google account that's connected to your YouTube channel.
Adding YouTube instant metrics
PowerMetrics includes a wide variety of instant metrics for YouTube. Created for you by industry experts and based on best practices, our instant metrics will get you tracking your YouTube data in no time!
Note: The first time you connect to YouTube, you’ll need to enter your Google login credentials and choose the Channel you want use for your metrics.
The following procedure describes adding an instant metric from the left navigation sidebar. You can also add instant metrics from the Metric List page, or from Explorer, or from an open dashboard, in Edit mode.
To add YouTube instant metrics:
- In the left navigation sidebar, click the + button beside Metrics and select See all services.
- On the Where is your data page, select YouTube.
- Select one or more instant metrics.
You can select up to 5 metrics each time you visit this page. If you want to learn more about a metric, click the information button (see below) to see a brief metric definition, a list of available dimensions, and the metric formula. For more detailed information, click the link to go to its information page in MetricHQ.
- Click Add metrics.
- If this is your first time adding metrics for YouTube, click Add new account.
- Enter your Google login credentials and click Allow to enable Klipfolio to securely access your YouTube data.
- Under Choose account settings, select your Channel from the drop-down list. Click Use account.
Note: The next time you connect to YouTube to create a custom metric, you won’t need to enter your Google credentials or choose account settings. That’s because we assume you want to use the same account as before and take you directly to the next step (creating a YouTube data feed). However, if you want to connect to a different account, you can do so from there by clicking the account connection at the top of the data preview window (see below) and either selecting an alternate, existing account or clicking “Add new account”.
That's all there is to it! You just added YouTube instant metrics to your account. If you added them from the navigation sidebar or from your Metric List page, they're added to your list of metrics. If you added them from an open dashboard, they're added to the dashboard and to your list of metrics. If you added them from Explorer, they open in Explorer and are added to your list of metrics.
You're ready to start analyzing and tracking your data as it changes over time. Learn more about viewing and exploring your data.
Note:
- Instant metrics are managed by Klipfolio. As such, they each have a set date range for the data being retrieved. If you add an instant metric and don’t see the date range you’re looking for, we suggest you create a custom metric instead.
- After adding an instant metric, you can edit it and set it as certified. Learn more about certifying metrics. You can also edit the metric to change its service icon. Learn more about changing metric icons. Learn more about editing instant metrics.
Adding YouTube custom metrics
If our YouTube instant metrics don’t get you to the data you’re looking for, create a custom metric instead.
Custom metrics use data feeds. Think of a data feed as the information channel between your source data and your metrics. Every time your data refreshes, the data feed gets updated accordingly. The resulting data is then added to the existing data for all the metrics that use the feed. Learn more about data feeds.
When you add YouTube custom metrics, you:
- Connect to your YouTube data and add a data feed.
- Choose the data to include in your data feed.
- Tips for retrieving playlist data.
- Refine the data in the data feed editor (optional).
- Tips for refining your data.
- Configure your custom metric.
Connecting to your YouTube data and adding a data feed
The first time you connect PowerMetrics to your YouTube data, you log into your Google account, allow Klipfolio PowerMetrics to access your data, and specify the data you want to connect to by choosing your Channel. When you create custom metrics next time, you can use the same account connection or add a new account to point to different data.
Every custom metric needs a data feed. As you create your metrics, you’ll either create a new data feed or select one from your list of existing data feeds.
To connect PowerMetrics to your YouTube data and add a data feed:
- In the left navigation sidebar, click the + button beside Metrics and select See all services.
- On the Where is your data? page, select YouTube.
- Click Can't find the instant metric you need? Build a custom metric instead. It's located at the end of your list of instant metrics. (See below.)
-
If this is your first time connecting to YouTube:
- Click +New data feed > Select YouTube data.
- Click Add new account.
- Enter your Google login credentials and click Allow to enable Klipfolio PowerMetrics to securely access your YouTube data.
- To further define the data you're looking for, under Choose account settings, select your Channel from the drop-down list. Click Use account.
- Next, choose the data to include in your data feed.
-
If you’ve connected to YouTube before:
- You skip the account connection steps described above (we assume you want to use the same account and account settings as before) and go directly to the step for creating a new data feed or selecting an existing data feed.
Note: If you want to connect to a different account, you can do so in the query builder when choosing data to include in your data feed. There you can click the account connection at the top of the data preview window (see below) and select an alternate, existing account or click “Add new account”.
- To create a new data feed, click Select data feed > +New YouTube data feed > Select YouTube data. Then, choose the data to include in your data feed.
- To use an existing data feed, click Select data feed. Choose a data feed from the list on the Select a data feed page and click Select. Then, configure your custom metric.
- You skip the account connection steps described above (we assume you want to use the same account and account settings as before) and go directly to the step for creating a new data feed or selecting an existing data feed.
Choosing data to include in your data feed
In the query builder, you tell us what data you want to retrieve for your data feed. When you use the data feed for your custom metrics, you’ll choose which pieces of data from the feed you want to display for each metric.
Using the data view you select, we’ll run a query to get a list of available columns (fields) from within the data view. You’ll then choose from those columns to specify what data to include in your data feed.
Tip: You can apply filters to the data view and to columns in the left sidebar and in the data preview. Applying filters helps narrow down the data you’re looking for, ensuring you only query the data you need. By pinpointing your desired data, you optimize the volume of data being queried, which not only makes your data easier to understand and handle, it often makes the query run faster! Learn more about filtering.
Note: If you want to retrieve data using either of these data views: TimeBasedReports or TopVideos, for a specific playlist, you'll find some helpful tips for retrieving playlist data in this section.
To choose data to include in your data feed:
- In the Choose data for your data feed page, under Data view, click the drop-down and choose the subset of data you want to query.
Tip: Find the data view you’re looking for by entering its name in the search box or by entering the name of a column/field to find the data view that includes it. - Under Data view filters, add required filters (if needed) and optional filters (if desired).
Tip: APIs for some services include "StartDate" and "EndDate" as optional data view filters. Applying filters here, at the query (source) level, rather than later at the query results level can improve efficiency and simplify data handling. - Under Columns, select the checkboxes beside the columns you want to include in your data feed.
Tip: Columns represent the fields that are available for the data view you selected above. Each item you choose will display as a column in the data preview table. If there are a lot of columns to choose from and you know what you’re looking for, start typing the column name into the search box. You can add up to 30 columns for each data view. - Optionally, apply filters to applicable columns to narrow down your data before previewing.
Note: You may find it easier to apply filters to columns in the next step (in the data preview table) as you can see your data more clearly there. However, if you know your data set well, applying filters in the sidebar can be beneficial because it removes excess data before previewing. It may also be necessary when your data is too large to query all at once. - When you’re done selecting (and filtering) columns, click Preview data. The data preview window is populated with the results of the query for the columns you chose.
Note: The data preview table can show up to the first 1000 rows of your data. As a result, if you have a large data set, some rows may not display. Using the drop-down, you can select the number of rows to display (50, 100, 500, or 1000). You can also see how long it took for your query to complete. (See below.)
- If this isn’t the data you want for your data feed, choose a different data view and/or columns. To preview your most recent choices, either click Preview data again or click
Reload data (located above the data preview table).
Note: At the top of the data preview window, you can see the YouTube account you’re currently connected to (see below). By clicking it, you can change to a different account. If you change accounts, your recent choices are removed and you start over by choosing a data view and columns.
- In the data preview window, you can narrow down the data you want to include in your data feed by applying filters to applicable columns.
- When you’re satisfied with your choices, click Use this data.
You've chosen your data. Next step - refine the data.
Tips for retrieving playlist data
If you want to retrieve data using either of these data views: TimeBasedReports or TopVideos, for a specific playlist, you’ll need to:
- Filter the data view by “IsCurated” and “Playlist”
- Select one or more of the following columns: “AverageTimeInPlaylist”, “AverageViewDuration”, “EstimatedMinutesWatched”, “PlaylistStarts”, “Views”, and “ViewsPerPlaylistStart”. Note: You must also select "Day" for TimeBasedReports.
To retrieve data for TimeBasedReport or TopVideos, for a specific playlist:
- Under Data view, click the drop-down and select either TimeBasedReports or TopVideos.
- Under Data view filters, click + Add filters (optional) and select the checkbox beside IsCurated and beside Playlist. Click Apply.
- Click the Click to add filter box for IsCurated. Select Equals as the operator and select true. Click Apply.
- Click the Click to add filter box for Playlist. Select Match All and Equals as the operators and enter your playlist Id as the value. Click Apply.
- Under Columns, select one or more of “AverageTimeInPlaylist”, “AverageViewDuration”, “EstimatedMinutesWatched”, “PlaylistStarts”, “Views”, and “ViewsPerPlaylistStart”.
Note: You must also select “Day” as a column for TimeBased Reports. - Click Preview data.
- Click Save query.
Refining data in the data feed editor
You’ve arrived in the data feed editor where you can choose to either accept the automatic settings or make changes. Learn more about editing data feeds.
If you’re happy with the automatic settings:
- Click Save data feed and proceed to Configuring your custom metric.
Note: If you chose Videos as the data view and Duration as one of the columns in the previous step, see the Tips for refining your data section below first.
If you want to make changes:
- Some common adjustments include changing the data format or names for columns, updating the data feed name, and combining columns using formulas - there are many customization options available.
- If you chose Videos as the data view and Duration as one of the columns in the previous step, see the Tips for refining your data section below.
- If you want to adjust your query choices (for example, add or remove columns or filters) click the tile under Data service to return to the query builder. (See below.)
- When you’re finished editing the data feed, click Save data feed and proceed to Configuring your custom metric.
Note: After you’re finished creating a custom metric with this data feed, you can return to it and use it to make more custom metrics. In the left navigation sidebar, click Data Feeds. Select the desired data feed from the list and click +Add metric.
Tips for refining your data
Did you choose Videos as the data view and Duration as one of the columns in the previous step (choosing data to include in your data feed)?
If the answer is yes, then you’ll need to edit the data format for the duration column to use ISO-8601 format.
To set the duration column to use ISO-8601 format:
- Select the Duration column.
- Under Data Format, click the drop-down and select Duration.
- Under Input Format, click the drop-down and select ISO-8601.
You've created a YouTube data feed. Next step - configure your custom metric.
Configuring your custom metric
As you configure your custom metric, you can click the 
button, located beside “Measure”, “Date and Time”, and “Date handling”. This opens a guide for each setting that helps you decide which options to choose. As you make choices, you’ll see the result in the metric preview window on the left. Don’t worry about getting everything right the first time. Before clicking “Save metric”, you can go back and forth, making changes and observing the preview until you arrive at the configuration settings that give you the exact metric you’re looking for.
To configure your custom metric:
- Under Data feed, you can see the data feed that’s associated with this metric. If desired, click its name to open it for viewing or editing.
- Under Measure, select the column from the data feed that contains the values you want to track in your metric.
- Under Dimensions, select the dimensions by which you want to be able to segment and filter your metric value.
Each selection shows a unique view of your business, for example, you might choose to look at your sales data based on region, sales rep, or product type. The dimensions you select will be available for filtering in the finished metric. You can filter on the individual metric level or at the dashboard level (when you add your metric to a dashboard). You can also create a metric with no ability to segment or filter, by not selecting any dimensions.
The number of dimensions you can select depends on your pricing plan. You can either upgrade your plan here (by clicking Upgrade) or from your pricing plan page (accessed by clicking the button in the left navigation sidebar and selecting Plan).
Note: When choosing dimensions, you can only select columns that have a text format. If the associated data feed doesn’t include any text columns (or has only one text column) there will be no available categories by which to segment.
Tip: You can optionally change a dimension’s name by selecting the current name and typing a new one. This changes the display name only (not the name of the dimension in the data feed). If you change the display name and want to see the one that’s being used in the data feed, hover over the dimension’s name.
Note: If you change a name for a dimension that’s also being used by other metric visualizations, associated filters and segmentations will be removed from those visualizations and need to be reapplied. - Under Date and Time, select the column from the data feed that contains the date/time associated with each value.
If the data feed doesn’t include a date column or history, deselect the Data feed contains historical data toggle to use the date and time the data feed is refreshed. (See below.)
- Click the Settings tab.
- Under Date handling, select Use all values or Use most recent values only. Your choice determines the data points your metric will use when calculating the metric value for a time period.
If you chose Use most recent values only, select the desired time period. (See below.)
If you need more help deciding which date handling option to choose, check out this article: Choosing the right date handling method for your custom metrics. - Under Format, select from Numeric, Currency, Percentage, or Duration.
If you selected Currency as the data format, the default currency symbol that will display is USD $. You can select an alternate Currency symbol from the drop-down list. Note: This is a display option only. Currency is not converted.
If you selected Duration as the data format, optionally, adjust the Maximum and Minimum Granularity settings. - Under Decimal places, select the number of decimals to display (from 0 - 9). The Auto setting displays up to 4 decimal places and drops trailing zeros.
Note: If you change the decimal place setting for a metric and want to see the source data values with their original decimal places, reselect Auto. - Under Favourable trend, choose whether you want ascending or descending values to indicate a positive trend. For example, if your metric includes sales totals, a higher (ascending) number demonstrates a positive trend but, if your metric includes cost to acquire customers, a lower (descending) number indicates a positive trend. Favourable trends are indicated by a green arrow. Unfavourable changes in metric values are indicated by a red arrow.
- Under Default aggregation, you’ll see the default aggregation type. It’s based on the measure you selected for the metric. For numeric columns, the default aggregation type is “sum”. For text columns, it's “count”. The default aggregation type will be used when the aggregation has not been set by the user in a metric visualization and wherever there are no configuration options available. For example, on the Metric List page, metrics will display using a default aggregation type based on your selection here.
Note: When metrics are created, they’re automatically visualized using the most appropriate aggregation type. As such, we don’t recommend changing the default aggregation type.
- Enable the Users can override aggregation option if you want to allow changes to the aggregation setting for the metric.
Note: When metrics are created, they’re automatically visualized using the most appropriate aggregation type. As a result, we recommend disabling the ability to override the default aggregation. - Click the About tab.
- Optionally, enter a new name and description for the metric.
Note: The metric was automatically named based on the measure you chose. - Under Metric image, optionally, click Edit image to change the metric’s service icon. Learn more here.
- Under Certification, optionally, enable the Certify this metric toggle. Learn more here.
- When you’re done configuring your metric, click Save metric.
If you added the custom metric from the navigation sidebar or from your Metric List page, it's added to your list of metrics. If you added the custom metric from an open dashboard, it's added to the dashboard and to your list of metrics.
You're ready to start analyzing and tracking your data as it changes over time. Learn more about viewing and exploring your data.