'Mailing_Id' and 'Is_Predictive' columns returning no data | Community
Skip to main content
Vidhi_Kare
Vidhi_Kare
New Participant
March 31, 2022
Question

'Mailing_Id' and 'Is_Predictive' columns returning no data

  • March 31, 2022
  • 1 reply
  • 1186 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Darshil_Shah1
Darshil_Shah1
Community Manager
March 31, 2022

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!

    Terms & ConditionsAccessibility statement

    Loading footer...