See also
Dashboards Getting Started Guide
Topics:
- Connect source data
- How to create Widgets
- Layout
- Data Sources for Widgets
- AI with the Dashboard
- Refreshing the Dashboard
- Filters
- Preparing Data for the Dashboard (Aggregating, Combining, and Filtering)
- Use Case: Show metrics only for a subset of clients
- Use Case: Top 10 products
- Use Case: Combine two stats for two ad platforms
- Sending a Dashboard to Clients
- Customize the appearance
Connect source data
Connect the required data sources for your dashboard, ensuring that the historical data and tables for each data source are accurate.
Historical Data
By default, data is loaded for the past 90 days, but you can extend this range up to 5 years. In certain plans, extending the range may require a paid addon. To adjust the date range, go to the Connection Setup UI.
Tables (Schemas)
Most data sources offer multiple tables for use in dashboards. Ensure that you’ve connected the correct table for your needs. You can verify or adjust this in the Connection Setup interface.
Data Loading Indicator
A data loading indicator is visible at the bottom of the screen.
You can begin designing your dashboard without waiting for the data to fully load. This indicator is also visible when our tool is resynchronizing data, which won’t interfere with your dashboard usage.
How to create Widgets
To add a new widget, click the + button.
Scorecard and Scorecard with Change
Time series chart and Time series chart with Change
Table
AI Chart
Before creating the "AI Chart" widget, you need to create a chart using the AI chat. Ask the AI to create a chart, then click "Save as dashboard AI chart. The chart will then be available for selection when creating a widget.
Layout
To adjust the layout of widgets, use the Change Order or Layout button in the top-right corner of the dashboard.
Data Sources for Widgets
You can connect various data sources to the dashboard, including:
- Applications and databases
- Spreadsheets (Google Sheets syncs automatically)
- Data via WebHooks and APIs
- Transformed data, such as aggregated data (e.g., weekly metrics instead of raw data). For this, create a Workflow first.
- AI-generated responses, including numbers and charts.
AI with the Dashboard
You can ask the AI to generate reports. Here’s how:
- Start a new chat and connect your data sources.
- Ask your question(s) in the chat.
- Once the AI provides a response, click "Save as dashboard data source".
- Create a new widget and set AI(Copilot) as the data source.
- For numeric AI answers, use any widget type.
- For chart-based AI answers, use the AI Chart widget.
Refreshing the Dashboard
Conduit automatically updates the dashboard daily by:
- Synchronizing data sources and updating the last 30 days of data if there are changes.
- Running workflows for fresh data.
- Re-running AI queries in the chat for updated answers.
If you need more frequent updates, contact support to enable this feature.
Filters
Filters for end users will be available in November. Currently, filters are available only for dashboard designers—please refer to the workflows for more information.
Preparing Data for the Dashboard (Aggregating, Combining, and Filtering)
To customize your data for the dashboard, use Workflows. For example:
- To filter data for a specific product, create a workflow, prepare the data, and use it as the data source.
- To merge data from multiple sources, create a workflow, combine the data, and use the merged dataset as the widget’s data source.
Use Case: Top 10 products
Suppose we want to create a table or chart showing a list of the most popular products or pages. We have the option to use either AI or Workflows. In this case, let's focus on using Workflows.
To generate a chart, start by creating a new Chat and ask the AI to create a chart based on the data prepared in the Workflow.
Please see more details here.
Use Case: Filtering - show metrics only for a subset of pages
Let's say you want to count the number of visitors.
You can create a workflow with a filter then use the workflow as a data source for the widget.
Please see more details here.
Use Case: Combine two stats for two ad platforms
If you use two advertising platforms and want to display statistics for both simultaneously, workflows can be very helpful. We've prepared a template that demonstrates how to integrate the platforms.
Please see a template.
Sending a Dashboard to Clients
For more details, visit:
- Delivery of Reports and Dashboards to Clients
- Sharing Dashboards Between Workspaces
- You can create a text version of the report and send it via email to the client. See Send to email
To restrict users from editing a report, assign them the Restricted User role.
Misc
- Clone a Dashboard
- You can customize the appearance of your dashboards using White Label features.