Squeezing More SEM Information From Web Analytics

  |  May 13, 2009   |  Comments

Get more out of your search engine marketing campaign by squeezing more out of your analytics package.

Whether you're working on search engine marketing (SEM) in-house or at an agency, your ability to prove your worth is only as great as your ability to pull that proof from your analytics program. Today, let's examine two tips for more efficiently extracting SEM-based information from analytics programs.

Watching URLs as Well as Keywords

Everyone watches referring traffic sources to gauge the amount of search-driven visits to your site. Another popular report is the Referring Keywords report. That's appropriate because you need to be able to tell what types of terms are driving qualified traffic, not just driving traffic.

Watching the top landing pages is a similarly important, but is a less popular method to assess a campaign's success. If you can isolate the referring keywords that drive visits to specific URLs, you have a great deal of intelligence to use for site improvement.

In Google Analytics, begin at the Content | Top Landing Pages report. In the report body, click a URL or search for a specific page using the Find Page search box at the end of the report. Click the URL in the report and you'll see the full report on that URL's performance. In the Analyze dropdown box on that full report, select Entrance Keywords. The resulting report will show you the specific search phrases that brought people not just to the site, but to this specific URL.

To find the same data in Omniture SiteCatalyst, start at the Content | Pages report. Click the green magnifying glass icon next to the page in the report, which results in a dropdown box. Select Break down by: Traffic Sources | Search Keywords.

In addition to tracking efforts across your entire URL set, watching this data is a very helpful way to detect and examine the effectiveness of site links on a results page for a given query. For example, for two distinct queries that each produces a site-links result, one query might result in 90 percent of all clicks going to the main link, while the other query might result in a fairly even split among the main link and the remaining site links.

Export More and Wonder Less

When people analyze their SEM campaigns, a common frustration about various analytics packages is their inability to export complete data sets. In Google Analytics, for example, you can export any report to various formats such as CSV (define) and XML (define), but the reports can show only 500 rows. This can make it very frustrating to analyze a keyword report with thousands of rows, because many people still export 500 at a time and stitch them together in Excel.

Bypassing the export limits and pulling all the data from a Google Analytics report is very easy.

Go to the Google Analytics report that you want to export. Take note of the total number of rows of data in your report. For example, a keyword report might say, "Search sent 40,195 non-paid visits via 12,240 keywords." In this case, the important number is 12,240.

Go to the URL field of your browser. At the end of the URL, add the following characters:

&limit=12240

The number after the equal sign should match the number of rows you want to export.

After typing those characters, hit "Enter" or otherwise tell the browser to fetch that URL. (In Firefox or IE, for example, you could click the green right-arrow at the right side of the URL field instead of hitting "Enter." In Chrome, click the blue right-facing triangle.)

Export the data as you normally would, and your export document should have all the data you requested.

Here are some important notes about this technique:

  • Some people recommend simply using the phrase &limit=50000 to ensure that they capture all the data in a report. This works too, as long as your report has no more than 50,000 rows, of course.


  • After you append the &limit=X parameter to your URL and hit Enter, your screen will not look any different. This confuses a lot of people, because they expect all 12,000 rows to suddenly fill the browser window. This does not happen. The data appears only on export, not in the on-screen report.

I wish I could take credit for finding this, but I read it on a blog about a year ago and can't remember where it was. So to whoever found it, thanks.

Conclusion

Don't be satisfied with aggregated keyword data; instead, split it down to the URL level. If you think you know exactly what URL maps to each query term, you might be surprised to see the facts. And feel free to share additional metrics or analytics tips in the comments section, below. I'll post the best ones in a future column.

ClickZ Live San Francisco This Year's Premier Digital Marketing Event is #CZLSF
ClickZ Live San Francisco (Aug 11-14) brings together the industry's leading practitioners and marketing strategists to deliver 4 days of educational sessions and training workshops. From Data-Driven Marketing to Social, Mobile, Display, Search and Email, this year's comprehensive agenda will help you maximize your marketing efforts and ROI. Register today!

ABOUT THE AUTHOR

Erik Dafforn

Erik Dafforn is the executive vice president of Intrapromote LLC, an SEO firm headquartered in Cleveland, Ohio. Erik manages SEO campaigns for clients ranging from tiny to enormous and edits Intrapromote's blog, SEO Speedwagon. Prior to joining Intrapromote in 1999, Erik worked as a freelance writer and editor. He also worked in-house as a development editor for Macmillan and IDG Books. Erik has a Bachelor's degree in English from Wabash College. Follow Erik and Intrapromote on Twitter.

COMMENTSCommenting policy

comments powered by Disqus

Get the ClickZ Search newsletter delivered to you. Subscribe today!

COMMENTS

UPCOMING EVENTS

Featured White Papers

BigDoor: The Marketers Guide to Customer Loyalty

The Marketer's Guide to Customer Loyalty
Customer loyalty is imperative to success, but fostering and maintaining loyalty takes a lot of work. This guide is here to help marketers build, execute, and maintain a successful loyalty initiative.

Marin Software: The Multiplier Effect of Integrating Search & Social Advertising

The Multiplier Effect of Integrating Search & Social Advertising
Latest research reveals 68% higher revenue per conversion for marketers who integrate their search & social advertising. In addition to the research results, this whitepaper also outlines 5 strategies and 15 tactics you can use to better integrate your search and social campaigns.

WEBINARS

    Information currently unavailable

Jobs

    • Interactive Product Manager
      Interactive Product Manager (Western Governors University) - Salt Lake CityWestern Governors University, one of the 20 largest universities...
    • SEO Senior Analyst
      SEO Senior Analyst (University of Phoenix (Apollo Education Group)) - San FranciscoSEO Senior Analyst   Position Summary...
    • SEM & Biddable Media Manager
      SEM & Biddable Media Manager (Kepler Group LLC) - New YorkAs an Optimization & Innovation Manager at Kepler Group, you will be on the bleeding...