Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!
SOLVED

Facebook Ads Manager Data Integration into Adobe Analytics

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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.

View solution in original post

15 Replies

Avatar

Correct answer by
Employee Advisor

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.

Avatar

Level 4

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  

Avatar

Level 2

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

Avatar

Level 6

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

Avatar

Level 4

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

Avatar

Level 6

looking forward, pls post the link here once published!

Avatar

Level 2

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.

Avatar

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

Avatar

Level 1

can you please share the experience as of today?

 

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

 

Avatar

Community Advisor

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

Avatar

Level 2

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!

Screen Shot 2019-11-13 at 10.28.45 AM.png

Avatar

Level 1

Hi Roman,

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

Avatar

Level 1

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