Catching ad performance dips with same-day alerts

Every day the scenario checks your ad metrics against the norm and, on a dip, immediately sends alerts to a messenger and email and logs the case in a sheet.

  • Gathers ad data every day
  • Compares metrics against benchmarks
  • Catches sharp dips
  • Sends alerts to a messenger and email
Meta

How it works

To get Microsoft SQL notifications in okoCrm, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Daily Ad Check2
  2. Then: Fetch Meta Ads Data
  3. Then: Set Benchmarks
  4. Then: Detect Performance Drop
  5. Check: If
  6. If yes: Loop Over Items
  7. Then: Send a message
  8. Then: Code in JavaScript
  9. Then: Wait1
  10. Then: your-google-sheets-name
  11. Then: Send a message4
  12. Then: Send message1
  13. Then: Set Benchmarks4
  14. Then: Get many campaigns
  15. Starts when: Daily Ad Check3

You can launch this Microsoft SQL + okoCrm integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.