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

[@tkdm2415]

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

[@houssemmhawek4540]

hii good work

[@tuetau]

Great work

[@johnramadhan3016]

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

[@denisehernandez7]

Thank you!

[@andrzejandrzejos6674]

Thx for your content

[@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?

[@DiegoMendozaPerez-ym5ns]

Great Content