automation in seo. tools and tricks
TRANSCRIPT
Ivan Kutas
Automation in SEO. Tools and tricks
Big project
Big project SEO
1. > 1 million pages.
2. Complicated structure.
3. Frequent reports.
4. Huge amount of data.
5. SEO team.
Automation in SEO
Automation in SEO
Data import from analytical systems
https://ga-dev-tools.appspot.com/query-explorer/
Google Analytics Query Explorer
Google Analytics add-on for Spreadsheets
Google Analytics Add-on
Reports scheduler
Scripts
R
Download and Install:http://cran.gis-lab.info/
Rtools (for dev tools):http://cran.r-project.org/bin/windows/Rtools/
Rstudio - IDE:http://www.rstudio.com/
Script:http://goo.gl/2v6uIP
Python
Download and Installhttps://code.google.com/p/pythonxy/wiki/Downloads
Optionshttp://goo.gl/kajAXw
API query
API query example
return service.data().ga().get( ids=table_id, start_date='2014-01-01', end_date='2014-01-31', metrics='ga:sessions,ga:pageviewsPerSession', dimensions='ga:landingPagePath,ga:keyword', sort='-ga:sessions', filters='ga:landingPagePath=~/some-category/', start_index='1', max_results='10000')
Automated reports
Google Analytics Add-on
Automated reports
+ QUERY function
Automated reports
= Dashboard
Automated reports
= Dashboard
Keywords collection
Keywords generation
Google webmaster tools
Google webmaster tools
Download top pages and their keywords
http://www.lunametrics.com/blog/2014/04/30/gwt-top-pages-export-bookmarklet/
Bookmarklethttp://goo.gl/P2v62C
Google webmaster tools
Competitors keywords
+
Ahrefs
Prodvigator
Prodvigator
Ideas for content plan
http://prodvigator.bg/keywords/additional?query=покриви&question=1
Other automation tools for big projects SEO
On-page checker
Collect datahttp://goo.gl/Enwkz
Check data and e-mail notificationhttp://goo.gl/Xvlgcn
Check parameters
E-mail notification
E-mail notification
Thank you for your attention!
netpeak.net