Web in Activity lead buckets | Community
Skip to main content
Randall_Tam
Randall_Tam
New Participant
September 15, 2020
Solved

Web in Activity lead buckets

  • September 15, 2020
  • 1 reply
  • 1296 views

Hi Folks,

 

I am trying to create 3 buckets of leads based off their web inactivity.   When I look at the inactivity filter for Not Visited Webpage, the In Past Before" Operator is not available.  

 

Here are the buckets I am trying to do:

  • Not Visited Any Web Page in the past 30 - 60 Days
  • Not Visited Any Web Page in the past 60 -  90 Days
  • Not Visited Any Web Page in the Past 90 + Days

Any suggestions?

 

Thanks,
Randall

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

90+ will not be reportable, since Marketo no longer keeps those activities after 90 days.

 

You should be able to approximate the 1st one, 30-60 days, by doing

 

  •  Not VWP [in time frame] Past Month

Of course the accuracy depends on running the batch at the end of a month, so This Month ≈ 30 days, Past Month ≈ 30-60d.

 

Off the top of my head I don't know if the 2nd one can be accomplished within the UI itself, though that data is retained (i.e. if you extract the data via API and insert it into a db, it's straightforward). I'll think about it a bit more.

 

In general, it's far better to keep a Last Web Activity DateTime updated at the end of each month. Set it to {{system.datetime}} when it runs. Then such inactivity queries become both easier to build in Marketo and faster to run.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
September 16, 2020

90+ will not be reportable, since Marketo no longer keeps those activities after 90 days.

 

You should be able to approximate the 1st one, 30-60 days, by doing

 

  •  Not VWP [in time frame] Past Month

Of course the accuracy depends on running the batch at the end of a month, so This Month ≈ 30 days, Past Month ≈ 30-60d.

 

Off the top of my head I don't know if the 2nd one can be accomplished within the UI itself, though that data is retained (i.e. if you extract the data via API and insert it into a db, it's straightforward). I'll think about it a bit more.

 

In general, it's far better to keep a Last Web Activity DateTime updated at the end of each month. Set it to {{system.datetime}} when it runs. Then such inactivity queries become both easier to build in Marketo and faster to run.

    Terms & ConditionsAccessibility statement

    Loading footer...