Create Alert for daily spend


#1

Hi,

We get spend data from our channel partners daily and ingest into looker. Sometimes the data doesn’t flow as expected. I would like to create an alert for each channel. Eg. alert me if daily spend for partner X is below average +/- 3% spend for last 7 days.

Thanks,
SS


(Marc Wilson) #2

This can easily be done by creating a schedule on a look. Assuming you have a look already created with the column (daily spend, for example), follow the below steps:

  1. Go to your look
  2. In the details pane on the right hand side select Edit Your Schedules (or settings > Schedule)
  3. Fill out the form fields and then you can run a test and save it if it’s good.

More notably, within that form, you’ll want to select the below settings:

Where should this data go? Email
Who should it be emailed to? list of email addresses
Trigger: Repeating interval
Filters: Setup the filters so it only returns the data related to what you’re after (+/- 3% and within last 7 days)
Advanced options: Send this schedule if: there are results

Also see Schedule Email Deliveries