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 target profiles who subscribed to a service 7 days ago? (AC Standard)

Avatar

Avatar
Validate 1
Level 2
sonjaluoto
Level 2

Likes

3 likes

Total Posts

20 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
sonjaluoto
Level 2

Likes

3 likes

Total Posts

20 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
sonjaluoto
Level 2

22-08-2017

Hi!

I want to send an email 7 days after a user subscribes to a service. I'm using Adobe Campaign Standard. In my workflow I have an incremental query targeting all service "X" subscribers but how do I define the "7 days ago" part? I would also like to include that it wouldn't get any older subscriptions than max. 10 days ago. So it would be something like "subscribed before 7 days ago" and "after 10 days ago."

Should I use Subscription history and Date for targeting? Or do I need to create this in Advanced mode?

Thanks in advance,

Br,

Sonja Luoto

View Entire Topic

Avatar

Avatar
Boost 5
Employee
elliottja
Employee

Likes

5 likes

Total Posts

8 posts

Correct Reply

4 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Applaud 5
Affirm 3
View profile

Avatar
Boost 5
Employee
elliottja
Employee

Likes

5 likes

Total Posts

8 posts

Correct Reply

4 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Applaud 5
Affirm 3
View profile
elliottja
Employee

23-08-2017

If you're using the incremental query you shouldn't need to include the older subscriptions part of the filter once you've run it the first time. I'll describe how to create your 7 days ago filter and you can expand this as required.

Assuming you started by selecting Shortcuts > Subscription menu, then dragged Subscriptions onto the filtering canvas and selected your service from there...

You can add another filtering criteria and use Advanced mode as follows:

Screen Shot 2017-08-23 at 23.39.52.png

For copy+paste purposes: DateOnly(@created)=DateOnly(SubDays(GetDate(),7))

Or you could use: DateOnly(@created)=DateOnly(DaysAgo(7)) and get the same result.

Note that the created date and GetDate() are both datetime fields, so I've had to use the DateOnly function.

My final incremental query looks like this:

Screen Shot 2017-08-23 at 23.46.52.png

You can save this filter to make it easier for other users of the platform.