Show the attributes of the related company in a report

[pieter_rijlaarsdam1]

Hey guys,

I am running a B2B email campaign targeting the contacts of a company.

In reporting, I would like to see the opens per company location (i.e. country).

The standard Analytics Stories and operational reports only show me the attributes of the recipient.

I have tried creating a custom analytical CDS view containing the interaction (for instance the EMAIL_OPENED), the related InteractionContact and the related account, but I cannot find the link between the InteractionContact and the Account.

What am I missing?

Thanks,

Pieter

[MarkusGrant]

Hi Pieter,

The view I_MKT_ContactRelation contains the relationship between the interaction contact and the account.

We used it for a similar reporting requirement recently.

Cheers,

Markus