​Create campaign export file

[former_member654580]

Hello experts

I am trying to create an export file of a campaign

Reviewing the documentation indicates that I should go to "To create interactions for the file export, you must define interaction types and channels in the Self-Service Configuration app Managing Interaction Content", but I cannot find that APP.

Is it by this means or how to create a download of a CSV file with information such as data from the campaign and the members of the target group that goes in that campaign?

I understand that an export definition must be built, is it the same as the target group? Where is that CSV file downloaded?

Best regards

Elio C.

[former_member226 · Accepted solution]

Hi,

There are multiple steps involved to create a CSV export campaign.

1. Create a new export definition for corresponding segmentation profile

export-definition.png.

export-definition-2.png

2. Go to segmentation and choose the same segmentation profile which was chosen against export definition in step 1. In my case, it is "All Contacts". Create a target group out of it.

3. Create a Blank/Email campaign based on the target group from step 2. Also, associate "Create Export File" action with it as shown along with other details like Filename and interaction etc.

campaign-flow.png

campaign-flow-2.png

campaign-flow-3.png

4. Finally, save and Start your campaign. Once finished you should be able to find the corresponding file in the export tab as shown. You can click the icon and download to your local machine.

final-export-file.png

[former_member226]

Hi,

Let me answers your questions point by point:
1. In case you are unable to see the export definition for another template, You need to make sure the target group associated with the campaign should have been derived from the same segmentation profile which was associated with the export definition.

2, 3. The export definition is just a CSV or table representation of what Segmentation application is already showing on UI. Hence it is a expected behaviour that when you pull Origin ID or Campaign ID then all the Origin ID and campaign are dumped in CSV.

In case you want to see a specific origin of the contact(SAP_C4C_BUPA) being only shown in CSV then you need to create a custom field, implement a BADI to copy desired facet value to a custom field, enable the custom fields to segmentation and include it in the export profile definition.

BR
Saurabh

[KunalBansal]

Hello eliocentenob,

You can find all the configuration in Manage Your Solution App.

Go to Manage Your Solution >> Configure Solution >> Marketing : Contacts & Profiles >> 7. Manage Interaction Contact.

Hope this was helpful. Thank you.

Best Regards,

Kunal Bansal

SAP Marketing Consultant

[andreina27_]

Hi everyone,

I have a question related to this process.

For the creation of download files in the Export Definition application, in my case the ID and Origin ID only of the SAP_CRM_BUPA type are required.

To bring me only those of SAP_CRM_BUPA, I filtered in the Segmenter by that Origin Id and create the Target Group that I later assigned to the download campaign.

The problem is that the download file that I created shows the fields of many of the empty IDS, By verifying the IDs of these Contacts exist in the system.

Why do you bring them empty? How can I get all the populated information to come?

Regards,

[former_member654580]

Hi saurabhkabra2009

Thanks for answering,

I found your proposal to create a new custom field to implement a BADI, in that BADI remove the data from SAP_C4C_BUPA from the ID field and put it in the new custom field.

That new custom field of course must be published in that desired profile and in the export definition.

So far I have it clear, what I do not know is, what BADI applies, how it is applied, is it a functional activity or should I request support from a developer.

Best regards

Elio C.

[former_member226]

HI,

Let me very clear that you will not remove the data from SAP_C4C_BUPA origin. You will just copy the value from SAP_C4C_BUPA to a custom field.

You can use any of the following BADI based on your use case.

badi.png

It is not much but it involves a little bit of ABAP coding.

[former_member654580]

Hola saurabhkabra2009

Following your steps I was able to do the process of downloading a campaign file.

The step of creating an Export Definitions.

fichero-para-campana.jpg

I had the opportunity to create a model to download target group.

However I have some doubts 1.- I see that inserting the export file action works only with email campaign, it had a template with an appointment action and it did not show the data and predefined.

fichero-para-campana-2.jpg

Photo fichero-para-campana-3.jpg

2.- I have a problem, well maybe it is normal in the system, but it brings me in the ID column all the IDs that the client has, and I just want to download one in particular, the ID related to the source SAP_C4C_BUPA .

Photo fichero-para-campana-4.jpg

fichero-para-campana-5.jpg

fichero-para-campana-6.jpg

3. The same case happens with campaign IDs, it shows a large number of campaign IDs, I thought it would show only the ID of the campaign that is being downloaded.

It is possible to download only the SAP_C4C_BUPA ID and the campaign ID from which the file is being downloaded.?

Photos

Best regards

Elio C.