List number of pages per pagetype in Optimizely CMS

Using this SQL addon, or any other SQL client, you may list the number of pages per page type in your Optimizely CMS solution like this.

SELECT ct.Name AS ContentType, COUNT(c.pkID) AS ContentCount
FROM tblContentType ct
LEFT JOIN tblContent c ON ct.pkID = c.fkContentTypeID
WHERE ct.ContentType = 0
GROUP BY ct.Name
ORDER BY ContentCount DESC

And you'll get the result sorted from the page type with most instances to the page type with the least intances.

To query different content types, change the ContentType value in line 4 as follows:

• 0: Pages
• 1: Blocks
• 2: Assets (files and folders)

Happy querying!