Campaign Attribution: Is there a way to push all activity into a data or reporting tool?
Is there a way to pull all activities made by contacts (even activities of the same or lower priority response type against the same campaign) and push them into a reporting or data processing tool like a Snowflake or PowerBI?
CONTEXT:
We want to report on our marketing campaigns' influence on opportunities. To calculate this, we look at when campaign members respond to a campaign relative to the opportunity open date and close date.
Currently, we use the SFDC campaign member first responded date in our calculations, but we know we are missing opportunity influence reporting for some of our evergreen campaigns, like our Global Organic Form Submissions campaign which captures all organic form submission activity across our website.