Data Studio Dashboard: Facebook Ads + Adwords (via Supermetrics)

Excerpted from the CIFL course, Data Studio the Lazy Way.
One of the main shortcomings of Google Data Studio is it's limited set of data sources (Google Analytics, Adwords, Search Console, UA-cam, etc).
This Google Sheets template allows you to get around that limitation, using Supermetrics and Google Sheets as a middleman, and connect Facebook Ads and Adwords to Google Data Studio.
Grab your copy from the CIFL Sheets Template Vault, which also contains a discount on the Data Studio course mentioned above:
trello.com/c/81e4nhsP/12-fb-a...

[@skdmedia9866]

Where could I find support on how to get started using the Facebook Ad connector from Supermetrics? Is there anyway to choose a custom conversion in the metric section?

[@fahimedits3]

Supermetricks isn;'t Free anymore any alternative?

[@RemiTurcotte]

How do you manage date ranges changing in Datastudio (vs what is pulled in Google Sheets by Supermetrics)

[@RemiTurcotte]

Coding is for Losers I mean you can't use the period selection module on datastudio.. correct?

[@Coachjaywilliams]

Hi Thanks for the video, I have an issues with the aggregated data tab. It doesn't have anything in it. Do you also know what we need to put in the campaigns tab?

[@NavigatorSAP]

You need to fill out the 'Campaign Setup' tab. That's what worked for me. You can copy the names of the campaigns and sources from the Google Analytics, facebook, and Adwords tabs after you've ran the query once.

[@AdamLundquist]

Can you please make a video of how you did that? Like did you hand copy it?

[@dontekillion7612]

Hey there... Thanks for sharing this video. I am not sure if your still need any Facebook ads advice/help, but I own a social media marketing agency and I need a dasboard to track everything... Pull data from Facebook ads, Google sheets and zapier. I would be more than happy to trade knowledge if you can help?

[@opteriananalytics]

Hi David, did you find a way to make the date diff work in tables ?

[@JakobManagerUnited]

Word fine except it’s so hard to add another data source (bing ads). Does anyone know where i can get help on the queries for the aggregated data?

[@cacheworthy]

Hey Keith and Tyrion, feel free to drop a note to [e-mail] if you're looking for specifics on this

[@GrantRTanner]

Thank you! This could be super powerful. Could this monitor ad spend for budget monitoring?

[@willem1777]

Have you found the answer to this question?

[@ryanjosephlock]

Yes

[@supernetmarketing1]

great

[@francestuble1304]

Hi, could you also send me a step by step instructions on how to populate the Campaign Setup tab and Aggregated Data, please? Thanks!

[@gregjohns4563]

did you ever figure it out

[@jackpallett]

Hi Frances, I am having the same issue as you. Did you manage to solve this?