Using InCites Benchmarking & Analytics, you can identify the articles and reviews that your organization has most likely paid the Article Processing Charges, or APCs.
The following video walks through performing a Publication Sources analysis to get to a single download of all the gold and gold-hybrid articles and reviews from a single publisher or unified publisher.
With those items identified, you can then start calculating the potential cost or cost savings of an agreement.
A python script was created to take the InCites export and attempt to find the APC amounts automatically. Download the script at our GitHub site: https://github.com/clarivate/incites-to-openalex-apc/tree/main
No API key is required to run this script.