I have exported Activity data to BigQuery via Marketo's Bulk Extract API. However, the SFDC Sync Error activity is not exported to BigQuery data, even though it is displayed in the Marketo UI.
Do you know how to define which activities can be extracted by BulkExport and which cannot?
Also, how can we visualize the number of leads that are not synchronized to SFDC?
...the SFDC Sync Error activity is not exported to BigQuery data, even though it is displayed in the Marketo UI.
Do you know how to define which activities can be extracted by BulkExport and which cannot?
Well, you can’t define the activities. The Describe Activities endpoints tells you which are available, but those are hard-coded restrictions.
There are numerous activities that appear in the Activity Log and can be filtered in Smart Lists, but aren’t accessible via API. There even are some examples of the reverse: Merge Lead, for example, can be retrieved via API and used in custom operations, but can’t be used in a Smart List.
Also, how can we visualize the number of leads that are not synchronized to SFDC?
If someone has an SFDC ID value in Marketo, you can consider them to have successfully synced at some point to SFDC. (Note that doesn’t mean they’re currently syncing without errors, it just means they synced in the past.)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.