Google Analytics help - exporting reports
-
Hey mozzers,
A little help if you will.
I am in traffic sources > sources > search > organic
I am view keywords and comparing 1 month with another.
Now I see what 1 keyword sends 1st month, 2nd month and % Change.
I want to export this data to an .xls file. When I do, I end up with a file that shows what 1 keyword sends 1st month and 2nd month, but no % Change!
I really need to include this in exported document....
Summary: Analytics hates me.
-
Thanks Nathan,
That saved me a lot of hours!!
-
Yeah, that would be a nice feature to have in export. The way we've done it is to add a column to show % change and used a forumula like =C1/C2 to show the percentage increase. Hope that helps!
And PS - Analytics doesn't hate you. It's just finicky in places.
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
-
What is Local SEO in Google Analytics (Organic Source)
Recently, I saw "Local SEO" is mentioned as the organic source. Can someone please tell what is this and from where Google is fetching data for this source?
Reporting & Analytics | | Kevin.Monks0 -
Cross domain tracking Google Analytics
Hi there, Got a question on cross domain tracking: We have a couple of TLD's to serve localized content to our visitors, next to our main .com TLD where our app is running as well in a subdomain. Situation is this: Local sites:
Reporting & Analytics | | jorisbrabants
marketingsite.be
marketingsite.com.br
marketingsite.fr Main site: marketingsite.com
app.marketingsite.com Conversion gets triggered when somebody ends up in app.marketingsite.com/firstuse for example. People can sign up at the local site filling in their email but they end up in app.marketingsite.com/firstuse Reading this article on cross domain tracking I'm getting a bit confused on the setup of the tracking code itself. The sample code provided shows these two lines: ga('require', 'linker'); ga('linker:autoLink', ['maindomain.com','targetdomain.com']); Now the question 🙂 Is it correct when I think that maindomain should be replaced with our local TLD's on every one of those, and that targetdomain is where the conversion happens? In this case the .com site?0 -
Google Analytics to sub domains
Hi, I have a site xyz.com and two separate sites on sub domains xyz.com/abc and xyz.com/def. What's the best way to go about with GA such that I can get all the data in the same place. Should I use the GA code for xyz.com on sub domains as well? Or should I create separate profiles?
Reporting & Analytics | | mayanksaxena0 -
Google Analytics Custom Alert For Goal Completions?
Hi currently setting up custom alerts for a website. I want to do a custom alerts for when goal completions decrease or increase by a certain % e.g. 20% as shown in the third example from this Moz Article back in 2012 - http://moz.com/blog/7-essential-google-intelligence-custom-alerts-that-keep-me-sane However when i go into my GA account the only options seem to be for when the goal completion conversion rate % drops. I could use this, but i rather do just based on completions rather than %. Any ideas on how i can do this? Thanks.
Reporting & Analytics | | MBASydney0 -
Unique Users higher than Session on Google Analytics
How could us have a situation in Google Analytics where the unique users for given page is higher than the number of sessions?
Reporting & Analytics | | cbarron0 -
Google Analytics Queries
Hi we used a web company who put our analytics under their company name we have left them and set up a new tracking code not associated with them, but we still have access to the data and it is all contained under the same login, is it possible to merge the two tracking codes? so that we have seemless history. Also does anyone know if you can change the primary e-mail address (gmail account) to a corporate email account? Any help would be appreciated as we have researched both and from what we have found we can't merge the data and also we are stuck with the primary email address.
Reporting & Analytics | | loopylu030 -
Duplicate content? Split URLs? I don't know what to call this but it's seriously messing up my Google Analytics reports
Hi Friends, This issue is crimping my analytics efforts and I really need some help. I just don't trust the analytics data at this point. I don't know if my problem should be called duplicate content or what, but the SEOmoz crawler shows the following URLS (below) on my nonprofit's website. These are all versions of our main landing pages, and all google analytics data is getting split between them. For instance, I'll get stats for the /camp page and different stats for the /camp/ page. In order to make my report I need to consolidate the 2 sets of stats and re-do all the calculations. My CMS is looking into the issue and has supposedly set up redirects to the pages w/out the trailing slash, but they said that setting up the "ref canonical" is not relevant to our situation. If anyone has insights or suggestions I would be grateful to hear them. I'm at my wit's end (and it was a short journey from my wit's beginning ...) Thanks. URL www.enf.org/camp www.enf.org/camp/ www.enf.org/foundation www.enf.org/foundation/ www.enf.org/Garden www.enf.org/garden www.enf.org/Hante_Adventures www.enf.org/hante_adventures www.enf.org/hante_adventures/ www.enf.org/oases www.enf.org/oases/ www.enf.org/outdoor_academy www.enf.org/outdoor_academy/
Reporting & Analytics | | DMoff0 -
How do I set up Google Analytics to track paid visitors from Bing
When looking at Traffic Sources in Google Analytics, Google is broken out into paid and organic visits. I want to do the same with Bing. How do I do it?
Reporting & Analytics | | cpantages0