Hi All,
I created a Looker Studio dashboard to compare our website's Query and Page performances for different time periods within the same table (Clicks, Impressions and Position) by blending data from GSC sources (URL and query sources).
All worked well until Saturday afternoon (India time). After this the comparison table in the dashboard started showing wrong (huge) numbers for ranks , impressions and clicks.
Later today (Sunday afternoon), entire data in the table disappeared and showing "no data".
I rechecked all by custom fields, blends and reconnected the data sources and even refreshed the dashboard.
I am unable to solve this issue.
Please help!
Thank you.No data is being shown the dashboard
Solved! Go to Solution.
I think I understood the reasons for the issues I faced earlier:
The table was not showing any data because of the date range I use in one of the database tables in the blended data source: "This week". There was no data from the GSC to work with for the current week (A week starting on a Sunday)
Earlier the dashboard was showing wrong (inflated) numbers in the table because an extra dimension (Country) I added to a table in the blended data source in addition to the only "Query" field that joins with other tables.
I think I understood the reasons for the issues I faced earlier:
The table was not showing any data because of the date range I use in one of the database tables in the blended data source: "This week". There was no data from the GSC to work with for the current week (A week starting on a Sunday)
Earlier the dashboard was showing wrong (inflated) numbers in the table because an extra dimension (Country) I added to a table in the blended data source in addition to the only "Query" field that joins with other tables.
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 |