Which schema should I query?

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

Thank you.

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

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

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

Thanks

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.

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

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...

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

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 .

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

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?