Facebook Ads Manager Data Integration into Adobe Analytics

Avatar

Avatar

mandyw65

Avatar

mandyw65

mandyw65

15-09-2017

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Gigazelle

Employee

Total Posts

1.9K

Likes

459

Correct Answer

734

Avatar

Gigazelle

Employee

Total Posts

1.9K

Likes

459

Correct Answer

734
Gigazelle
Employee

14-02-2018

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.

Answers (9)

Answers (9)

Avatar

Avatar

Roman_Gazarek

Avatar

Roman_Gazarek

Roman_Gazarek

17-06-2019

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

Avatar

Roman_Gazarek

Avatar

Roman_Gazarek

Roman_Gazarek

22-05-2019

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

Avatar

jessesingh

Avatar

jessesingh

jessesingh

27-11-2019

Hi Roman,

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

Avatar

Avatar

juanp51467129

Avatar

juanp51467129

juanp51467129

13-11-2019

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

Avatar

alv123456

Avatar

alv123456

alv123456

17-06-2019

looking forward, pls post the link here once published!

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250
ursboller
MVP

14-06-2019

would be interested as well

Avatar

Avatar

alv123456

Avatar

alv123456

alv123456

14-06-2019

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

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250
ursboller
MVP

09-11-2019

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

Avatar

Avatar

juanp51467129

Avatar

juanp51467129

juanp51467129

08-11-2019

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.