Google reports api

Yesterday we reported how Google released the Google Indexing API specifically for job posting URLs but if you look closely at the wording, the API can be expanded well beyond just job posting URLs. I asked John Mueller of Google about the possibility of Google expanding the Indexing API beyond just job posting URLs and he said "I don't know." Well, we'd expect that kind of answer from him. … [Read more...] about Google On Expanding The Google Indexing API

/******************************* * Grab the GEO_PERFORMANCE_REPORT for the given * date range. dateRange can be things like LAST_30_DAYS * or more specific like 20150101,20150201 *******************************/ function getGeoReport(dateRange) { // The columns are in a function so I can call them // later when I build the spreadsheet. var cols = getReportColumns(); var report = 'GEO_PERFORMANCE_REPORT'; var query = ['select',cols.join(','),'from',report, 'where CampaignStatus = ENABLED', 'and AdGroupStatus = ENABLED', 'and Clicks > 0', // You can increase this to // reduce the number of results 'during',dateRange].join(' '); var reportIter = AdWordsApp.report(query).rows(); var retVal = []; while(reportIter.hasNext()) { var row = reportIter.next(); // If we don't have city level data, let's ignore it if(row['CityCriteriaId'] == 'Unspecified') { continue; } retVal.push(row); } return retVal; } // Helper function to return the report columns function getReportColumns() { return … [Read more...] about Machine Learning With AdWords Scripts And Google Prediction API

Ads Testing in Google Assistant results Google seems to be testing the surfacing of ads in Google Assistant results. While it is too early to assume anything about its possible rollout at this point, it appears Google has started experimenting with the idea already. As Search Engine Land reports, Gennaro Cuofano, Creator of FourWeekMBA.com, spotted this while performing a search on an Android phone (for an Executive MBA program in Italy). Gennaro, who posted about it on Twitter as well, said that “the answer on the voice assistant pretty much mirrored the search result page on that one.” Search Engine Land's Greg Sterling reports they couldn't confirm Gennaro’s results themselves in multiple attempts on both iOS and Android, but notes that Google Assistant ads are "probably inevitable." … [Read more...] about Google News Digest: New Features in Google Ads, Google Docs API, .dev Domain and More

I have used Screaming Frog as an example, but a similar outcome can also be achieved directly in Google Sheets using the IMPORTXML function to scrape the data using XPath expressions. The only downside to this option is that it requires you to have a list of the URLs you want to crawl. This can be pulled from Google Analytics, however pages that have had no traffic won’t be part of the analysis. Another downside is that when crawling large websites, Google Sheets tends to struggle. … [Read more...] about No data? No problem! Retroactive content analysis in Google Analytics

Related reading … [Read more...] about Where is Google heading with mobile local search?