Why Are Some Emails Missing From the EMAIL_TAG Table?

Question

Why are some emails missing from the EMAIL_TAG table? Shouldn't the table include all email with tags?

Environment

Connector: Pardot

Answer

When you send a list email, only one record has a tag and appears in the EMAIL_TAG table. Records for individual emails sent to recipients included in the list don't have tags.

You can use the following SQL query to see a list of all emails with a tag:

select t.id as tag_id, t.name as tag_name, et.*, e.*
from email e
left join email_tag et on e.id = et.email_id
left join "tag" t on et.tag_id = t.id
where e.list_email_id is not null;