Dynamic Table Cleanup - Marketing Efforts
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?
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?
0
Comments
-
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.0
Categories
- All Categories
- 6 Blackbaud Community Help
- 206 bbcon®
- 1.4K Blackbaud Altru®
- 394 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 357 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 561 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.6K SKY Developer
- 242 ResearchPoint™
- 118 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 778 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

