In our last post about using Google Webmaster Tools SEO reports in Google Analytics for keyword traffic insights, we pointed out that this information is only available for 90 days.
What if you need to look back more than 90 days? As you can see below, as of today, there isn’t any data in GA from GWMT earlier than November 23.
Not a problem if you plan. You can set up a system to send yourself a monthly automated email containing the data.
For this to really work for you, do think ahead to what questions you’ll have to answer, and send yourself a few pre-segmented reports that will answer these questions. Reports can be appended to existing emails, so that you don’t receive a barrage of emailed reports. (For more about emailing reports, read the full Email & Export help article from the Google Analytics Help Center)
Landing page impression data by country or web property helps you see if you may need to localize or focus your efforts. What types of pre-segmented reports might you need for your landing pages or queries?
- Interested by country? United States, Canada, etc
- Interested by Google Search Property? Web, image, video, mobile (smartphone) search
- Interested in a specific group of keyword phrases by country?
It’s worthwhile reading further using the SEO webmaster tools reports in Google Analytics.
One thing that we’d like to point out is that you’ll have to use of Secondary Dimensions to segment your data by the country or the Google search property, since Segments cannot be used with these reports.
If you want to send yourself a specific group of keyword phrases by country (let’s say United States), use the in-report filter for the keyword phrase and select secondary dimension United States. Here’s the in-report advanced filter. Replace “your kw” with your keyword phrases:
To make this an automated email report, while you have this report customized:
- Click [Email]
- Select the email address that will receive the report
- Select the format – csv, Excel, Google Spreadsheets – whatever works best for you
- Select monthly and then day 3 or 4 (since data is 2 days lagged from GWMT to GA)
- Write a description in the body
For some of the more complicated questions, such as how many clicks by country and Google property you can use a Pivot Table and Secondary Dimensions.
Let us know if you find this useful, how you’re using it, or if you have any other suggestions.