Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

how to query date join is last month?

Avatar

Avatar
Validate 1
Level 2
binhr47192046
Level 2

Likes

9 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
binhr47192046
Level 2

Likes

9 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
binhr47192046
Level 2

20-09-2017

Hi,

I am building a campaign to target new customer who joined last month then send them a welcome email.

thinking will be using

  1. Scheduler: automate the workflow to run monthly
  2. Query : query all new customers who has joined last month (for example if run the Workflow this month; it will pull out all new customers who joined last month August)
  3. email delivery: to send email

My question are:

  • in this scenario we should use normal query or incremental query activity?
  • normal email delivery or recurring delivery?
  • say for example there is a field called date join in the table. how to query people who has date join is last month ?

Thanks and regards

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

21-09-2017

Hi,

find my answers inline:

  • In this scenario, we should use standard query or incremental query activity? Incremental Query
  • normal email delivery or recurring delivery? Neither, Go with Continous delivery
  • say for example there is a field called date join in the table. How to query people who have date join is last month?

With an Incremental Query, if you schedule it to run monthly with history saved permanently, you shouldn't need any query but it's not ideal, it may cause problems with migration and upgrade so use below query:

1306598_pastedImage_3.png

Just replace creation date with Joining date.

Targeting activities

Answers (0)