'Mailing_Id' and 'Is_Predictive' columns returning no data

[Vidhi_Kare]

Hi,

Hope you all are having a good week & keeping well.

I just had a question regarding two columns in Marketo database tables i.e. ‘Mailing_Id’ and’ Is_Predictive’

In the Marketo destination tables there are two data columns that are not clear where they come from.

Specifically, tables:

[dbo].[Ext_Marketo_SendEmail]

[dbo].[Ext_Marketo_ClickEmail]

[dbo].[Ext_Marketo_EmailDelivered]

[dbo].[Ext_Marketo_OpenEmail]

[dbo].[Ext_Marketo_EmailBounced]

[dbo].[Ext_Marketo_UnsubscribeEmail]

have a column:

[Mailing_Id]

and:

[dbo].[Ext_Marketo_ClickEmail]

has a column:

                [Is_Predictive]

Are the columns ‘Mailing_Id’ and’ Is_Predictive’ valid for activity types mentioned? They are returning no data.

Apologies if it is confusing! Any help is appreciated.

Kind Regards,

Vidhi

[Darshil_Shah1]

Marketo returns Mailing ID attribute for the following activities - 

Activity ID	Activity Name	Activity Description
8	Email Bounced	Marketo Email is bounced for a lead
9	Unsubscribe Email	Person unsubscribed from Marketo Emails
10	Open Email	User opens Marketo Email
11	Click Email	User clicks on a link in a Marketo Email
27	Email Bounced Soft	Campaign Email is bounced soft for a lead
38	Send Alert	Send alert Email about a lead
111	Sent Forward to Friend Email	User Forwards Email to a person/record
112	Received Forward to Friend Email	User receives forwarded Email from friend
6	Send Email	Send Marketo Email to a person
7	Email Delivered	Marketo Email is delivered to a lead/contact

Mailing ID is primaryAttribute for the above activity types that has the email asset id in the primaryAttributeValueId parameter and the email asset name in the primaryAttributeValue parameter

Marketo returns Is Predictive attribute in the attributes JSON array for the following activities:

Activity ID	Activity Name	Activity Description
11	Click Email	User clicks on a link in a Marketo Email
41	Click Sales Email	User clicks on a link in a sales Email

 I believe the Is Predictive attribute will only be included in the response if the email uses predictive content.

Hope this helps!