Skip to main content
A
Anonymous
October 6, 2015
Question

Question about "Data Value Changed" filter behaviour

  • October 6, 2015
  • 2 replies
  • 3660 views

Hi there,

Hoping someone can confirm something for me! I ran the following single-filter smart list two days in a row and noticed the number of leads changed overnight; this led me to question my interpretation of its behaviour.

The filter in question is set up as such:

Data Value Changed

Attribute: Variant

New Value (is) : A

Date of Activity (between): 09/13/2015 & 09/19/2015

I've come up with the following possibilities; hoping to find out which is the true description of the resulting lead list:

1) Leads that had Variant change to A during the time period, and still have that value of A when the smart list is processed

2) Leads that had Variant change to anything during that time period, and have a value of A when the smart list is processed

3) Leads that had Variant change to A during the time period, regardless of the value of A when the smart list is processed.

Thanks in advance!

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

2 replies

J
Adobe Employee
JohnCl9Adobe Employee
Adobe Employee
October 6, 2015

Hi Kevin,

The third option is true.  The smart list is only looking for leads that had the Variant field changed to A between those two dates.  It won't matter what the value is now, only that a Change Data Value activity was logged for that field in that time period.

If you need to find leads with a specific value in this field right now, then you would use the filter for that field in addition to the filter you already have in your list.  That would tell you who changed in the time period you've given, and who still has that same value.

John

A
Anonymous
October 6, 2015

Thanks John.

Would that mean the only explanation for the lead that went missing overnight is that they've been removed from Marketo between yesterday and today?

J
Adobe Employee
JohnCl9Adobe Employee
Adobe Employee
October 6, 2015

Hmmmm, if the smart list filter has not changed at all, then yes.  The only way the lead wouldn't show up on the list any more is that the activity doesn't exist any more.  And the only way to remove an activity is to delete the lead.

Kristen_Malkov1
Kristen_Malkov1
Level 7
October 6, 2015

Something to keep in mind/probably the reason for your variance is Marketo only keeps 'data value was changed' information for 90 days. So that information is constantly going to be in flux. What you should do instead is use channel/program tags to track the date/time stamps. Those are forever and easier to report on depending on the type of marketing program you're creating.

Josh_Hill13
Josh_Hill13
Level 10
October 6, 2015

This is true, but the DVC was not even a month ago.

Kristen_Malkov1
Kristen_Malkov1
Level 7
October 6, 2015

Good point. I'd also look at Salesforce or your CRM if those values sync to SFDC/CRM.

Terms & ConditionsAccessibility statement

Loading footer...