Is there any way to tag/attribute a tag to an email (to categorize them for example) and use it in the SQL queries to get tracking information by email types (transactional, commercial, welcome pack, etc) ?



1 Answer 1


This question discusses querying tags and campaigns (Is it possible to write a SQL Query to extract send data that includes Tags and/or Campaign names) - apparently not possible.

However, if you want to break down tracking information by transactional, commercial, etc, you could consider using specific Send Classifications for the email sends. You are probably already using "Default Commercial" and "Default Transactional" for their respective sends. You can create additional ones (eg: we have a send classification for "Reengagement").

The Send Classification value is then available on the _Job view, making it very easy to use in SQL queries.

  • Thanks a lot. It's a shame we can't use "tags" or "campaigns" on emails in the SQL. I also thought about using the Send classifications as a workaround.
    – Ludivine L
    Apr 30, 2021 at 7:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.