There seems to be no way to export the attempted amount when an automated recurring gifts fail. The only value than can be exported is $0.

It is saved somewhere, because it offers us the opportunity to reproccess the gift and it shows the amount but there is no way to query/export this.

The Recurring Gift Instalment Amount field that we used to use in query shows $0 when gifts have been automated. This information makes it impossible to calculate the realisation rate (amount received/amount attempted) from RE data, which is a KPI for our regular giving programme.

Not having being able to query/export the attempted amount also makes it more difficult to follow up failed gifts because it is not available for letters, emails or to give to our telefundraising agency when calling donors about their failed gift.