I am loading Campaign Members via the Data Import Wizard. Specifically, I am adding new leads and updating existing leads. The leads get created but Campaign Membership is not established because I am receiving a TOO MANY SOQL queries error because the Campaign Member object is being called multiple times from process builders we have created. There are 2 process builders that reference the Campaign Member object and they are both being called when I import leads via the Data Import Wizard. Also, from my testing I am able to successfully load 9 Leads as Campaign Members but when I get to 10 I receive an error on all records. I am trying to understand what in the Process Builder would be calling the query.
I have attached the Process Builder for review.
Does anyone know what is causing the Process Builder to call the SOQL Queries, as we are hitting the limit of 100 on a file of only 45 leads?