Got a 'How do I' question? Join 'Ask a Trainer' Monday to Friday, 11am to 4pm ET for instant help and pro tips!

How to display birthdate in contact columns

SOLVED
Go to solution
NOLABrad
Campaign Collaborator

My database consists of about 1,000 clients. We use their birthdate to send an automated birthday greeting card. I'm attempting to update the database by filling in any missing birthdates via our office records, but in the 7 columns that can be configured in the contacts display, there is no option for birthdate (only addresses, company, 2nd email, etc.). Is there a way to get the birthdate to be one of the 7 columns so I can scroll down the list and see which records need to be updated?

1 ACCEPTED SOLUTION
William_A
Administrator
0 Votes

Hello @NOLABrad ,

 

At this time the Birthday and Anniversary date fields are not available as selectable columns for viewing or sorting in the contacts dashboard. I've tracked your account as being interested in such a feature being developed, and submitted it to the devs for further review. If and when they have an update regarding this feature request, they'll notify you directly.

 

At this time the only workaround would be to export all of your contacts with at least the email address and birthday fields selected, use your spreadsheet program to sort them based on birthday date, and then fill in info for those missing it. You can then re-import that updated file, which will update the existing contacts with that new info. If you don't already have a list where all of your contacts are, you can create a list to dump everyone into for the sake of the re-import, then delete-the-list-only afterwards if you don't want it among your others.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support

View solution in original post

6 REPLIES 6
NOLABrad
Campaign Collaborator
0 Votes

Sorry, meant to include these two screenshots:

NOLABrad_0-1647535854454.png

NOLABrad_1-1647535870939.png

 

William_A
Administrator
0 Votes

Hello @NOLABrad ,

 

At this time the Birthday and Anniversary date fields are not available as selectable columns for viewing or sorting in the contacts dashboard. I've tracked your account as being interested in such a feature being developed, and submitted it to the devs for further review. If and when they have an update regarding this feature request, they'll notify you directly.

 

At this time the only workaround would be to export all of your contacts with at least the email address and birthday fields selected, use your spreadsheet program to sort them based on birthday date, and then fill in info for those missing it. You can then re-import that updated file, which will update the existing contacts with that new info. If you don't already have a list where all of your contacts are, you can create a list to dump everyone into for the sake of the re-import, then delete-the-list-only afterwards if you don't want it among your others.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
NOLABrad
Campaign Collaborator

While that certainly sounds like a reasonable workaround, it's definitely not as convenient as being able to view it on the dashboard. I suppose for now it's what I'll have to do. Thanks, but yes, please let me know if an update ever occurs.

JoseY88
Rookie
0 Votes

We also would appreciate the ability to sort via birthday column as we are attempting to accomplish this same task.

CrystaB
Rookie
0 Votes

I am trying to accomplish the same task, and while following these instructions have still not yet found out how to segment based on birthdays with this dilemma. This post also looks like it was made awhile ago. Is there any updates to these fixes? Not only is it inconvenient, but those who are new to this program may not even be able to work through this workaround. 

JoseY88
Rookie
0 Votes

We also would appreciate the ability to sort via birthday column as we are attempting to accomplish this same task.

  • Avatar

    Featured Article

    Use Sections to Build Email Campaigns Faster and Improve Engagement Rates

    Using Sections while designing your marketing email not only increases your own efficiency but helps you to deliver a more friendly, organized message. Check out some of the key benefits of using sections in email.

    See Article
  • Avatar

    Featured Thread

    Casual Conversations: What's your go-to playlist?

    If you listen to music while you work, share your playlist below so we can be inspired and maybe find some new music!

    View thread
  • Avatar

    Featured Thread

    Ready, Set, Send Reflections

    The Ready, Set, Send Challenge has finished! Let's reflect on the wins and accomplishments over the last six weeks.

    Join challenge
Updates
Just Getting Started?

We’re here to help you grow. With how-to tutorials, courses, getting-started guides, videos and step-by-step instructions to start and succeed with Constant Contact.

Start Here

73% of SMBs express doubt that their marketing strategy is effective. Does this sound familiar? Read our Small Business Now Report to learn how you can tweak your strategy to see better results.

Go read our article
Upcoming Webinars
DEC 12
Ask Us Anything: Your Digital Marketing Questions Answered
2PM - 3PM EST