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
5.3K members online now
5.3K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Query error issue

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

Open https://datastudio.google.com/open/0BxlJphQEIHquNDNFQzBmTzROYnM, list Adwords Keyword Perfomance.

  1. It shows loading indicator and then an error: Configuration error. 839ee597
  2. Click on. It shows the message
"Error Details

There`s a query error.

Error ID: 839ee597

 
Errors logged by Postgres:
2017-03-13 14:45:09 UTC [3903-1] datastudio@report_loader LOG: could not send data to client: Broken pipe
2017-03-13 14:45:09 UTC [3903-2] datastudio@report_loader STATEMENT: SELECT SUM(clicks) AS _clicks_, SUM(conv) AS _conv_, SUM(imps) AS _imps_, SUM(spend) AS _spend_, account_id, date, keyword_name FROM keywords_103_adwords AS t0 GROUP BY account_id, date, keyword_name ORDER BY _conv_ DESC
2017-03-13 14:45:09 UTC [3903-3] datastudio@report_loader FATAL: connection to client lost
2017-03-13 14:45:09 UTC [3903-4] datastudio@report_loader STATEMENT: SELECT SUM(clicks) AS _clicks_, SUM(conv) AS _conv_, SUM(imps) AS _imps_, SUM(spend) AS _spend_, account_id, date, keyword_name FROM keywords_103_adwords AS t0 GROUP BY account_id, date, keyword_name ORDER BY _conv_ DESC
 
Number of elements the query returns:
report_loader=# select count(*) from (SELECT SUM(clicks) AS _clicks_, SUM(conv) AS _conv_, SUM(imps) AS _imps_, SUM(spend) AS _spend_, account_id, date, keyword_name FROM keywords_103_adwords AS t0 GROUP BY account_id, date, keyword_name ORDER BY _conv_ DESC) as t;
count
---------
5085429
(1 row)
Time: 122411,121 ms
 
Number of elements the same query with WHERE conditions returns:
report_loader=# SELECT COUNT(*) FROM (SELECT SUM(clicks) AS _clicks_, SUM(conv) AS _conv_, SUM(imps) AS _imps_, SUM(spend) AS _spend_, account_id, date, keyword_name FROM keywords_103_adwords AS t0 WHERE "date" BETWEEN '2017-02-01' AND '2017-02-14' AND account_id='4604598940' GROUP BY account_id, date, keyword_name ORDER BY _conv_ DESC) AS t;
count
-------
15014
(1 row)
Time: 68,022 ms
 
 
Structure of the table:
keywords_103_adwords_table.png
 
The database table "keywords_103_adwords" contains data from 2016-10-01 to 2017-03-14. Requested account_id is 4604598940 and date interval is from 2017-02-01 to 2017-02-14.
DB server is hosted at AWS us-east-1 region. PostgreSQL version 9.5.4.
 
- Please tell what does error with this identifier mean?
- Why Datastudio executes this query? Notice that the report has "date" range and "account_id" filter specified but the query has no WHERE clause with any filter.
- It seems that Datastudio fetches all table data grouped by [account_id, date and keyword_name] and then filters received resultset by date and account_id client-side. Am i right? Possible some limits were exceeded by this query (timeout or resultset size)? What should we do here?

 

Thank you!