Welcome to the Q&A Forum

Hi guys, I'm looking to use google analytics google sheets extension to pull data into a google sheet with metrics from other tools e.g. semrush, moz, etc. From my understanding with google analytics google sheet extension its designed to run reports and doesn't really allow you to add other metrics. Basically what i'm trying to do is this: https://www.useloom.com/share/c1e42bfa60bd46fca2b1120018969ce8 Any suggestions/advice on how to do this would be great. Cheers.

Hello, I was running universal GA via a GA Drupal module. We setup Google Tag Manager and setup a GA tag to run through GTM. When we pushed the GTM container live our Real Time was at around 1900 and when we turned off the Drupal module the Real Time was reporting around 1100. After 24 hours the sessions for that day were about 100k lower than what they usually are. Any ideas Why the larger discrepancy? Any places that are obvious to look? *I didn't setup the original Drupal GA module, nor do I know who did. Thanks

Hi All, This might be a silly question, but for all the properties I monitor in Google Analytics, I'm now showing no data for SEO Queries under Acquisition for the past 6 days. Normally I would expect a few day delay in queries, but nothing for 6 days is somewhat peculiar especially as it was functioning fine prior to November 12th. Does anyone have insight into what might be going on? Thanks! URaNMa3

Hello, I'm hoping one of you search geniuses can help me. We have a successful client who started seeing a HUGE spike in direct visits as reported by Google Analytics. This traffic now represents approximately 70% of all website traffic. These "direct visits" have a bounce rate of 96%+ and only 1-2 pages/visit. This is skewing our analytics in a big way and rendering them pretty much useless. I suspect this is some sort of crawler activity but we have no access to the server log files to verify this or identify the culprit. The client's site is on a GoDaddy Managed WordPress hosting account. The way I see it, there are a couple of possibilities.
1.) Our client's competitors are scraping the site on a regular basis to stay on top of site modifications, keyword emphasis, etc. It seems like whenever we make meaningful changes to the site, one of their competitors does a knock-off a few days later. Hmmm. 2.) Our client's competitors have this crawler hitting the site thousands of times a day to raise bounce rates and decrease the average time on site, which could like have an negative impact on SEO. Correct me if I'm wrong but I don't believe Google is going to reward sites with 90% bounce rates, 1-2 pages/visit and an 18 second average time on site. The bottom line is that we need to identify these bogus "direct visits" and find a way to block them. I've seen several WordPress plugins that claim to help with this but I certainly don't want to block valid crawlers, especially Google, from accessing the site. If someone out there could please weigh in on this and help us resolve the issue, I'd really appreciate it. Heck, I'll even name my third-born after you. Thanks for your help. Eric

Since I've become a fellow MOZer I've seen an increase on my sites and proud to say that ALL of my clients have now accomplished 1st page rankings on at least 2 of their top 3 keywords. Yes, I am as stoked as them. Although I am a bit worried because as I rank keywords and test them on Google and engines alike all of our rankings direct to the homepage. I am essentially new to SEO. So as happy as I am to be doing something right I'm worried I'm losing the end user. By having them need to Search our site/menus/blog for the keywords/phrase that got them to us will turn most searchers away. They want the content now. What am I doing wrong? My pages are pretty specific so I never cared to use rel-canonical's...I dont have duplicate content, other than your typical footer/side bar consistent info. So I'm curious where I've gone wrong. Little history on my sites: I Use Joomla 2.5 & 3.x. I manage seo details through sh404seo. I've cleaned all duplicates I can up other than what these dynamic cms generate by just using one. I've done fairly well and all my pages rank A for moz's onpage grader for the keyword optimized around. Any help is appreciate, THANK YOU!

Hello, After listening to the advice of many of you on this forum, I have managed to move my site up in the SERPS, close enough to where I want/need to be. My traffic has increased heavily, yet I am still not seeing a large increase in orders being placed. I am positive that I have the lowest prices on these items, and the most information available about them, yet I still can't seem to convert a lot of this traffic into sales. Can you guys please take a look at my site and provide some guidance on what I can/should do to help convert these visitors to customers? my site is : http://goo.gl/JgK1e Thanks

When using Google Analytics, what is the difference between total goal conversions and total goal completions? We have many goals set up in a lead generation environment. Therefore, the only element of conversion is submitted a lead and arriving on the "Thank You" page. THose thank you pages are tagged accordingly. When we run reports though, the number of "Total Goal Conversions" and "Total Goal Completions" never match up.

We use Google Analytics on our ecommerce site and we recently made several changes to an important page.  Due to logistical reasons, we couldn't perform a Google web optimizer test but tracked the page's numbers in analytics from before/after the changes were made. After a week, we noticed that the bounce rate on the page went up by about 10% but the dollar index also doubled.  We're trying to figure out how this could happen, since it seems kind of odd. Any feedback would be appreciated.