-
1. Re: External Activities Upload list automation
Devon Guerrero Nov 27, 2018 12:23 AM (in response to Simiha)You could create a script that runs on a schedule, ingests a csv, converts it to json, and uploads it to the correct activity import definition, using the bulk api. You could then upload that list through the rest api and create a contact list.
-
2. Re: External Activities Upload list automation
thangarajduraisamy Nov 27, 2018 2:15 AM (in response to Simiha)Hi Simiha,
Below approach does not require an API
You can use Data Import and Export option.
Step1: Configure the file path from SFTP server and schedule the import on the recurring basis. (You can flag the contacts with Y/N value in separate field to identify in eloqua contact database. Create & Map to the contact field called "External Activity record")
Step2: Install the cloud app "External Activity"
https://cloud.oracle.com/marketplace/app/AppExternalActivity
Step3:
Create a segment to fetch the records those who have "External Activity record=Y'.
Step4:
Create a campaign canvas - > Add the segment + External Activity App -> Configure the app step
Step5:
Schedule the campaign and activate.
Thanks
Thangaraj.
-
3. Re: External Activities Upload list automation
Devon Guerrero Nov 27, 2018 4:48 AM (in response to thangarajduraisamy)If this is on a campaign, then a contact can only run through it once. What if a contact is a member of multiple external activities? This app doesn't run in the program canvas.
Also, where do you map the campaign ID, external activity, asset date, asset name, and asset type fields? You would need to configure that in the app and create a new segment and campaign for each possibility. The asset type, activity, and name are static within the app configuration on the canvas.
-
4. Re: External Activities Upload list automation
thangarajduraisamy Dec 3, 2018 1:46 AM (in response to Devon Guerrero)Hi Devon,
In the multiple occurrence case, Segment can be configured and route the contacts from the Program canvas to the campaign canvas. (Allow contacts to enter multiple times)
Yes, i agree. The app needs to be configured with the necessary external activity details. Configure the app based on the segment setup. More than 3 app step needs to configured based on the number of external activity type.
-
5. Re: External Activities Upload list automation
Simiha Dec 6, 2018 12:38 AM (in response to thangarajduraisamy)Thank you both. I do have 2 concerns when we do this, 1. How can we track if there is an issue 2. How can do deduplicate meaning, same member could be in 3 different external activities at the same list upload?