Expand my Community achievements bar.

SOLVED

Which schema should I query?

Avatar

Level 3

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

1 Accepted Solution

Avatar

Correct answer by
Level 3

Hi Thomas,

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

Thanks,

Subhajit

View solution in original post

7 Replies

Avatar

Employee

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

Level 3

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

Avatar

Employee

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

Level 3

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

Employee

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

Level 3

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

Correct answer by
Level 3

Hi Thomas,

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

Thanks,

Subhajit