Merging data from two different sources
I was wondering if there is a way to merge data from two different data sources. There are two different instances and variations where I want to do this.
1. I would like to pull my spend, clicks, CTR columns from Facebook but I want to use the conversion data for these campaigns as reported through Google Analytics. (GA matches my client's actual data better.)
2. I would like to combine some charts to include both bing and google data so I get a table/chart showing total search engine data, such as spend, clicks,etc.
Are either of these possible?
Thanks so much!