Combine Data Sources in Google Data Studio | Lesson 2
Вставка
- Опубліковано 1 сер 2017
- In this lesson we're going to setup our data sources in Google Sheets with the help of Supermetrics. We're going to pull data from Facebook Ads and Google Analytics and prepare it to later be used in Google Data Studio.
Google Sheets combined with Supermetrics is a great way to control data that later goes into our data dashboards - it gives you the possibility to change data around, clean it up and even combine data sources (which is not possible in Google Data Studio itself).
Previous video: bit.ly/2f4FgZl
#GoogleDataStudio
#DataSources
#DataVizualisation
🔗 Links mentioned in the video:
Google Data Sheet: bit.ly/2tUX3EF
Full Playlist: bit.ly/2hkwUx4
Coding is for Losers: codingisforlosers.com/
Ben Collins: benlcollins.com/
The Dashboard Plan: measureschool.com/dashboardplan
Google Data Studio:bit.ly/2bcb7zt
Google Sheets: bit.ly/1GAUvK5
Supermetrics: bit.ly/2hmxvOR
🎓 Measure Masters Membership: measureschool.com/measure-mas...
❓ Take Our GA4 Quiz: measureschool.com/google-anal...
FREE Tag Manager Course: measureschool.com/products/fr...
FREE Analytics Course: measureschool.com/products/fr...
🔀 GTM Copy Paste - Our Chrome extension chrome.google.com/webstore/de...
🚀 Hire us: measureschool.com/services/?u...
📚 Recommended Measure Books: kit.co/Measureschool/recommen...
📷 Gear we used to produce this video: kit.co/Measureschool/measures...
📡 Our Live Streaming Software: restream.io/join/YXLM2
👍 FOLLOW US
Facebook: / measureschool
Twitter: / measureschool
LinkedIn: / measureschool - Наука та технологія
Fantastic Julian!!! Congratulations for your clear and objective classes!
Thank you Julian! Im a big fan of u after this video! :) keep it up man!
The dashboard plan link works, but the email you receive does not contain a link or an attachment.
thanks Julian - great video - keep it coming
Hi,site to pull current stock prices from India or source to pull stock prices from India?
Hey Julian! I've been loving your youtube channel and was curious if you are using a green screen for most of your backgrounds like the one in this video?
Hi Julian! my supermetrics is not giving me correct data, it always give to me zeroes in all the queries, with google API works well, what is happening? how can I fix it? thanks
is it possible to create custom calculated fields from two different data sources? E.G. Facebook_Ads_Metric/Google_Sheets_Metric
thanks,nice video Very practical
Julian, Great stuff! Any thoughts about how to match late conversions, which register in GA on a different date? That FB campaign could no longer exist, or have zero spend.. and we'll miss conversions.
Thanks in advance!
How is this different using the data blend?
Thanks Julian, any luck to merge 2 different GDS in single dashboard
The video was great !! Congratulations!!
A query: when I perform all the steps to extract the data, when I click on the supermetrics button "Get data to table", I get a message: "Error, Query failed: Your query returned no data",
Why is this happening??
Julian, I appreciate your videos very much. Thank you for taking the time to train us on these processes! I have a question for you. I set up a tab to contain aggregated data so that I can pull it into the Google Data Studio. I have the SuperMetrics tabs scheduled to update on a daily basis. Those work fine but how can I get the query function to update on a daily basis? I'm specifically talking about the query you ran at 19:50 in the video with the asterisk to get all the data. Is there a way to run that query on a daily basis so that the aggregated tab has all the new data?
that's interesting. I haven't taken that into account. Thanks for pointing it out.
Maybe try the following: Go to File > Spreadsheet Settings and change the Calculation fields to update more frequently.
If that doesn't work the only other thing I could think about it using AppScript with a timer trigger. But that would be more complicated to setup.
Measureschool I ended up using the trusty vlookup instead to match up the dates on the aggregated tab and that seems to be working just fine. I just pulled the formulas all the way down to the bottom of my sheet to allow variations in the number of days per month.
The query function never updates, am I correct? It appears to be a one-time search whereas a formula/function always updates when the corresponding cells change.
Great vid! Question, in order to match the rows in FB+GA, the campaign names (etc) needs to match. How do you make sure to always keep the FB campaign names equivalent to GA? do you use the as campaign name in FB?
Cheers
yes, correct
manually input headers and have datastudio pull into row 2 with setting 'no header row' (protip: double check you have the column sorting set so that they don't become rearranged when data is updated)
Is there a way to find out the meaning of all the different metrics? For example, at 11:16, you see 6 different "click" metrics... how can I find out the difference between these and other metrics that appear to be so similar?
it depends on your traffic source. So you would need to go to Fb Analytics directly and look up the different metrics and their meaning.
' I followed all steps but the website i'm trying to get the data from isn't E-commerce therefore "Transaction" etc are not working for me, any suggestions for a different other than "session" I can use?
if you have goals configured you could use those instead
Now that there is a Facebook connector on Data Studio, would you still use google sheets first?
there is some stuff you can do with that connector, but if you have different sources you want to combine, you can still only do this outside (sheets) of GDS
@@MeasureSchool Hey Julian! thanks for all the content. If you only have one source you want to evaluate, FB, would you just use the connector or would you still use Google Sheets with Supermetrics?
Hi Julian, how did you solve this problem in 20:11 with #REF!? I cant figure out how to do it :(
are you familiar with the query function?
Hi Julian, really appreciate your sharing. But I have the same question too with #REF in the query and I'm not familiar with it. Could you kindly tell how to solve it? Thank you so much! =)
Hi Julian, thanks for the video (this and many others). I wanted to combine Facebook Data with GA in Data Studio in a different way. Could you tell me if it's correct?
1- Download Facebook Data with Supermetrics (Date-Campaign-Ad Set-Ad Name).
2- Upload Facebook Data in Google Sheets to Data Studio
3- Connect Data Studio with GA
4- Edit Dimension names of Facebook Data Source in Data Studio (Change 'Ad Set' to Ad 'Content' and 'Ad Name' to 'Keyword')
5- Create 'Source / Medium' Dimension in Facebook Ads Data Source in Data Studio (Source / Medium = Facebook / cpc)
6- Use Blended Data in Data Studio using as Join Keys the Dimensions mentioned previously
7- Add to the Blended Data metrics of GA such as Transactions, Sessions & Revenue
8- Add to the Blended Data metrics of Facebook Ads such as Cost, Impressions, Link Clicks
Thanks Julian. Nice tutorial but I found Supermetrics very expensive.US$50/month is too much for personal use. They need a tier for non agency business. Do you know another platform to pull data from GA and FB?
We manually export from Facebook into Google Sheets once per month at our company.
@@Getfoundmadison , does it mean you are not using any add-on at all?
Thank.😊😊
Hi Julian! As always, great video:) I have one question. You are using Supermetrics to create a feed. This is not a free tool, and, after the trial, it's rather expensive. Can you recommend another way of creating the feed in Google Sheets (that might require a little more work, but still be relatively easy)?
Simple data export from Facebook Ads doesn't seem easy to format. Maybe you have an idea? Thank you:)
Thinking the same thing here. Would love to hear what other options are available.
Facebook has their own Excel tool for pulling data (FAME). It's not as user friendly as Supermetrics, but this is at least free for pulling data from Facebook Ads manager :: facebook.com/business/news/facebook-ads-manager-for-excel.
anyone have a FREE alternative to Super Metrics for importing Facebook data into Sheets?
I found www.digishuffle.com.. it's not free but much cheaper. The only problem is that I can't find the metric "amount spent"... so maybe sb has an another solution.
blockspring is the cheapest, Zapier also an option, Supermetrics most expensive but for a reason. :) to me knowledge there is no free solution. Best
Hi Julian,
I have a question. Can you suggest or tell me how to add multiple data sources to a single chart in data studio? I am aware of blended data but there the limitation is upto 5, and i have more than that.
Kindly let me know if there are any workarounds.
Regards,
Sujit
you could combine them ouside of GDS, like in Sheets or Big Query, then use it as a single data source
Can i use this with Facebook Pixel
yes
Hi Julian, the information you gave to your 17: 06s from your video does not work. We are having serious issues with a customer because we need to bring real data from within the Google Analytics API (after all, it's actual sales data, properly collected by the platform, not sampled) and he insists on bringing false data when we run the queries In Supermetrics, even if we use this "try to avoid" functionality.
After two weeks of waiting after proving that the data was not coming correctly the Supermetrics staff washed their hands indicating that they could do nothing and asked us to complain to Google, which in turn does not support Google Analytics (wich is free), only to Analytics 360.
Frustrating.
I don't speak for Supermetrics or Google, so I can't comment on it working or not. That's something you need to try out with the data set that you are working with - I merely try to teach the information, which I still think is valid.
Off course Julian, I did not imagine that you were passing on wrong information, either intentionally or not. I just wanted to add to the subject so that other people who can try to be alert about this problem that until now has no solution.
Keep up the wonderful work, I am one of your most devoted followers.
Best regards
Junior
Hi, maybe try to use the official Analytics plugin to google sheet: developers.google.com/analytics/solutions/google-analytics-spreadsheet-add-on