You work for a marketing organization and business analysts in your organization want to export all Marketo lead activities. You want to review the lead activities in an analytics tool.
Configure a
mapping
task to use the insert operation. You use the following objects in the Marketo mapping:
Source object
The source object for a
mapping
task is a Marketo LeadActivity. Use the Marketo connection to connect to Marketo and read data from Marketo. The LeadActivity object is a single source in the
mapping
task.
Specify the ActivityType IDs of interest. For example,
12,13
. The ActivityType IDs may differ by Marketo subscription. Specify the Since Date Time in the advanced source properties of the
mapping
task.
Target object
Use the .csv file as the target object in the
mapping
task. The target in a
mapping
task is a flat file. The target includes the
activityId
,
activityDate
,
activityTypeId
,
primaryAttributeValueId
,
primaryAttributeValue
,
attributeName
,
attributeValue
, and
id
fields.
Mapping
Map the fields of the Marketo LeadActivity source to the flat file target.
The following image shows the Marketo mapping:
The following image shows the mapped fields of Marketo source with the flat file target object:
When you run the mapping, the Secure Agent writes the lead activities to the flat file based on the fields you mapped in the