Running Smart Campaign every 15 minutes | Community
Skip to main content
Jo_Pitts1
Jo_Pitts1
Community Manager
October 21, 2020
Question

Running Smart Campaign every 15 minutes

  • October 21, 2020
  • 3 replies
  • 5673 views

All,

I have a situation where I can't use a trigger to fire off webhook calls (I won't get into the reasons why, suffice to say there is a quirky legacy system at the far end of the pipe).

 

My desire is to use a smart campaign running every fifteen minutes to fire off all eligible records created and/or changed in that timeframe.  However, Smart Campaigns can't be scheduled to run at that frequency.

 

Any thoughts on how to do that?

 

Cheers

Jo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Erik_Larson
Erik_Larson
New Participant
October 23, 2020

If you have dev resources, or want to write some code yourself, it's easy enough. You could set up a campaign to react to the changes you care about on records that adds the records to a static list. Then stand up a cron job in python or something that runs every 15 minutes, which simply pulls off that static list and requests your campaign with the webhook, and removes the records from the static list. This could be done in a few lines of python using the rest api package out there. Happy to help if needed.

 

    SanfordWhiteman
    SanfordWhiteman
    New Participant
    October 23, 2020

    Still, the final effect is either one or zero webhook calls per person per 15-minute window. Would still like to hear what it is about the rate of change within that 15-minute window that makes it untenable for the other side. A field that must change multiple times in 15 minutes, all the time, across the db, seems like a design problem.

    Erik_Larson
    Erik_Larson
    New Participant
    October 24, 2020

    Yeah it's an interesting requirement, my guess would be that the legacy system has some state associated with it? And can only run every n minutes or so under 15 minutes. This would explain limiting the incoming records to a certain cadence to prevent stale data or cache misses, but who knows, just a guess.  

      Jo_Pitts1
      Jo_Pitts1Author
      Community Manager
      October 22, 2020

      @sanfordwhiteman , don't suppose you've got any insight on this?

      SanfordWhiteman
      SanfordWhiteman
      New Participant
      October 22, 2020

      Can you explain the whole can't-trigger-when-updated-must-send-batch-to-trigger thing?

      Jay_Jiang
      Jay_Jiang
      New Participant
      October 22, 2020

      I think the use case is essentially a custom one-way sync.

       

      @ OP, this is typically architected using middleware to PULL the data from the source system via API

      K
      Kelly_Marco2
      New Participant
      October 21, 2020

      This might be an incredibly unsexy solution, but you could create the same smart campaign 4 times and just run them at different intervals. 

       

      (just realized my first solution likely wouldn't solve what you're trying to do) 🙂 

      Jo_Pitts1
      Jo_Pitts1Author
      Community Manager
      October 21, 2020

      Kelly,

      give the scheduling granularity only goes down to daily, the 'unsexy' solution (and it is that 🙂 ) becomes untenable, given it would need 48 instances of the smart campaign.

       

      Jay_Jiang
      Jay_Jiang
      New Participant
      October 22, 2020

      this is the most non-technical solution. you don't need a smart campaign each time, you can have a flow with multiple wait 15mins + request campaign flow steps until every 15 minute interval in a day is covered

      e.g. 96x 15 min intervals in 24 hours = 4 smart campaigns with 24x wait + request campaign flow steps. each smart campaign's daily recurrence would be 6 hours apart - but you could probably forgo the sync during after business hours?

       

      The likely solution would have more moving parts than just this by the way...

      Terms & ConditionsAccessibility statement

      Loading footer...