Analytics
5.6K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
 
Guide Me
star_border
Reply

Calculated fields from different data source.

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I am currently working on a project, where for some analysis I need to combine data from different advertising sources such as Google Analytics, Facebook Ads, Google Ad words, Bing Ads and CRM into a single data set. 

I have integrated all these sources into a single ware house but struggling to extract important information from all these sources and combine all of it in a single data set.

Is there any standard procedure or tool that can help me to do this ?

 

Thanks.

1 Expert replyverified_user

Calculated fields from different data source.

Rising Star
# 2
Rising Star

Hi Sahil,

 

There are several platforms you could use for the analysis: OLAP Cubes, PowerBI, Tableau, Google Data Studio.. Each of them have their own strengths and connectors and each will require you to do some ETL to get some of the data ready.  That said, you also need something to connect your CRM data to GA.  Here is a reference for that:

https://developers.google.com/analytics/solutions/crm-integration

 

Lastly, GA can accept data from these sources: Facebook Ads, Google AdWords, Bing Ads.  AdWords is a native connection via linking in the property settings and the others are via cost data import.

 

https://support.google.com/analytics/answer/2803329?hl=en

 

Best,

 

Theo Bennett

Analytics Evangelist at MoreVisibility | Contact Me
Connect on LinkedIn