Database Connector
The Database Connector add-on is available for purchase on all plans. It offers seamless access to AgencyAnalytics' entire collection of database integrations, including Google BigQuery, MySQL, and Amazon Redshift.
This add-on allows you to integrate custom data sets directly into your agency's dashboards and client reports, enabling thorough and effective reporting on the metrics that matter most.
How to use database integration widgets
First, open a report or dashboard in edit mode. Then, in the widget sidebar to the right, scroll down until you find the database integration you'd like to connect. Click the integration to expand the widget menu.
In this example we use MySQL, however the same steps apply for all database connectors.
Once expanded all available widget types will be listed. Locate the widget format you want to add, then click, hold, and drag the widget over to the section and release it to add the widget.
Unlike other integration widgets, database connector widgets must be told via query what data to pull and display.
After adding a widget, the edit widget sidebar will automatically update to the Data tab. If needed, you can click the widget and then the Data tab on the right.
Enter the query in the Query field, then click Update Query to pull the data from your database instance into the selected widget.
If there's an issue with the SQL, an error message describing the nature of the error will display above the Update Query button.
Remember to click save in the upper right of the dashboard or report to save your query.
Simple Query Example
The query below can be used to pull data from a database connector. Simply change the test variables to your own!
SELECT
my_field,
SUM(number)AS total
FROM
`my_table`
GROUP BY
my_field
ORDER BY
total DESC
LIMIT
10;
Time Series Query Example
The below query can be used to pull in time series data by replacing the test variables with your own.
SELECT
DATE(date) as date,
count(*) as my_field_count
FROM
`my_table`
WHERE
$__dateFilter(date)
GROUP BY
date
ORDER BY
date ASC;
💬 Need additional help?
If you have any questions, please contact our friendly support team by following these instructions! We're available 24/5 to help 😄