Build mechanism to track apps with no traffic

[plittlewood-rpt]

Background context There are a number of active registered apps that do not have any traffic associated with them. We should consider whether or not these apps should remain active and if we should build a mechanism that notifies the developer they will be removed in X weeks or similar, before cleaning up.

Additional Information: Target point: Apps with active installations and 0 traffic (requests) for 2 + months

Example: The customer below installed an app on 16/01/24 and has no traffic since installation and the installation is still active:

Real example data available (speak to HP)

• The request is to create an automated email notification to the developer, to provide them the ability to contact the customer or uninstall.
• We also look to surface this information on the existing internal email or a sperate monthly email (TBC).

Example email template: Main Recipient: Notifications Email (if present, otherwise main developer org member email address) Bcc List: Store in parameter store, HP and MW

Dear Developer Name

We have noticed that following customer(s) have installed ‘APP NAME’, there has been no activity since installation and or for the past 2+ months:

CUSTOMER NAME – DATE OF INSTALLATION

Please reach out to the customer directly to continue the setup process or if the installation was done in error or no longer needed, you can terminate the installation from within the DeveloperPortal.

For more information on your installations, please click here.

Specification

• Project: Reapit.Lambdas.AppTrafficMonitor (or similar, name TBC)
  • Use CDK for the infra here
  • Should accept an input that allows the output to be previewed
  • Should be fired by event bridge to perform the following functions:
  • Fetches all active installations from the app market. From this get a list of unique apps to govern which apps we need to fetch traffic for. We can either do this via the Marketplace GET /installations?isInstalled=true endpoint or use the DynamoDb table Marketplace_Installations
  • Queries the billing API to get traffic for that app for the previous 3 months and the current month to date. Use the v2 trafficStatistics /{month}/stats endpoint for this eg GET trafficStatistics/2024-04/stats?applicationId=162ff1bb-5838-4329-abc4-e929cb531e3c
  • Compare the output against active installations to understand which installations have had zero traffic for the current months
  • Build an email per app that has one or more installations with no traffic for the last month + current month to date using the template provided above.
  • If fired in preview mode, the email content should be generated and stored somewhere (or emailed to a different supplied email address???)
  • If not fired in preview mode, the email should be generated and sent to the main developer email and support email (if configured)

[HollyJoyPhillips]

Hey @plittlewood-rpt we had an internal conversation with the Partnerships team about this and it's agreed we should look at notification automation. Partnerships team to provide content copy/requirements etc so we can review once received.

[plittlewood-rpt]

@plittlewood-rpt Tech spec needed (Lambda -> Eventbridge -> Email Template -> SES)

[plittlewood-rpt]

This is still on my to do list - skip in refinement this week