DomoStats Connector

Last updated
Save as PDF

Version 7

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. However, you do not need to be an Admin to deploy the related DomoStats app, which provides access to all DomoStats DataSets. If you want to install the DataSets separately without going through the app, you will need Admin access.

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.

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.
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.
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.

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.

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.

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.

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.