Skip to main content
Skip table of contents

Records with birthday within 7 days opted into email


This campaign template selects all records that have a birthday within 7 days of current execution that are also opted into email. There are a few different parts to the template that when put together in an interaction will allow you to send out birthday communications. The following will break down each of the parts of the Birthday Week campaign.

Use this campaign template to target all records that have birthdays within the next 7 days and that are opted into receiving emails.

Interaction: GRS - Birthday Next 7 days

This template is located in RPI/Interactions/RPI Campaign Templates/Email/Birthday Campaigns/Birthday Week. The interaction is where the selections rules and audience are put together to allow the RPI user to send the final selected group of records out of the system.

  1. Batch Audience: This process block is where the user-created audience is assigned and run at the time of processing. We will dig further into the audience set up in the next section, but this is just a look at how this process block would be configured to run an audience.

    1. Audience: In this example, an audience has been assigned, which is “GRS - Birthday Current Day”. We look deeper into this audience further into this document.

    2. Placeholders: These are attributes that have been created to simplify updating criteria within the selection rules within an audience. This configuration lets you make these changes in one place without needing to go into the underlying audience. Click Manage placeholders to access or change this option any time you use this template. The second screenshot shows that there is only one placeholder for the initial audience, which is looking for Business Unit Code.


Audience: GRS - Birthday Within 7 Days

  1. The first process block within the audience is a filter block. This filter block allows you to assign a selection rule to select certain records based on their information within the database. The configured selection rule in this filter block is looking for records with the selected Business Unit Code, which is being set using a placeholder as mentioned above.

  1. The second process block is another filter block, which is using a selection rule to select records based on their auth_code within the Contact_Auth_Email_Summary.

When creating this audience, both of the provided rules could be combined into one selection rule, but splitting them out gives you the ability to see the count breakdown at each step.

  1. The third process block is also a filter block. This filter block is being used to select records that have a birthday within the next 7 days within the current month. This rule is using a custom attribute within the selection rule. This rule is using the birth_date field from the GRS table to determine the birth day for each record that has qualified the previous filters.

Custom Attribute: GRS - Birthday-CurrentDay
  1. The fourth process block in the audience is a suppression block, which takes all of the qualified records from the previous selection rules and removes records based on information about these records in the database. The suppressions that have been applied to this campaign are based on these selection rules.

  1. Control: This process block is used to either execute an offer, generate an export file, or in this case write to a control table. This process will work with any of those options, but this example uses a control group.



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.