Export blog content from Wagtail for content analysis

[data-sync-user]

Context: For the website revamp we want to better understand what content already exists. Exporting the content of the blog will help run this analysis and inform our content strategy moving forward.

Request: Please export the content of the mozilla foundation blog from wagtail. Unsure what formats are possible, but CSV or spreadsheet should be fine.

┆Issue is synchronized with this Jira Task

[data-sync-user]

➤ Daniel Miranda commented:

Hi Genevieve Baldassano !

I have just completed an export of the Foundation Site’s blog page data, and it can be found here ( https://docs.google.com/spreadsheets/d/11Ft0H4N1beTT_2FjWQ5FmYcQrw3fS3J8XN-8wDBodHk/edit?gid=1023003077#gid=1023003077 ).

I have queried for the following columns:

• Page ID
• Title
• Slug
• Is the page live?
• Date Last Published
• Date First Published
• Page URL
• Meta/SEO Description
• Related Topics
• Related Tags
• Authors
• Related Posts
• Does the page show “Author Details” section?
• Does the page have comments enabled?

Whenever you find a free moment, could you please take a look at the linked spreadsheet and let me know if the information is sufficient, or if there's any other data you'd like me to include?

Thanks in advance!

[data-sync-user]

➤ Genevieve Baldassano commented:

Thank you so much Daniel Miranda - this looks great to me. Tagging in Abigayle Fidler as well so she can review to see if she needs anything else for her analysis.