Which schema should I query?

Avatar

Avatar

thomash82948276

Avatar

thomash82948276

thomash82948276

26-11-2018

I've sent a few deliveries manually using ad hoc data.

How do I setup a Campaign Workflow to query these sends to send a follow up email?

I've tried to query the Archived Event Tracking Logs for all Labels containing a certain word.  That produces a count of zero.  I've also tried the Recipient Tracking Logs and Tracking Log.

Can someone help with this please?

Logs.png

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

subhajit9830660

Avatar

subhajit9830660

subhajit9830660

26-11-2018

Hi Thomas,

Please the attribute dateOnly. e.g. DateOnly(@eventDate) = DateOnly(DaysAgo(3))

Thanks,

Subhajit

Answers (6)

Answers (6)

Avatar

Avatar

Adhiyan

Employee

Avatar

Adhiyan

Employee

Adhiyan
Employee

26-11-2018

HI Thomas,

What is confusing me is that the preview of the data that you see , has the deliveries listed that has a label Buy but ideally it should return the recipients. Like this .

1630423_pastedImage_0.png

But in your case I see the deliveries belonging to nms:delivery being returned. So I suspect a problem with the targeting dimension.

Regards,
Adhiyan

Avatar

Avatar

thomash82948276

Avatar

thomash82948276

thomash82948276

26-11-2018

Thank you, that worked.  Sorry for being slow on that one.

Can you help me with one more thing please?

I went to add an extra filter item, I only want people with an Event date of 3 days ago.  The Event date field is date & time though, so when I select "today minus 3 days" nothing is selected.  What is the syntax to trim the date & time so that Campaign only looks at the date portion of the field?

Avatar

Avatar

Adhiyan

Employee

Avatar

Adhiyan

Employee

Adhiyan
Employee

26-11-2018

Hi Thomas,

Which Filtering and targeting dimension have you used in the query. Are you filtering on BroadLogRcp.

You should ideally select filtering as broadLogRcp and targeting as Recipient for this purpose and the filter should look like.

1630404_pastedImage_0.png

If you want to check if the formatting of the word buy is causing this , change the filter to the primary key of the delivery and check if you have data.

Regards,
Adhiyan

Avatar

Avatar

Adhiyan

Employee

Avatar

Adhiyan

Employee

Adhiyan
Employee

26-11-2018

Hello Thomas,

In general, the broadLogRcp table stores the delivery logs and trackingLogRcp stores the tracking logs. This however can be changed from the target mapping used in a delivery.

You can verify this by clicking on "To" in the email editor and check the target mapping. In this target mapping , you can find the details where logs are stored for this delivery . So you should query on these tables for the delivery you have sent.

Regards,
Adhiyan

Avatar

Avatar

thomash82948276

Avatar

thomash82948276

thomash82948276

26-11-2018

I'm using BroadLogRcp and targeting as Recipient yes.

I've run the query to output where Primary Key is not empty, and that has confirmed that I have data in this table.

Within this result I can see the emails that I'm trying to filter by...

Label Buy 2.png

However, when I then update the main query to Label contains Buy, I get a result of zero.

Avatar

Avatar

thomash82948276

Avatar

thomash82948276

thomash82948276

26-11-2018

Thank you.

I'm trying to get all email addresses who were sent an email with "buy" in the Delivery Label.

Label Buy.png

Here it is in the data.  And here is my query.

Query.png

I'm getting no records though.  Is it because of the way that Buy is formatted in the Value field or something?

Thanks