You can easily connect Clickup by using the connector by Vidi which allows connecting the data to Power BI, Tableau, Looker Studio, Excel and any other data consumption tool of your choice.
The data can be extracted from multiple Clickup spaces.
It extracts the most essential data from Clickup API, however, customisations are possible. If you can not find some data that you need, feel free to contact us. We are open to customizing our code for individual customers.
CONTACT US TO GET THIS SOLUTION
The data comes in the following format: Clickup Connector.xlsx
The set up cost of the connector is $750. The monthly retainer is then $35 per month. The retainer would cover maintenance of the connector. Furthermore, Vidi Corp is committed to extracting more tables from Clickup overtime. Once those are extracted, they would be made available to all the clients who pay the monthly retainer.
Below is the documentation for the tables inside the connector:
This table extracts the essential data for grouping tasks into lists, folders and spaces.
| Value | Description |
| id | ID of the folder |
| name | Name of the folder |
| orderindex | Order index of a folder |
| status | Status of the folder |
| priority | Priority of the folder |
| assignee | The person responsible for list of tasks in a folder |
| task_count | Number of tasks in a list |
| due_date | Due date of the list of tasks |
| start_date | Start date of the list of tasks |
| archived | True/False referring to the list of tasks |
| override_statuses | True/False referring to the list of tasks |
| permission_level | refers to the permissions of a given user (create, edit, etc) |
| folder_hidden | True/False referring to the folder |
| folder_access | True/False referring to the folder |
| space_id | Id of the space |
| space_name | Name of the space |
| space_access | True/False referring to the space |
| content | description of content of a list |
| List_status | Red/Amber/Green/etc |
| List_color | HEX code for the color of the status |
| List_hide_label | True/False |
| load_date | Date for when data is loaded |
CONTACT US TO GET THIS SOLUTION
The tasks table contains data on tasks, time they took and they were supposed to take, their status, priority, etc. Both closed and open tasks are included in this table.
Custom fields are extracted for the tasks. On top of that the clickup links for the tasks are also available.
Users responsible for the tasks are also extracted as well as their profile image urls, emails, etc.
| Value | Description |
| id | ID of the task |
| custom_id | Name of the folder |
| name | Name of the task |
| text_content | description of content of a task |
| description | description of content of a task |
| orderindex | Order of the task |
| date_created | Date the task is created |
| date_updated | Date the task is last updated |
| date_closed | Date the task is closed |
| date_done | Date the task is marked as “done” |
| archived | True/Fals referring to the task |
| assignees | The people responsible for the task. Contains names of the people, their initials, profile images and emails |
| watchers | Watchers of the tasks |
| checklists | Checklists used for a particular task. Contains number of resolved and unresolved items within a checklist, group assignees and individual assignees |
| tags | Tags of tasks that can be used to categorize them |
| parent | parent task for child tasks |
| priority | Priority of the task |
| due_date | Due date of the task |
| start_date | Start date of the task |
| points | Points is a way to estimate number of effort a task would take |
| time_estimate | Time estimate for the task |
| time_spent | Time spent for the task |
| custom_fields | Your custom fields and their values |
| dependencies | Task IDs of dependency tasks and user id of people responsible for them |
| linked_tasks | Task IDs of linked tasks |
| locations | Locations for the tasks |
| team_id | Team ids |
| url | The lisk to your task inside of clickup |
| permission_level | Create/edit/etc |
| status_status | The status of a task |
| status_color | The color of the task |
| status_type | The type of the task |
| status_orderindex | Order of the status that can be used for sorting |
| creator_id | ID of user who created the task |
| creator_username | User name of the task creator |
| creator_color | HEX color of the icon for the user |
| creator_email | Creator email |
| creator_profilePicture | Creator profile URL |
| list_id | List id |
| list_name | Name of the list |
| list_access | Create/edit/etc |
| project_id | Project ID |
| project_name | Name of the project |
| project_hidden | True/False |
| project_access | Create/edit/etc |
| folder_id | Folder id |
| folder_name | Folder name |
| folder_hidden | True/False |
| folder_access | Create/edit/etc |
| space_id | ID of the space |
| priority_color | HEX Color code of the priority |
| priority_id | ID of the priority name |
| priority_orderindex | Order index for the priority id |
| priority_priority | Priority name of the task |
| load_date | Date for when data is loaded |
This table return the all time entries that have been added to cluckup automatically and manually
| Value | Description |
| id | ID of the time entry |
| wid | ID of the task |
| billable | True/False |
| start | Start date/time |
| end | End date/time |
| duration | Duration in seconds |
| description | description of the task |
| tags | Tags categorising your time entries |
| source | Clickup/clickup automatic/etc |
| at | Same as start date/time |
| task_url | task url in clickup |
| task_id | ID of the task |
| task_name | task name |
| task_status_status | task status |
| task_status_color | hex code for the status |
| task_status_type | task status type: closed/open/custom |
| task_status_orderindex | index used for sorting the status |
| task_custom_type | Task custom type |
| user_id | User ID |
| user_username | User Name |
| user_email | User email |
| user_color | HEX code for the user icon |
| user_initials | User initials |
| user_profilePicture | user profile picture url |
| task_location_list_id | the list id for the task |
| task_location_folder_id | the folder id for the list |
| task_location_space_id | the space id for the folder |
| load_date | Date for when data is loaded |
CONTACT US TO GET THIS SOLUTION
This table contains the history of task changes for every task. It can be used to calculate the number of time that every task was in a particular status.
| Value | Description |
| task_id | ID of the task |
| current_status_status | Current status |
| current_status_color | HEX color code of the current status |
| current_status_total_time_by_minute | Number of minutes the task has been in the current status |
| current_status_total_time_since | The date/time when the latest status change happened for the task |
| load_date | Load date |
| history_status | Past statuses of a task |
| history_color | HEX color for the past statuses of the task |
| history_type | refers to the past task statuses: open/closed/custom |
| history_total_time_by_minute | Total number of minutes that a task was in the statuses |
| history_total_time_since | Date/time when the past statuses were changed |
| history_total_order_index | Order index used to sort the past statuses |
