Facebook Ads Manager Data Integration into Adobe Analytics

[mandyw65]

Hi,

I am looking to integrate Facebook Ads Manager data into Adobe Analytics as I want the campaign and ads sets data (cost, clicks, impressions) etc.

Is there a way to do this? My thought is Adobe analytics will ingest data given to it from Facebook on a regular basis (daily?) from a FTP file is that's possible?

Please let me know if that is possible and any solutions that would work...

Many thanks

[Gigazelle · Accepted solution]

You would want to use Data Sources.​ It allows you to upload any data that you'd obtain from Facebook ads manager. It has the capability to regularly pull data via FTP.

[Roman_Gazarek]

I use Facebook Insights API to pull data from Facebook Ads Manager so I can import it into Adobe Analytics every night (automated job). It's very simple application you can write in Java, Python or any other common language. I use Java + Facebook SDK for Java + FTP upload to Adobe servers using some Java library.

SAINT classifications structure:

• Account Name
• Campaign Name
• Adset Name
• Ad name
• .. it's possible to add some more

Data sources (numeric success events):

• Impressions
• Clicks
• Cost

You just need to adjust landing page URL in all running ads. URL macro {{ad.id}} does the trick so you can match these uploads with your tracking code eVar and website behavior  

[amendez92]

Hello @Roman_Gazarek ,

Can you share with us how you develop this option? Do you have any documentation?

Can you assign Cost of the FB Ads for each day or you assign this cost  for each campaign id?

Thanks

[alv123456]

Hi Roman, that sounds interesting. Is it open source? Do you mind sharing it?

[Urs_Boller]

would be interested as well

[Roman_Gazarek]

Yes, I want to make a blog post about it. Example code in Java will be published on Github in coming weeks. I will let you know

[alv123456]

looking forward, pls post the link here once published!

[juanp51467129]

Hi mandyw65

We tried to bring it all into Adobe but it got messy for our clients and our account managers. Instead, we now use a third-party tool that basically combines our Ads Manager accounts (Facebook, Instagram, Adwords,etc...) with our Adobe Analytics data through their own analytics offerings to help us determine our best performing campaigns. You will need to ensure two things so that you can view your data correctly:

1. If you want to be able to map out your data so that you can essentially sort out which Ad performed by KPIs (ie shares/ad, comments/ad, ad spend, entrances, bounce rate, revenue, ROI), you will need to follow a standardized process for your link building. For example, your Campaign UTM link name will have to match how you named your campaign in Facebook. If they're different, your data won't match up.

2. You will need to set up your classification rules/classifications in Adobe to track your campaign URLs correctly. Otherwise, you won't be able to sort your data.

I'd be happy to share more about our experience with this tool. So far, it's been great for us and has helped us with FB optimization, increased transparency with our clients, and reduced waste for our entire team.

[jasminsehic]

@juanp51467129 could you please share your experience with this tool and the name as well if it worked well for you?

[jasminsehic]

...

[txtx_777]

can you please share the experience as of today?

also please share your inputs if possible on priyeshdatascience@gmail.com

[Urs_Boller]

@ Roman: do you already have a blog how you did the export/import?

[juanp51467129]

I also found a pretty good article on how to combine your Facebook KPIs with your Adobe Analytics data. They showcase the data example through another tool that pulls the data together and compares it to their platform benchmarks but hopefully it can give you an idea of how some marketers can view their Facebook data (likes/comments/shares/relevance/ctr) with the Adobe Analytics data (entrances/bounce rate/goals/engagement rate) at a high level (see a copy of their screenshot). Hope this helps!

[jessesingh]

Hi Roman,

Do you have your post about setting this one from Facebook Business Manager to Adobe?

[jasminsehic]

@juanp51467129 could you please share your experience with this tool and the name as well if it worked well for you?