Recently we came across an issue with publishing new segments. Turns out, we surpassed the max number of segments allowed.
- Current Dynamic segments count: 3000 max allowed: 3000.\"}"
- isError: true
- scenario: "SegmentService.PublishSegmentAsync"
- splitTimings: "[{\"name\":\"Scenario.Start\",\"timestamp\":0},{\"name\":\"Scenario.End\",\"timestamp\":792.6000000238419}]"
- startTime: 93055.5
-
After working through a Power Automate flow to automatically delete segments, I came across a few things that just aren't adding up.
There seems to be multiple entities used for segments:
- msdynmkt_segment
- Entity that stores both virtual and segment definition ID
- msdynmkt_segmentdefinition
- This entity is used when editing or creating a segment in real-time marketing
- msdynmkt_virtualsegment
- OOB view uses this entity
- msdyncrm_segment.
- This seems to be the old entity before MSFT deprecated outbound marketing ( thats my guess)
In the flow, I added delete steps for msdynmkt_segment and msdynmkt_segmentdefinition. Deleting from msdynmkt_segment automatically deletes from msdynmkt_virtualsegment but not msdynmkt_segmentdefinition.
If you dont delete from msdynmkt_virtualsegment, the segment still displays in the view even though you cant open the segment. Very odd.
My two main concerns/questions are the following:
- What table does this limit apply to? With so many entities used, I had to delete from all of them.
- The limit is 3000 dynamics segments and 10000 static segments per org. When creating in msdynmkt_segmentdefinition ( real-time marketing), the only way to create a static segment is by hitting the settings icon on the right side of the page and select Static Snapshot.
- After creating several static snapshots, I queried the table only to find that static snapshots also have a type of Dynamic.
- Is there no way to truly create static segments that would count toward the 10k limit or do all segments made from here on out only count toward the Dynamic limit?? If thats the case, their limit should increase.
Thank you!
317
Share
Report
All responses (
Answers (
