Changelog

7th Oct 2025 Release

Two new tables have been added:

  • exchange_rate_daily: Stores daily exchange rate information for various currencies, enabling currency conversion and financial reporting across different currencies.
  • item_mrr_history: Captures the historical changes in item-level Monthly Recurring Revenue (MRR) for subscription items. Each row represents a distinct change event at the item level, allowing for detailed analysis of how individual subscription items contribute to overall MRR changes.

Table Renamed:

  • subscription_mrr_changes has been renamed to subscription_mrr_history. The table structure has been updated with renamed fields: status → subscription_status, status_previous → subscription_status_previous, mrr → subscription_mrr, mrr_previous → subscription_mrr_previous, and mrr_change → subscription_mrr_change.

Note:

12th Sep 2025 Release

Three new tables have been added:

  • omnichannel_subscriptions: Represents subscription records unified across Apple App Store and Google Play Store, mapped to Chargebee’s omnichannel format.
  • omnichannel_subscription_items: Represents subscription items across app stores, with lifecycle, renewal, cancellation, expiration, and catalog mapping attributes.
  • omnichannel_transactions: Unified view of subscription purchase transactions across app stores. The price reflects the actual price paid by the end customer.

19th Aug 2025 Release

Three new metadata columns are now available across all tables, enabling better tracking of data flow.

  • record_extracted_at: The column represents the timestamp when the updated data became available in Chargebee’s data lakehouse.
  • record_exported_at: The column represents the timestamp when the data was exported to the configured destination.
  • change_type: The column indicates the type of change [create, update, delete, read] and can be used to load data into the warehouse accordingly

24th June 2025 Release

item_entitlements table has been removed from Automatic Exports until further notice.

14th May 2025 Release

Fourteen new tables have been added:

  • business_entity_transfers: business_entity_transfer encapsulates the details of the movement of a resource (such as customer and subscription) from one business_entity to another.
  • contract_terms: Subscriptions can run indefinitely, or they may run for a fixed number of billing cycles. Subscription can have 'contract terms', which define a lock-in period on the subscription for a certain number of billing cycles. This prevents the subscription from being canceled by the customer when it is within the contract term.
  • orders: Orders are automatically generated for an invoice when it gets paid, based on the shipping preference chosen for the invoice's product and the shipping date configuration.
  • order_line_item_discounts: The list of discounts applied for the order.
  • order_line_item_taxes: The list of taxes applied on the order line items.
  • order_line_items: The list of line items for this order.
  • order_linked_credit_notes: The credit notes linked to the order.
  • resent_orders: The list of resent orders applied on the order.
  • ramps: The ramp resource or a subscription ramp represents a planned change to a subscription set to occur at a future date. By using this resource, you can define and schedule modifications to a subscription, such as updating pricing, altering the quantity, or transitioning to a different plan, without immediately applying them.
  • ramp_coupons_to_add: Details about the coupons added to the subscription through this ramp.
  • ramp_discounts_to_add: Details about the discounts added to the subscription through this ramp.
  • ramp_item_tiers: Overrides the item_tiers for specific item_prices of the subscription.
  • ramp_items_to_add: Details about the item prices added to the subscription through this ramp.
  • ramp_items_to_update: Details about the item prices updated in the subscription through this ramp.

10th Apr 2025 Release

Two new tables have been added:

24th Jan 2025 Release

Three new tables have been added to enhance subscription and MRR analysis:

Table Name Table Description
subscription_mrr_history This table captures the historical changes in subscription status and Monthly Recurring Revenue (MRR) for each subscription. Each row represents a distinct change event, allowing for a comprehensive view of a subscription's lifecycle. The table is designed to facilitate root cause analysis of subscription upgrades, downgrades, and cancellations when joined with internal product analytics datasets.
subscription_mrr_daily_summary The subscription_mrr_daily table offers a comprehensive daily view of Monthly Recurring Revenue (MRR) for each subscription in both the billing currency and the site’s reporting currency.
subscription_mrr_monthly_summary The subscription_mrr_monthly table offers a comprehensive monthly view of Monthly Recurring Revenue (MRR) for each subscription in both the billing currency and the site’s reporting currency.

Note: All tables automatically recalculate when reporting timezone or currency settings change.

7th Jan 2025 Release

New field available: dunning_status is added to the invoices table.

3rd Dec 2024 Release

New table available: invoice_dunning_attempts