Campaign performance drilldown by language

[alessandroventuri]

I need to split campaign performance data by language but I can't find it as a selectable dimension:

How can I get this data?

Thank you!

[former_member192216]

I understand your needs and it is a valid question/request/scenario.

FYI: at run time the campaign execution framework is choosing, dynamically, the email template language based on the contact main language. However, AFAK, the performance metrics are stored and aggregated at the campaign level, hence (unfortunately) independently from email template language used nor the user main language.

"Thinking out loud": I believed to achieve this we would need to retrieve the main language of the contact store in the interaction (with type EMAIL_OPENED) and then aggregate this count per different user main languages.

I will investigate further internally with some colleagues and get back to you....

[alessandroventuri]

Thanks, I am eagerly waiting!

[former_member192216]

Hi Alessandro,

After some internal investigation, I can (unfortunately) confirm that the aggregation of (EMAIL_OPEN interactions) can only be done at the campaign interaction level, i.e. not based on the user main language that open it (or as you mentioned, the language version of the email template used), at least from the Gallery Report.

I am still looking for different avenue to help you on that, and for this I will some time to get back to you.

Meanwhile, one (none optimal) way to work around it, could potentially be to use different email templates for the different targeted languages with associated TG filtered by the same language and then visualise the open rate in the Campaign Performance "By Content Name".

[alessandroventuri]

OK. I'll leave the question open until a proper solution will be found. Thanks.

[alessandroventuri]

I ask because I use a translated content for every language version:

[alessandroventuri]

I see. So, if I send a newsletter in many languages, how can I get data about the open rate, say, in english vs. french?

[former_member192216]

Hi Alessendro,

I know it was that field, however there is no dependency (nor aggregation) of any standard performance measures/metrics based on this language field, hence impossible to drill down with. From the standard delivery, that language field, in the Campaign Performance query, is only used internally to display the descriptions of text fields in the login language of user but has no impact on the metrics.

[alessandroventuri]

Thank you Alain!

I am referring to this field, that can be populated from an import and is not dictated solely from language login.

[former_member192216]

Hi Alessandro,

I double checked in HANA the CDS view behind this Campaign Performance query, and from the standard, there is no performance measures that are language dependent, therefore it is not possible to drill down on performance based on language. The language is currently automatically feed from the user login language and it is being used only to translate the descriptions of text fields (like category, marketing area, status, communication, communication medium, etc.).

I hope this answer your questions, if not please give us some more details about what kind of drill down you are drying to achieved.

Regards