Skip to content
Crawlune

Looker Studio reports from Crawlune

Crawlune Pro keeps one spreadsheet per site in your Google Drive with every crawl's numbers. Point a Looker Studio report at it once and it stays current as crawls run, including scheduled ones.

1. Create the data set

  1. In Crawlune, connect your Google account under Settings → Integrations (the Sheets permission only touches files Crawlune creates).
  2. After a crawl, choose Export → Google Sheets → Looker Studio data set. The first run creates Crawlune data set: your-site in your Drive and opens it; each later run appends the crawl.
  3. To keep it updating by itself, set up a schedule under Settings → Schedules and tick the data set in its exports.

2. What is in the spreadsheet

SheetOne row perColumns
Crawlscrawlcrawl_date, site, start_url, urls, html_pages, indexable, health, errors, warnings, opportunities, elapsed_s, app_version
Issuescheck and crawlcrawl_date, site, check, category, severity, urls
Pagespage of the latest crawlcrawl_date, site, url, status, indexable, depth, title, word_count, inlinks, link_score, issues, segment, clicks, impressions, ctr, position, sessions, views, perf_score, lcp_ms, cwv

Search Console, Analytics and PageSpeed columns fill in when those integrations ran for the crawl; otherwise they are blank. The Pages sheet is replaced on every run so it never grows beyond one crawl; Crawls and Issues accumulate.

3. Build the report

  1. Open lookerstudio.google.com → Create → Report.
  2. Add data → Google Sheets → pick Crawlune data set: your-site → worksheet Crawls. Tick "Use first row as headers". Add the Issues and Pages worksheets as two more data sources the same way.
  3. Set crawl_date to type Date & Time in each source (Resource → Manage added data sources → Edit).
  4. Suggested charts:
    • Time series on Crawls: health by crawl_date. Add errors, warnings and opportunities as a second time series.
    • Scorecards on Crawls, filtered to the latest date: urls, indexable, health.
    • Table on Issues, filtered to the latest crawl_date, sorted by urls: the current issue list. A time series of urls broken down by check shows which problems are being fixed.
    • Table on Pages: url, clicks, impressions, position, perf_score, issues, sorted by clicks: the pages that matter most and what is wrong with them.
  5. Share the report with the client as view-only. It refreshes from the spreadsheet on its own (Looker caches Sheets data for up to 15 minutes).

Several sites

Each site gets its own spreadsheet. For one report across sites, blend the sources on site and crawl_date, or add each spreadsheet as a data source and use a page per site.