Allow for creation of dynamic 'views' in workbook
codingisforlosers opened this issue · 2 comments
These are static BQ queries, similar to the current On-page / Off-page etc views. Idea is to give a space to format WQA data for use in other processes (keyword research, content audits, etc).
This could be as simple as having a look through Blueprint templates, and seeing what formats of the raw data would be useful elsewhere.
Initial examples would be Keyword Research (rising and falling keywords from organic pulse models), Keyword Cannibalization, and Content Audit (to match BPT template).
This doesn't need to be an exhaustive library at first, rather just a demo.
These views will likely take a 'site' input from the summary tab. We could accept a 'report month' variable as well, but likely should default to the last full monthend.
Let's focus on one view for now, keyword reporting.
It can basically be a SELECT * FROM search_console_keyword_stats_monthly WHERE report_month = current month ORDER BY clicks_30d desc.
Going to mention this in the docs + the workbook, but no need to set these up to start with.
Will just make users aware of the types of data that they can query from BQ.