Skip to main content
Clayton_Houser
Clayton_Houser
Level 1
August 14, 2019
Question

Database Cleanup - Lists

  • August 14, 2019
  • 3 replies
  • 4354 views

I am looking to cleanup my current database in Marketo by removing old list that have been imported and are no longer needed. That being said, I am having difficulty locating where every smart list is stored when importing the list for a specific campaign. Since, we are looking at developing a process to clean up old list, I am trying to create a report with the following dimensions.

  • List Name
  • Number of Contacts
  • Date Last Used

I do not know if this is possible but it would sure help clean up the database structure.

 

Thank you,

Clay Houser

Demand Generation Manager

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

    3 replies

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    August 14, 2019

    The "Date Last Used" requirement puts this idea firmly in the Ideas‌ category.  You can't build such a report right now, even with robust use of the REST API.

      Jay_Jiang
      Jay_Jiang
      Level 10
      August 15, 2019

      Not sure why you need to delete entire lists of leads when individual leads from old lists may be interacting with your company. Consider cleaning up old, inactive leads in general by using the following criteria instead:

      Created At In past before 6 months

      Not Filled out form is any

      Not clicked email is any

      Not visited webpage is any

      Export everyone before deleting. Up to you if you want to leave Unsubscribes IN Marketo - because if you import lists further down the track, you won't need to scrub email addresses against people who have unsubscribed and been removed from Marketo.

        Rani_Persaud
        Rani_Persaud
        Level 2
        August 15, 2019

        Hi,

        We're in the process of cleaning up our MKTO DB and one of the filters we're using is simply "No email address". That's the first step as no point having incomplete data and not having an email address is pointless in Marketo. Hope this helps!

        Cheers!

        SanfordWhiteman
        SanfordWhiteman
        Level 10
        August 15, 2019

        It's not at all true that not having an Email Address makes a lead worthless! Such leads can still receive SMS comms and can be reengaged via direct mail. They also can still be logging web activities.

        I urge you to reconsider your concept of inactivity.

          Terms & ConditionsAccessibility statement

          Loading footer...