How to Dynamically Blend Google Sheets and Google Search Console Data Based on Date Ranges?

[mhdrahbar]

Hi,
I'm working on a data blending scenario in Looker Studio that combines Google Sheets and Google Search Console data. However, I've encountered a problem and would appreciate your help.

Here's the situation:
I want to display the total clicks for a specific group of URLs in a Looker Studio report. The URLs are listed in a Google Sheet, along with "start date" and "end date" columns. Instead of using the default date range selection in Looker Studio, I need the clicks for each URL to reflect the date ranges specified in the Google Sheet.

Essentially, I want a dynamic report where changes to the date ranges in the Google Sheet automatically update the clicks data from Google Search Console in Looker Studio.

However, I haven't been able to find a way to link Google Search Console to the date ranges defined in the Google Sheet. Does anyone have a solution for this?

Thanks in advance!

[kosiorro]

It seems to me that there is no way to import dates as a range, but perhaps one of the following options will be helpful for you:

Essentially, you want to use Google Sheets as variables here. You can try to divide the data from Google Search Console into groups based on data through calculated fields, for example:

If the date is greater than the field, then the group - display If the date is less than the field, then the group - do not display

However, this will not be a rigid date filter, but a group filter.

You can also add a field that will be updated based on the date and completely change additional calculated fields, which will be the date.

Or tell me what you exacly want to do, maybe we find a solution 🙂

[mhdrahbar]

Thanks for the tip! For now, I managed to solve it by using a script and a few formulas in Google Sheets to calculate the dates between the start and end for each URL. Then I blended that data with Search Console data in Looker Studio. Now, whenever I update the data in Google Sheets, my dashboard updates automatically too.

[ArkadyZagdan]

You can achieve that by feeding data from BigQuery and custom SQL connection with date as parameter.

[mhdrahbar]

Yeah, that idea was the best solution, but I just wanted to stick with Google Sheets since I haven’t worked with BigQuery yet.