How to find out the most active senders in organization

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

NameDescriptionDataTypeData Extension Data TypeNullable
JobIDThe job ID number for the email sendintNumber 
EmailIDThe email ID for the jobintNumberX
AccountIDThe ID number for the account that performed the jobintNumberX
AccountUserIDThe ID number for the account user that performed the jobintNumberX

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.

Reach out to us if you have any questions: support@digitalaquila.com

Reach out: support@digitalaquila.com