Custom Reporting
Receive a weekly report on key user data and customize to your use case.
Time Frequence
The default template will execute every Friday at 5pm. You can adjust the time frequence under Condition
in the top action block if you prefer daily or monthly updates.
Database Query
For our example in the default version we are interested to receive a report on number of sign ups in the past week, best referral source and which country most of the new sign ups are coming from. We will receive results for those questions from the database using a sequence of DB Query action blocks.
- New users last 7 days
SELECT COUNT(*) AS TotalUsers
FROM customers_saas
WHERE system_created_at >= (CURRENT_TIMESTAMP - '7 days'::interval);
- Best referral source
SELECT Source, COUNT(*) AS NumCustomers
FROM customers_saas
WHERE system_created_at >= (CURRENT_TIMESTAMP - '7 days'::interval)
GROUP BY Source
HAVING COUNT(*) = (
SELECT MAX(sub.count)
FROM (
SELECT COUNT(*) AS count
FROM customers_saas
WHERE system_created_at >= (CURRENT_TIMESTAMP - '7 days'::interval)
GROUP BY Source
) AS sub
);
- Most frequent country
SELECT geography, COUNT(*) AS NumCustomers
FROM customers_saas
WHERE system_created_at >= (CURRENT_TIMESTAMP - '7 days'::interval)
GROUP BY geography
HAVING COUNT(*) = (
SELECT MAX(sub.count)
FROM (
SELECT COUNT(*) AS count
FROM customers_saas
WHERE system_created_at >= (CURRENT_TIMESTAMP - '7 days'::interval)
GROUP BY geography
) AS sub
);
Slack Message
In a last step, we will send the outcomes of all queries in a condensed Slack message. The default version will look like:
In the last month,
{{steps.new-users-last-7-days.outputs.Result.0.totalusers}}
new users have signed up. The best performing referral source was{{steps.best-referral-source.outputs.Result.[0].source}}
with{{steps.best-referral-source.outputs.Result.0.numcustomers}}
signups. The country with most user signups was:{{steps.most-frequent-country.outputs.Result.0.geography}}
with{{steps.most-frequent-country.outputs.Result.0.numcustomers}}
signups.
In action it will look something like this:
Modification
You are able to customize all parts of this report. Starting from inserting data in the database (or data source you are checking) to change the statistics you are querying for.