A quick and dirty export (ie you may need to do a bit of data filtering) of the SEO Focus Keywords data used in the Yoast SEO WordPress plugin.. The data could then be imported into SEO tools such as MOZ. For a better solution have a look at Get Yoast SEO Data
SELECT `meta_value`
FROM `wp_postmeta`
WHERE `meta_key` = '_yoast_wpseo_focuskw'
AND `meta_value` != ''
ORDER BY `wp_postmeta`.`meta_key` DESC
Leave a Reply
Want to join the discussion?Feel free to contribute!