Dynamic Table Cleanup - Marketing Efforts

Rick Root
Rick Root
Tenth Anniversary Kudos 2 Name Dropper Participant
in Blackbaud CRM Developer Discussions
So, I just ran my script to delete old dynamic tables... cut my table count from about 150,000 to 75,000.


The following tables account for another 35,000 but I'm not sure if they are "important"


MKTSEGMENTATIONDATA_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

MKTSEGMENTATIONDATA_NORMALGIFTS_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

MKTSEGMENTATIONDATA_UNRESOLVEDGIFTS_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

MKTSEGMENTATIONSEGMENTCACHEADDRESSES_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

MKTSEGMENTATIONSEGMENTCACHEEMAILADDRESSES_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

MKTUPDATEMAILINGCOUNTSOUTPUT_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

MKTSEGMENTATIONEXPORTEXCEPTION_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


Thoughts?

Comments

  • Harry Frank
    Harry Frank
    Eighth Anniversary Kudos 1 Name Dropper Participant
    I believe the MKTSEGMENTATIONDATA ones are for information and reporting on marketing efforts. If the efforts are done and old/deleted, then perhaps these can be cleaned up as well. The MKTSEGMENTATIONSEGMENT one is related to the segments stored within the efforts, so a similar situation.


    I'm not sure about the other 2.

Categories