We have created fields in our external database to hold a true/false value if a customer is enrolled in a campaign. Our problem is getting the data into our database.
We have tried looping through each customer, getting their VID, then getting the customer’s enrolled campaigns. The problem with this is that the daily limit for an API token is 40,000/day whereas we have 100,000 customers and each customer requires 2 API calls.
Surely someone has tried to reflect the campaigns to their own internal database before, what is the best/most efficient way to do this?