Saturday, September 22, 2018

Customer Search that Groups Email Address by Domain Name

To create the search, perform the following steps:

     1. Navigate to Lists > Search > Saved Searches > New.
     
     2. Select Campaign.
     
     3. Provide a Search Title.
     
     4. In the Criteria tab > Standard subtab, add filter to narrow down result (e.g. Campaign ID).
     
     5. In the Results tab > Columns subtab, set the following:

Field

Summary Type

Formula

Summary Label

Campaign Recipient: Internal ID

Count

 

Count of Users with the Email Address

Response

Group

  
Formula (Text)

Group

substr({campaignrecipient.email},instr({campaignrecipient.email},'@') + 1)

Email Address Domain

         
     6. Click Save and Run.

Note: Search works best when targeting specific Campaigns used in the criteria. Filtering this search for only a particular response type provides high level information on domains with higher failure and/or success rates so user can adjust the Campaign strategy.

No comments:

Post a Comment