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.
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
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 select only the current month totals by filtering the labels
that have the current month and year.
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.