In the end of the video, you mention that bulk exports can be utilized for machine learning, clustering, statistical modeling, etc. Would be very interesting to see a video from you with (detailed) examples of this type of advanced usage of GSC data.
-- So you do not need to write it to SELECT url, query, SUM(impressions) AS impressions, sum(clicks) AS clicks, sum(clicks) / sum(impressions) as ctr, ((sum(sum_position) / sum(impressions)) + 1.0) AS avg_position FROM `searchdata_url_impression` WHERE data_date between DATE_SUB(CURRENT_DATE(), INTERVAL 14 day) AND CURRENT_DATE() AND is_anonymized_query = false -- AND clicks > 0 GROUP BY url, query ORDER BY clicks DESC LIMIT 100
Subscribe to keep up with the latest episodes of the new season of Search Console Training! → goo.gle/SearchCentral
Roberto janaban
In the end of the video, you mention that bulk exports can be utilized for machine learning, clustering, statistical modeling, etc. Would be very interesting to see a video from you with (detailed) examples of this type of advanced usage of GSC data.
Hello Brazil!!!
The query example at 4:10 really should have a DESC in the ORDER BY clause, else its just 100 zeros with the LIMIT 100.
-- So you do not need to write it to
SELECT
url,
query,
SUM(impressions) AS impressions,
sum(clicks) AS clicks,
sum(clicks) / sum(impressions) as ctr,
((sum(sum_position) / sum(impressions)) + 1.0) AS avg_position
FROM `searchdata_url_impression`
WHERE data_date between DATE_SUB(CURRENT_DATE(), INTERVAL 14 day) AND CURRENT_DATE()
AND is_anonymized_query = false
-- AND clicks > 0
GROUP BY url, query
ORDER BY clicks DESC
LIMIT 100
Does anyone know how to resolve this:
Oops! Something went wrong We had a problem submitting your indexing request. Please try again later