How to Get Bounce Category from Historical Email Bounce Activity Data?

Question

Hello Marketo Community,My team has created a bounce directory that populates a custom field with the latest bounce category number for each record. However, we've found that this value is missing for many records because the data has been archived. The only way to find this information for archived records is to go into each one individually, check the activity log, find the 'Email Bounce' activity, open it, and then find the bounce category number. This is a very time-consuming process.I'm aware that some activity data can be exported via the Bulk API. I'm trying to figure out if exporting the 'Email Bounce' activity type would also include the bounce category. If so, where exactly can I find this information within the export file?Any guidance or tips on this would be greatly appreciated!Thanks,

Devesh · Accepted Answer

Hi @emilio_ped , You can refer the activity Id - 8 to download the email bounced details. Below are the details.

 {
            "id": 8,
            "name": "Email Bounced",
            "description": "Marketo Email is bounced for a lead",
            "primaryAttribute": {
                "name": "Mailing ID",
                "dataType": "integer"
            },
            "attributes": [
                {
                    "name": "Step ID",
                    "dataType": "integer"
                },
                {
                    "name": "Choice Number",
                    "dataType": "integer"
                },
                {
                    "name": "Category",
                    "dataType": "string"
                },
                {
                    "name": "Details",
                    "dataType": "string"
                },
                {
                    "name": "Subcategory",
                    "dataType": "string"
                },
                {
                    "name": "Email",
                    "dataType": "string"
                },
                {
                    "name": "Test Variant",
                    "dataType": "integer"
                },
                {
                    "name": "Campaign Run ID",
                    "dataType": "integer"
                },
                {
                    "name": "Has Predictive",
                    "dataType": "boolean"
                },
                {
                    "name": "Browser",
                    "dataType": "string"
                },
                {
                    "name": "Platform",
                    "dataType": "string"
                },
                {
                    "name": "Device",
                    "dataType": "string"
                },
                {
                    "name": "User Agent",
                    "dataType": "string"
                }
            ]
        },

Michael_Florin-2 · Answer

My team has created a bounce directory that populates a custom field with the latest bounce category number for each record.

Good idea. Everybody should have such a directory.

However, we've found that this value is missing for many records because the data has been archived.

What do you mean by that? The custom field that you populate in your Bounce Directory will hold its value forever. And the Bounce activity itself is maintained in Marketo for 25 months. Are you looking for even older entries? If so, you can't extract them via API anymore.

Within these 25 months you can still export specific bounce categories by using the Smart List Filter Constraint:

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded