A Data Studio Report on Your Crawl History

Data Studio, Google's free reporting tool, cannot read a PerfBee live link. It reads a Google Sheet. So a report on your crawl history takes three steps: a live link returns the crawl history as CSV, a Google Sheet reads the link, and Data Studio reads the sheet. Live links are on Starter and up and use no credits.

Build the report

Open Settings, then Live links, and press New live link. Choose Crawl history and the site. Copy the formula PerfBee shows: it is shown once.
In a new Google Sheet, name a tab Crawl history and paste the formula into cell A1. The tab fills with one row per finished crawl of the site, newest first, the last 365.
In Data Studio, create a report, add data and choose Google Sheets. Pick your sheet and the Crawl history tab, and tick Use first row as headers.
Add your charts and set each number column to a number.

What the table holds

The table has 16 columns. The first ten describe the crawl: Scanned At (UTC), Scan ID, Scan Mode, Pages Checked, URLs Checked, Working URLs, Redirecting URLs, Broken Links, Not Checked URLs and Credits. Six more sit on the right: SEO Issues, the total from a detailed crawl, and New Broken Links, Fixed Broken Links, New Pages, Gone Pages and Changed Pages, which compare the crawl with the one before it. A sheet you built earlier keeps working, because the first ten columns did not move. An empty cell means the crawl did not measure it: SEO Issues is empty for a Fast crawl, and the comparison columns are empty for the first crawl of a site.

What to chart

Scorecards for the latest crawl: Broken Links and URLs Checked. Sort by Scanned At (UTC), newest first, and limit the scorecard to one row.
A time series of Broken Links and Redirecting URLs against Scanned At (UTC).
A table of the last 20 crawls with Scan Mode, Pages Checked, Broken Links, New Broken Links and Credits.

If Data Studio does not read Scanned At (UTC) as a date, add a calculated field: PARSE_DATETIME("%Y-%m-%d %H:%M:%S", Scanned At (UTC)). Google Sheets may show the time as a number: select the column and choose Format, Number, Date time. An empty cell means the crawl stored no count for it. It is not zero.

Keep it working

Do not rename the tab, and do not insert columns to the left of the data. Add your own columns to the right.
The sheet reads the link again on its own, and each read builds the table from the newest crawl. Data Studio keeps its own cache of the sheet, so a new crawl can take a while to show.
Without a plan that has exports, fill the sheet through the REST API with an Apps Script instead. Data Studio reads that sheet the same way.

Keep it private

The formula in cell A1 holds the secret address of the link. Anyone who can open the sheet can read your crawl data. Share the sheet and the report only with people who may see it. If the link leaks, open Settings, then Live links, and choose Replace: the old address stops working at once, so paste the new formula into the sheet.

The limits of live links, and what each link can hold, are in Large Exports and Live Links for Google Sheets. The same route is in the guide.