Re: 'Mailing_Id' and 'Is_Predictive' columns returning no data

Vidhi_Kare
Level 3

'Mailing_Id' and 'Is_Predictive' columns returning no data

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

1 REPLY 1
Darshil_Shah1
Level 10 - Community Advisor

Re: 'Mailing_Id' and 'Is_Predictive' columns returning no data

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!