"Is there a problem with GSC and Looker integration for others? I have noticed that when I use the "country" filter, it only shows data for approximately one month, regardless of the selected timeframe. Is there a solution to this issue? I am thinking about extracting raw data from the Cloud API, has anyone accomplished this successfully?"
It seems you’re encountering a common issue with Google Search Console (GSC) integration in Looker Data Studio, where the “country” filter only displays data for a limited period, regardless of the selected timeframe. This is a known limitation with the GSC connector, as it retrieves only the most recent month of data for specific dimensions like “country.”
While extracting raw data from the Cloud API could potentially offer a workaround, it requires a significant effort and technical expertise. The API provides access to detailed data but requires you to handle data processing, aggregation, and visualization independently.
A more practical solution might involve exploring alternative methods for visualizing country-specific data within the chosen timeframe. This could include:
- Using a different data source: Consider using alternative analytics platforms that offer a broader data retention period and provide robust filtering capabilities.
- Creating custom reports: Within Looker Data Studio, you might be able to create custom reports that combine data from GSC with other sources to achieve the desired country-specific insights across the chosen timeframe.
- Reaching out to Google Support: Contacting Google Search Console support for clarification on the limitation and potential workarounds could provide specific guidance and solutions tailored to your specific use case.