search

getsentry / sentry

Developer-first error tracking and performance monitoring
https://sentry.io
Other
38.89k stars 4.17k forks source link

[Usage Reports] Show usage details for deleted projects #76069

Open souredoutlook opened 2 months ago

souredoutlook commented 2 months ago

Problem Statement

Usage reports don't show data for deleted projects (usage reports can be downloaded from here as an example https://us.sentry.io/organizations/some-slug/billing/history/some-id/export/)

This makes it impossible to match event totals from the report to bill totals

Solution Brainstorm

Show usage/outcomes from deleted projects on csv - obfuscate the project name and show

For now the workaround is for Support to explain to the customer the missing totals by getting the deleted project ID by inspecting audit log API request details and then running such a query in the usage database: 

select sum(quantity), billing_metric from accounts_billingmetricusage where project_id = some_id and outcome = 0 and date >= '2024-08-05'::date group by billing_metric

Product Area

Unknown

getsantry[bot] commented 2 months ago

Assigning to @getsentry/support for routing ⏲️

getsantry[bot] commented 2 months ago

Routing to @getsentry/product-owners-unknown for triage ⏲️

hubertdeng123 commented 2 months ago

This seems like an admin portal endpoint so not sure where to route. Going to go with enterprise for now

getsantry[bot] commented 2 months ago

Routing to @getsentry/product-owners-settings-projects for triage ⏲️