Impression and click discrepancies in Search Console when filtering by date
-
I recently filtered query information by week and day. The impression and click totals were different depending on whether I looked at totals by a full weeks or by day.
So for example, the impression and click totals when I choose a date range of monday-sunday are different when I look at impressions and clicks that same week by day and then add up the click and impression numbers to get a weekly total. At first i was expecting a slight difference since I know the data is heavily sampled but the totals were very different.
Any explanations for this?
Thanks
-
Hi Zack,
Unfortunately, this is just down to sampling. Results in the interface, in particular, are very heavily sampled. There's a limit of 1000 rows per response when using the interface, but this goes up to 5000 when using the API. So the best you can do, really, is to use the API and pull out as many combinations of filters as you can.
I wrote this script for that purpose, and my colleague Dom also wrote about it in this Moz post.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Can Anyone help me with Google search console soft 404 error?
Hello everyone, I just build one site on WordPress and submitted it to the Google search console along with the sitemap. Some URLs got indexed but one of my URL is showing error in Search console. My post https://hotpass.site/create-subdomain-godaddy/ is showing soft error 404 webpage not available in Google search console. I have rechecked the site and seo settings. Nothing is there. I have even checked it with LIVE URL test. But still Search console is not accepting this URL. Can anyone help me with this? Help will be appriciated.
Reporting & Analytics | | Pauline210 -
Search Console API script aggregating over date range
Hi I was recently reading this article https://moz.com/blog/how-to-get-search-console-data-api-python and found it really helpful to get started with the search console API. However, it makes note that it is designed to return data for each day individually in a date range. I don't know python very well and was wondering if anyone knew how to edit the script to aggregate over the given date range for each url in a list of urls.
Reporting & Analytics | | aranzato0 -
When I click an outgoing link from Analytics - why are they all broken?
On one of my websites, if I visit the Behavior > Site Content section of Anayltics any link I try to open is broken. Google Analytics is appending the domain before every URL causing it to open in a popup but as a broken link. Example: Trying to click a link to a page on the website at this URL: http://www.thisisanexample.com/test.html But in the Analytics popup browser this is what it tries to load: www.thisisanexample.comhttp://www.thisisanexample.com/test.html So I can't preview any of the content within Google Analytics. I feel like this is a settings issue somewhere... Any ideas?
Reporting & Analytics | | ShawnW0 -
Help with GA Filters - IP Addresses
I'm having a hard time filtering out both of the IP addresses at our office. One is easy with regular expressions, but the other one does not seem to be working. Here are the two IP addresses: 2606:a000:4e2b:d500:61d9:9d4e:c539:ea86
Reporting & Analytics | | ReunionMarketing
174.99.90.148 I set up these two custom filters and neither worked for the longer IP address. 2606:a000:4e2b:d500:61d9:9d4e:c539:ea86|174.99.90.148
2606:a000:4e2b:d500:61d9:9d4e:c539:ea86|174.99.90.148 Would you please help steer me in the right direction? Thanks as always MOZ friends!0 -
Why do WMT's Search Analytics & GA's Real Time Keywords Differ?
I took a screen shot of the keywords from Google Analytics Real Time Keywords for Google / Organic. Then I waited a week and filtered Google Webmaster Tools' Search Analytics for queries with those keywords. None of them showed up. Why not? What I missing? Why do some keywords show up in Google Analytics RT for Google / Organic while most others are in Not Provided? I see WMT's Search Analytics says that it doesn't always show queries that "are made a very small number of times or those that contain personal or sensitive information." But most of my queries are like that. Anybody know any patterns / criteria that leads WMT to show some but not others? Thanks
Reporting & Analytics | | GilReich0 -
I want to track product click so how to create project object or how to pass project object ?
Hey, I am reading this post - https://developers.google.com/tag-manager/enhanced-ecommerce#product-clicksIn this there is function like given below - function(productObj) { dataLayer.push({ 'event': 'productClick', 'ecommerce': {.....................................................................................................................Now my developer asking how to create object? or how to pass product object? Like on page we have more than 50 products listed, so if any one clicks on any product from list then how will we know which product has been clicked?Hope you understand what i want to say? Regards,Mitesh
Reporting & Analytics | | bkmitesh0 -
Ways to analyze a 1M rows dataset of search queries
Hi, I have this large dataset, about 1 million search queries with visits, bounce rate and a few other metrics. I'm trying to explore this data to find keyword "buckets" (such as include product name, location name, transactional objective, informational, etc.), as well as explore the density of certain keywords (keywords as in instances of a single word amongst all queries) My idea was to use Excel and a macro to split all queries in separate words (also clearing punctuation and uppercase/lowercase), then storing this word in a new worksheet, adding to another column the visit counts from the row where the word was extracted (as to give a sense of weight). Before adding the word to the new worksheet, the script will look if the word already existed, if so it would just add the current value of visits to the existing visit counts etc. In the end it will create sort of a "dictionary" of all the keywords in all search queries ranked by weight (= visits from search query including this keyword) This would help me get started I believe, because I can't segment and analyze 1M raw search queries... My issue is: this VBA has been running on my (fast) PC for the last 24hr and it doesn't seem to get to an end. Obviously excel+VBA is not the best way to do text mining and manipulation in such a large dataset (although it's just a 30mb file) What would you do if you had this dataset and would like to mine the text/semantic as I am doing? Any idea of tools? process? I'm considering dumping this data into a MySQL db and doing the processing through PHP (the only backend language I'm versed in), and getting the "summified" data stored into another table, which I'll then be able to export to a Excel for analysis. But I'm afraid that I'll be facing memory limit issues and such... In the meantime, I'm definitely interested into knowing what you guys would do if you had this data and wanted to simply start exploring its constituencies Thanks!
Reporting & Analytics | | briacg0 -
Nofollow page is being reported as a landing page for organic search in Google Analytics
One of my client's websites includes a series of pages for an enrollment process. All of these pages are blocked by robots.txt. In Google Analytics these pages are showing data as landing pages for organic search traffic, and have been for quite some time. There was recently a surge of organic search traffic landing on one of these pages, coming from multiple search engines. The pages appear to be blocked and I'm not finding any of them in the search results for the keywords that are being reported in GA or by searching for the url. Does anyone have any insights into why this might be happening?
Reporting & Analytics | | rgibson1000