DomoStats Connector
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.
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:
|
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 user that received an action. | ||||||||||
Source_ID |
The ID of the person who performed an action. 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.
|
||||||||||
Name | The name of the person who performed an action. | ||||||||||
Action |
The event that took place. The following actions may be logged here:
|
||||||||||
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:
|
||||||||||
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:
|
||||||||||
Import_Type | The source for the DataSet. Could be a connector, DataFlow, API, etc. | ||||||||||
Source_Type | UNDER CONSTRUCTION |
DataSet History DataSet
Original Columns
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 | ||||||||||||
Link | A Data Source URL | ||||||||||||
Status |
The status for the DataSet history item. The following statuses may appear here:
|
||||||||||||
Execution Type |
The type of execution. The following execution types may appear here:
|
||||||||||||
Updated Rows | The total number of Updated Rows | ||||||||||||
Bytes Inserted | The total number of Bytes inserted | ||||||||||||
Total API Calls | The total number of API Calls | ||||||||||||
Start Time | The time the DataSet started running. | ||||||||||||
End Time | The time the DataSet finished running, went into an error state, or became invalid. |
Optional Columns (Increase Runtime for the DataSet)
These columns are available by selecting the Checkbox in the DataSet.
Data Source Name | The name of the Data Source |
Data Provider Key | The key for the Data Provider (Connector Details) |
Transport Descriptions | The transport description for a given stream (Connector Name) |
Transport Version | The transport version for a given stream (Connector Version) |
Retry Count | The number of retries for a given execution |
Update Method | The update method (Append, Replace, Upsert) |
Details | Metadata details about the execution |
Created At | The time the execution was created |
Modified At | The time the execution was last modified |
Run Time | The amount of the time the execution took |
Started by | How the execution was started, and by which user |
Canceled by | The user that canceled the execution |
Phase Type | The phase type the execution is in |
Run Type | The run type (Connector, API, etc.) |
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. |
|
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:
|
||||||||||||||
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. |