Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The reference to the entity answer must end with a ; delimiter #214

Open
andreamoro opened this issue Apr 18, 2019 · 1 comment
Open

The reference to the entity answer must end with a ; delimiter #214

andreamoro opened this issue Apr 18, 2019 · 1 comment

Comments

@andreamoro
Copy link

In an attempt to update an existing note, I got the above error even if the note is not altered at all.

Code from the debug is as follow:

	The reference to entity "answer" must end with the ';' delimiter.
	Last command: replace_view_text {'characters': '---\ntitle: SEO Dashboard in Google Docs with Google Analytics and SEOmoz Mozscape\ntags: []\nnotebook: Analytics\n---\n\n# If you spend too much time in your daily SEO reporting activities, pulling, integrating and sharing your SEO traffic data from Google Analytics and link related metrics from tools such as Open Site Explorer you have arrived to the right place! The Solution: An SEO Traffic & Link Popularity Dashboard in Google Docs.\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nLet’s use the [APIs of Google Analytics](https://developers.google.com/apps-script/service_analytics) and [SEOmoz MozScape](http://www.seomoz.org/api) to import their data to Google Docs and easily automate and share our SEO Dashboards. I promise it’s going to be much easier than it sounds (no coding involve!), since we’re going to use some already created scripts:</div>\n<en-media type="image/jpeg" hash="1c01b2d18d718fd3678c3c5190519f01"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nTo import Google Analytics data to Google Spreadsheets we’re going to use the [Google Analytics integration with Apps Script](http://analytics.blogspot.com.es/2012/08/automate-google-analytics-reporting.html) released last August that allows us to [pull and display the data in Google Docs](https://developers.google.com/analytics/solutions/articles/reporting-apps-script).</div>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nTo facilitate the process we will use as a template the Google Analytics Report Automation Script that can be found by going to the Google Spreadsheets Script Gallery (in the Tools menu) and searching for “analytics” as shown in the following image:</div>\n<en-media type="image/jpeg" hash="cc7ddb5d739c6b64102467564583880a"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nThis script can be easily installed and run as explained in the following step-by-step video:</div>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nOnce 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 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, that will be published in a sheet named “OrganicWeek”:</div>\n<en-media type="image/jpeg" hash="1d1af3be116ff220644d5fef070e260d"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nIf you want to add or modify any metrics or dimensions you can use this [Google Analytics dimensions and metrics reference](https://developers.google.com/analytics/devguides/reporting/core/dimsmets) and test with the [Google Analytics Query Explorer](http://ga-dev-tools.appspot.com/explorer/).</div>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nAfter running the script we will get the following sheet with the desired Google Analytics data:</div>\n<en-media type="image/jpeg" hash="5a701e337af9d812b96e759b7a288e50"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nNote how I have marked in red two areas of the sheet:</div>\n\n  1. The key: The characters in the “key=nnnnn#gid” area. We’re going to use this later to import the data of the sheet from another one to be used for the dashboard.\n\n  2. The data: The organic traffic related data we’re going to use for the dashboard. I have selected an unfiltered profile to show how you can do in the case you don’t have a [filter to show the full URL](http://support.google.com/analytics/bin/answer.py?hl=en&answer=1012243) of the pages (which is recommended although unfotunately not that common). Also, in this case we see many “(not provided)” as top keywords, so if you don’t want to include these you may want to apply a segment for organic traffic without “(not provided)”.\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nAdditionally we can also configure the script to be run automatically at any time and frequency (by going to Tools > Script Editor > Resources > All your triggers), for example, every day in the morning:</div>\n<en-media type="image/jpeg" hash="44b2c32b8098da6601bdf6c0e1373957"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nWith this we have the first part of the data we need in Google Docs! Let’s continue with the second part…</div>\n<en-media type="image/jpeg" hash="9c723ac02fc4036b78dfb9d08082cd7e"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nTo get Open Site Explorer’s link related metrics we’re going to use the SEOmoz data for Google Docs tool from [Chris Le](https://twitter.com/iamchrisle). Chris explained in [this SEOmoz post](http://www.seomoz.org/ugc/updated-tool-seomoz-api-data-for-google-docs) how the script works and he shared an [easy to configure template](https://docs.google.com/spreadsheet/ccc?key=0Apam75iNJI9idERXRktaTFZRME1Kdjl2c3NZYmtBSFE#gid=2) so we could copy and use it, thank you Chris!</div>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nAfter copying the template and adding our [SEOmoz API credentials](http://www.seomoz.org/api/keys) we will automatically get link related metrics such as MozRank, page authority, domain authority, links, external links, http status code and title for a specific set of URLs that we can add to the sheet:</div>\n<en-media type="image/jpeg" hash="03f6e091fe86592cfbf3abb5272b69cb"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nSince we want to get these metrics for the landing pages with more organic traffic that we have obtained from Google Analytics what we’re going to do is to import the URLs of the landing pages from the previously generated “OrganicWeek” sheet into this one using the [ImportRange](http://support.google.com/drive/bin/answer.py?hl=en&answer=155183) function:</div>\n<en-media type="image/jpeg" hash="92a369f061f50bcd2acefbc3783613ec"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nThe requested URIs we obtain don’t show the domain name and we need it to be able to get their link metrics from the SEOmoz API so we’re going to add a “Concatenated URL” column, using the [Concat operator](https://support.google.com/drive/bin/static.py?hl=en&topic=25273&page=table.cs&tab=1240294) to add our full domain name:</div>\n<en-media type="image/jpeg" hash="289bd73e8b143be1b83360fde14b566e"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nOnce we have the full URLs we can obtain the desired authority and link related metrics (MozRank, PA, DA, links, external links, http status code, title) for the top organic landing pages of the Google Analytics report:</div>\n<en-media type="image/jpeg" hash="eaa960d387a7a39f0036f25f23a6d91e"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nNow we have the second part of the data we need in Google Docs! Let’s create the SEO Dashboard…</div>\n<en-media type="image/jpeg" hash="6527eb638218f570e4c94f88ffb0fa5b"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nIt’s time to put the SEO Dashboard together by importing the data 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:</div>\n<en-media type="image/jpeg" hash="5d383d7cb78e1cc13926b608d649fa26"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nAnd the second part from the SEOmoz authority and link metrics sheet:</div>\n<en-media type="image/jpeg" hash="6012e1f719c797666aca826f8216e921"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nThen we will have a complete table with the SEO related information we imported from both sources:</div>\n<en-media type="image/jpeg" hash="aeed596730acb871b86ba3e83c3e3e6b"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nWe can also re-organize the data to be more easily visualized with the chart option. 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):</div>\n<en-media type="image/jpeg" hash="ac8a6c3b8bf2750d4302af92746c1533"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nOr simply by creating a graphic visualization of the data!</div>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nFinally, one of the best part if that we can share our SEO dashboard with a link, giving only the type of access we want -to view or also edit-:</div>\n<en-media type="image/jpeg" hash="295d6b2377ba9cf7d66452bd495240e6"/>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nWith this example I hope you’ve gotten more ideas and see the possibility to build your own SEO Dashboard by using Google Docs, automatizing some of the more time consuming SEO tasks.</div>\n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nPhotos under Creative Commons taken from Flickr: [Photo 1](http://www.flickr.com/photos/pinkpurse/5406911690/) & [Photo 2.](http://www.flickr.com/photos/pinkpurse/5291302347/)</div>\n\nShare it · Compártelo \n\n<div markdown="1" style="margin-top: 1em; margin-bottom: 1em;-en-paragraph:true;">\n\nThis post is also available in: [Spanish](http://www.aleydasolis.com/seo/informes-posicionamiento-google-docs-seomoz-analytics/)</div>\n\n  \n\n'}```
@bordaigorl
Copy link
Owner

This looks like another failure of the markdown converter.
The only occurrences of answer are in the urls: http://support.google.com/drive/bin/answer.py?hl=en&answer=....

See #185 for a similar issue.

You can workaround the issue by replacing the = with %3D in the URLs.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants