In your query step add an additional field for "orgunit2" which would be the org id.  Then in the update profile (Fields to Update) use the additional field as the source and move it to the orgunit.

Reconcile the organization by the ID under the Admin/User and Security/Org Units.

You have posted this to Adobe Campaign Standard, and I believe you are using Adobe Campaign Classic which is a different forum.

As an FYI, our organization has implemented Celigo to interface between ACS and Salesforce.  We use a combination of Salesforce SOQL queries (Delta's and Extracts) and ACS (Via S3-SFTP and API).  There is a connector for Salesforce but not for ACS so we use the Http/Ftp methods. John

Try this logic instead. 

I don't see your primary = yes in the query logic.  I had that turned on which sums up in 1 delivery.  I do have recurring deliveries but they are removed and only shows the parent or primary delivery.  When you use Primary = Yes it will not show you single deliveries so I added a Label clause.  

Under properties, is the resource and targeting dimension Deliveries (Delivery)? Add @label in additional data.  Then run the query with the next step paused.  Click on the #record count, click open transition, then data.  You should see this:  

The easy fix is to in you query select Primary = Yes.  That gives you an overall total for that delivery.  If you want a monthly total, you will need to change your recurring deliveries to aggregation period to a Month.  Your example indicates it is set to Day.  If you do the later then you can sele...

The easiest way I found was to query my email address, because I want the email and then add additional data to the query.  The additional should be a key of value of what you want to retrieve.  Then in an enrichment activity bring the data together for the email.

Maybe this will work: Administration/Development/Diagnosis/Data schemas Search for Profile