Welcome to the Q&A Forum

Browse the forum for helpful insights and fresh discussions about all things SEO.

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Page Views for a List of URL's (Excel & Analytics)

Reporting & Analytics

585

AndreVanKets last edited by

I've been playing around with a few excel plugins trying to get the visit count for over 350 different URL's on the same website.

I cant seem to find a function that can do this. Can anyone advise a work around or a way i can achieve this?

Greg
1 Reply Last reply
Reply Quote 0
RuthBurrReedy last edited by

Hi Greg,

Which analytics tool are you using? In Google Analytics you should be able to select a view of up to 500 URLs to export. Let me know what tool you're using and I can give you some more specific advice.
1 Reply Last reply
Reply Quote 0

Got a burning SEO question?

Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.

Start my free trial

Browse Questions

View

From

Sorted by

With category

Explore more categories

Related Questions

Directory Listings the DO's and Dont's

Hi guys, We are currently working on increasing our online marketing presence and with a new website on the cards I am turning to all of our B2B business directories to update, and being tracking referrals etc to see ones that may be worth premium listings. I have a list of 200 business directories to scope and check, some are relevant some are not, obviously i dont want to sign up to them all and risk a dodgy link profile so im going to be selective, but im not sure how many to aim for etc. So im looking for some general advice and guidance at this early stage so I can properly plan my approach. What advice would you give and are there any major DO's and DONT's of sorting through these directories to look for some new ways to source customers. EDIT: We are UK based Thanks
Reporting & Analytics | | ATP

0
Google Analytics Question - Impressions & Queries Up, Sessions Down

I'm working with a client who, according to the Google Query report, impressions and sessions are up since we've started work with them about 6 months ago, but Google sessions are down. In moz, we're seeing a gradual, but steady increase in search visibility specifically with Google. Note: this is all organic. From when we started tracking queries, the first month we were tracking there were 43,581 impressions and 690 click throughs for the month. This past month there were 98,293 queries and 1015 clicks throughs for the month (granted not year over year data) - of these 1,015 clicks, 995 of them were from web. However, for those same time periods, sessions from Google are down over 30% - 1,750 vs. 1,189. I'm not sure how to interpret this. I realize that clicks and sessions are not a straightforward comparison, but I would think that if clicks were up according to the query report that sessions would also be up. Is it that some of these clicks are bouncing and therefore not being tracked as a session? Is there a potential issue with how data is being tracked?
Reporting & Analytics | | Corporate_Communications

0
Google Analytics View Filters

Using the same GA property, I would like to set up three filtered views: 1. Tracking across one subdomain and one primary domain (example: shop.example.com & example.com) 2. Track only primary domain (example.com) 3. Track only subdomain (shop.example.com) Can this be achieved by using view filters? If so, how do they need to be set? Also, according to this article: https://moz.com/blog/cross-domain-subdomain-tracking-in-google-analytics, with cross domain tracking, I need to ignore self-referrals, which can only be done at the property level. If set up to ignore example.com referrals, will this cause problems with filter 2 and 3?
Reporting & Analytics | | Evan34

0
How can we view traffic from specific Twitter, Facebook, YouTube and Reddit accounts in Google Analytics?

Dear Moz Community, This is a Google Analytics question. Using Google Analytics, we're trying to identify trends of visitors on a website from specific social media accounts, i.e: twitter.com/account-x facebook.com/account-x youtube.com/account-x reddit.com/r/account-x Ideally, we would like to be able to see the success rate for specific posts on these social media accounts, and how users engaged on the website after arriving from clicking a link on one of these accounts. Is this drill-down feature currently possible in Google Analytics? Many thanks for helping!
Reporting & Analytics | | BoomDialogue69

0
Does analytics track an order two times by refresh on the confirmation-page?

Hi there,
I have a quick question. Does Google analytics track an order two times, if the user buys a product, see the confirmation page and then click refresh/click or back and forward again?
The order/tracking data must be the same, but i guess the tracking code runs for every refresh and therefore tracks the order two times in Analytics or does analytics know that it is the same order? Someone that can clearify this?Thanks! Regards
Kasper
Reporting & Analytics | | Webdannmark

0
Google Analytics Content Experiments don't deliver 50/50?

Our A/B test is actually delivering at about a 70/30 page view rate. 70% in favor of the original version and only 30% of the new. We are sending 100% of our traffic to this homepage test. Has anyone else experienced this? There seems to be a lot of folks experiencing this.....anyone know why?
Reporting & Analytics | | VistageSEO

0
Does Google Analytics use your data against you?

I couldn't find this question answered anywhere in Q&A, so I apologize if it's a duplicate of another post. I heard, about a year ago on either Web Pro World, or Warrior Forum that Google uses your visitor data in your Google Analytic account to rank your site. Someone said that when they took out the Google code, their site went from the third to the first page within 48 hours. That was then verified over the next couple of weeks by others. Their thought was that regardless of the optimized page and incoming link, if the site wasn't getting visitors, then it would be penalized. Since Google has the data, they would be able to use it. I then started using another, paid, solution - getclicky.com. While I like clicky, there is some info Google has that clicky doesn't, everyone integrates with Google analytics - like SEOmoz, and I'm paying a monthly fee. Now that I'm a part of a community of experts, what do you think? Have you noticed Google ranking you based on your analytics data? Has anyone experienced this, or heard about it before? Because I'd like to go back to using Google analytics. Thanks!
Reporting & Analytics | | DallasBonsai

0
New Google Analytics Site Speed tool and excel

Hello, I was wondering if there is a good tool or method to pull the new Google Analytics Site Speed data into excel and use this document to track site speeds on a weekly basis for multiple clients? Any good articles or how-to's would be awesome!
Reporting & Analytics | | Hakkasan

0