This blog promotes knowledge sharing through experience and collaboration. For more product information, visit our WebSphere Commerce CSE page. For easier navigation, utilize the Categories to find posts that match your interest.
How is Marketing Data Stored in the Database?
In this post, we will talk about marketing web activity and its elements are stored in the database, and data relation.
Here is the simple activity which displays a content in eMarketingSpot:
Here is how above WebActivity looks like in database:
Let's breakdown each component and understand them.
Query: Select DMACTIVITY_ID,NAME from DMACTIVITY where name='Shoeb'
Query: Select DMELEMENT_ID,NAME,DMELETEMPLATE_ID,DMACTIVITY_ID from DMELEMENT where DMACTIVITY_id = 10201
Query: Select DMELEMENT_ID, NAME, VALUE from DMELEMENTNVP where DMELEMENT_ID in (10857,10858,10859 )
Query: Select EMSPOT_ID, NAME, USAGETYPE from EMSPOT where name = 'Shoeb'
If e-Marketing spot has default content set then, it will be referenced in DMEMSPOTDEF table.
Query: Select * from DMEMSPOTDEF where EMSPOT_ID = 10801
Query: Select COLLATERAL_ID, COLLTYPE_ID, NAME, URL from COLLATERAL where COLLATERAL_ID = 10801
Query: Select COLLATERAL_ID, LOCATION, MARKETINGTEXT from COLLDESC where COLLATERAL_ID =10801