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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

juliak39390008
Community profile juliak39390008 Level 2
Job title here
Location here
6 BADGES
Level 2

Level 2

Learn more
Joined the community 18-07-2017 10:35:54 AM
Offline
Top badges earned by juliak39390008
Customize the badges you want to showcase on your profile
Re: Query on a rolling schedule
Avatar
Ignite 3
Level 2
juliak39390008
Level 2

Like

1 like

Total Posts

5 posts

Correct reply

1 solution
Top badges earned
Ignite 3
Give Back
Ignite 1
Validate 1
Boost 1
View profile
juliak39390008
- Adobe Campaign Standard
Created a workflow for the T-30 & T-14 emails. Have 2 queries in the workflow- first one pulls the T-30 until an event and then also anyone who bought a ticket for that event. Formula for T-14 query: @eventdatetime >= DateOnly(DaysAgo(-14)) AND @eventdatetime < DateOnly(DaysAgo(-15)) Did the same for all the others, except a positive 1 and 2 for the T+1 event. Hope that helps.

Views

1.7K

Likes

0

Replies

0
Query on a rolling schedule
Avatar
Ignite 3
Level 2
juliak39390008
Level 2

Like

1 like

Total Posts

5 posts

Correct reply

1 solution
Top badges earned
Ignite 3
Give Back
Ignite 1
Validate 1
Boost 1
View profile
juliak39390008
- Adobe Campaign Standard
Hi All, I am trying to develop a query that delivers emails on a rolling basis for event campaigns that are running in parallel. Here are the details:Need to query off of an "Event date" within a data table and send out an email with dynamic content30 days before the event date- to a certain segment of event ticket holders14 days before the event date- to a certain segment of event ticket holders1 day before the event date- to all event ticket holders (dynamic content based on type of ticket hol...

Views

2.6K

Likes

0

Replies

3
Identifying a 'no activity' segment of customers
Avatar
Ignite 3
Level 2
juliak39390008
Level 2

Like

1 like

Total Posts

5 posts

Correct reply

1 solution
Top badges earned
Ignite 3
Give Back
Ignite 1
Validate 1
Boost 1
View profile
juliak39390008
- Adobe Campaign Classic
I want to identify customers who received an email or push notification, did not click or open the delivery, and then re-target them. Is the best way to do this to create a fork to run an incremental query to identify who clicked, an incremental query to identify who the email was sent to and an incremental query to identify who did not click. Then find the exclusion and deliver the email to that group of customers? Any suggestions on a different way to identify a group of customers who have not...

Views

1.0K

Like

1

Replies

1
Likes from