{"id":3405,"date":"2012-11-07T14:28:57","date_gmt":"2012-11-07T13:28:57","guid":{"rendered":"https:\/\/www.aleydasolis.com\/?p=3405"},"modified":"2012-11-07T14:28:57","modified_gmt":"2012-11-07T13:28:57","slug":"seo-dashboard-google-docs-seomoz-analytics","status":"publish","type":"post","link":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/","title":{"rendered":"Create your SEO Dashboard in Google Docs with Google Analytics and SEOmoz MozScape Data"},"content":{"rendered":"<p>If you spend too much time in your daily SEO reporting activities, pulling, integrating and sharing your SEO traffic data from <a href=\"http:\/\/www.google.com\/analytics\/\">Google Analytics<\/a> and link related metrics from tools such as <a href=\"http:\/\/www.opensiteexplorer.org\/\">Open Site Explorer<\/a> you have arrived to the right place! The Solution: <strong>An SEO Traffic &amp; Link Popularity Dashboard in Google Docs.<\/strong><\/p>\n<p style=\"text-align: justify;\">Let&#8217;s use the <strong><a href=\"https:\/\/developers.google.com\/apps-script\/service_analytics\">APIs of Google Analytics<\/a> <\/strong>and <strong><a href=\"http:\/\/www.seomoz.org\/api\">SEOmoz MozScape<\/a> <\/strong>to import their data to Google Docs and easily automate and share our SEO Dashboards. I promise it&#8217;s going to be much easier than it sounds (no coding involve!), since we&#8217;re going to use some already created scripts:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3428\" title=\"Google Docs Analytics API Data \" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/10\/google-docs-analytics-api-data.jpg\" alt=\"Google Docs Analytics API Data \" width=\"750\" height=\"133\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/10\/google-docs-analytics-api-data.jpg 750w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/10\/google-docs-analytics-api-data-300x53.jpg 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/p>\n<p style=\"text-align: justify;\">To <strong>import Google Analytics data to Google Spreadsheets we&#8217;re going to use the <a href=\"http:\/\/analytics.blogspot.com.es\/2012\/08\/automate-google-analytics-reporting.html\">Google Analytics integration with Apps Script<\/a> <\/strong>released last August that allows us to <a href=\"https:\/\/developers.google.com\/analytics\/solutions\/articles\/reporting-apps-script\">pull and display the data in Google Docs<\/a>.<\/p>\n<p style=\"text-align: justify;\">To facilitate the process we will use as a template the <strong>Google Analytics Report Automation Script<\/strong> that can be found by going to the <strong>Google Spreadsheets Script Gallery<\/strong> (in the Tools menu) and searching for &#8220;analytics&#8221; as shown in the following image:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3473\" title=\"Google Analytics Report Automation (Magic) in Script Gallery\" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/google-analytics-report-automation-magic-script-gallery.jpg\" alt=\"Google Analytics Report Automation (Magic) in Script Gallery\" width=\"643\" height=\"260\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/google-analytics-report-automation-magic-script-gallery.jpg 643w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/google-analytics-report-automation-magic-script-gallery-300x121.jpg 300w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/p>\n<p style=\"text-align: justify;\">This script can be easily installed and run as explained in the following step-by-step video:<\/p>\n<div align=\"center\"><object width=\"480\" height=\"360\" classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http:\/\/download.macromedia.com\/pub\/shockwave\/cabs\/flash\/swflash.cab#version=6,0,40,0\"><param name=\"allowFullScreen\" value=\"true\" \/><param name=\"allowscriptaccess\" value=\"always\" \/><param name=\"src\" value=\"http:\/\/www.youtube.com\/v\/rL4N3qFyycg?version=3&amp;hl=es_ES&amp;rel=0\" \/><param name=\"allowfullscreen\" value=\"true\" \/><\/object><\/div>\n<p style=\"text-align: justify;\">Once the script is installed we need to configure it to pull the relevant SEO traffic data we want for our dashboard. For this example I will configure it to <strong>get the visits, pageviews per visit, goal completions and conversion rates for the top 50 organic landing pages and keywords of the last 7 days<\/strong>, that will be published in a sheet named &#8220;OrganicWeek&#8221;:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3463\" title=\"Google Analytics Dashboard with API\" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/ga-dashboard-api-google-docs.jpg\" alt=\"Google Analytics Dashboard with API\" width=\"525\" height=\"340\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/ga-dashboard-api-google-docs.jpg 525w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/ga-dashboard-api-google-docs-300x194.jpg 300w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/p>\n<p style=\"text-align: justify;\">If you want to add or modify any metrics or dimensions you can use this <a href=\"https:\/\/developers.google.com\/analytics\/devguides\/reporting\/core\/dimsmets\">Google Analytics dimensions and metrics reference<\/a> and test with the <a href=\"http:\/\/ga-dev-tools.appspot.com\/explorer\/\">Google Analytics Query Explorer<\/a>.<\/p>\n<p style=\"text-align: justify;\">After running the script we will get the following sheet with the desired Google Analytics data:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" title=\"Google Analytics Dashboard (Magic) Google Docs\" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/ga-dashboard-magic-google-docs.jpg\" alt=\"Google Analytics Dashboard (Magic) Google Docs\" width=\"674\" height=\"491\" \/><\/p>\n<p style=\"text-align: justify;\">Note how I have marked in red two areas of the sheet:<\/p>\n<ol>\n<li style=\"text-align: justify;\"><strong>The key:<\/strong> The characters in the &#8220;key=<strong><span style=\"color: #ff0000;\">nnnnn<\/span><\/strong>#gid&#8221; area. We&#8217;re going to use this later to import the data of the sheet from another one to be used for the dashboard.<\/li>\n<li style=\"text-align: justify;\"><strong>The data:<\/strong> The organic traffic related data we&#8217;re going to use for the dashboard. I have selected an unfiltered profile to show how you can do in the case you don&#8217;t have a <a href=\"http:\/\/support.google.com\/analytics\/bin\/answer.py?hl=en&amp;answer=1012243\">filter to show the full URL<\/a> of the pages (which is recommended although unfotunately not that common). Also, in this case we see many &#8220;(not provided)&#8221; as top keywords, so if you don&#8217;t want to include these you may want to apply a segment for organic traffic without &#8220;(not provided)&#8221;.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Additionally we can also configure the script to be run automatically at any time and frequency (by going to Tools &gt; Script Editor &gt; Resources &gt; All your triggers), for example, every day in the morning:<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3493\" title=\"Google Analytics Report Automation Timer\" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/google-analytics-report-automation-timer.jpg\" alt=\"Google Analytics Report Automation Timer\" width=\"664\" height=\"318\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/google-analytics-report-automation-timer.jpg 664w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/google-analytics-report-automation-timer-300x143.jpg 300w\" sizes=\"auto, (max-width: 664px) 100vw, 664px\" \/><\/p>\n<p style=\"text-align: justify;\">With this we have the first part of the data we need in Google Docs! Let&#8217;s continue with the second part&#8230;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3422\" title=\"Bring SEOmoz data to Google Docs\" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/10\/google-docs-seomoz-api-data.jpg\" alt=\"Bring SEOmoz data to Google Docs\" width=\"750\" height=\"133\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/10\/google-docs-seomoz-api-data.jpg 750w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/10\/google-docs-seomoz-api-data-300x53.jpg 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/p>\n<p style=\"text-align: justify;\">To get Open Site Explorer&#8217;s link related metrics we&#8217;re going to use the <strong>SEOmoz data for Google Docs tool<\/strong> from <a href=\"https:\/\/twitter.com\/iamchrisle\">Chris Le<\/a>. Chris explained in <a href=\"http:\/\/www.seomoz.org\/ugc\/updated-tool-seomoz-api-data-for-google-docs\"><strong>this SEOmoz post<\/strong><\/a> how the script works and he shared an <a href=\"https:\/\/docs.google.com\/spreadsheet\/ccc?key=0Apam75iNJI9idERXRktaTFZRME1Kdjl2c3NZYmtBSFE#gid=2\">easy to configure template<\/a> so we could copy and use it, thank you Chris!<\/p>\n<p style=\"text-align: justify;\">After copying the template and adding our <a href=\"http:\/\/www.seomoz.org\/api\/keys\">SEOmoz API credentials<\/a> we will automatically get link related metrics such as <strong>MozRank, page authority, domain authority, links, external links, http status code and title<\/strong> for a specific set of URLs that we can add to the sheet:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3500\" title=\"SEOmoz API Google Docs Tool\" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seomoz-api-google-docs.jpg\" alt=\"SEOmoz API Google Docs Tool\" width=\"660\" height=\"234\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seomoz-api-google-docs.jpg 660w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seomoz-api-google-docs-300x106.jpg 300w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><\/p>\n<p style=\"text-align: justify;\">Since we want to get these metrics for the landing pages with more organic traffic that we have obtained from Google Analytics what we&#8217;re going to do is to <strong>import the URLs of the landing pages from the previously generated &#8220;OrganicWeek&#8221; sheet into this one using the <a href=\"http:\/\/support.google.com\/drive\/bin\/answer.py?hl=en&amp;answer=155183\">ImportRange<\/a> function<\/strong>:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3505\" title=\"ImportRange SEOmoz API Google Docs\" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/importrange-seomoz-api-google-docs.jpg\" alt=\"ImportRange SEOmoz API Google Docs\" width=\"661\" height=\"363\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/importrange-seomoz-api-google-docs.jpg 661w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/importrange-seomoz-api-google-docs-300x164.jpg 300w\" sizes=\"auto, (max-width: 661px) 100vw, 661px\" \/><\/p>\n<p style=\"text-align: justify;\">The requested URIs we obtain don&#8217;t show the domain name and we need it to be able to get their link metrics from the SEOmoz API so <strong>we&#8217;re going to add a &#8220;Concatenated URL&#8221; column, using the <a href=\"https:\/\/support.google.com\/drive\/bin\/static.py?hl=en&amp;topic=25273&amp;page=table.cs&amp;tab=1240294\">Concat operator<\/a><\/strong> to add our full domain name:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3507\" title=\"Concat SEOmoz API Google Docs\" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/concat-seomoz-api-google-docs.jpg\" alt=\"Concat SEOmoz API Google Docs\" width=\"661\" height=\"464\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/concat-seomoz-api-google-docs.jpg 661w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/concat-seomoz-api-google-docs-300x210.jpg 300w\" sizes=\"auto, (max-width: 661px) 100vw, 661px\" \/><\/p>\n<p style=\"text-align: justify;\">Once we have the full URLs we can obtain the <strong>desired authority and link related metrics<\/strong> (MozRank, PA, DA, links, external links, http status code, title)<strong> for the top organic landing pages of the Google Analytics report<\/strong>:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3516\" title=\"SEOmoz API Google Docs Metrics\" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seomoz-api-google-docs-metrics.jpg\" alt=\"SEOmoz API Google Docs Metrics\" width=\"657\" height=\"306\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seomoz-api-google-docs-metrics.jpg 657w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seomoz-api-google-docs-metrics-300x139.jpg 300w\" sizes=\"auto, (max-width: 657px) 100vw, 657px\" \/><\/p>\n<p style=\"text-align: justify;\">Now we have the second part of the data we need in Google Docs! Let&#8217;s create the SEO Dashboard&#8230;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3432\" title=\"Get the Google Analytics and SEOmoz Api Data in Google Docs\" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/10\/get-google-analytics-seomoz-api-data.jpg\" alt=\"Get the Google Analytics and SEOmoz Api Data in Google Docs\" width=\"750\" height=\"133\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/10\/get-google-analytics-seomoz-api-data.jpg 750w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/10\/get-google-analytics-seomoz-api-data-300x53.jpg 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/p>\n<p style=\"text-align: justify;\">It&#8217;s time to <strong>put the SEO Dashboard together by importing the data<\/strong> from the two previous Google Docs sheets. The first part of the dashboard is going to be imported from the sheet with Google Analytics organic traffic data:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3518\" title=\"GA SEOmoz SEO Dashboard Import \" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/ga-seomoz-seo-dashboard-import.jpg\" alt=\"GA SEOmoz SEO Dashboard Import \" width=\"656\" height=\"303\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/ga-seomoz-seo-dashboard-import.jpg 656w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/ga-seomoz-seo-dashboard-import-300x138.jpg 300w\" sizes=\"auto, (max-width: 656px) 100vw, 656px\" \/><\/p>\n<p style=\"text-align: justify;\">And the second part from the SEOmoz authority and link metrics sheet:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3519\" title=\"Google Analytics SEOmoz SEO Dashboard Import \" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/ga-seomoz-seo-dashboard-import-2.jpg\" alt=\"Google Analytics SEOmoz SEO Dashboard Import \" width=\"656\" height=\"303\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/ga-seomoz-seo-dashboard-import-2.jpg 656w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/ga-seomoz-seo-dashboard-import-2-300x138.jpg 300w\" sizes=\"auto, (max-width: 656px) 100vw, 656px\" \/><\/p>\n<p style=\"text-align: justify;\">Then we will have a complete table with the SEO related information we imported from both sources:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3521\" title=\"SEO Dashboard Google Docs\" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs.jpg\" alt=\"SEO Dashboard Google Docs\" width=\"650\" height=\"313\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs.jpg 650w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs-300x144.jpg 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/p>\n<p style=\"text-align: justify;\">We can also <strong>re-organize the data to be more easily visualized with the chart option<\/strong>. For example, creating a table to see the top landing pages organized together with their keywords showing also their titles to have a better idea of their content and possible keywords in case we have (not provided):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3526\" title=\"Google Docs Top Landing Pages Keywords Table\" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/google-docs-landingpages-keywords-visits-title-chart.jpg\" alt=\"Google Docs Top Landing Pages Keywords Table\" width=\"655\" height=\"310\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/google-docs-landingpages-keywords-visits-title-chart.jpg 655w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/google-docs-landingpages-keywords-visits-title-chart-300x141.jpg 300w\" sizes=\"auto, (max-width: 655px) 100vw, 655px\" \/><\/p>\n<p>Or simply by creating a graphic visualization of the data!<\/p>\n<p>Finally, one of the best part if that we can <strong>share our SEO dashboard with a link, giving only the type of access we want<\/strong> -to view or also edit-:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3523\" title=\"Share Google Docs SEO Dashboard\" src=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/share-google-docs-dashboard.jpg\" alt=\"Share Google Docs SEO Dashboard\" width=\"670\" height=\"438\" srcset=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/share-google-docs-dashboard.jpg 670w, https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/share-google-docs-dashboard-300x196.jpg 300w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/p>\n<p style=\"text-align: left;\">With this example I hope you&#8217;ve gotten more ideas and see the possibility to <strong>build your own SEO Dashboard by using Google Docs, automatizing<\/strong> some of the more time consuming SEO tasks.<\/p>\n<p><em>Photos under Creative Commons taken from Flickr: <a href=\"http:\/\/www.flickr.com\/photos\/pinkpurse\/5406911690\/\">Photo 1<\/a> &amp; <a href=\"http:\/\/www.flickr.com\/photos\/pinkpurse\/5291302347\/\">Photo 2.<\/a><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Create your SEO dashboard in Google Docs by importing your most relevant traffic, link and authority related SEO data from Google Analytics and SEOmoz Mozscape. <\/p>\n","protected":false},"author":2,"featured_media":3521,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[17],"tags":[],"class_list":["post-3405","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-search-engine-optimization"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SEO Dashboard in Google Docs with Google Analytics and SEOmoz Mozscape<\/title>\n<meta name=\"description\" content=\"Create your SEO dashboard in Google Docs by importing your most relevant traffic, link and authority related SEO data from Google Analytics and Mozscape.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SEO Dashboard in Google Docs with Google Analytics and SEOmoz Mozscape\" \/>\n<meta property=\"og:description\" content=\"Create your SEO dashboard in Google Docs by importing your most relevant traffic, link and authority related SEO data from Google Analytics and Mozscape.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"International SEO Consultant, Author &amp; Speaker | Aleyda Solis\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/aleydaseotips\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/aleydaseotips\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-07T13:28:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"650\" \/>\n\t<meta property=\"og:image:height\" content=\"313\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Aleyda Solis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@aleyda\" \/>\n<meta name=\"twitter:site\" content=\"@aleyda\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aleyda Solis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/\"},\"author\":{\"name\":\"Aleyda Solis\",\"@id\":\"https:\/\/www.aleydasolis.com\/#\/schema\/person\/ec6584c7e2f6e1ca7db25bd52cc3e14f\"},\"headline\":\"Create your SEO Dashboard in Google Docs with Google Analytics and SEOmoz MozScape Data\",\"datePublished\":\"2012-11-07T13:28:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/\"},\"wordCount\":961,\"commentCount\":22,\"publisher\":{\"@id\":\"https:\/\/www.aleydasolis.com\/#\/schema\/person\/ec6584c7e2f6e1ca7db25bd52cc3e14f\"},\"image\":{\"@id\":\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs.jpg\",\"articleSection\":[\"Search Engine Optimization\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/\",\"url\":\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/\",\"name\":\"SEO Dashboard in Google Docs with Google Analytics and SEOmoz Mozscape\",\"isPartOf\":{\"@id\":\"https:\/\/www.aleydasolis.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs.jpg\",\"datePublished\":\"2012-11-07T13:28:57+00:00\",\"description\":\"Create your SEO dashboard in Google Docs by importing your most relevant traffic, link and authority related SEO data from Google Analytics and Mozscape.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#primaryimage\",\"url\":\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs.jpg\",\"contentUrl\":\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs.jpg\",\"width\":\"650\",\"height\":\"313\",\"caption\":\"SEO Dashboard Google Docs\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.aleydasolis.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create your SEO Dashboard in Google Docs with Google Analytics and SEOmoz MozScape Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.aleydasolis.com\/#website\",\"url\":\"https:\/\/www.aleydasolis.com\/\",\"name\":\"Aleyda Solis - International SEO Consultant, Founder, Author & Speaker\",\"description\":\"Aleyda Solis is an SEO consultant and founder of Orainti -a boutique SEO consultancy-, speaker, and author. She shares the latest news and resources in SEO in the #SEOFOMO newsletter and Digital Marketing in #MarketingFOMO, SEO tips in the Crawling Mondays video series, and a free SEO Learning Roadmap called LearningSEO.io. European Search Personality of 2018, she&#039;s also co-founder of Remoters.net, a remote work hub, featuring a free remote job board, tools, guides, and more to empower remote work.\",\"publisher\":{\"@id\":\"https:\/\/www.aleydasolis.com\/#\/schema\/person\/ec6584c7e2f6e1ca7db25bd52cc3e14f\"},\"alternateName\":\"Aleyda Solis\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.aleydasolis.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.aleydasolis.com\/#\/schema\/person\/ec6584c7e2f6e1ca7db25bd52cc3e14f\",\"name\":\"Aleyda Solis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.aleydasolis.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2023\/06\/aleyda-solis-profile-pic-1024x1024.png\",\"contentUrl\":\"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2023\/06\/aleyda-solis-profile-pic-1024x1024.png\",\"width\":1024,\"height\":1024,\"caption\":\"Aleyda Solis\"},\"logo\":{\"@id\":\"https:\/\/www.aleydasolis.com\/#\/schema\/person\/image\/\"},\"description\":\"Aleyda Solis is an SEO consultant and founder of Orainti -a boutique SEO consultancy-, speaker, and author. She shares the latest news and resources in SEO in the #SEOFOMO newsletter and Digital Marketing in #MarketingFOMO, SEO tips in the Crawling Mondays video series, and a free SEO Learning Roadmap called LearningSEO.io. European Search Personality of 2018, she's also co-founder of Remoters.net, a remote work hub, featuring a free remote job board, tools, guides, and more to empower remote work.\",\"sameAs\":[\"https:\/\/www.aleydasolis.com\/\",\"https:\/\/www.facebook.com\/aleydaseotips\/\",\"https:\/\/www.instagram.com\/crawlingmondays\/\",\"https:\/\/www.linkedin.com\/in\/aleyda\/\",\"https:\/\/x.com\/aleyda\",\"https:\/\/www.youtube.com\/c\/crawlingmondaysbyaleyda\"],\"url\":\"https:\/\/www.aleydasolis.com\/en\/author\/aleyda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SEO Dashboard in Google Docs with Google Analytics and SEOmoz Mozscape","description":"Create your SEO dashboard in Google Docs by importing your most relevant traffic, link and authority related SEO data from Google Analytics and Mozscape.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/","og_locale":"en_US","og_type":"article","og_title":"SEO Dashboard in Google Docs with Google Analytics and SEOmoz Mozscape","og_description":"Create your SEO dashboard in Google Docs by importing your most relevant traffic, link and authority related SEO data from Google Analytics and Mozscape.","og_url":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/","og_site_name":"International SEO Consultant, Author &amp; Speaker | Aleyda Solis","article_publisher":"https:\/\/www.facebook.com\/aleydaseotips\/","article_author":"https:\/\/www.facebook.com\/aleydaseotips\/","article_published_time":"2012-11-07T13:28:57+00:00","og_image":[{"width":650,"height":313,"url":"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs.jpg","type":"image\/jpeg"}],"author":"Aleyda Solis","twitter_card":"summary_large_image","twitter_creator":"@aleyda","twitter_site":"@aleyda","twitter_misc":{"Written by":"Aleyda Solis","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#article","isPartOf":{"@id":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/"},"author":{"name":"Aleyda Solis","@id":"https:\/\/www.aleydasolis.com\/#\/schema\/person\/ec6584c7e2f6e1ca7db25bd52cc3e14f"},"headline":"Create your SEO Dashboard in Google Docs with Google Analytics and SEOmoz MozScape Data","datePublished":"2012-11-07T13:28:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/"},"wordCount":961,"commentCount":22,"publisher":{"@id":"https:\/\/www.aleydasolis.com\/#\/schema\/person\/ec6584c7e2f6e1ca7db25bd52cc3e14f"},"image":{"@id":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs.jpg","articleSection":["Search Engine Optimization"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/","url":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/","name":"SEO Dashboard in Google Docs with Google Analytics and SEOmoz Mozscape","isPartOf":{"@id":"https:\/\/www.aleydasolis.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#primaryimage"},"image":{"@id":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs.jpg","datePublished":"2012-11-07T13:28:57+00:00","description":"Create your SEO dashboard in Google Docs by importing your most relevant traffic, link and authority related SEO data from Google Analytics and Mozscape.","breadcrumb":{"@id":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#primaryimage","url":"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs.jpg","contentUrl":"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs.jpg","width":"650","height":"313","caption":"SEO Dashboard Google Docs"},{"@type":"BreadcrumbList","@id":"https:\/\/www.aleydasolis.com\/en\/search-engine-optimization\/seo-dashboard-google-docs-seomoz-analytics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.aleydasolis.com\/en\/"},{"@type":"ListItem","position":2,"name":"Create your SEO Dashboard in Google Docs with Google Analytics and SEOmoz MozScape Data"}]},{"@type":"WebSite","@id":"https:\/\/www.aleydasolis.com\/#website","url":"https:\/\/www.aleydasolis.com\/","name":"Aleyda Solis - International SEO Consultant, Founder, Author & Speaker","description":"Aleyda Solis is an SEO consultant and founder of Orainti -a boutique SEO consultancy-, speaker, and author. She shares the latest news and resources in SEO in the #SEOFOMO newsletter and Digital Marketing in #MarketingFOMO, SEO tips in the Crawling Mondays video series, and a free SEO Learning Roadmap called LearningSEO.io. European Search Personality of 2018, she&#039;s also co-founder of Remoters.net, a remote work hub, featuring a free remote job board, tools, guides, and more to empower remote work.","publisher":{"@id":"https:\/\/www.aleydasolis.com\/#\/schema\/person\/ec6584c7e2f6e1ca7db25bd52cc3e14f"},"alternateName":"Aleyda Solis","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.aleydasolis.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.aleydasolis.com\/#\/schema\/person\/ec6584c7e2f6e1ca7db25bd52cc3e14f","name":"Aleyda Solis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.aleydasolis.com\/#\/schema\/person\/image\/","url":"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2023\/06\/aleyda-solis-profile-pic-1024x1024.png","contentUrl":"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2023\/06\/aleyda-solis-profile-pic-1024x1024.png","width":1024,"height":1024,"caption":"Aleyda Solis"},"logo":{"@id":"https:\/\/www.aleydasolis.com\/#\/schema\/person\/image\/"},"description":"Aleyda Solis is an SEO consultant and founder of Orainti -a boutique SEO consultancy-, speaker, and author. She shares the latest news and resources in SEO in the #SEOFOMO newsletter and Digital Marketing in #MarketingFOMO, SEO tips in the Crawling Mondays video series, and a free SEO Learning Roadmap called LearningSEO.io. European Search Personality of 2018, she's also co-founder of Remoters.net, a remote work hub, featuring a free remote job board, tools, guides, and more to empower remote work.","sameAs":["https:\/\/www.aleydasolis.com\/","https:\/\/www.facebook.com\/aleydaseotips\/","https:\/\/www.instagram.com\/crawlingmondays\/","https:\/\/www.linkedin.com\/in\/aleyda\/","https:\/\/x.com\/aleyda","https:\/\/www.youtube.com\/c\/crawlingmondaysbyaleyda"],"url":"https:\/\/www.aleydasolis.com\/en\/author\/aleyda\/"}]}},"jetpack_featured_media_url":"https:\/\/www.aleydasolis.com\/wp-content\/uploads\/2012\/11\/seo-dashboard-google-docs.jpg","jetpack_shortlink":"https:\/\/wp.me\/pgpHtA-SV","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.aleydasolis.com\/en\/wp-json\/wp\/v2\/posts\/3405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aleydasolis.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aleydasolis.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aleydasolis.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aleydasolis.com\/en\/wp-json\/wp\/v2\/comments?post=3405"}],"version-history":[{"count":0,"href":"https:\/\/www.aleydasolis.com\/en\/wp-json\/wp\/v2\/posts\/3405\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aleydasolis.com\/en\/wp-json\/wp\/v2\/media\/3521"}],"wp:attachment":[{"href":"https:\/\/www.aleydasolis.com\/en\/wp-json\/wp\/v2\/media?parent=3405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aleydasolis.com\/en\/wp-json\/wp\/v2\/categories?post=3405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aleydasolis.com\/en\/wp-json\/wp\/v2\/tags?post=3405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}