Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Google Search Console Connector Improvement

Planned
Abhimanyu Mahajan User
  • Edited

Add a page column in the site_report_by_page table, to know the number of clicks per page as soon as possible. 

Also, before you say that we can get that by page_report table. The number of clicks in the google search console doesn't match the sum of clicks per page I get from the "page_report" table. Whereas, the "search_report_by_page" is giving the right sum of clicks on a particular site on a particular timeframe or a day. 

Please sign in to leave a comment.

Comments

7 comments

Date Votes
  • Official comment
    Drew Fivetranner

    Hi Abhimanyu Mahajan, Drew from the Product Team here!

    I'd be happy to work on getting additional fields added, could you confirm again which table you are referring to? Are you referring to the SITE_REPORT_BY_PAGE table?

    The table you referenced is not in our schema.

  • Abhimanyu Mahajan User
    • Edited

    Hi Drew

    Yes, I wanted the page column to be added in the "site_report_by_page" table, to get the right number of clicks per page.

    Thanks!

  • Sean Rose User
    • Edited

    We have the same problem, where the SITE_REPORT_BY_PAGE and KEYWORD_SITE_REPORT_BY_PAGE tables don't include page URLs so we can't tell which page each row is for, making those tables unusable for us in their current state.

    After contacting Fivetran support about this, it appears this issue might be specific to the newer "domain properties" added to Google Search Console in 2019 (versus the older "URL-prefix properties"), but I've confirmed the Google Search Console API for those reports can return page URLs for domain properties if `PAGE` is specified as one of the dimensions.

    So we'd also like a PAGE column to be added to the SITE_REPORT_BY_PAGE and KEYWORD_SITE_REPORT_BY_PAGE tables.

  • Abhimanyu Mahajan User

    Hi Drew, Do we have any updates on this product improvement ? 

  • Sean Rose User

    I've belatedly realized that the PAGE_REPORT and KEYWORD_PAGE_REPORT tables contain the page-specific data I was looking for in the SITE_REPORT_BY_PAGE tables, and that the SITE_REPORT_BY_PAGE tables appropriately aggregate at the site level with "by page" referring to using Google's particular "aggregate by page" method of calculating the metrics, so I've removed my upvote for this request.

  • Luke Roy User

    Hi Sean, were you able to get a workaround for this? Everything Abhimanyu is saying is exactly my current situation!

  • Luke Roy User

    Both of those tables are not reflecting what the Google Search Console is showing by clicks by page the number of clicks is always off between the two.