AC OOTB Report from 3rd Party Performance data | Community
Skip to main content
S
sidheshwarc5116
Level 3
July 22, 2017
Solved

AC OOTB Report from 3rd Party Performance data

  • July 22, 2017
  • 4 replies
  • 3561 views

I am doing segmentations in Adobe Campaign but the actual campaign is being sent out of another system (EPSILON). I want to leverage the performance data like open, click, channel etc. information from the other campaign system (EPSILON) to generate OOTB URL Clickstream reports out of Adobe Campaign.

Theoretically, what I understand is if I use the Direct Mail component to generate my segment lists to push to other system for targeting it will automatically generate respective keys in the Broadlog table but how do I map the tracking logs from other campaign system to generate the OOTB URL Clickstream reports.

Any help would be highly appreciated.

Sid

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Amit_Kumar

Hi,

Screen shot from the schema for reference.

The Bare minimum is just the primary key, but that's not meaningful.

You need to ensure that you can populate as much information as you can so that reporting can work because you are not building tracking logs here, so you need to get, address, status, recipient Id, msg id and delivery id. after that you need to import tracking logs so that tracking reports can work. you will be building a workflow to import and create all these fields and relationships.

Regards,

Amit

4 replies

Amit_Kumar
Amit_Kumar
Level 10
July 24, 2017

Hi Sid,

first of all, you are paying twice for every mail send because Adobe campaign count every broadlog entry as communication send. So your strategy is not recommended or following best practices.

Second, to solve this you have to add another column i.e contact date,  in the export file and store in EPSILON, pull the broadlog from EPISON into Adobe CAMPAIGN and use your email id and contact date to reconcile the data.

Regards,

Amit

S
sidheshwarc5116Author
Level 3
July 24, 2017

Thanks Amit for your quick response.

Sorry if my question is silly. I will be doing this for the first time.

Do you know by any chance what is the bare minimum information required in the Delivery Log Table (Broadlog) for reports to generate based on the tracking info from tracking logs.

Amit_Kumar
Amit_KumarAccepted solution
Level 10
July 25, 2017

Hi,

Screen shot from the schema for reference.

The Bare minimum is just the primary key, but that's not meaningful.

You need to ensure that you can populate as much information as you can so that reporting can work because you are not building tracking logs here, so you need to get, address, status, recipient Id, msg id and delivery id. after that you need to import tracking logs so that tracking reports can work. you will be building a workflow to import and create all these fields and relationships.

Regards,

Amit

L
lee_cav
Level 2
October 2, 2018

Hi Amit,

Where is this count tracked? I am trying to easily find a place in the platform where the tool counts the number of Ids produced, so that we do not run out of broadLog Ids.

Thanks,

Lee

Terms & ConditionsAccessibility statement

Loading footer...