Records with birthday this month opted into email
Overview
This campaign template selects all records that have a birthday within the given month of 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 Month with Email campaign.
Use this campaign template to target all records with birthdays within the current month that are opted into receiving emails.
Interaction: GRS - Birthday Month
This template is located in RPI/Interactions/RPI Campaign Templates/Email
. 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.
![image-20240214-151807.png](../__attachments/3843655101/image-20240214-151807.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)
Batch Audience: This process block is where the user-created audience is assigned and run at 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.
Audience: In this example, an audience has been assigned, which is “GRS - Birthday Current Month w/Email”. We look deeper into this audience further in this document.
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.
![image-20240214-152823.png](../__attachments/3843655101/image-20240214-152823.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)
![](../__attachments/3843655101/image-20230322-155354.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)
Audience: GRS - Birthday Current Month w/Email
![image-20240214-154619.png](../__attachments/3843655101/image-20240214-154619.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)
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.
![image-20240214-154655.png](../__attachments/3843655101/image-20240214-154655.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)
The second process block is another filter block, which is using a selection rule to select records based on their
auth_code
within theContact_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.
![image-20240214-154720.png](../__attachments/3843655101/image-20240214-154720.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)
The third process block is also a filter block. This filter block is being used to select records that have a birthday month that is equal to 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 month for each record that has qualified the previous filters.
![image-20240214-155759.png](../__attachments/3843655101/image-20240214-155759.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)
Custom Attribute: GRS - Birthday Month
![image-20240214-155916.png](../__attachments/3843655101/image-20240214-155916.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)
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.
![image-20240214-160011.png](../__attachments/3843655101/image-20240214-160011.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)
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.
![](../__attachments/3843655101/image-20230316-155812.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)