Add option to export a list of all set focus keywords

[tacoverdo]

This feature was mainly requested by marketers, who want to have a clear overview of the current (SEO) status of their website. Allowing them to create an overview of the focus keywords used, and the page they're used on would help them a great deal.

[Rarst]

What would be desired format and set of information?

[Rarst]

After some internal discussion something like this would do: ID;title;keywords. Probably goes into tools tab, restricted to admins.

[shalintj]

Hi.. Is this feature live? If not, can you help me with the db_query to export the list of all focused keywords..

[Rarst]

No, this feature hasn't been implemented yet. From quick look keywords are stored with _yoast_wpseo_focuskw meta key in wp_postmeta table.

[shalintj]

@Rarst Got it.. Thanks.

[monbauza]

Please inform the customer of conversation # 114571 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 120326 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 140588 when this conversation has been closed. User also requests an option to search keywords.

[benvaassen]

Please inform the customer of conversation # 143789 when this conversation has been closed.

[Pcosta88]

User # 143789 also reports an option have "The URL also needs to be included in the format when you export it."

[Pcosta88]

We should also allow exportation of other Yoast SEO data such as

• Title
• URL
• Title tags
• Meta data
• SEO score
• Readability Scores
• The post/page where the keyword was assigned.

We should make an option to export into a CSV file

[shalintj]

@Pcosta88 @Rarst Hey guys.. Thanks for keeping this thread alive. Can you let us know by when can we expect to see this feature in the plugin?

[Rarst]

As per sidebar it is currently planned for 3.6 release.

[Pcosta88]

Please inform the customer of conversation # 151290 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 143789 when this conversation has been closed

[Pcosta88]

Please inform the customer of conversation # 140588 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 152899 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 154792 when this conversation has been closed.

[Pcosta88]

Above user also asks that the SEO data for custom post types be exportable too.

[monbauza]

Please inform the customer of conversation # 154004 when this conversation has been closed.

[monbauza]

The above customer would also like to have the matching URLs next to the exported focus keywords

[Pcosta88]

Please inform the customer of conversation # 159707 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 159827 when this conversation has been closed.

[moorscode]

@tacoverdo and I have been analyzing the specifications for this issue and came to the following approach:

We want to implement this as a page on which the user can export various statistics concerning the SEO of posts.

On this page the user should be able to select the options to be included in the export:

• Title
• URL
• Focus keywords (default on)
• SEO score result (needs improvement, ok, good)
• Readability score result (needs improvement, ok, good)

The post ID will always be included in each row.

When multiple keywords (or other variations of a post) are present, these should be exported as separate rows.

There should also be a selector to chose to export all post-types or just a specific one. When all post-types are exported, the post type should be a column in the export.

Technical/privacy note: The export should not be saved on disk, just presented to the browser.

[Pcosta88]

Please inform the customer of conversation # 163638 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 171451 when this conversation has been closed.

[mmikhan]

Please inform the customer of conversation # 174298 when this conversation has been closed.

[monbauza]

Please inform the customer of conversation # 177578 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 183934 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 183834 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 185103 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 185094 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 198958 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 198885 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 200778 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 200587 when this conversation has been closed.

[aprilholle]

WOOT! I'm excited you guys and gals are working on this issue - it's been a huge issue for us. Please let me know when this has been completed! <3

[Pcosta88]

@aprilholle Now that you have commented on the issue, you can expect to get updates on it.

[mmikhan]

Please inform the customer of conversation # 205462 when this conversation has been closed.

[mmikhan]

Please inform the customer of conversation # 205587 when this conversation has been closed.

[atimmer]

Removing this from the queue for now, because this is much easier to implement when we have a custom table.

[monbauza]

Please inform the customer of conversation # 208950 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 212484 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 212515 when this conversation has been closed.

[devnihil]

Please inform the customer of conversation # 215437 when this conversation has been closed.

[Pcosta88]

Please inform the customer of conversation # 215816 when this conversation has been closed.

[Pcosta88]

We should also add The post/page where the keyword was assigned.

[devnihil]

Please inform the customer of conversation # 217469 when this conversation has been closed.

[mutag]

Is this SEO data export option being released soon?

[benvaassen]

@DorjeTrollo The feature has been released a while ago. It's available in the newest version 5.5 of Yoast SEO Premium when you go to SEO -> Tools -> Import and Export -> Export keywords.