Count the Leads and Send an Alert

[reetusharma123]

If any one can help with below requiremnet

Data Limit of 2000 leads per day – each day and if threshold meet then alert will send on particular email.

Additional email if over 10K – each day

[SanfordWhiteman]

Only with the use of a separate app. There’s no internal trigger/filter for the overall number of records.

[reetusharma123]

Thanks @SanfordWhiteman 

Could you please provide the app name or we can achieve this with API 

Thanks

[SanfordWhiteman]

You can use the Get Lead Changes API endpoint to see people created since a given timestamp (i.e. check the leads for that day). While that endpoint is quite simple, obviously you’d need some dev experience plus a reliable way to run the code on a schedule.

If you want to avoid using the API entirely, you can log new leads to a Google Sheet using a Marketo webhook. See my old blog post to learn how that’s done.

Then using a 2nd Marketo webhook, compare the count of rows in the Google Sheet where <created_date_column> = <todays_date>. As a hint, the VQL to accomplish that is:

select true where E = date '{{system.datetime}}' LIMIT 1 OFFSET 2000

If that returns any row with the value "true", that means there are more than 2000 rows matching the query.