How to Build a Facebook Ads Report Dashboard with Google Sheets in 10 Steps (QUERY FORMULA)

Purchase template here: www.etsy.com/l...
Automate Facebook Ads data to Google Sheets: supermetrics.c...
Book a consultation: clarity.fm/hus...
Video Chapters:
0:28 Dashboard Features
2:35 Data Source
3:45 Choosing Metrics
5:38 Export Data from FB
6:25 Paste Data to Sheets
7:55 Format Google Sheet
8:40 Add Helper Column
11:40 QUERY Formula
14:50 Calculated Metrics
21:34 Format Tables
23:49 Re-Labeling Headers
28:24 Sparkline Graphs
31:50 Adding Charts
34:37 Color Scale
36:00 Top Campaigns
39:20 Campaign Filter
42:00 Date Filter
Build a Facebook Ads reporting dashboard inside Google Sheets using the QUERY formula.

[@denisehernandez7]

Thank you!

[@tkdm2415]

I want to do monthly and weekly reporting sheets, do I need put the data manually each time or will it does automatically?

[@DiegoMendozaPerez-ym5ns]

Great Content

[@andrzejandrzejos6674]

Thx for your content

[@johnramadhan3016]

is it possible to move the dashboard from spreadsheet into tableau?

[@houssemmhawek4540]

hii good work

[@ttth225]

Hi, totally unrelated, but what course did you take ?

[@hustlesheets]

Hi, course for what?

[@michaelphilips6154]

How to automate it automatically?

[@hustlesheets]

supermetrics.com/?idev_id=2372

[@ConorGordon-ec6el]

I'm getting #VALUE! when trying to pull the months column

[@hustlesheets]

What else does the error message say? (when you highlight over it?)

[@ConorGordon-ec6el]

@@hustlesheets It's saying "Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC"

[@hustlesheets]

@@ConorGordon-ec6el it's because you the columns you are trying to avg( ) or sum( ) aren't numbers.
Go back to your data source, and check those columns - there is either a text/letter somewhere in those columns, or any empty space etc that is causing it to error our when trying to apply an average or sum
if you delete those entire columns (the ones in your average or sum, and re-input a number in the first non-header row, it will work

[@ConorGordon-ec6el]

@@hustlesheets That worked great and it's NEARLY worked for me! But I'm having the same issues you had with creating a start date / end date filter. I use the exact same formula as you in the same cells and yet I'm seeing:
"Unable to parse string query parameter 2: Invalid date literal [Start Date]. Date literals should be of form yyyy-MM-dd.

[@j_m_h00]

I'm having the same problem...did someone find where the problem is?

[@ontisalvacarm6146]

I'm Single 😍😥

[@tuetau]

Great work