I conceptualized and built this to add efficiency and transparency for client and team.
Generally clients requesting data would go through several hands Client -> Program Manager -> Support -> Data or Technical Architect -> Client. To resolve this I made use of the Marketing Cloud SOAP API: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/web_service_guide.htm
There are complex relations added to some of the standard objects, notably the triggered send definition also has lookup relationships on email returning the full path as well as the code.
This system allowed client to search and build their own inventory records. It allowed my team to search and build their own inventory records as well as answer difficult questions without engaging several resources to query the databases.
