In this talk, Clair will show how to take Google Search Console data into Tableau and turn it into dashboards you can actually work from.

Starting with a raw export and a blank workbook, Clair will build up the calculations that make Search Console metrics behave correctly in Tableau, and how to group pages into categories that Search Console doesn't give you.

The session also covers the routes in, from the native BigQuery export to the Search Console API, Google Sheets and other data warehouses, and what each one costs you in row limits and history.

It closes on one view the Search Console interface cannot produce: every keyword paired with the individual page it ranks for.