I need to extract data from Salesforce Marketing Cloud. I'm using KingswaySoft SSIS Integration Toolkit to do the ETL, but I don't know the tables that retrieve the columns I need. I've searched on the documentation, but I wasn't able to identify the proper columns.
This is how my connection manager to the source SF Marketing Cloud looks like:
KingswaySoft SSIS Integration Toolkit - Salesforce Marketing Cloud Source Editor:
These are the columns I need:
- Journey Name
- Journey Activity Name
- Email Sends
- Email Delivery Rate
- Email Bounce Rate
- Email Open Rate
- Email Click To Open Rate
- Email Unique Opens
- Email Click Rate
- Email Unique Clicks
- Email Unsubscribe Rate
- Email Unique Unsubscribes
- Subscriber_Key
- timestamp
- Birthdate
- CouponCode
- ExitDate
- IsRedeemed
- ClaimedDate
- ExpirationDate
- EngagementPhase
- SentEngagement1
- SentEngagement2
- SentEngagement3
- SentEngagement4
- OpenedEngagement1
- OpenedEngagement2
- OpenedEngagement3
- OpenedEngagement4
- ClickedEngagement1
- ClickedEngagement2
- ClickedEngagement3
- ClickedEngagement4
To extract from Salesforce Service Cloud, I've used a Chrome extension "Salesforce Inspector" where I could search the column name and would obtain the source table, but it doesn't seem to work for SF marketing cloud.