Analytics data transfer to Adobe Campaign

[RinaPatel]

Hi 

I want to export analytics data to Adobe campaign. I would like to send an automated data extract file to Adobe campaign every hour.

I only want to extract 2 prop variables, date/timestamp and Marketing cloud id.

What is the best solution to do this with Analytics to Campaign?

Is data feeds/data warehouse the best solution with ftp or can i also set this up using an API?

Thanks 

[florentlb · Accepted solution]

Hi,

Considering your use case, using data warehouse with FTP to extract your data would be the easier solution.

In Adobe Campaign you can set up workflows that would check every hour the files present on the FTP server and import and process the data.

You can find more details about workflows in the detailed documentation.

Hope this helps,

Florent

[RinaPatel]

Thank you for confirming solution - this was very helpful.

I have one more question. I have a AEM form and on submit, the form fields and a unique id is sent to campaign. But I would also want to capture the unique id in analytics. Can I just use the Marketing cloud id to do this, or would i also need an unique id to match the analytics behavioural data with the crm data?

[florentlb]

Hello,

Do you mean that you want the unique id from the AEM form to be sent to Analytics when the form is submitted? I'm not sure this is natively supported with Campaign forms edited in AEM. I'd suggest to open a dedicated thread in the AEM forum as they would surely know if there is a way to exchange data between AEM and Analytics.

Florent

[RinaPatel]

Hey Florian,

Yes so when i submit a AEM form, the fields + a unique id is sent to campaign. In addition that unique id is passed to analytics in an evar for example. 

I just wanted to check if there was another way to do this or if the marketing cloud id could be used to match data from analytics to the data captured in campaign.

[florentlb]

Hi,

You can share segments/audiences between these solutions by using People core service or Audience Manager. What it does is that visitor Id or declared Ids can be reconciled with profiles from Campaign database. I'm not sure that this would be an easy way to serve your use case but you can have a look at this document to check whether it could be useful to you or not.

Florent.