Create Custom Report Subscriptions
Creating a custom report subscription enables you to specify the attributes of reports,
such as the frequency that a report is generated, the type of transaction data included
in the report, and the length of time in which a subscription is enabled. After your
customer report subscription is generated, it is available to download in the Available
Reports page.
You can maintain up to 20 report subscriptions at any time.
Follow these steps to create a custom report subscription:
- On theBusiness Center's left navigation panel, clickReports.
- Under Downloadable Reports, clickReport Subscription Management.The Report Subscription Management page appears.
- ClickCreate custom subscriptionin the upper right corner.The Create Report Subscription page appears.
- Under Account Setup, select whether your custom report will generate transaction data from a specific merchant or a group of merchants by choosing eitherMerchantsorGroups. Then select the specific merchant or group from the drop-down menu.If you selectMerchants, the default selection in the drop-down menu isAll Merchants, which if not changed, will generate a report of all the merchant transaction data in your portfolio. For more information, see Create Portfolio-Level Reports.
- Under Basic Report Setup, enter the following:In this fieldDo thisReport NameEnter the name for your report that best reflects the data you want to capture. Each report must have a unique name containing up to 250 characters.Report TypeSelect the type of report that most closely represents the data or process you want to include. TheBusiness Centerautomatically includes the most commonly used fields in your report based on this selection. See the next step for more information on how to customize these values.File FormatChoose whether theBusiness Centercreates the report in XLS or XML format.FrequencyChooseRecurring subscriptionto automatically generate daily, weekly, or monthly reports.
- To change any of the default fields included in your report, click theArrowicon to expand the Advanced Report Features section, and then perform one or more of the following actions (available actions are based on the report type and format you select):
ADDITIONAL INFORMATION
In this field or tabDo thisCredit AmountsCheck the box if you want credits to appear as negative amounts (for example: -1390.00).Naming ConventionSelect how you want the field names to appear in the report:- Simple Order APIdisplays most field names in camel case (for example: FirstName)
- SCMP APIdisplays most field names with underscores (for example: first_name)
ApplicationSelect one or more types of transactions you want to include in the report.Leave blank to include all types.Connection MethodSelect one or more connection methods used to perform the transaction that you want to include in the report.Leave blank to include all types.Available only for reports that include theSourcefield.Payment ChannelSelect one or more payment channels used to perform the transaction that you want to include in the report.Leave blank to include all types.Field SelectionOne or more of the following:- Enter text matching a field name you want to find in theSearchfield.
- Check the box for one or more fields or field types to include or remove from the report; check theSelect Allbox to add or remove all fields. Click theArrowicon in a section to expand or collapse it.In the Selected column, click theDeleteicon to remove a field or field type from the report.
Field OrderingClick and hold theHandleicon to rearrange fields (in theSelectedcolumn on the Field Selection tab) into the order in which you want them to appear in the report.This option is only available for CSV output. XML field ordering cannot be guaranteed. - To change any of the default fields included in your report, use the Advanced Report Features section to perform one of these actions. The available actions are dependent on the report type and format you select:Advanced Report FeaturesAdvanced Report FeaturesDescriptionCredit AmountsCheck the box if you want credits to appear as negative amounts (for example: -1390.00).Naming ConventionSelect how you want the field names to appear in the report:
- Simple Order APIdisplays most field names in camel case (for example: FirstName)
- SCMP APIdisplays most field names with underscores (for example: first_name)
ApplicationSelect one or more types of transactions you want to include in the report.Leave blank to include all types.Connection MethodSelect one or more connection methods used to perform the transaction that you want to include in the report.Leave blank to include all types.Available only for reports that include theSourcefield.Payment ChannelSelect one or more payment channels used to perform the transaction that you want to include in the report.Leave blank to include all types.Field SelectionOne or more of the following:- Enter text matching a field name you want to find in theSearchfield.
- Check the box for one or more fields or field types to include or remove from the report; check theSelect Allbox to add or remove all fields. Click theArrowicon in a section to expand or collapse it.In the Selected column, click theDeleteicon to remove a field or field type from the report.
Field OrderingClick and hold theHandleicon to rearrange fields (in theSelectedcolumn on the Field Selection tab) into the order in which you want them to appear in the report.This option is only available for CSV output. XML field ordering cannot be guaranteed. - ClickCreatewhen you are done configuring the report attributes.After the report is created, the generated report is downloadable. It appears in theAvailable Reportspage, in theCustom Reportstab. It can take up to 6 hours to generate a report.