Skip to main content

Getting access to platform metrics through a dataset

Follow the process outlined in this section to get access your metrics.

metrics_outline.png

STEP 1: Getting access to the ddw-metrics resources

Private instance and single tenant instance installations and organizations in multi-tenant installation that are on the Enterprise plan get the ddw-metrics resource tables through a special ddw-metrics dataset.

If you don't have access to the dataset or the tables in it, do the following to get access:

  1. Contact data.world support and ask them to add the metrics resources to yourorgname.

  2. In your request, include the name of the organization where you want them to add the metrics dataset.

    Important

    Your organization should be on an Enterprise plan (for multi-tenant installation) or you should be using private instance or single-tenant install.

  3. Once the Support team informs you that the dataset is added to your organization, you can browse to the dataset to view the metrics tables.

STEP 2: Know your ddw-metrics dataset and project

  1. A special metrics dataset - ddw-metrics dataset is available in your data.world organizations. You can explore it by browsing to the datasets list of your organization or by searching for it. The dataset name will be: ddw-metrics-<custom_name> for example, ddw-metrics-democorp

  2. Click the Explore this dataset button to see the contents of the dataset.

  3. The Metrics categories available are: Events, Membership, Resources, Tops and Visits. See here for more details on these.

    Warning

    Restrict the use of the dataset!

    • This dataset has all the information about how the application is being used by your organization. It is recommended that you share this dataset with limited number of people in your organizations.

    • This dataset is automatically updated at regular intervals. You should not edit any properties of this dataset and should not add any files in it. Any changes made to the dataset will be overwritten at the next automatic update.

    ddw_metrics.png

  4. Along with the ddw-metrics-<custom_name> dataset, the support team also adds the ddw-metrics-etl-<custom_name> project to the organization. This project stores queries that creates the metrics in the Metrics dataset (ddw-metrics-<custom_name>).

    Warning

    Restrict the use of the project!

    Just like the ddw-metrics-<custom_name> dataset, this project is periodically updated by the system. It should not be edited and should not be shared with wider audience.

STEP 3: Query the metrics to generate insights

  1. Create a project and link the ddw-metrics-<custom_name> dataset with it so you can query it.

  2. Locate the events_searches_last_90_days table and create a new query to find out how many times a keyword Sales was searched in the last 90 days.

    Important

    • We are using events_searches_last_90_days to just show a sample query of how this is done. You can use any query or table for this exercise.

    • Replace Sales with a search term that is relevant for your organization.

    Sample query

    DECLARE ?search_value AS STRING = "sales"

SELECT DATE, 
       COUNT(*) AS number_of_searches
FROM events_searches_last_90_days
WHERE search_value = ?search_value
GROUP BY DATE
ORDER BY DATE DESC
LIMIT 90

    When you run the query, you will see the results for last 90 days.

  3. Click the Open with Chart Builder (or any other BI tool) to see a graphical representation of the results.

    Caution

    The Chart Builder tool is available only in organizations in multi-tenant installation.

    view_query_results.png

  4. In the Chart Builder tool, set the X and Y axis to see the chart for the data returned by the query.

    sample_chart.png

    Note

    Pro tip: Generate graphical representation and charts from the data and publish to a shared projects as Insights or other tools so others can consume the information.

View the results!🎉

We just showed you how to open the results in the built-in Chart Builder tool. You can choose to open the results in Tableau, Microsoft Excel, or other tool of your choice to build charts and share insights with your team.

Note

Pro tip: For BI tools, use the Postgres Proxy service to connect directly to the metrics dataset.

Try a few more queries on your own now!

In this section: