Help Center
Training
Knowledge Base
Community
Developers
Support

DomoStats Connector

Domo University
  • Updated
Follow

Intro

The DomoStats connector gives you the freedom to explore how your team is using Domo. Dive in to your team's activities, Projects and Tasks, and DataSets, Buzz conversations, and more to find insights and shape your company’s Domo experience. 

You must have an "Admin" security profile to access the DomoStats connector or to connect to the DomoStats apps. However, once the DataSets have been created or the app has been deployed, they can be shared with anyone in your organization.   

You import DomoStats DataSets in the Data Center. This topic discusses the fields and menus that are specific to the DomoStats connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Note: DomoStats does not track mobile card views at this time. If a user only uses Domo from their phone, they will show zero activity for card views.

Prerequisites

To pull in DomoStats DataSets using this connector, you must have "Admin" security access. No credentials are required for connecting. 

Connecting to DomoStats DataSets

This section enumerates the options in the Details pane in the DomoStats Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Details Pane

This pane contains a single Report menu from which you select your desired DomoStats DataSet.

Menu

Description

Report

Select the DomoStat DataSet you want to pull into your Domo. The following reports are available:

Activity Log Returns information about team member activities within Domo such as logins, card creation, card viewing, DataSet creation, etc.
Buzz Returns information about Buzz usage within Domo such as conversation participants, number of messages posted, etc.
DataFlows Returns information about DataFlows within your Domo instance, such as DataFlow name, type, status, last updated date, etc.
DataFlow History Returns DataFlow run history information for your Domo instance, such as DataFlow name, run start and end time, whether runs were successful, etc.
 
Note: This report may have up to a 24-hour window without data. For example, if your report run at 1 a.m. on 10/10, the report might not pull anything more recent than 1 a.m. on 10/09.   
DataSets Returns information about DataSets within your Domo instance, such as DataSet name, owner, connector, last run date, etc.
DataSets History Returns DataSet run history information for your Domo instance, such as DataSet name, run start and end time, whether runs were successful, etc.
DataSets Execution Error Returns DataSets with errors.
Mobile Activity Returns a user ID, the user's mobile device, and their session start date and time.  
Pages Returns information regarding Pages.
Pages with Multiple Owners Returns information of each owner of a Page broken out per row.
People Returns information about users in your Domo instance, such as user name, security role, contact information, last login date, etc.
Projects Returns information about projects in your Domo instance, such as project name, owner, associated tasks, etc. 
Project Stages Returns information about project stages in your Domo instance.
Tasks Returns information about tasks in your Domo instance, such as task name, parent project, assignees, etc.
Task Owners Returns information about task owners in your Domo instance.
User Activity Returns User Activity, similar to the Activity Log in the Admin section.

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.

Handling DomoStats Backfill Requests

The DomoStats DataSet begins collecting and outputting data on the date and time of creation.  If you need more data prior to the creation date, then a backfill request must be submitted.

Domo Account Team:

If you would like to backfill a DomoStats Activity Log Dataset for a customer, please follow these steps: 

1. Find the single DomoStats Activity Log DataSet you want backfilled. (Please include the URL.) 
2. Choose a date to backfill to for your use case. 
3. Get authorization from an Admin for an advisor to create an access token to complete the backfill. 
4. Submit a Case to Domo Support including the information above. If you have a deadline, please include it in the case.

Please send the backfill request to support@domo.com with the following information:

  • Dataset URL

  • Start Date

  • Dataset Owner (Admin)

  • Estimated Required Completion Time

  • Use Case

For example, the following email would suffice:

"Please backfill this dataset <URL> to Jan. 1st, 2018. Please create an access token from John Doe. If possible, please complete it by this date: <DATE>, as we have a meeting with the customer and I want to build some cards to show their usage to justify a renewal.

For Support: 

Once the case is received, please double-check to make sure all the necessary information is included in the case. Make sure the requested Admin still exists and is an Admin. This need to be checked, as a custom role will not suffice. They need to have the role of Admin.

DataSet Fields

 

This section lists and describes the fields (columns) available for each DomoStats report.

Activity Log DataSet

Field Description
Object_Name The name of the object that received an action.
User_ID The ID of the person or thing that performed an action.
Source_ID

The ID of the type. For a simplified example, let's say a user added a card to a page. You would get these two actions on an event, and both would be returned on the DataSet.

  • "User updated page." This returns the following in the DataSet:

    • UserId: user_id 

    • Type: USER

    • Source_Id: userId 

    • action: updated

    • object_type: page

    • object_id: page_id

  • "Card added to page." This returns the following in the DataSet:

    • UserId: user_id

    • Type: CARD

    • Source_Id: card_id

    • action: added_to

    • object_type: page

    • object_id: page_id
Name The name of the object that performed an action.
Action

The event that took place. The following actions may be logged here:

LOGGEDIN Logged when someone successfully logs in from the login page using their password. Mobile logins are recorded when a person logs out of the app and back into the app. If a person opens and closes the app, that is not counted toward logins.
LOGGEDIN_SSO Logged when someone successfully logs in from the login page using SSO.
LOGGEDIN_TWO_FACTOR

Logged when a two-factor code is successfully used to login.
PAGE VIEW Counted each time a page renders.
CARD VIEW Counted only if a user clicks into the Details view for a card.
Object Type Clarifies what the object is.
Object ID The ID of the object.
Type The type of person or thing that performed an action.
Event Time The time at which the event occurred. The audit endpoint records/returns it in UTC, but the connector converts it to the user's time zone.

DataSet DataSet

Field Description
Status

The status for the DataSet. The following statuses may appear here:

Error Error during the import.
Idle A stream has been created but the DataSet has not yet been executed.
Success The import completed successfully.
Active (or blank) The import is in process.
Invalid There may be another execution still running and this has been deactivated until the previous one is complete.
ID The unique identifying value for the DataSet.
Owner_User_ID The unique identifying value for the person who owns the DataSet.  A DataSet owner is either the person who created the DataSet or the person whom ownership was assigned to.
Created_Date The date on which the DataSet was run for the first time.
Last_Run_Date The date on which the DataSet last successfully completed a run.
Name The current name given to the DataSet.
Schedule

The schedule option that has been configured for this DataSet. The following options may appear here:

Manual The schedule has been set so that it only updates when you manually go in and run the DataSet.
Day The DataSet is set to run once per day.
Minute The DataSet is set to run within the given minute interval.
Hour The DataSet is set to run once per hour.
Blank The DataSet has been created but no schedule has been set.
Import_Type The source for the DataSet. Could be a connector, DataFlow, API, etc.
Source_Type UNDER CONSTRUCTION

DataSet History DataSet 

Field Description
Stream ID A Domo-specific ID to map to the stream.
Execution ID The ID for a specific run of the DataSet.  
Datasource ID A Domo-specific datasource ID
Status

The status for the DataSet history item. The following statuses may appear here:

Success Data was imported successfully.
Error Error during the import.
Invalid There may be another execution still running and this has been deactivated until the previous one is complete.
Execution Type

The type of execution. The following execution types may appear here:

Manually The import was executed manually.
Automated The import was executed on a schedule.
Retry The import failed and Domo automatically tried to execute it again.
Replay A previously imported DataSet was rerun.
Batch Data was imported in batches.
Extended The data import continued into the next scheduled run.
Start Time The time the DataSet started running.
End Time The time the DataSet finished running, went into an error state, or became invalid.

People DataSet

If any of the "personal information" fields (name, email, location, etc.) return blank in this DataSet, you can fill in the missing information in the user's Profile page or their page in Admin Settings > People. For more information, see Specifying Your Personal Profile Information.

Field

Description

Department

The user's department within your organization.

Display Name

The name used to represent the user within Domo.

Role

The user's role within your organization.

Title

The user's title within your organization.

Email

The user's email address.

Alternate Email

The user's alternate email address.

Phone Number

The user's personal phone number.

Desk Phone Number

The user's desk phone number.

Employee Number

The user's employee number within your organization.

Location

The company location the user has been assigned to. 

Locale

UNDER CONSTRUCTION

Timezone

The user's time zone.

Role ID

A Domo-generated ID for a specific role.

User ID

A Domo-generated user ID for each person.

Last Login

A timestamp for the last time this user logged in. Login is measured by any regular, SSO, or mobile login. To count as a login for mobile, a person must actually log out of the instance and log back in. Opening and closing the app does not count as a login.

Password Created

A timestamp for when a user's password was created. This gets updated when the password is updated.  

Account Locked

Returns a "True" value if the account is locked.

Profile Picture

Returns a "True" value if a profile picture has been added in the user's Profile page or on his/her page in Admin Settings > People.

Org Chart

Returns a "True" value if the user has been added as a report on their company org chart in the Profile page. 

Two Factor Enabled

Returns a "True" value if the company has enabled two-factor authentication as an option in Admin Settings > Security > Authentication and the user has chosen to have two-factor enabled in their Settings menu (available via clicking the Gear menu under their profile picture).

Created Date

A timestamp for the date the user was added to the system.

Last Updated Date

A timestamp for the date the user's information was last updated.

DataFlows DataSet

Field

Description

Current Version

Returns the version number of the DataFlow.

ID

Returns the DataFlow ID number.

Description

Returns the description for the DataFlow if one has been specified.

Type

The type of DataFlow.

Status

The status for the DataFlow. The following statuses may appear here:

Success

The DataFlow was executed successfully.

Not Runnable/Rejected

There is a problem with the DataFlow definition; please view the DataFlow details.

Cancelled

A user manually cancelled the execution of the DataFlow.

Enabled

The DataFlow has been built but not yet run.

Failed

There was an internal problem executing the DataFlow.

Running

The DataFlow is currently being executed.

Success

Executed successfully.

Owner ID

Returns the user ID of the DataFlow owner. This ID is the same as the User ID in the DomoStats People DataSet.

Display Name

Returns the current name of the DataFlow.

Last Executed Date

Returns a timestamp for the time of the last execution.

Last Updated Date

Returns a timestamp for the time when the DataFlow was last updated.

Last Updated By

Returns the user ID of the last person to edit the DataFlow.

 DataFlows History DataSet

Field

Description

ID

An ID for a specific run of the DataFlow.

DataFlow ID

The ID number for the DataFlow.

Display Name

The name of the DataFlow.

Type

Returns the DataFlow type, either ETL, MYSQL, or REDSHIFT.

Status

Returns the status for the DataFlow run, either CANCELLED, FAILED, REJECTED, or SUCCESS.

Execution Type

Returns the type of execution, either DATA_UPDATE, MANUAL, RETRY, or SCHEDULED.

Start Time

A timestamp for the time the DataFlow started executing.

End Time

A timestamp for the time the DataFlow stopped executing.

Projects DataSet 

Field

Description

Created_by_user

The person who created the project.

Project_id

The ID number for the project.

Created

Project creation date and time.

DueDate

Due date for the project.

Created_by

User ID of the person who created the project.

Project_name

Name of the project.

Description

Description for the project, if one has been specified.

Active

Returns "True" if the project is currently viewable.

Deleted

Returns "True" if the project has been deleted.

Tasks DataSet

Field

Description

DueDate

Due date for the task.

Project_id

ID number for the parent project for the task.

ProjectListId

ID number of the list the task is found in.

ProjectListName

Name of the list the task is found in.

ProjectListType

Type of the list the task is found in.

ProjectTaskId

ID number for the task.

ProjectTaskName

Name of the task.

Created

Date and time the task was created.

Updated

Date and time the task was last updated.

ProjectName

Name of the parent project for the task.

CreatedBy

User ID of the person who created the task.

CreatedByName

Name of the person who created the task.

Owner

The ID number for the task owner. The task owner is the creator by default, but can be changed to anyone in the instance.

OwnerName

The name of the person who created the task. In the case that the original owner reassigned ownership, then it is the name of the new owner.

Priority

The order in which the task shows up on the task board. Lower priority numbers are above higher priority numbers.

Active

Returns "True" if the task hasn't been archived.

Description

The description of the task, if one has been specified.

Contributors

Individuals assigned to work on the task.

Task Owners DataSet 

Field

Description

ProjectTaskName

Name of the task.

ProjectName

Name of the parent project for the task.

ProjectListId

ID number of the list in which the task is found.

ProjectListName

Name of the list in which the task is found.

ProjectListType

Type of list in which the task is found.

ProjectTaskID

ID number for the task.

ProjectID

ID number for the parent project of the task.

Created

Date and time the task was created.

AssignedBy

ID number of the person who assigned the task.

AssignedByName

Name of the person who assigned the task.

AssignedTo

ID number of the person the task has been assigned to.

AssignedToName

Name of the person the task has been assigned to.

Project Stages DataSet 

Field

Description

Priority

Defines the order in which the lists or stages are shown. Smaller numbers are on the left.

Project_id

ID number for the project. 

Project_name

Name of the project.

List_name

Name of the list.

List_type

Type of the list.

Project_list_id

ID number of the list.

Created

Person who created the project.

Updated

The time when the list was last edited (e.g. moved, renamed, etc.).

Active

Returns "True" if the list or stage hasn't been archived.

Related articles

Comments

0 comments

Please sign in to leave a comment.