Why Are Past Discounts Missing From the SUBSCRIPTION_DISCOUNT Table?

Question

Past discounts that my customers used for their subscriptions are missing from the SUBSCRIPTION_DISCOUNT table. Why are they missing?

Environment

Connector: Stripe

Answer

Per Stripe's API documentation, Fivetran can only pull the current discount of every object in the subscription. Stripe does not provide APIs to pull past discounts applied to a particular subscription. Consequently, past discounts do not appear in the SUBSCRIPTION_DISCOUNT table.

Use Case

For example, let's say your customer has redeemed the following two coupons:

• Coupon ID 12345: For a 3-month discount period that ended before you created your Stripe connector.
• Coupon ID abcde: For a 2-month discount period that is currently active.

In the SUBSCRIPTION_DISCOUNT table, you will only see an entry for the most recent discount period, which was activated with the coupon code abcde. You can view the data for the coupon ID 12345 in the INVOICE_DISCOUNT table, which does store information about past discounts.