Automate subscribing people to different smart list/ report | Community
Skip to main content
Eben_Saputra
Level 3
Mar 14, 2019 7:13 PM UTC
Solved

Automate subscribing people to different smart list/ report

Hey guys,

I am requested to create daily list of patients who just recently finished a survey

This list will be sent to 100 clinics, and each can only receive data of its own patient. (no two clinics receive same data!)

The list will contain person's name, email, and survey score among other.

Right away, my thought is to create 100 smart lists, subscribed to each clinic.

But I wonder if there are other, more automated way to do this?

Thanks,

Eben

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
Mar 14, 2019 9:27 PM UTC

I would integrate with an external spreadsheet (i.e. Google Sheet, SmartSheet, etc.), mirror the data via webhook, then create a Marketo lead that represents each clinic and retrieve + send them their daily delta. (Obviously you may have data privacy concerns that would make an in-house equivalent preferable.)

Otherwise your idea is best -- you can't filter a single Smart List down based on the subscription recipient, you need different SLs and subscriptions.

2 replies

Eben_Saputra
Level 3
Mar 15, 2019 12:56 PM UTC

Cool, thanks as always Sanford!

Just making sure I don't skip any option

Thanks,

Eben

Translate
SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
Mar 14, 2019 9:27 PM UTC

I would integrate with an external spreadsheet (i.e. Google Sheet, SmartSheet, etc.), mirror the data via webhook, then create a Marketo lead that represents each clinic and retrieve + send them their daily delta. (Obviously you may have data privacy concerns that would make an in-house equivalent preferable.)

Otherwise your idea is best -- you can't filter a single Smart List down based on the subscription recipient, you need different SLs and subscriptions.

Translate