List import of members taking significantly longer for them to be available to smart campaigns | Community
Skip to main content
Dan_Stevens_
New Participant
August 29, 2017
Solved

List import of members taking significantly longer for them to be available to smart campaigns

  • August 29, 2017
  • 5 replies
  • 7127 views

We have a common process for those programs that include offline engagement - like attending an event.  When the event has concluded, the marketer provides the list of attendees - contained in our standard "campaign response" Excel template - for a member of my team to upload to the appropriate program (added to a static list within that program).  Once imported, we have a batch campaign that is run against this list to place these members into the appropriate program status (attended, promoted to MQL, etc.).

Lately, we're finding that it sometimes takes over an hour before the imported leads - primarily NEW leads - are available to run through the batch campaign.  So even though they appear in the static list, they are not reflected within the SCHEDULE tab ("Smart list status: Set to affect xx existing people").  Eventually they are represented in the number of qualified people, but the delay we're experiencing seems awfully excessive (hours/days) and is causing a lot of frustration on my team (since they can't complete the process until they're available; which affects other marketing activities they're working on).

Is anyone else experiencing this sort of delay?

BTW, I started a similar discussion a few weeks back: Delays/unable to search for new people immediately after they've been entered (manually or via list import).  But now, the delays are really becomng excessive.

Best answer by kyle.mccormick

Our process is very similar to yours.  It could very well be something else that's causing the delay, however I have found that deleting triggers and filters in the smart lists seemed to fix it. I've been wanting to ask support, but I can never seem to replicate the issue when I want it to occur.

5 replies

October 30, 2017

Was anyone able to find a resolution here? I loaded a list (25 members) to a static list and all the members are showing in the list, but only 4 qualifying for both the existing trigger campaign and a newly created batch campaign with a Member of List filter.

Is this consistent with what you guys were seeing as well? And if so, has anyone found something that will resolve it?

Dan_Stevens_
New Participant
October 30, 2017

Hi Kayla - yes, this is very consistent with what we've been experiencing in our instance.  And no, there is no resolution.  When I spoke to one of the Support leads last week, they informed me this has been on ongoing known issue and they are able to resolve them on a one-off basis.  When I say "resolve", I mean the specific issue (e.g., a specific smart campaign properly qualifying the correct number of people).  They issue a patch into the program - but that's it.  It's not an instance-wide patch/resolution.  So it will probably occur again - until they figure the root-cause of the issue.

October 30, 2017

Have you found that it will resolve itself over time or would you recommend reaching out to Marketo?

New Participant
September 15, 2017

We've haven't personally but a few of our customers have in the past few weeks.

Today I watched someone upload a list of 1 person and it took about 8 minutes.

Dan_Stevens_
New Participant
September 16, 2017

This past week, during some testing, we manually added a new person to the US partition.  While the person appeared in the default partition (after about 10 minutes), it took over an hour for this person to appear (and be used in a smart campaign) in the US partition - even though we specifically defined the partition on the record as "US".

Dan_Stevens_
New Participant
September 14, 2017

We opened up a case yesterday with Support around a similar issue.  Their response was very surprising (and concerning).  And btw, our database is relatively small (< 200,000) compared to many customers.

Following initial creation, it can take a few hours for the indexing for the Large Database processor to finish the index job; Once that's done the record will be searchable/usable by normal means.

September 15, 2017

Dan Stevens   If that is the case, then Marketo should send an email alert or system notification letting you know when the indexing is done. IMO the import isn't done until it is usable.

August 31, 2017

@Dan Stevens​

Hi Dan,

The only time our team noticed this type of issue it turned out to be an indexing backlog. Here is how it presented. The list upload always seemed to run within the expected time, but if you searched against the static list, the records would not show up.  Bottom line - ingesting data was fine however indexing the date which makes it available for programs was delayed.

I hope that gives you path to explore.

Eric

Dan_Stevens_
New Participant
August 31, 2017

Hi Eric - yeah, that's consistent with what we were told by support - as documented in this thread: Delays/unable to search for new people immediately after they've been entered (manually or via list import)

New Participant
August 29, 2017

I have noticed this quite a bit when cloning programs or batch campaigns lately. I typically delete the filters in the smart list and re-add them and the leads will usually show up as qualified leads.  Not sure if you're cloning or not, but that is usually what is happening to me. Hope that helps.

-Kyle

Dan_Stevens_
New Participant
August 29, 2017

Hi Kyle - the majority of our program originate from a core set of program templates contained in our CoE workspace.  As our programs are quite complex, it's necessary for my team to start with the proper framework vs. start from scratch each and every time.  Not sure how/why that would impact the list import delays that we're experiencing.

kyle.mccormickAccepted solution
New Participant
August 30, 2017

Our process is very similar to yours.  It could very well be something else that's causing the delay, however I have found that deleting triggers and filters in the smart lists seemed to fix it. I've been wanting to ask support, but I can never seem to replicate the issue when I want it to occur.