Custom reports are generated by a two step process:
- select the columns on the custom report page
- select the rows on the contact list page
1. Go to the custom report page
Go to Data exchange > Custom reports ⤴.
2. Create a new report template
Click the Add button.
Fill in a name for your report. Choose ‘Contact’ as the type. If you want to be the only person who can see your report, tick ‘Make private’.
Click Save and continue editing
3. Configure your report
Click Add columns to add columns to your report. Every available column for a contact report is listed. Tick the columns you want to include, or fill in the filter to search for a column or columns (e.g. ‘address’).
Click Save
The columns you have selected are displayed. Drag and drop a column to change the order it will appear on your report. You can add or remove columns at any time.
The page you are configuring defines the columns of your spreadsheet, but does not populate the rows. To confirm the selected columns are as expected, click Export sample to Excel to populate with some randomly selected records.
4. Populate the report
Go to People > Contacts ⤴, and search to narrow down your selection (e.g. within a range of publication dates).
Make your selection by ticking the boxes. Click the top box once to select everything on that page. Click the top box twice to select everything on all pages.
Click Run custom report.
Choose the name of the custom report you created above. Click Save.
Your report runs in the background. Go to Notifications ⤴ to retrieve your report.