Solved

Facebook Ads Manager Data Integration into Adobe Analytics

Forum|Forum|8 years ago
September 15, 2017
11 replies
19674 views

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

Analytics

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 Gigazelle

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.

Gigazelle

Accepted solution

Adobe Employee

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

A

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

A

alv123456

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

Urs_Boller

Community Advisor

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

A

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.

J

jasminsehic

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

Urs_Boller

Community Advisor

@ 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!