The Columns page for a report is where you specify the data fields to be shown in the report. The Columns page also determines the order of the columns in the report.
Select and Re-order Data Columns
Available Data Fields are listed on the left. Using the arrow controls, select fields there and move them to the Selected Data Fields list on the right.
To save scrolling through a long list of fields, you can type any part of a field name in the Filter text box. The predictive search limits the list to matching fields.
Click the right arrow symbol to move selected items to the right. Click the left arrow symbol to move selected items to the left.
Click the double right arrow symbol to move all items to the right. Click the double left arrow symbol to move all items to the left.
Top, Bottom, Up, or Down change the position of a selected field in the Selected Data Fields box. That position determines the order in which columns will appear in the report.
Note: The system cannot know if the profile and event custom data are the same across all accounts. You must ensure that these fields contain the data intended.
Example 1: Report Data is this account only. Custom Profile Data fields show "Office" (instead of "Custom Profile Data #01"), "Region" (instead of "Custom Profile Data #02"), etc. Custom Event Data fields show "Event Type" (instead of "Custom Event Data #01"), "Client" (instead of "Custom Event Data #02"), etc.
Example 2: Report Data is Current Account and all sub-accounts. Regardless of how the custom data fields are set up in the current account, the list of Custom Profile Data fields shows "Custom Profile Data #01", "Custom Profile Data #02", etc. The list of Custom Event Data fields shows "Custom Event Data #01", "Custom Event Data #02", etc.
Sort Order
You can specify up to four fields on which to sort report data in ascending or descending order in this area. The first field takes precedence over those that follow it. Pick the field you would like to sort on and choose Asc (A->Z) or Desc (Z<-A) to specify the order for the sort.
Customize Reports Columns
Click the Customize Reports Columns button at the lower left of the Columns page to customize the column headers in your report.
The Customize Reports Columns window displays the system-generated standard column headers under Default Column Label. To modify the column headers on the final report:
Enter new column labels under Custom Column Label.
When finished, click Submit or Submit and Close to save your changes.
Click Run Report to see the results or continue customizing the report.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Comments
0 comments
Please sign in to leave a comment.
[End of content]