Issuer Insights Report
The Issuer Insights report provides transaction details for a designated activity (post day) that include Insights data. Worldpay produces this report weekly on Friday and includes data for the previous week, Sunday through Saturday. For example, a report generated on Friday, June 16, 2017 would contain data for June 4th (Sunday) through June 10th (Saturday of the previous week).
When we configure a merchant to receive this report, all sFTP report sites associated with the organization receive the report and can access it via iQ.
Filename Syntax
The syntax of the report filename is:
Issuer_Insights_Report_${organizationId}_${endDate}_W
where
-
organizationIdis the ID of the parent merchant organization -
endDateis the date of the last day of the week for data included in the report (alway the previous Saturday) -
Wsignifies this is a weekly report
Report Structure
The table below provides information about the fields included in the report. The report fields are in the order presented in the table.
A data type of Signed Decimal (17,2) with a Max Size of 21 is defined as:
17 digits + decimal point + 2 digits + sign.
|
Field Name |
Data Type |
Max Size |
Description |
|---|---|---|---|
| Method of Payment | Alphanumeric | 2 | The two character abbreviation for the payment method used. |
| Account Range ID | Numeric (with preceding apostrophe) | 20 | The Worldpay eComm internal identifier for the account range. You can use this value as a data point when analyzing card performance by Account Range. |
| Note: Depending upon your configuration, the report includes either the Range Start and Range End fields or the Account Range ID field, but not both. | |||
| Range Start | Numeric (with preceding apostrophe) | 20 | The beginning value of the applicable account range. |
| Range End | Numeric (with preceding apostrophe) | 20 | The ending value of the applicable account range. |
| BIN | Alphanumeric | 6 | The Bank Identification Number. |
| Bank Name | Alphanumeric | 100 | The name of the bank associated with the BIN. |
| Issuer Country | Alphanumeric | 50 | The country associated with the issuing bank for this account range. |
| Funding Source | Alphanumeric | 20 | Indicates the Funding Source of the card. For example, CREDIT, PREPAID, DEBIT, etc. |
| Card Product Name | Alphanumeric | 100 | Indicates the Product Name of the card. |
|
Corporate |
Alphanumeric |
1 |
Indicates the classification of the card as a Corporate card. Possible values are: Y or N. |
|
Regulated |
Alphanumeric |
1 |
Indicates the classification of the card as a Regulated Debit card. Possible values are: Y, N, or blank (indicating unknown). |
|
Affluence |
Alphanumeric |
15 |
Indicates the classification of the card as one of the following: AFFLUENT, MASS_AFFLUENT, or NOT_AFFLUENT. |
|
Prepaid Type |
Alphanumeric |
40 |
Indicates the type of Prepaid card used. Some example values are: General, Payroll, Gift, etc. |
|
Reloadable |
Alphanumeric |
1 |
Indicates whether the Prepaid card is reloadable. Possible values are: Y, N, or blank (indicating unknown). |
|
Authorization Count |
Numeric |
20 |
The count of Authorizations for the organization in the account range. |
|
Approval Count |
Numeric |
20 |
The count of Approved Authorizations for the organization in the account range. |
|
Approval Rate |
Alphanumeric |
7 |
The Authorization Approval rate for the organization in the account range. |
|
MCC Benchmark for Approval Rate |
Alphanumeric |
300 |
The benchmark Approval rate for other organizations with the same MCC as merchants in this organization. Each entry consists of the MCC Code = percentage with each entry separated by a semi-colon. For example, 9402=96.88%;7372=81.25%. |
|
Total Decline Count |
Numeric |
20 |
The count of Declined Authorizations for the organization in the account range. |
|
Decline Count: Non-sufficient Funds |
Numeric |
20 |
The count of Declined Authorizations with reason, Non-sufficient Funds, for the organization in the account range. |
|
Decline Count: Do Not Honor |
Numeric |
20 |
The count of Declined Authorizations with reason, Do Not Honor, for the organization in the account range. |
|
Decline Count: Invalid Account |
Numeric |
20 |
The count of Declined Authorizations with reason, Invalid Account, for the organization in the account range. |
|
Decline Count: Lost/Stolen |
Numeric |
20 |
The count of Declined Authorizations with reason, Lost/Stolen, for the organization in the account range. |
|
Account Update Participating Issuer |
Alphanumeric |
1 |
Indicates whether the Issuing Bank participates in the Account Updating program. Possible values are:
|
|
Portfolio AU Requests Sent |
Numeric |
20 |
The number of Account Update requests sent for the Worldpay eCommerce portfolio in the account range. |
|
Portfolio AU New Accounts |
Numeric |
20 |
The number of Account Update responses indicating a new card number for the Worldpay eCommerce portfolio in the account range. |
|
Portfolio AU New Expiration Dates |
Numeric |
20 |
The number of Account Update responses indicating a new card expiration date for the Worldpay eCommerce portfolio in the account range. |
|
Portfolio AU Accounts Closed |
Numeric |
20 |
The number of Account Update responses indicating the account closed for the Worldpay eCommerce portfolio in the account range. |
|
Portfolio AU Contact Cardholder |
Numeric |
20 |
The number of Account Update responses indicating the merchant should contact the cardholder for the Worldpay eCommerce portfolio in the account range. |
|
Approval Rate by MCC |
Alphanumeric |
300 |
The Approval rate for each MCC used by your organizations. Each entry consists of the MCC Code = percentage with each entry separated by a semi-colon. For example, 9402=96.88%;7372=81.25%. |