It was setup before I joined. It works (!). I would like to report on the Subscribers and their associated MC tags from within Salesforce and I cannot find the field that contains that info. I have looked at all the tables that are MC related to set up a new report type but coming against a wall...
Looking in Salesforce for a subscriber the tags do appear - they must be stored somewhere. Any help would be appreciated.
Screenshot attached.
@Sharm Das You'll notice that the MC Subscriber page is not like a typical Salesforce object page. It is a Visualforce page that has some processing to look up the names in the Tags user interface field/area.
As you have probably figured out, there is no Tags field the MC Subscriber object. The items listed in the Tags bulleted list are stored in the MC Subscriber's Static Segments field (data type Long Text Area). The Static Segments field is used to store one or more MC Static Segment record Ids (as comma separated values). The tag names are MC Static Segment's Name field values.
You can create a report to look at the MC Static Segment record field values. Alternatively, this SOQL will also work:
SELECT Id, Name FROM MC4SF__MC_Static_Segment__c
You may have realized by now, there is no easy report to get at you want.
I recommend that you submit an enhancement request to Mailchimp. IMHO, they should provide an association object that would have lookup fields Subscriber and Static Segment (or label this last field "Tag").
I'm thinking you'll need to make a few customizations to get the report you want. The approach and design depend on how you want your report(s) to work with respect to columns and filtering.
For example, you could add a new custom field to MC Subscriber, appropriately named "Tags", to store a comma separated list of names. Use a MC Subscriber record trigger flow(s), that updates this custom field with the appropriate MC Static Segment record Name values. If you go this approach, I recommend you use these two Unofficial SF's flow actions: ExecuteSOQL and Extract Strings From Collection.
