Chargebee Billing Analytics with BigQuery
1) Add a new report
The template already has the fields needed for a trial-to-paid report. Give your agent a prompt like this:
Add assets/chargebee_reports/monthly_trial_conversion.sql to this Bruin project.
Use one row per metric_month and currency. Count subscriptions whose trial ended in the month, then count how many became MRR eligible within the conversion window. Include trials_ended, trials_converted, trial_conversion_rate, and converted_mrr_minor.
Follow the existing report conventions: keep amounts in native minor units, add a full @bruin header, document every column, add not-null checks, and add a custom check that the conversion rate is between 0 and 1. Show the SQL before writing it. After approval, run bruin validate and show the first 10 rows.
The important parts are the grain, the metric policy, and the request to show the SQL before writing. A coding agent can generate SQL quickly; your review still decides whether the definition matches how the company talks about trials.