Skip Navigation
Expand
Unable to export more than 1000 entries from a segment list
Answer ID 5539   |   Last Review Date 03/18/2019

Why do contacts display in my Segment report, but they are not listed when I export the report in Excel? 

Environment:

Segments
November 2011 and newer
Oracle Service Cloud, Outreach and Feedback

Resolution:

The Segment Preview functionality was revised in November 2011 to make use of the Analytics functionality and the ability to export the data for purposes of examining the data. The Segment Preview results are now limited to 1,000.

To view and export the entire segment, open the Segment from the Segments Explorer and click Export in the ribbon. Save it as an XML file. 

Note:  This will export all contacts matching the segment criteria. The export option does not exclude invalid addresses or opt-out and suppression lists. 

Next, create a new report and select "Import Existing Report Definition". Select the Segment XML file and save your report. Through the report, you can use all the Analytics tools and functionality to manipulate the Segment results as needed.

For additional information, refer to the 'Preview a segment' section in online documentation for the version your site is currently running. To access Oracle Service Cloud manuals and documentation online, refer to the Documentation for Oracle Service Cloud Products.

See also Answer ID 2509: Creating a basic custom report

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.