The Email Facts metadata includes a number of Email…Fact query subjects, which represent different filters applied to a single database table. For simplicity, these query subjects are all represented by the Email Count Fact, shown highlighted in the diagram that follows:
The Email Facts metadata also uses the Participant (User), Time, and Date query subjects from the platform metadata.
All Email…Fact query subjects have the same relationships to the other query subjects in the model. The query subjects are:
Email Count Fact
Email Sent Fact
Email Failed Fact
Email Opened Fact
Email Hard Bounce Fact
Email Soft Bounce Fact
Email Opt Out Fact
Email Clicked Fact
The Email…Fact query subjects include the following query items:
