Interface

Overview


Screenshot - Datamine

The Data Mine tool is run via Hive queries in the Query Editor. Query results are returned in the Results Panel, and data exploration is presented via the Table Explorer panel.

A. Scheduled Queries

B. Grouped Queries

C. Shared Queries

D. Table Explorer

E. Query Editor

F. Results Panel

Scheduled Queries


Schedule queries to run without requiring a user to log in. This will email a .csv file containing the results to any user on the Distribution List.

Screenshot - Datamine Scheduled Queries

  1. Open the query you would like to share by clicking it in the Queries explorer.
  2. Click the Schedule button to open the Schedule Query pop-up.
  3. Choose the frequency that your query will run. Your query can run Daily, Weekly, or Monthly.
  4. Choose the Date you would like your query to start on.
  5. If you would like your query to run at a specific time, select the corresponding checkbox and choose the Time you would like your query to start at.
  6. Choose the Date you would like your query to end on. You can also choose the Never option to have your query run forever.
  7. Click the Add Co-workers link to choose which Upsight users you would like to receive the query results.
  8. Click the Schedule button to start the query schedule.
  9. Upon receiving the first scheduled email, users will be able to opt out of receiving further query results.
  10. A scheduled query will have the Schedule icon schedule icon next to the name to indicate that it will run periodically.

Grouped Queries


When closing your queries they will be automatically saved in the My Queries explorer. Organize your queries to easily locate them in the future.

Screenshot - Datamine Queries

  • In the Query Editor, click the X button on your current tab to close and save your open query.
  • In the My Queries, tab click the Add New Group link to create a new group to store your queries.
  • Double click a group to rename it.
  • Click a group's + button to expand the group and reveal all the queries within it.
  • Click a group's list Button to Open, Duplicate, Share, or Delete the group.
  • Drag a query from the Query Editor tab or the My Queries list into a group to save the query within the group.

Shared Queries


Share commonly used queries with Co-workers with a click of a button.

Screenshot - Shared Queries

  1. Open the query you would like to share by clicking it in the Queries explorer.
  2. Click the Share Button button to open the Share Query pop-up.

Screenshot - Share Query

  1. In the Share window's text box, start typing in the Co-worker's email address. As you type, DataMine will suggest valid email addresses that you can click on.
  2. In the Share window, click Share Button when the desired addresses are added.
  3. The selected Co-workers will now be able to see queries that are shared with them on their Share Queries explorer whenever they login to DataMine.
  4. To modify who can see a Query that is already being shared, click the Share Button button to open the Share Query pop-up.
  5. To prevent a single user from accessing a shared query, click the delete button next to their name.
  6. To completely disallow shared access to a query, click the Stop Sharing button.

Table Explorer


The Table Explorer is located at the left side of the query editor. Message tables (MSGTs) are shown in an expandable list, grouped by their applications.

Screenshot - Tables

  • Click the triangle icon, next to each application to have a quick view of the tables it contains.
  • Click the triangle icon, next to each table to to have a quick view of the data samples it contains.
  • Click the pencil icon to rename the common prefix of tables in batch mode.
  • Click the table name and table name to insert the table name into the query editor.
  • Click Run to generate a Select All query in the query editor.

Mapping Application Tables


When you have created an application in your account and begin to send data to Upsight servers, you will be able to add the application to your Data Mine environment. To do this, click on the "Tables" tab to access the Table Explorer. Under the "Application Tables" header you will see a "Map New Application" button.

Tables Tab

Once clicked, you will see a modal pop-up that allows you to choose which application you would like to map.

Map New Application Modal

If you have added an application but our servers have not received any data corresponding to that application’s API key, you will not be able to map that application into Data Mine, as indicated by the list in the modal.

Applications without data on Upsight servers

Once an application is mapped in Data Mine, the application will be added to the Table Explorer. While the name of the application will be automatically assigned by the system, once added you will be able to edit the application name by clicking on the pencil icon that appears alongside the Application name in the Table Explorer. You will also be able to see all of the tables that you can query by clicking the drop-down arrow next to the newly mapped application name.

You can remove a mapped application at any time by clicking on the trash can icon next to a mapped application. This will not remove any data, but queries that reference any table within that mapped application will not longer work. You can also re-map an application at any time.

Mapped Applications

Data Mine Table Mapping FAQ

Why can't I see all of the message type tables in my application?

Tables will only become available after the server has received data for a specific message type.

Can I choose the name of my application in the Table Explorer?

Application names are automatically created when the application is mapped and currently cannot be changed.

Why can't I see the "Map New Application" button?

If all of the available applications have been mapped within Data Mine, the Map New Application button will not appear. When an application is added and data has been received by our servers the button will appear.

Query Editor


The Query Editor allows you to input Hive queries.

Note A semicolon is not needed at the end of the query, and will be automatically trimmed if included.

Screenshot - Datamine Query

  • Click plus button to add a new editor.
  • Click Duplicate to duplicate the current active editor in a new tab.
  • Each editor is associated with a tab with a descriptive name, and the name of the tab can be changed by being double clicked.
  • All open editors are automatically saved every three seconds, and will be automatically loaded at the next login.
  • The content of the current editor is saved in the My Queries box if the editor is closed.
  • To delete a query without saving it, click Delete
  • If a query successfully returns results, the results will be shown in the Results Panel, and will be associated to the editor/tab within which the query was submitted.

Results Panel


Hit Run to execute one or more queries. The results section is located below the query editor.

Each query can be in four different states: Setting Up, Retrieving Results, Failed, and Finished.

Setting Up

If the current status of your query is Setting Up, the query is under execution, and the following operation can be performed on the query:

  • Click Kill to kill the current running query.

Retrieving Results

If the current status of your query is Retrieving Results, the query is under execution, and the following operation can be performed on the query:

  • Click Kill to kill the current running query.

Failed

If the current status of your query is Failed, the query execution has failed. An error message will be presented detailing the cause of failure.

  • Fix the issues that are causing the error, and try to run your query again.

Finished

If the current status of your query is Finished, the query has completed, and the following operation can be performed:

  • The results are now displayed in table format in the results panel. Use the scroll bar to navigate through the records. Note Query results are only temporarily saved, and will go expire after a certain number of days. It is strongly recommended to export the results you need before their expiration
  • Click the Export button to export results to local filesystem as a .csv file. Note Exports are limited to 1 GB, any result set larger than this will be truncated.

Visualize Results


What is Data Mine Visualization?

Data Mine Visualization allows you to chart your Data Mine query results. It also allows you to pin scheduled query result charts to Upsight Analytics Custom Dashboards. Data Mine Visualization makes your Data Mine results easier to view share in a more accessible format.

How do Data Mine Visualizations help me?

  • Better customization, look at the exact metrics that interest you.
  • Compare metrics for multiple applications on the same chart.
  • Allow users who are not familiar with Data Mine to also see results on the Upsight Analytics Dashboard.
  • View metrics for a custom cohort of users.

How do I use Data Mine Visualization?

Creating a Data Mine Visualization Chart

  1. Create a Data Mine query that returns the data you are looking to chart.
  2. To identify a data series as your x-axis, name your first column with the appropriate Upsight Analytics Data Mine Visualization label. For reference to Upsight Analytics Data Mine labels, see the table below.
  3. Add up to four records in your SELECT statement that you would like to display on the chart.
  4. Click the Run Query button to run your query.
  5. When your result set is returned, click the Chart button in the Results section.
  6. Data Mine will chart the first five fields of the first 100 records that the query returns. The first column will be the x-axis with its format defined by the label.
Label Name Label Function
ktlabel_date Creates a time series chart with FROM_UNIXTIME formatted time as the x-axis, and the columns as data series in your y-axis. FROM_UNIXTIME formatted time.
ktlabel_epoch Creates a time series chart with ktlabel_epoch as the x-axis, and the columns as data series in your y-axis.
ktlabel_number Creates XY scatterplot chart with the values of ktlabel_number as your x-axis, and the remaining values as your y-axis. The input for this must be an integer.
ktlabel_string Creates a bar chart with the values of ktlabel_string as your x-axis, and the remaining values as your y-axis.

Pinning a Data Mine Visualization Chart

  1. Before you can pin your chart, you must schedule it. This is to prevent charts with outdated data from appearing on your Upsight Analytics Dashboard. For more information on scheduling Data Mine queries, please see this page.
  2. On the top right corner of the Data Mine chart, click the Pin button to access the Pin Menu.
  3. You will be able to Pin any Data Mine chart onto any Upsight Analytics application's Data Mine Custom Page.

Sharing a Data Mine Visualization Chart

There are two ways of sharing your Data Mine charts: sharing queries, or sharing custom pages. Sharing a query will allow users you share with to run the query and generate their own visualizations. Sharing a custom dashboard page will allow other users to view pinned charts without having to run the query for themselves.

Examples

Unique Users Who Performed a Custom Event

Unique Users Who Performed a Custom Event

  • In this specific example, we have unique users who have completed a specific custom event for each of the days. We can also use tags such as any of the parameters you have put in the JSON object.
  • Replace all text enclosed with ## and ## (for example: ##month_in_YYYYMM_format## could be 201303) using the following instructions:
    • Replace ##APP1_evt## with the name of the applications you are interested in reviewing, for example: demoapp_evt.
    • Replace ##month_in_YYYYMM_format## as the month period of interest using the format YYYYMM, for example: 201303.
  • Note that the alias ktlabel_date is reserved in this case. With this keyword, Data Mine will know to treat this column as the x-axis and as a date.
    SELECT FROM_UNIXTIME(utc_timestamp, 'yyyy-MM-dd') AS ktlabel_date, COUNT(DISTINCT(s)) AS DAU_Event1
    FROM ##APP1_evt##
    WHERE month = ##month_in_YYYYMM_format##
    AND st1 = "your_event"
    GROUP BY FROM_UNIXTIME(utc_timestamp, 'yyyy-MM-dd')

Unique Users Who Performed a Custom Event - Multiple Data Series

Unique Users Who Performed a Custom Event - Multiple Data Series

In this specific example, we have unique users who have completed custom event 1 for each of the days and unique users who have completed custom event 2 in a different data series. In the same chart, we can display up to 4 data series.

  • Replace all text enclosed with ## and ## (for example: ##month_in_YYYYMM_format## could be 201303) using the following instructions:
  • Replace ##APP1_evt1## with the name of the applications you are interested in reviewing, for example: demoapp_evt.
  • Replace ##month_in_YYYYMM_format## as the month period of interest using the format YYYYMM, for example: 201303.
  • Note that the alias ktlabel_date is reserved in this case. With this keyword, Data Mine will know to treat this column as the x-axis and as a date.
SELECT event1.datelabel AS ktlabel_date, event1.DAU_Event1, event2.DAU_Event2
FROM (
   SELECT FROM_UNIXTIME(utc_timestamp, 'yyyy-MM-dd') AS datelabel, COUNT(DISTINCT(s)) AS DAU_Event1
   FROM ##APP1_evt##
   WHERE month = ##month_in_YYYYMM_format##
   AND st1 = "your_event1"
   GROUP BY FROM_UNIXTIME(utc_timestamp, 'yyyy-MM-dd')
) event1
JOIN (
   SELECT FROM_UNIXTIME(utc_timestamp, 'yyyy-MM_dd') AS datelabel, COUNT(DISTINCT(s)) AS DAU_Event2
   FROM ##APP1_evt##
   WHERE month = ##month_in_YYYYMM_format##
   AND st1 = "your_event2"
   GROUP BY FROM_UNIXTIME(utc_timestamp, 'yyyy-MM-dd')
) event2
ON event1.datelabel = event2.datelabel

Time Taken To Reach Highest Level For Each User

Time Taken To Reach Highest Level For Each User

  • In this specific example, we have the time taken to reach the highest level for each user displayed on a scatter plot.
  • Replace all text enclosed with ## and ## (for example: ##month_in_YYYYMM_format## could be 201303) using the following instructions:
    • Replace ##APP1_evt## with the name of the applications you are interested in reviewing, for example: demoapp_evt.
    • Replace ##month_in_YYYYMM_format## as the month period of interest using the format YYYYMM, for example: 201303.
    • Replace ##timeout_in_minutes_integer## with the desired timeout, for example a value of 2 would mean that when a user is inactive for 2 minutes or more, the session would end.
  • For mobile applications we recommend setting the timeout to 2 minutes and for web applications we recommend using 30 minutes.
  • Note that the alias ktlabel_number is reserved in this case. With this keyword, Data Mine will know to treat this column as the x-axis and as a number.
  • ktlabel_number must be an integer.
    SELECT CAST(time_spent.app_timespent AS BIGINT) AS ktlabel_number, userlevel.maxlevel AS user_level
    FROM (
       SELECT MAX(l) AS maxlevel, s AS unique_users
       FROM ##APP1_evt##
       WHERE month >= ##month_in_YYYYMM_format##
       GROUP BY s
       -- Currently, the scatter plot is limited to 100 data points, which this ORDER BY, we will look at the 100 users with the highest levels
       ORDER BY maxlevel DESC
    )userlevel
    JOIN (
       SELECT session_info.s,
       ROUND(SUM(session_info.session_length)/60,0) AS app_timespent
       FROM (
          SELECT kt_session(calc_session.s, calc_session.evt_lst,##timeout_in_minutes_integer##) AS (s, session_number, session_length)
          FROM (
             SELECT session_set.s, collect_set(session_set.timestamps) evt_lst
             FROM (
                SELECT total_list.s, total_list.timestamps
                FROM (
                   SELECT pgr.s, pgr.utc_timestamp AS timestamps
                   FROM ##APP1_pgr## pgr
                   WHERE month >= ##month_in_YYYYMM_format##
                   AND s IS NOT NULL
                   UNION ALL
                   SELECT evt.s, evt.utc_timestamp AS timestamps
                   FROM ##APP1_evt## evt
                   WHERE month >= ##month_in_YYYYMM_format##
                   AND s IS NOT NULL
                ) total_list
             )session_set
             GROUP BY session_set.s
          ) calc_session
          ORDER BY s,session_number DESC
       )session_info
       GROUP BY session_info.s
    )time_spent
    ON userlevel.unique_users= time_spent.s

Unique Users Who Have Completed A Custom Event, By Event

Unique Users Who Have Completed A Custom Event, By Event

  • In this specific example, we have unique users who have triggered each custom event for a specific time range.
  • Replace all text enclosed with ## and ## (for example: ##month_in_YYYYMM_format## could be 201303) using the following instructions:
    • Replace ##APP1_evt## with the name of the applications you are interested in reviewing, for example: demoapp_evt.
    • Replace ##month_in_YYYYMM_format as the month period of interest using the format YYYYMM, for example: 201303.
  • Note that the alias ktlabel_string is reserved in this case. With this keyword, Data Mine will know to treat this column as the x-axis and as a string.
    SELECT n AS ktlabel_string, COUNT(DISTINCT s) AS unique_users
    FROM ##APP1_evt##
    WHERE month = ##month_in_YYYYMM_format##
    GROUP BY n
    ORDER BY unique_users DESC
    LIMIT 10

Table Creation


What are User Created Tables?

The Upsight Analytics Data Mine gives you the ability to create your own table from a query result set. This allows you to reference the results of one query in another query without nesting queries inside one another.

How are User Created Tables useful?

Table creation simplifies query writing by removing the necessity to use multiple nested queries. It also saves time whilst running multiple queries using the same calculated dataset. By running the nested query once and saving the results, you will no longer need to continuously reprocess the same nested query.

How do I create a table?

  1. In the Query Editor, create a draft of the query that you would like to store as a table.
  2. Run the newly created query.
  3. Once the query successfully completes, you will see the Menu icon in the upper right of the results pane.
  4. Click on the Menu button and choose Create table from results.
  5. Enter a name for your table.
    Note Once a table is created and named, it is not editable for the life of the table so choose carefully.
  6. Your table is now queued for creation.
  7. Wait a few minutes and then in the upper right hand portion of the User Created Tables box, click the refresh link. When the table has been created, you will see your table under the Table Explorer.
    Note Much like a query, these requests are queued and it is often difficult to estimate the amount of time required to complete the creation of a table.
  8. If you see your newly named table in the User Created Table, Congratulations! You are now the proud new owner of your very own user created Upsight Analytics Data Mine table.

Use Cases

Custom Segmentation

With Data Mine, I am constantly analyzing the behavior of my whales. I define my whales as the users who have spent $5.00 in the last 30 days. To do this, I have written a query that generates all the users who fall in to my definition of a whale. The frustrating part is that I have to include this query as a subquery in any analysis I do on my whales.

With User Created Tables, I can create a table in Data Mine by leveraging my users who spent $5.00 in 30 days query and writing separate queries that build on top of that table. If I want to change my definition of a whale, I can do that in one place and have it propagate to all of my other analyses automatically.

In addition to a more modular approach to your Data Mine query writing, it also makes query writing easier and more efficient for the end BI user.

Requirements/Restrictions

  • You have a limit on total number of tables and size of all tables. This limit is listed in the Table tab of the sidebar.
  • Once you create the table you cannot rename the table, nor can you rename the columns.
  • There is no way to partition User Created Tables.
  • The column datatype will always be strings.

CSV Uploader


What is Data Mine CSV Uploader?

Data Mine CSV Uploader is a new product that allows you to upload data tables into Upsight's Data Mine Cluster so that you can query this data within the normal Data Mine interface. This is especially useful if you have internal or third-party data that you would like to query within Data Mine.

How do I access the CSV Uploader?

For now, this product is only available to selected partners. To gain early access to this feature prior to general release, please contact your CSM.

Once you have been whitelisted, you will be able to upload CSV files into Data Mine by clicking on the Upload CSV button found on the Tables tab to the right of the Data Mine Query Editor window.

Data Mine Tables Tab

To upload a table via CSV, start by clicking the Upload CSV button

The Create Table and Upload CSV popup should appear with three sections for you to fill in.

CSV Uploader Popup

Step 1 - Name your table

You must name the table that you are uploading. The name you choose for this table will be the name you will use in queries that reference this table's data. It will also be saved among the other tables that you have available within your Data Mine account. As indicated in the helper text, the table name must be all lowercase letters, with no spaces or special characters. Instead of spaces, we suggest you use underscores, "_".

Step 2 - Provide column names for your table

Each field name should correspond to the columns included in your CSV. For every column in your table, you must also include the type of the data that the column represents.

Field Types

Step 3 - Choose the file you wish to upload

The upload format is required to be a CSV (comma separated values) filetype. Note The maximum file size is 128MB but you can upload multiple CSV files to add more data to the same table.

CSV Uploader FAQ

Is there a limit to the number of tables I’m able to create via CSV Uploader?

Yes, there is a limit of 100 user-created tables. This limit includes both CSV uploaded tables and user tables created from a query result.

How long does it normally take to upload a file? Is there a way to track upload progress?

The upload and verification time depends on the file size. It can take seconds or several minutes.

Can I upload CSV data to existing tables that were not created using CSV Uploader?

No. Data from CSV uploads can only be uploaded to tables created using CSV Uploader.

Can the data I upload into Data Mine be visualized in the dashboard?

You will be able to visualize Data Mine data in the dashboard by using the Data Mine Visualization tool. If a query is both scheduled and formatted for visualization, you will be given the option to visualize with a chart once results post. That chart can then be pinned to a custom dashboard.

Is it possible to schedule and share queries to run on tables that have been uploaded via CSV Uploader?

Yes. Tables created using the Data Mine CSV Uploader behave the same as other tables saved in Data Mine. Queries that reference these tables can be scheduled and shared with other users just as you would for any other query referencing a table in Data Mine.

Data Mine Push Notifications


What is the Data Mine Push Notifications feature?

Data Mine Push Notifications allow you to send push notifications to a very specific segment of your users. This is done by querying the users using the power of Data Mine. Once you have identified your perfect cohort, immediately send a push notification or schedule a push notification to this group.

How do I access Data Mine Push Notifications

To use Data Mine Push Notifications, you will first need to request access from your CSM. Once access has been granted, you can access Data Mine Push Notifications from the regular Data Mine page once your request has completed.

Data Mine Push Interface

Step 1 Run Query

Run a Data Mine query that returns s values only.

Step 2 Open Send Push Notifications Dialogue

When the query is complete and the results are displayed, click on the Menu button and select Send push notification.

Data Mine Push Button

Step 3 Select the App

From the Choose Application drop down list, select the app for these users. Note Only apps instrumented with the Upsight SDK will appear.

Select App Drop Down Box

Step 4 Open the Push Dashboard

Click the Send Push Notifications button and the page to create your push message will open. You can return to Data Mine at any time by clicking on the link in the yellow box that says Go back to Data Mine.

Step 5 Create Push Notification Message

The users from your Data Mine query will be added to the Audience section of the Push Dashboard.

Fill in the Message section with the message you want to send, select the option desired in the Action section, and choose when you want your Push Notification to go out in the Schedule section.

Push Dashboard

Step 6 Confirm the Push Notification

Click the Send Push Notification button to confirm sending the Push Notification. Once sent, you will have the option to return to Data Mine by clicking the Back to Data Mine button.

Push Confirmation

Best Practices

  • If the Send Push Notification button does not appear on your Data Mine options, contact your CSM to enable this feature.

  • Ensure that you are using the Upsight SDK in your app. This functionality will not work if you are only using the Kontagent SDK.

  • Ensure that your app has Push Notifications enabled within the Upsight SDK.

  • Ensure that all the s values are coming from the same app. Push notification delivery will fail for users that do not belong to this app.

Data Mine Push Notifications FAQ

I have the Kontagent SDK and the PlayHaven SDK. Can I still use this feature?

No. You need to have the Upsight SDK integrated to use this feature.

How long does it take for push notifications to get to the devices?

The first push notification should be sent within 20 seconds. If your Data Mine query contains a large result of s parameters it may take several minutes.

I integrated the Upsight SDK but did not enable Push. Can I still use this feature?

No. You will need to enable push notification and release a new build of your app to take advantage of this feature.

I am on my Data Mine page and I cannot see the Push Notification button, why?

Please contact your CSM so this feature can be enabled on your account.

I sent Push notifications using Data Mine Push Notifications, now what?

You can navigate to the Marketing section of the Upsight dashboard and click on the Push tab. From here, click on the app you sent a push to and you will be able to see the message you just sent, how many pushes were sent, what the current status is, and what the open rate is.

Data Mine Admin Panel


What is the Data Mine Admin Panel feature?

The Data Mine Admin Panel is a feature we’ve added to the Data Mine interface to enable greater control and visibility into how your organization is using Data Mine. From the Admin Panel, users with access are able to see which queries are currently running, scheduled, and have recently completed. You can also kill, schedule, or remove recurring queries directly from the Admin Panel.

How do I access Data Mine Admin Panel?

Users can be granted access to the Data Mine Admin Panel through our Role Based Access Controls (RBAC) system. When a user has access to the Admin Panel, when she logs into Data Mine, she will see the Admin Panel button, located next to Documentation and Keyboard Shortcuts.

Data Mine Admin Panel

When you click on the Admin Panel button, the panel will open in a new tab in your browser, where you can then manage and browse all your organization's queries from one place.

Tabs

The Data Mine Admin Panel is comprised of three tabs:

  1. Running
  2. Scheduled
  3. Completed

Running Tab

The Running tab will display queries within your organization that are currently running.

Running Tab

By default, the queries are sorted by submitter from latest to earliest submission. Every column can also be sorted by query name, type (API, Dashboard, or Scheduled), and status by clicking on the column header. On the Running tab, you will find the following columns:

  • Submitted By: Name of the person submitting or scheduling the query. Clicking on a name to send an email directly to this user.

  • Query Name: Name of the query as it appears on the tab in the user's Data Mine interface. Hover over the Query Name for a quick view of the query text, or click on it to select text from the query or copy and paste it into a new Data Mine tab.

  • Type: Indication of how the query was submitted. Options are Dashboard, Scheduled, or API Time Elapsed: Time elapsed since the query was submitted. Updated every 5 seconds.

  • Progress: Visual representation of the progress bar as reported by the user's Data Mine interface. Updated every 5 seconds.

  • Kill Query: Gives Data Mine Admin Panel user the ability to kill the query. If a query is killed, Data Mine will indicate that the Query has failed and an email will be sent to the user indicating that an Admin Panel user has killed the query.

Scheduled Tab

The Scheduled tab will display all queries within your organization that are scheduled to run at some point in the future.

Scheduled Tab

By default, the queries are sorted by submitter then by the order they are scheduled to run. Every column can also be sorted by query name, type (API, Dashboard, or Scheduled), and status by clicking on the column header. On the Scheduled tab, you will find the following columns:

  • Scheduled By: Name of the person scheduling the query. Clicking on a name to send an email directly to this user.

  • Query Name: Name of the query as it appears on the tab in the user's Data Mine interface. Hover over the Query Name for a quick view of the query text, or click on it to select text from the query or copy and paste it into a new Data Mine tab.

  • Type: Indication of how the query was submitted. In this tab, queries will always appear as Scheduled

  • Average Run Time: Average time the query has taken to run to completion based on the last 3 months of results.

  • Scheduled: Indicator of when the query is scheduled to be run. Click here to see the exact days or modify the schedule.

Change Scheduled Query

Remove: Gives Data Mine Admin Panel user the ability to remove any future scheduled occurrences of the query. If a query is removed, it will no longer run in the future, and an email will be sent to the person who scheduled the query notifying them of the change.

Remove Scheduled Query

Completed Tab

The Completed tab will display all queries within your organization that have been completed with the most recent run time of each query.

Completed Tab

You will also be able to see when the query completed, and whether it was successful or failed. On the Completed tab, you will find the following columns:

  • Scheduled By: Name of the person scheduling the query. Clicking on a name to send an email directly to this user.

  • Query Name: Name of the query as it appears on the tab in the user's Data Mine interface. Hover over the Query Name for a quick view of the query text, or click on it to select text from the query or copy and paste it into a new Data Mine tab.

  • Type: Indication of how the query was submitted. Options are Dashboard, Scheduled, or API

  • Run Time: Amount of time the query took to yield a result or fail.

  • Status: Indication of whether the query ran to completion or failed.

  • Completed On: Date and time the query completed or stopped running.

Data Mine Admin Panel FAQ

What happens on the query page if an admin kills the query from the Admin Panel?

The query will not return a result, and will instead display a "query failed" message. In addition, the user who submitted the query will receive an email alerting her that the query was killed by a Data Mine Admin Panel user.

Is it possible to have multiple queries with the same name?

Yes, because queries are named with Query # in the tab by default, it is very likely that many users will have the same names of queries. To avoid this, we encourage all users to name queries with unique names that also succinctly describe the purpose of the query.

How is the "average run time" calculated on the Scheduled Query tab?

The Average Run Time is the average amount of time it has taken the query to return a result for the previous three times the query was run. It is not the overall historical average of the run time. This way, the average more accurately reflects recent trends in the queries run time and will be more sensitive to syntax changes within the query or performance upgrades within the cluster.