marriage: SeoFrog & ID_category or ID_product

[Pedalman]

I am looking for an option to connect the results, the marvelous site crawler "SeoFrog" can give, to Thirtybees (Prestashop) categories and products via CSV.

Most of you will know that SeoFrog is an excellent tool to make a website audit and to crawl for interesting data of your own (and others) web shop. It is possible to export this data into csv for example.

 

Today for example I wanted to check my categories for good meta data informaion (title and description length). This data I can get via SeoFrog easily and export the data into a csv.

The trick is now to connect this data to the corresponding ID_categories so I can edit meta titles etc. in a fast way in CSV and re-upload eventually into Thirtybees. I wonder how this can be done?

 

[gtasanmobile]

1. Export Data from Both Systems

1. From SeoFrog: Crawl your site, export the SEO data (URLs, meta titles, meta descriptions) into a CSV.
2. From Thirtybees: Export your categories or products with their ID_category or ID_product and URLs.

---

2. Match SeoFrog Data with Thirtybees IDs

• Open both CSVs in Excel or Google Sheets.

• Use a formula like VLOOKUP to match the SeoFrog URLs with the IDs from the Thirtybees export.
   

3. Edit Metadata

• Add or update meta titles and descriptions in the SeoFrog CSV, now enriched with ID_category or ID_product.

---

4. Re-Upload to Thirtybees

• Save your updated CSV with columns like ID_category, Meta title, Meta description.
• Import it into Thirtybees using the built-in Import tool.

[DRMasterChief]

is SeoFrog now Screaming Frog ?

i didn´t know about SeoFrog and can not find good results about it anymore...     anybody with an link here? 

[nickz]

On 12/27/2024 at 11:15 AM, DRMasterChief said:

is SeoFrog now Screaming Frog ?

i didn´t know about SeoFrog and can not find good results about it anymore...     anybody with an link here? 

Those are one tool.
I'd be careful in trusting the results of so called SEO Audits.
It takes years to find a few ranking signals not being published, and you find also published SEO signals which are not.