{"id":12047,"date":"2021-12-11T17:34:38","date_gmt":"2021-12-11T16:34:38","guid":{"rendered":"https:\/\/flaven.fr\/?post_type=bf_videos_manager&#038;p=12047"},"modified":"2021-12-12T10:09:53","modified_gmt":"2021-12-12T09:09:53","slug":"part-3-poc-for-a-seo-dashboard-made-with-streamlit-managing-screaming-frog-automation-storing-results-in-a-database-sqlite-and-create-data-analysis-graphics-for-seo-reports","status":"publish","type":"bf_videos_manager","link":"https:\/\/flaven.fr\/videos\/part-3-poc-for-a-seo-dashboard-made-with-streamlit-managing-screaming-frog-automation-storing-results-in-a-database-sqlite-and-create-data-analysis-graphics-for-seo-reports\/","title":{"rendered":"Part 3 POC for a SEO dashboard made with Streamlit, managing Screaming Frog automation, storing results in a Database (SQLite) and create data-analysis graphics for SEO reports."},"content":{"rendered":"<p>Part 3 POC for a SEO dashboard made with Streamlit, managing Screaming Frog automation, storing results in a Database (SQLite) and create data-analysis graphics for SEO reports.<\/p>\n<p><b>QUICK DESCRIPTION<\/b><br \/>\nA personal tooling. A &#8220;tool&#8221; industrialized and automatized to: chain actions between them in order to improve productivity and facilitate decision-making, delegate tedious work to machines in order to give me more free time.<br \/>\nSo, the output is a Streamlit Dashboard, Screaming Frog SEO Spider for large time saves and fast audits then manage the output (csv reports), save it into a SQLite database and analyse it with creating graphics.<\/p>\n<ul>\n<li><b>Streamlit<\/b>: Streamlit turns data scripts into shareable web apps in minutes. All in Python. All for free. No front\u2011end experience required. More on <a href=\"https:\/\/streamlit.io\/\" target=\"_blank\" rel=\"noopener\">https:\/\/streamlit.io\/<\/a><\/li>\n<li><b>SQLite<\/b>: Streamlit turns data scripts into shareable web apps in minutes. All in Python. All for free. No front\u2011end experience required. More on <a href=\"https:\/\/sqlite.org\" target=\"_blank\" rel=\"noopener\">https:\/\/sqlite.org<\/a><\/li>\n<li><b>SQLAlchemy<\/b>: Streamlit turns data scripts into shareable web apps in minutes. All in Python. All for free. No front\u2011end experience required. More on <a href=\"https:\/\/www.sqlalchemy.org\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.sqlalchemy.org\/<\/a><\/li>\n<li><b>The Screaming Frog SEO<\/b>: Streamlit turns data scripts into shareable web apps in minutes. All in Python. All for free. No front\u2011end experience required. More on <a href=\"https:\/\/www.screamingfrog.co.uk\/seo-spider\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.screamingfrog.co.uk\/seo-spider\/<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Part 3 POC for a SEO dashboard made with Streamlit, managing Screaming Frog automation, storing results in a Database (SQLite) and create data-analysis graphics for&hellip; <\/p>\n<p class=\"text-center\"><a href=\"https:\/\/flaven.fr\/videos\/part-3-poc-for-a-seo-dashboard-made-with-streamlit-managing-screaming-frog-automation-storing-results-in-a-database-sqlite-and-create-data-analysis-graphics-for-seo-reports\/\" class=\"more-link\">Continue reading &rarr; <span class=\"screen-reader-text\">Part 3 POC for a SEO dashboard made with Streamlit, managing Screaming Frog automation, storing results in a Database (SQLite) and create data-analysis graphics for SEO reports.<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":11707,"comment_status":"open","ping_status":"closed","template":"","bf_videos_manager_tag":[2707,2708,2685,2719,2771,2711,2704,2674,2754,2845,2805,2683,2813,2846,2714,2672,2848,2812,2806,2842,2811],"bf_videos_manager_cat":[2729,2700,2682,2678,2679,2680],"class_list":["post-12047","bf_videos_manager","type-bf_videos_manager","status-publish","has-post-thumbnail","hentry","bf_videos_manager_tag-agile","bf_videos_manager_tag-agile-toolkit","bf_videos_manager_tag-anaconda","bf_videos_manager_tag-automation","bf_videos_manager_tag-automatization","bf_videos_manager_tag-bulk","bf_videos_manager_tag-bulk-processing","bf_videos_manager_tag-database","bf_videos_manager_tag-learning-by-doing","bf_videos_manager_tag-mac","bf_videos_manager_tag-numpy","bf_videos_manager_tag-p-o","bf_videos_manager_tag-panda","bf_videos_manager_tag-poc","bf_videos_manager_tag-processing","bf_videos_manager_tag-python","bf_videos_manager_tag-sqlalchemy","bf_videos_manager_tag-sqlite","bf_videos_manager_tag-streamlit","bf_videos_manager_tag-tooling","bf_videos_manager_tag-wireframing","bf_videos_manager_cat-agile","bf_videos_manager_cat-anaconda","bf_videos_manager_cat-experiences","bf_videos_manager_cat-python","bf_videos_manager_cat-tutorials","bf_videos_manager_cat-videos"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/bf_videos_manager\/12047","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/bf_videos_manager"}],"about":[{"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/types\/bf_videos_manager"}],"author":[{"embeddable":true,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/comments?post=12047"}],"version-history":[{"count":2,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/bf_videos_manager\/12047\/revisions"}],"predecessor-version":[{"id":12049,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/bf_videos_manager\/12047\/revisions\/12049"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/media\/11707"}],"wp:attachment":[{"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/media?parent=12047"}],"wp:term":[{"taxonomy":"bf_videos_manager_tag","embeddable":true,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/bf_videos_manager_tag?post=12047"},{"taxonomy":"bf_videos_manager_cat","embeddable":true,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/bf_videos_manager_cat?post=12047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}