My Pro Metrics has an alert feature to notify the right people when something happens in your reporting.
For data warehouse, data lake, and My Pro Metrics Storage, you can set up an alert if data warehouse transfers require your attention.
With scheduled refreshes in Google Sheets or Excel, you can be alerted for any issues that need attention.
In Google Sheets, you can set up conditional alerts that notify you only when certain conditions are met in your report.
Alerts can be sent to an email address or to a Slack or Microsoft Teams channel. You can also have the report itself sent to an email address or a Slack/Teams channel.
Before you begin
To receive notifications in Slack or Microsoft Teams channels, you need the email address of the channel.
Get Slack channel email address
- Create or open a Slack channel you want the alerts or reports sent to.
- Go to channel details.
- Click Integrations.
- Click Send emails to this channel.
- Copy the email address.
Get Microsoft Teams channel email address
- Create or open a channel for a team in Microsoft Teams. Any privacy option works. To create a channel, click the 3-dot menu next to the team name, and click Add channel.
- In the top-right corner of the channel view, click the 3-dot menu, and select More options → Get email address.
- Copy the email address.
My Pro Metrics data warehouse transfers are designed to automatically recover from most errors. However, some errors cannot be automatically recovered and require your attention.
On the My Pro Metrics Hub, go to Data transfers under Manage.
Click Create new.
Select the data source and click OK.
Fill the Send alerts to field with the email addresses you want to receive notifications.
You can add multiple email addresses, separated by commas.
These email addresses do not need to belong to the same My Pro Metrics team.
When you’re ready, click Save to store the transfer.
Ensure that the email addresses are valid and actively monitored by the recipients. Alerts will be sent once per 24 hours for all failed transfers that require your attention.
Open the My Pro Metrics sidebar in Google Sheets.
Go to the Schedules tab.
Click Automatic refresh.
Select an action from the Action menu, and define the time you want to run the action
Click Send email alerts if queries fail on refresh.
Fill the Email report to field with the email addresses you want to receive notifications.
Click Create refresh.
Take a look at our article for more details about scheduled refreshes and email notifications in Google Sheets.
With the conditional alert, you can select a cell or a cell range, and get an alert when the condition is met. The available conditions are:
Equals
Does not equal
Greater than
Less than
Is empty
Is not empty
Open the Supermetrics sidebar in Google Sheets.
Go to the Schedules tab.
Click Email alerts or Slack alerts.
Set the conditions for the alert.
Fill the Email reports to field with the email addresses you want to receive notifications. To receive notifications to multiple email addresses, click Advanced settings, click CC, and add the email addresses to the CC field.
Click Create alert.
Open the My Pro Metrics sidebar.
Navigate to the Schedule tab.
Click Add trigger.
Select an action from the Action dropdown menu.
Fill the Email alerts to field with the email addresses you want to receive notifications.
Click Save changes.
Take a look at our article for more details about scheduled refreshes and email notifications in Excel.
Open the My Pro Metrics sidebar.
Navigate to the Schedule tab.
Click Add trigger.
Select a Refresh & email option from the Action menu, and define the time you want to run the action.
Fill the Email reports to field with the email addresses you want to receive notifications. To receive notifications to multiple email addresses, click More options, and add the email addresses to the CC field.
Click Save changes.
