Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Is it possible to crea...
Customer experience | Sales, Customer Insights,...
Unanswered

Is it possible to create a custom solution to export Real-time Segments to Excel?

(1) ShareShare
ReportReport
Posted on by Stephani
I know that Microsoft has on their roadmap the ability to export Real-time segments to Excel - but until we have this feature, is it technically possible to create a custom solution to do this?  If so - can you provide some tips/tricks/how-to information to get us started?
  • Suggested answer
    Yogesh Mulay Profile Picture
    Yogesh Mulay 54 on at
    Is it possible to create a custom solution to export Real-time Segments to Excel?

    While native export to Excel for Real-time segments is not yet available in Microsoft Dynamics 365 Marketing, it's technically feasible to build a custom solution to achieve this functionality. Here's a breakdown of how you can approach this:

    Conceptual Approach:

    1. Retrieve Segment Data:

      • Use the Dynamics 365 Marketing API to fetch the members (contacts) of the Real-time segment.
      • You'll need appropriate authentication and authorization to access the API.

    2. Format Data for Excel:

      • Organize the retrieved contact data into a structure suitable for Excel (e.g., rows representing contacts, columns for attributes like name, email, etc.).
      • Consider any data transformations or filtering required based on your specific needs.

    3. Generate Excel File:

      • Utilize a library or tool to create an Excel file (e.g., OpenXML SDK, EPPlus, ClosedXML).
      • Populate the Excel file with the formatted contact data.

    4. Provide Download or Export:

      • Make the generated Excel file available for download to the user.
      • You could trigger this process manually (e.g., a button in the Dynamics 365 Marketing interface) or automate it based on certain events or schedules.
     
    Please mark my answer verified if this is helpful!
  • Suggested answer
    PaulineKolde Profile Picture
    PaulineKolde 730 Super User 2025 Season 1 on at
    Is it possible to create a custom solution to export Real-time Segments to Excel?
    Hi Stephani, 
     
    Amey Holden has created a great solution for segments in realtime marketing. Maybe this also helps for your request: Browse and Search Segment Membership in Customer Insights - Journeys — Amey Holden | Anything But Code | Dynamics 365 Marketing & Power Platform

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,011 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans