Written by Digital Aquila team – Salesforce Marketing Cloud experts from Washington D.C.
Many organizations where multiple consultant companies and agencies send emails, need to control users who send emails (so called job performers) and what emails are sent by a particular user.
There is no report, which allows us to find it out.
What is often required is to generate the report who has sent emails for the last 3 months or so, and how many email jobs have been performed by a user.
The nearest solution to answer this question is to use the _Job system data view.
Among other fields, there is a field AccountUserID
| Name | Description | DataType | Data Extension Data Type | Nullable |
| JobID | The job ID number for the email send | int | Number | |
| EmailID | The email ID for the job | int | Number | X |
| AccountID | The ID number for the account that performed the job | int | Number | X |
| AccountUserID | The ID number for the account user that performed the job | int | Number | X |
AccountUserID is the ID number for the account user that performed the job.
Every user has its own AccountUserId, but where you can find it?
If you go to the user admin screen, you can’t find any AccountUserId there.
The way we can able to find out the AccountUserId is to use the following SOAP call:
<s:Envelope xmlns:s=”http://www.w3.org/2003/05/soap-envelope” xmlns:a=”http://schemas.xmlsoap.org/ws/2004/08/addressing” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>
<s:Header>
<fueloauth>XXXXXXXXXXX</fueloauth>
</s:Header>
<s:Body xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema”>
<RetrieveRequestMsg xmlns=”http://exacttarget.com/wsdl/partnerAPI”>
<RetrieveRequest>
<ClientIDs>
<ClientID>XXXXXXXX</ClientID>
<ID>XXXXXX</ID>
</ClientIDs>
<ObjectType>AccountUser</ObjectType>
<QueryAllAccounts>true</QueryAllAccounts> // to enable child accounts
<Properties>email</Properties>
<Properties>ActiveFlag</Properties>
<Properties>CreatedDate</Properties>
<Properties>isAPIUser</Properties>
<Properties>UserID</Properties>
<Properties>LastSuccessfulLogin</Properties>
<AssociatedBusinessUnits>
<BusinessUnit>
<Properties>Name</Properties>
</BusinessUnit>
</AssociatedBusinessUnits>
<Roles>
<Role>
<Properties>Name</Properties>
</Role>
</Roles>
</RetrieveRequest>
</RetrieveRequestMsg>
</s:Body>
</s:Envelope>
The Response to this call will give us the full information about each user
<Results xsi:type=”AccountUser”>
<Client>
<ID>XXXXXX</ID>
</Client>
<PartnerKey xsi:nil=”true” />
<PartnerProperties>
<Name>email</Name>
<Value>xxx.xxx@xxx.com</Value>
</PartnerProperties>
<PartnerProperties>
<Name>isAPIUser</Name>
<Value>False</Value>
</PartnerProperties>
<CreatedDate>2015-05-29T13:08:33.033</CreatedDate>
<ID>7282002</ID>
<ObjectID xsi:nil=”true” />
<UserID>xxxx.xxx@xxxxx.com</UserID>
<ActiveFlag>false</ActiveFlag>
<Delete>0</Delete>
<LastSuccessfulLogin>2015-12-01T07:11:36.63</LastSuccessfulLogin>
</Results>
So now you have all details needed to align users, user_ids and user’s email address in order to build a report that would tell you what users is the most active sender in your instance.
We can build this report for you!
Digital Aquila – Salesforce Marketing Cloud experts can help you to optimize your Salesforce Marketing Cloud operational costs and identify the ROI you get from the platform.
We are based in Washington D.C with offices in Sydney and London. We are Salesforce specialists with presence in New York, Atlanta, Boston, New York, Denver, Los Angeles and Chicago.
Reach out to us if you have any questions: support@digitalaquila.com
Reach out: support@digitalaquila.com