Excel: Copy Formula

One of the most powerful features of Excel is the formula and the ability to copy the formula easily across rows. But in a scenario where rows are filtered in other columns, the shortcut will not work -- this applies to both Excel desktop and Excel online. 

Rows filter >> double click bottom left of formula cell

• will copy the value to all the rows below if all rows below are blank
• will stop copying when it reaches a row (filtered or unfiltered) that is not blank

Rows filter >> manual copy and paste the formula

• works, the filtered rows will be ignored, and the value will not be overwritten from the paste

Salesforce: ListEmail

In addition to the B2B Marketing Analytics - Account Engagement Emails and Account Engagement Email Templates Datasets discussed here. We can also retrieve email statistics sent from MCAE/Pardot using SOQL into the ListEmail object in Salesforce. 

The ListEmail object represents a list email sent from Salesforce or from Account Engagement, and the email sent result is synced to Salesforce. When the list email is sent, recipients are generated by combining the recipients from ListEmailIndividualRecipients and ListEmailRecipientSource. Duplicate and other invalid recipients are removed. The result is recipient sent any given list email. ListEmail has a one-to-many relationship with ListEmailRecipientSource and ListEmailIndividualRecipient. This object is available in API version 41.0 and later.

To differentiate emails sent from Salesforce or Pardot, check the SentVia field. 

SELECT SentVia, count(Id) FROM ListEmail WHERE CreatedDate = this_year GROUP BY SentVia

Each row represents an email sent; no recipients are on this object because the email can be sent to many people. Check ListEmailIndividualRecipient for email recipients, which is a child of ListEmail.

Reference:

• B2B Marketing Analytics: Account Engagement Email Datasets
• Salesforce Field Reference Guide - ListEmail
• Object Reference for the Salesforce Platform - ListEmail