Facebook Ads Dashboard with Google Data Studio | Lesson 3
Вставка
- Опубліковано 8 сер 2017
- Facebook Dashboards can be easily built with Google Data Studio if you have prepared the data correctly. In this lesson we are going to visualize our data set and build our Dashboard complete with date control, filters and calculated fields.
You are going to learn how to calculate custom metrics, change their metrics name, layout your dashboard, build the visualizations required, build filter and date controls and make it all look pretty.
The template can be found at measureschool.com/facebookdas...
Previous video: bit.ly/2uoa4qA
#GoogleDataStudio
#FacebookAdsDashboard
#FacebookPixel
🔗 Links mentioned in the video:
Full Playlist: bit.ly/2hkwUx4
Google Data Studio: www.google.com/analytics/data...
Google Sheets: www.google.com/sheets/about/
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 - Наука та технологія
thanks for this comprehensive tutorial. I've followed exactly how you did it, but I got a different result, most probably the data I got was somewhat altered. still, I learned a lot. thanks again, Julian.
Hi Julian, thanks a lot for the tutorials which are very well presented and structured.
Thanks for taking the time to share all your awesome content man
Awesome lesson.
Thanks, Julien!
Wow, Julian, that was a great one! Thanks for sharing your knowhow.
Amazing video and amazing playlist! Thanks for share!
Thank You!!
Gracias Julian
Great tutorial Julian!
This looks fun! Thanks for sharing this; I must admit I don't use this tool but shall now!
Good job. Thanks for tutorial
Awesome!!! Great thanks
You're awesome! Thanks a lot for all the content
thank you so much
Amazing!!
Amazing video. I saw also other videos from you and I your are easy, clear and the video quality is top. thanks a lot
you are*
Hi Julian, Thanks very much for the demo it's very useful...I had a question on the facebook insights connector - how would I go about combining facebook insight data with GA metrics? I'm looking to join the data together somehow, but I cant find a relevant connection between the two. I'm wanting to combine GA bounce and goal metrics with the facebook insights info for certain posts. The 'post url' and 'post link' metrics (from the facebook connector) dont actually give the shared link to the website, otherwise I could match that with the landing page in GA.
Thank you
Hi Julian thanks for the course, it means a lot for me.
If you dont mind, I want to ask is it possible to add monthly target revenue to the dashboard? How can we do that?
Thankyou
Great Video - isn't CTR calculate Link Clicks / Impressions? seems you did it other way around.
Great I need this dashboard for seo
CTR = Clicks/Impressions but because you are using date ranges the function AVG() must be used for correct computations
Julian is it possible to allow a copy of this dashboard to be made? I can't get the dimensions right and it looks really wonky
What a great video. Thanks for the help. Do you have any suggestions on where to find and hire someone who can help build these types of reports?
We can certainly help with GDS dashboard or you can ask Julian :)
Amazing job Julian! Quick question: In this example you pulled data from Facebook Ads and GA. What if i want to pull more data from sources like AppsFlyer how can I do that? Thank you!
I'm not sure if Supermetrics has a connection to AppsFlyer - If not you could build it yourself in AppsScript or look for another tool that does that
2 Quick Questions... 1. Is it possible to include Audience data from both Facebook and Google? Specifically the list size of custom audiences in FB and G? 2. Is it possible to include Ad copy and/or Ad Images from F and G in data studio? Loving the videos!
1. please watch my previous video 2. No, I don't think that's currently possible.
To calculate the click through rate it is actually sum(clicks)/(sum(impressions))
good catch
my metrics doesnt show comarison date range, when i click on it, it just show None and Custom, in some of my dashboard it shows some , is there any date format issue? i applied dates as suggested by you GDS DATE YYYYMMDD and GDS Month YYYYMM ,please advise if possible why its not showing other options like Last Year , Quaters,Last Month etc
Love the tutorial, Julian! Is there any way you could share the Data Studio file as a template (not Google Sheets)?
Again, awesome job. :)
there is a link under in the description
Why can't I get any comparison data in Google Data Studio?
Hey Juliann, is there a way to display the "Pixel" count of a business' Facebook Pixel? And/or the Google Analytics count?
I'm trying to display in Google Data Studio, a running count of the number of Pixeled Users there are for a client account, is that possible??
there is not really a defined metric of pixeled users. I'm afraid you need to just take users instead
could u also share the Google Sheets u used for making the dashboards?
i do, in the previous video
Hy Julien Plz correct ROAS = Revenue/cost @4:53. If i am not wrong buddy :)
Awesome Work Man
how can I correct it? I can't change the video
@@MeasureSchool it's ok buddy 😊
but what are these data in the tables talking about?! could you please explain these data in shortly?
Request you to share the data file you used to create this Dashboard.
If I don't update the google sheet will it be updated in google studio ?
no, the data comes from google sheets
so how I can use it dynamically? without refreshing the google sheet? Is there any way?
Is it possible to automatically update the Google Sheets? With Zapier or something?
@@StephanPuffler Supermetrics has a configuration so it updates your Google Sheets hourly, daily, etc, he mentions it in his previous video.
CTR = Clicks/Impressions
thanks