Hello is it possible to export all the SFMC analytics data to an outside BI. What I'm trying to do is have an MDM then that MDM will connect my SFMC to a BI Cognos.


Yes, very much and there are multiple ways you can extract tracking data out of SFMC -

  1. Using Query Activities
    Query Activity

  2. Using Tracking Extracts
    Tracking Extract

  3. Using API

For SMS Tracking, look at the Tracking section on the page below. Although it is not as comprehensive as Email -
SMS Tracking

From my experience, use a combination of Queries and Tracking Extracts and get the data into your MDM for analytics. Hope this helps

| improve this answer | |
  • What about for web/mobile analytic. Example shopping cart abundant card. – Einstein Mar 19 '17 at 1:04
  • updated my answer – Maneesh Mar 19 '17 at 16:00

As @ Maneesh explained those are a few of the common options. There are some caveats depending on the volume of data. Using the SOAP API there are some limits in terms of the amount of data that can be pulled, so you need to care for managing the multiple transactions needed to page and pull larger data volumes. For example, if you have thousands, or even millions, of subscribers as part of your list(s), then you will want to factor that into your approach. Also, depending the volume of campaigns and the configuration of your account, certain approaches may work better than others. For example, some people teams want to have more of a real-time transactional view by campaign. All of this then needs to align with how you pipeline data in Cognos.

We have done various integrations with SFMC to support the exact use case you are describing. If you want to discuss further, just send me a note.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.