Count of Transactions by Merchant
Overview
The Count of Transactions by Merchant insight is a schedule-trigger insight that tracks the user's spending across the top merchants based on the total number of transactions done during the given duration for an aggregated bank or card account. Only expense merchants are considered for this insight.
Following are the additional details for the insight:
| Insight Name | COUNT_OF_TRANSACTIONS_BY_MERCHANT |
|---|---|
| Applicable Entities | ACCOUNT, VIEW |
| Insight Type | OTHER |
| Trigger Type | SCHEDULE |
| Supported Containers | BANK, CARD |
Use Cases
- Customer:
- User engagement
- Up-Sell / Cross-Sell Opportunities: Offer co-branded products or dedicated offers based on user spending patterns.
- User:
- Financial awareness - Keep track of spending.
Suggested Action
NA
Duplicate Insight Checks
To prevent the same insight from generating repeatedly, the insight is generated once per frequency cycle for each of the applicable entity ID.
The following are the applicable frequencies for this insight:
| Frequency | Description | |
|---|---|---|
| DAILY | The insight will be triggered daily. Duplicate check will evaluate if the insight instance that matches the duplicate check criteria exists for the current day from 12:00 AM same day to the time of insight evaluation. | |
| WEEKLY | The insight will be triggered once every Monday. Duplicate check will evaluate if the insight instance that matches the duplicate check criteria exists for the current calendar week (Monday to Sunday). For example:
|
|
| MONTHLY | The insight will be triggered once on the first day of the calendar month. Duplicate check will evaluate if the insight instance that matches the duplicate check criteria exists for the current calendar month (1st of the calendar month to the last day of the month). For example:
|
|
Insight Dynamic Trigger (On-Demand Evaluation)
The dynamic trigger is applicable to the insight. Depending on the configuration, this insight can be invoked dynamically when:
- A new View is created
OR - A View ID is patched using the user subscription API
The insight is generated dynamically using any of the above two methods only if the view is eligible and the other insight generation checks are passed.
Note: By default, the configuration is set to dynamically trigger insight evaluation, everytime a new entityId (view ID) is added using the PATCH userSubscription API. During onboarding, this preference can be changed.
In addition to the dynamic trigger capability chosen, this insight can be triggered using the following on-demand insight trigger API
Method and URL:
POST /insights/trigger
Peer Benchmarking Data
This insight does not provide peer benchmarking data.
Thresholds
Threshold lets the customer or the user decide when the user has to be alerted about the transactions spending trends. If the count of merchants is 5, the top 5 merchants based on the highest transaction count will be returned in the insight.
- Threshold Name: TOP
- Data Type: NUMBER
- Range Allowed: 1 <= MINIMUM <= 100
- Default: 5
Note: Depending on the customer segment and account, threshold might need to be different for different users. If the default value is insufficient, the users can set a threshold they are comfortable tracking.
GET Customer Subscription
The GET customer subscription API provides all the information about the defaults set for the insights that are subscribed by the customer. The default frequency for the insight is MONTHLY and the default duration for the insight is THREE_MONTHS.
Method and URL:
GET /insights/configs/customerSubscriptions
Header Parameters:
| Key | Value | |
|---|---|---|
Authorization |
Client credentials-based authorization | Bearer {{Access Token}} |
| API key-based authentication | Bearer {{JWT Token_Customer}} |
|
| Deprecated cobrand and user credential-based authentication | cobSession={cobSession received in the cobrand login service} |
|
Content-Type |
application/json |
|
Api-Version |
2.1 |
|
2 |
||
Cobrand-Name |
{Name of the Customer} |
|
Sample Request:
GET /insights/configs/customerSubscriptions
Sample Response:
For more information about the attributes that are returned in the API response, refer to the Insights Data Model page.
- Api-Version 2.1 Response
{
"customerSubscription": [
{
"insightName": "COUNT_OF_TRANSACTIONS_BY_MERCHANT",
"insightTitle": "Count of Transactions by Merchant",
"insightType": "OTHER",
"triggerType": "SCHEDULE",
"containers": [
"BANK",
"CARD"
],
"description": "Generates an insight that provides spending trends (based on transaction count) by merchant over a configured time period.",
"applicableEntity": [
"ACCOUNT",
"VIEW"
],
"customerConfiguration": [
{
"entityType": "ACCOUNT",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
},
{
"entityType": "VIEW",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
}
]
}
]
}
- Api-Version 2 Response
{
"customerSubscription": [
{
"insightName": "COUNT_OF_TRANSACTIONS_BY_MERCHANT",
"insightTitle": "Count of Transactions by Merchant",
"insightType": "OTHER",
"triggerType": "SCHEDULE",
"container": [
"BANK",
"CARD"
],
"description": "Generates an insight that provides spending trends (based on transaction count) by merchant over a configured time period.",
"applicableEntity": [
"ACCOUNT",
"VIEW"
],
"customerConfiguration": [
{
"entityType": "ACCOUNT",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
},
{
"entityType": "VIEW",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
}
]
}
]
}
PATCH Customer Subscription
Using the PATCH API for customer subscription, customers can change the defaults for each insight. Alternatively, customers can use the insights configuration tool to achieve the same result.
Warning! Changing any defaults can potentially impact all users who have subscribed to this insight. If the user has overridden the customer threshold, then the user preference will be applied. For all other users, the new defaults will apply.
Method and URL:
PATCH /insights/configs/customerSubscriptions
Header Parameters:
| Key | Value | |
|---|---|---|
Authorization |
Client credentials-based authorization | Bearer {{Access Token}} |
| API key-based authentication | Bearer {{JWT Token_Customer}} |
|
| Deprecated cobrand and user credential-based authentication | cobSession={cobSession received in the cobrand login service} |
|
Content-Type |
application/json |
|
Api-Version |
2.1 |
|
2 |
||
Cobrand-Name |
{Name of the Customer} |
|
Editable Parameters:
| Editable Attributes | Impact | Allowed Values |
|---|---|---|
| isSubscribed | Subscribes or unsubscribes all the users from the Count of Transactions by Merchant insight. | true, false |
| insightTitle | The title returned in the GET feed API as well as the insights config tool can be changed. | Alphanumeric characters up to 100 characters (including spaces) |
| frequency | The frequency with which an insight will be evaluated. |
|
| duration | The data range that should be considered for evaluating the insight. |
|
| threshold | The threshold (TOP) can be modified to adjust the number of merchants to get the transactions. | Any number between 1 and 100 |
Sample Request:
{
"customerSubscription":[
{
"insightName":"COUNT_OF_TRANSACTIONS_BY_MERCHANT",
"insightTitle":"New Title",
"customerConfiguration": [
{
"entityType": "ACCOUNT",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
},
{
"entityType": "VIEW",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
}
]
}
]
}
Response Messages:
| HTTP Status Code | Reason |
|---|---|
| 400 | Y806: Invalid Input |
| 400 | Y800: Invalid value for insightName |
| 400 | Y800: Invalid value for insightTitle; special characters ><\"'%{}|^~[] are not supported |
| 400 | Y801: Invalid length for insightTitle; min 3 and max 100 characters including spaces are allowed. |
| 400 | Y800: Invalid value for TOP in COUNT_OF_TRANSACTIONS_BY_MERCHANT insight Min =1 and Max = 100 |
| 400 | Y813: Invalid request. The entire object within threshold should be provided |
| 400 | Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT, modifying applicableEntity is not allowed |
| 400 | Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT, modifying triggerType is not allowed |
| 400 | Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT, modifying container is not allowed |
| 400 | Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT, modifying description is not allowed |
| 400 | Y800: Invalid value for isSubscribed; Supported values are true, false |
| 400 | Y825: Update not allowed without a valid request body |
| 400 | Y803: Invalid request; Either a valid insightTitle or customerConfiguration is required. |
| 400 | Y800: Invalid value for frequency; Supported values are DAILY, MONTHLY, WEEKLY |
| 400 | Y800: Invalid value for duration; Supported values are THIS_MONTH, LAST_MONTH, THREE_MONTHS, SIX_MONTHS, ONE_YEAR |
| 400 | Y812: Required field/value - insightName missing in the request |
| 400 | Y802: Modifying InsightType attribute is not allowed |
| 400 | Y813 :entityType should be provided |
| 400 | Y803 :At least one additional attribute is required in addition to entityType. |
| 400 | Y800: Invalid value for customerConfiguration; customerConfiguration is either missing, duplicated, or has insufficient/ incorrect attributes. |
| 400 | Y800: Invalid value for entityType. Supported entityType for COUNT_OF_TRANSACTIONS_BY_MERCHANT insight are - [ACCOUNT, VIEW] |
| 400 | Y800: Invalid value for input json |
| 400 | Y802: For COUNT_OF_TRANSACTIONS_BY_MERCHANT insight, {Invalid String} inside the threshold is either repeated or not allowed |
| 400 | Y802: For COUNT_OF_TRANSACTIONS_BY_MERCHANT insight, {Invalid String} inside the threshold is not allowed |
GET User Subscription
The GET user subscription API provides all the information about the user defaults set for the insight.
Method and URL:
GET /insights/configs/userSubscriptions
Header Parameters:
| Key | Value | |
|---|---|---|
Authorization |
Client credentials-based authorization | Bearer {{Access Token}} |
| API key-based authentication | Bearer {{JWT Token_Customer}} |
|
| Deprecated cobrand and user credential-based authentication | cobSession={cobSession received in the cobrand login service}, userSession={userSession received in the user login service} |
|
Content-Type |
application/json |
|
Api-Version |
2.1 |
|
2 |
||
Cobrand-Name |
{Name of the Customer} |
|
Sample Request:
GET /insights/configs/userSubscriptions?insightName=COUNT_OF_TRANSACTIONS_BY_MERCHANT
Sample Response:
For more information about the attributes that are returned in the API response, refer to the Insights Data Model page.
- Api-Version 2.1 Response
{
"userSubscription": [
{
"insightName": "COUNT_OF_TRANSACTIONS_BY_MERCHANT",
"insightTitle": "Count of Transactions by Merchant",
"insightType": "OTHER",
"triggerType": "SCHEDULE",
"containers": [
"BANK",
"CARD"
],
"description": "Generates an insight that provides spending trends (based on transaction count) by merchant over a configured time period.",
"applicableEntity": [
"ACCOUNT",
"VIEW"
],
"userConfiguration": [
{
"entityType": "ACCOUNT",
"entityId": "10255809",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
},
{
"entityType": "VIEW",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
}
],
"customerConfiguration": [
{
"entityType": "ACCOUNT",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
},
{
"entityType": "VIEW",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
}
]
}
]
}
- Api-Version 2 Response
{
"userSubscription": [
{
"insightName": "COUNT_OF_TRANSACTIONS_BY_MERCHANT",
"insightTitle": "Count of Transactions by Merchant",
"insightType": "OTHER",
"triggerType": "SCHEDULE",
"container": [
"BANK",
"CARD"
],
"description": "Generates an insight that provides spending trends (based on transaction count) by merchant over a configured time period.",
"applicableEntity": [
"ACCOUNT",
"VIEW"
],
"userConfiguration": [
{
"entityType": "ACCOUNT",
"entityId": "10255809",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
},
{
"entityType": "VIEW",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
}
],
"customerConfiguration": [
{
"entityType": "ACCOUNT",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
},
{
"entityType": "VIEW",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
}
]
}
]
}
PATCH User Subscription
Using the PATCH user subscription API for user subscription, users can change the defaults for each insight. If the user wants the insight to be evaluated for a new account or view, then add that account or view using the PATCH user subscription API. The customer default threshold values will apply if the user has not set any values.
Method and URL:
PATCH /insights/configs/userSubscriptions
Header Parameters:
| Key | Value | |
|---|---|---|
Authorization |
Client credentials-based authorization | Bearer {{Access Token}} |
| API key-based authentication | Bearer {{JWT Token_Customer}} |
|
| Deprecated cobrand and user credential-based authentication | cobSession={cobSession received in the cobrand login service}, userSession={userSession received in the user login service} |
|
Content-Type |
application/json |
|
Api-Version |
2.1 |
|
2 |
||
Cobrand-Name |
{Name of the Customer} |
|
Editable Parameters:
| Editable Attributes | Impact | Allowed Values |
|---|---|---|
| entityId | The ID of the account or view for which account gets evaluated. | Valid IDs for accounts or views belonging to the user |
| isSubscribed | Subscribes or unsubscribes from the Count of Transactions by Merchant insight. | true, false |
| frequency | The frequency with which an insight will be evaluated. |
|
| duration | The data range that should be considered for evaluating the insight. |
|
| threshold | The threshold (TOP) can be modified to adjust the number of merchants to get the transactions | Any number between 1 and 100 |
Sample Request:
{
"userSubscription": [
{
"insightName": "COUNT_OF_TRANSACTIONS_BY_MERCHANT",
"userConfiguration": [
{
"entityType": "ACCOUNT",
"entityId": "10255809",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
},
{
"entityType": "VIEW",
"isSubscribed": true,
"frequency": "WEEKLY",
"duration": "THREE_MONTHS",
"threshold": [
{
"name": "TOP",
"value": "5",
"type": "NUMBER"
}
]
}
]
}
]
}
Response Messages:
| HTTP Status Code | Reason |
|---|---|
| 400 | Y806: Invalid input |
| 400 | Y800: Invalid value for insightName |
| 400 | Y800: Invalid value for input param in COUNT_OF_TRANSACTIONS_BY_MERCHANT insight |
| 400 | Y802: Modifying insightTitle using this API is not allowed |
| 400 | Y800: Invalid value for threshold data in COUNT_OF_TRANSACTIONS_BY_MERCHANT insight |
| 400 | Y800: Invalid value for TOP in COUNT_OF_TRANSACTIONS_BY_MERCHANT insight Min =1 and Max = 100 |
| 400 | Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT, modifying applicableEntity is not allowed |
| 400 | Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT, modifying triggerType is not allowed |
| 400 | Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT, modifying container is not allowed |
| 400 | Y802: For insight COUNT_OF_TRANSACTIONS_BY_MERCHANT, modifying description is not allowed |
| 400 | Y800: Invalid value for frequency; Supported values are DAILY, MONTHLY, WEEKLY |
| 400 | Y800: Invalid value for duration; Supported values are THIS_MONTH, LAST_MONTH, THREE_MONTHS, SIX_MONTHS, ONE_YEAR |
| 400 | Y813: Invalid request. The entire object within threshold should be provided |
| 400 | Y800: Invalid value for isSubscribed; Supported values are true, false |
| 400 | Y825: Update not allowed without a valid request body |
| 400 | Y812: Required field/value - insightName missing in the request |
| 400 | Y802: Modifying InsightType attribute is not allowed |
| 400 | Y813: entityType should be provided |
| 400 | Y803: At least one additional attribute is required in addition to entityType. |
| 400 | Y800: Invalid value for userConfiguration; userConfiguration is either missing, duplicated, or has insufficient/ incorrect attributes |
| 400 | Y800: Invalid value for entityType. Supported entityType for COUNT_OF_TRANSACTIONS_BY_MERCHANT insight are - [ACCOUNT, VIEW] |
| 400 | Y800: Invalid value for entityId; This id is either invalid or not supported for this insight. |
| 400 | Y802: Duplicate entityId entries within userConfiguration is not allowed |
| 400 | Y800: Invalid value for userConfiguration; entityId should be provided. |
| 400 | Y802: Duplicate entityId entries is not allowed |
| 400 | Y800: Invalid value for input json |
| 401 | Y020: Invalid token in authorization header |
| 401 | Y020: Token has expired |
GET Insight Feeds
The GET insights feed API retrieves all or a subset of the valid insight notifications generated for a particular user. However, using the insightName filter, the Count of Transactions by Merchant insight can be specifically requested. The insight will be generated only if transactionCount for all merchants and debitTotal are greater than 0.
Calculation Logic for Derived Attributes:
averageNetTotal = netTotal/duration
Method and URL:
GET /insights/feed
Header Parameters:
| Key | Value | |
|---|---|---|
Authorization |
Client credentials-based authorization | Bearer {{Access Token}} |
| API key-based authentication | Bearer {{JWT Token_Customer}} |
|
| Deprecated cobrand and user credential-based authentication | cobSession={cobSession received in the cobrand login service}, userSession={userSession received in the user login service} |
|
Content-Type |
application/json |
|
Api-Version |
2.1 |
|
2 |
||
Cobrand-Name |
{Name of the Customer} |
|
Sample Request:
GET /insights/feed?insightName=COUNT_OF_TRANSACTIONS_BY_MERCHANT
Sample Response:
For more information about the attributes that are returned in the API response, refer to the Insights Data Model page.
{
"feed":[
{
"id":"60d43db8d59fdb46b0c911ff",
"insightName":"COUNT_OF_TRANSACTIONS_BY_MERCHANT",
"insightTitle":"Count of Transactions by Merchant",
"insightType":"OTHER",
"triggerType":"SCHEDULE",
"createdDate":"2021-06-24T08:09:27Z",
"subscription":[
{
"entityId":"60d43ca5f74fce189c9cf1ba",
"entityType":"VIEW",
"frequency":"WEEKLY",
"duration":"THREE_MONTHS",
"threshold":[
{
"name":"TOP",
"value":"5",
"type":"NUMBER"
}
]
}
],
"basicView":[
{
"id":"60d43ca5f74fce189c9cf1ba",
"name":"View 1",
"link":{
"entityName":"view",
"url":"/views/60d43ca5f74fce189c9cf1ba"
},
"basicTrend":[
{
"debitTotal":{
"amount":488286.09,
"currency":"USD"
},
"creditTotal":{
"amount":2779.86,
"currency":"USD"
},
"netTotal":{
"amount":485506.23,
"currency":"USD"
},
"averageNetTotal":{
"amount":161835.41,
"currency":"USD"
},
"transactionCount":251,
"merchantTrend":[
{
"basicMerchant":{
"name":"Others"
},
"debitTotal":{
"amount":276028.44,
"currency":"USD"
},
"creditTotal":{
"amount":478.0,
"currency":"USD"
},
"netTotal":{
"amount":275550.44,
"currency":"USD"
},
"averageNetTotal":{
"amount":91850.15,
"currency":"USD"
},
"transactionCount":150,
"detail":[
{
"dateRange":{
"fromDate":"2021-06-01",
"toDate":"2021-06-24"
},
"debitTotal":{
"amount":87357.23,
"currency":"USD"
},
"creditTotal":{
"amount":26.0,
"currency":"USD"
},
"netTotal":{
"amount":87331.23,
"currency":"USD"
},
"transactionCount":51
},
{
"dateRange":{
"fromDate":"2021-05-01",
"toDate":"2021-05-31"
},
"debitTotal":{
"amount":87795.23,
"currency":"USD"
},
"creditTotal":{
"amount":126.0,
"currency":"USD"
},
"netTotal":{
"amount":87669.23,
"currency":"USD"
},
"transactionCount":49
},
{
"dateRange":{
"fromDate":"2021-04-01",
"toDate":"2021-04-30"
},
"debitTotal":{
"amount":100875.98,
"currency":"USD"
},
"creditTotal":{
"amount":326.0,
"currency":"USD"
},
"netTotal":{
"amount":100549.98,
"currency":"USD"
},
"transactionCount":50
}
]
},
{
"basicMerchant":{
"name":"Comcast"
},
"debitTotal":{
"amount":2964.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":2964.0,
"currency":"USD"
},
"averageNetTotal":{
"amount":988.0,
"currency":"USD"
},
"transactionCount":5,
"detail":[
{
"dateRange":{
"fromDate":"2021-06-01",
"toDate":"2021-06-24"
},
"debitTotal":{
"amount":4.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":4.0,
"currency":"USD"
},
"transactionCount":1
},
{
"dateRange":{
"fromDate":"2021-05-01",
"toDate":"2021-05-31"
},
"debitTotal":{
"amount":1480.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":1480.0,
"currency":"USD"
},
"transactionCount":2
},
{
"dateRange":{
"fromDate":"2021-04-01",
"toDate":"2021-04-30"
},
"debitTotal":{
"amount":1480.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":1480.0,
"currency":"USD"
},
"transactionCount":2
}
]
},
{
"basicMerchant":{
"name":"Duke Energy"
},
"debitTotal":{
"amount":100399.76,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":100399.76,
"currency":"USD"
},
"averageNetTotal":{
"amount":33466.59,
"currency":"USD"
},
"transactionCount":5,
"detail":[
{
"dateRange":{
"fromDate":"2021-06-01",
"toDate":"2021-06-24"
},
"debitTotal":{
"amount":99999.76,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":99999.76,
"currency":"USD"
},
"transactionCount":1
},
{
"dateRange":{
"fromDate":"2021-05-01",
"toDate":"2021-05-31"
},
"debitTotal":{
"amount":200.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":200.0,
"currency":"USD"
},
"transactionCount":2
},
{
"dateRange":{
"fromDate":"2021-04-01",
"toDate":"2021-04-30"
},
"debitTotal":{
"amount":200.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":200.0,
"currency":"USD"
},
"transactionCount":2
}
]
},
{
"basicMerchant":{
"name":"LA Fitness"
},
"debitTotal":{
"amount":1213.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":1213.0,
"currency":"USD"
},
"averageNetTotal":{
"amount":404.33,
"currency":"USD"
},
"transactionCount":5,
"detail":[
{
"dateRange":{
"fromDate":"2021-06-01",
"toDate":"2021-06-24"
},
"debitTotal":{
"amount":13.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":13.0,
"currency":"USD"
},
"transactionCount":1
},
{
"dateRange":{
"fromDate":"2021-05-01",
"toDate":"2021-05-31"
},
"debitTotal":{
"amount":600.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":600.0,
"currency":"USD"
},
"transactionCount":2
},
{
"dateRange":{
"fromDate":"2021-04-01",
"toDate":"2021-04-30"
},
"debitTotal":{
"amount":600.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":600.0,
"currency":"USD"
},
"transactionCount":2
}
]
},
{
"basicMerchant":{
"name":"Netflix"
},
"debitTotal":{
"amount":4199.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":4199.0,
"currency":"USD"
},
"averageNetTotal":{
"amount":1399.67,
"currency":"USD"
},
"transactionCount":5,
"detail":[
{
"dateRange":{
"fromDate":"2021-06-01",
"toDate":"2021-06-24"
},
"debitTotal":{
"amount":2999.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":2999.0,
"currency":"USD"
},
"transactionCount":1
},
{
"dateRange":{
"fromDate":"2021-05-01",
"toDate":"2021-05-31"
},
"debitTotal":{
"amount":600.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":600.0,
"currency":"USD"
},
"transactionCount":2
},
{
"dateRange":{
"fromDate":"2021-04-01",
"toDate":"2021-04-30"
},
"debitTotal":{
"amount":600.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":600.0,
"currency":"USD"
},
"transactionCount":2
}
]
}
]
}
]
}
]
},
{
"id":"60d43db8d59fdb46b0c911fc",
"insightName":"COUNT_OF_TRANSACTIONS_BY_MERCHANT",
"insightTitle":"Count of Transactions by Merchant",
"insightType":"OTHER",
"triggerType":"SCHEDULE",
"createdDate":"2021-06-24T08:09:26Z",
"subscription":[
{
"entityId":"13709571",
"entityType":"ACCOUNT",
"frequency":"WEEKLY",
"duration":"THREE_MONTHS",
"threshold":[
{
"name":"TOP",
"value":"5",
"type":"NUMBER"
}
]
}
],
"basicAccount":[
{
"id":13709571,
"providerName":"Dag Site",
"accountName":"PDV_Test_Data-Long_Tenure_Recurring_Payments",
"accountType":"CHECKING",
"container":"bank",
"link":{
"entityName":"account",
"url":"/accounts?accountId=13709571"
},
"basicTrend":[
{
"debitTotal":{
"amount":6080.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":6080.0,
"currency":"USD"
},
"averageNetTotal":{
"amount":2026.67,
"currency":"USD"
},
"transactionCount":12,
"merchantTrend":[
{
"basicMerchant":{
"name":"Comcast"
},
"debitTotal":{
"amount":1480.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":1480.0,
"currency":"USD"
},
"averageNetTotal":{
"amount":493.33,
"currency":"USD"
},
"transactionCount":2,
"detail":[
{
"dateRange":{
"fromDate":"2021-05-01",
"toDate":"2021-05-31"
},
"debitTotal":{
"amount":740.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":740.0,
"currency":"USD"
},
"transactionCount":1
},
{
"dateRange":{
"fromDate":"2021-04-01",
"toDate":"2021-04-30"
},
"debitTotal":{
"amount":740.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":740.0,
"currency":"USD"
},
"transactionCount":1
}
]
},
{
"basicMerchant":{
"name":"Duke Energy"
},
"debitTotal":{
"amount":200.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":200.0,
"currency":"USD"
},
"averageNetTotal":{
"amount":66.67,
"currency":"USD"
},
"transactionCount":2,
"detail":[
{
"dateRange":{
"fromDate":"2021-05-01",
"toDate":"2021-05-31"
},
"debitTotal":{
"amount":100.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":100.0,
"currency":"USD"
},
"transactionCount":1
},
{
"dateRange":{
"fromDate":"2021-04-01",
"toDate":"2021-04-30"
},
"debitTotal":{
"amount":100.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":100.0,
"currency":"USD"
},
"transactionCount":1
}
]
},
{
"basicMerchant":{
"name":"LA Fitness"
},
"debitTotal":{
"amount":600.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":600.0,
"currency":"USD"
},
"averageNetTotal":{
"amount":200.0,
"currency":"USD"
},
"transactionCount":2,
"detail":[
{
"dateRange":{
"fromDate":"2021-05-01",
"toDate":"2021-05-31"
},
"debitTotal":{
"amount":300.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":300.0,
"currency":"USD"
},
"transactionCount":1
},
{
"dateRange":{
"fromDate":"2021-04-01",
"toDate":"2021-04-30"
},
"debitTotal":{
"amount":300.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":300.0,
"currency":"USD"
},
"transactionCount":1
}
]
},
{
"basicMerchant":{
"name":"Netflix"
},
"debitTotal":{
"amount":600.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":600.0,
"currency":"USD"
},
"averageNetTotal":{
"amount":200.0,
"currency":"USD"
},
"transactionCount":2,
"detail":[
{
"dateRange":{
"fromDate":"2021-05-01",
"toDate":"2021-05-31"
},
"debitTotal":{
"amount":300.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":300.0,
"currency":"USD"
},
"transactionCount":1
},
{
"dateRange":{
"fromDate":"2021-04-01",
"toDate":"2021-04-30"
},
"debitTotal":{
"amount":300.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":300.0,
"currency":"USD"
},
"transactionCount":1
}
]
},
{
"basicMerchant":{
"name":"Quicken Loans"
},
"debitTotal":{
"amount":2600.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":2600.0,
"currency":"USD"
},
"averageNetTotal":{
"amount":866.67,
"currency":"USD"
},
"transactionCount":2,
"detail":[
{
"dateRange":{
"fromDate":"2021-06-01",
"toDate":"2021-06-24"
},
"debitTotal":{
"amount":1300.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":1300.0,
"currency":"USD"
},
"transactionCount":1
},
{
"dateRange":{
"fromDate":"2021-04-01",
"toDate":"2021-04-30"
},
"debitTotal":{
"amount":1300.0,
"currency":"USD"
},
"creditTotal":{
"amount":0.0,
"currency":"USD"
},
"netTotal":{
"amount":1300.0,
"currency":"USD"
},
"transactionCount":1
}
]
}
]
}
]
}
]
}
]
}