Catalog what tags are where
I’d like to generate a catalogue of what tags are in what places in a site. It would be in the format of a list of pages/locations (with links to those locations) that have tag settings, along with what those settings are.
This could have several uses:
1. Generally auditing tag usage for maintaining consistency.
2. Documentation
3. Ability to identify and delete unnecessary tags
4. Assist in recreating the setup in a CRM migration if one of the CRMs does not have dynamic tags.
This is definitely a priority item, it’s a little bit of a big job because we have so many integrations… but something I hope to finish this year.
In the meantime, a “sloppy” solution that will cover about 90% of the integrations is running this SQL command:
`SELECT `post_id`, `meta_value` from `wp_postmeta` WHERE `meta_key` LIKE “wpf%” AND `meta_value` LIKE “%tags%”`
And that will give you a result like this: https://i.wpfusion.com/RmMxD9zl
Yes, this would be a really nice admin utility. I guess it’s not directly a WPF responsibility, but it sure would be a nice addition.
And thanks for the SQL statement, Jack. I can also see a way to run a content grid in a page builder (e.g. Beaver Builder) that only lists out posts that have the meta keys set.
What I will need to do is figure out how to return posts where modules have tag rules applied even thought the postmeta doesn’t have any rules applied.