You can track the number of indexed pages on Google for your website or your competitors by using a simple python script to scrape the data from Google SERPs, store them in Google Sheets, and visualize the data in Google Data Studio dashboard.
Knowing the search intent for your keywords is very important for your content plan and strategy. It can give you hints about what your content is missing. You can get the search intent using Python by importing the data, including the keywords from Google Search Console. And Pandas library to read the data into data frames, and another Python function to assign the keywords into groups.
You can get the URLs of any WordPress website by using Python libraries such as BeautifulSoup for scraping the XML sitemap content, Requests to make the requests, and the Pandas library to save the URLs in a data frame where you can export it later to Excel or Google sheets.