AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
2K members online now
2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Query Error when using date field in Date Range Dimension or Filter (PostgreSQL)

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Using "Date Range Dimension" when you select a field type "date" to the server comes SQL-query without condition "WHERE" and Data Studio throws an error "There`s a query error.", because the result is too large and Data Studio crash.

Query like this one:

2017-04-03 11:31:46 UTC [7965-2] agency_103@agency_103 STATEMENT: SELECT SUM(conv) AS _conv_, SUM(imps) AS _imps_, account_id, date, keyword_name FROM keywords_raw_table_adwords AS t0 GROUP BY account_id,

date, keyword_name ORDER BY _imps_ DESC

Also condition "WHERE" won't be added if use additional filters as e.g. account_id. 

Instruction step-by-step: https://docs.google.com/document/d/1Brg0N0SShzGOuB4zmN8VFTwqbTnDtfQtSkGE_AnBzws/edit?usp=sharing

Video: https://monosnap.com/file/9NKt8iJDAe4qTS4rgpYwTlcDTeZCna