• Pat Grady

    The Search Terms report is best kept “secret” in PPC. Haha! Secret = you’ve gotta be willing to dig in for a few hours every day, so few do, it’s a “secret”.

  • http://www.facebook.com/carrie.hill1 Carrie Hill

    Hi Pat,

    I agree – why is something SO important SO hard to find?

  • Terry Whalen

    Hi Carrie, you actually can see revenue data in the AdWords search query reports. Just use the column picker to add those columns. And maybe at some point we’ll be able to add the Google Analytics columns into the search query report as we can now do for keywords/ad groups/campaigns.

  • http://www.facebook.com/carrie.hill1 Carrie Hill

    I just wrote a huge comment that the system apparently didnt like. Terry I just went back and checked the Keyword Details report and the columns available, revenue is not one of them. You can do it in Analytics, but not in AdWords…..

  • Terry Whalen

    That is odd. The only thing I can think of that might explain that is if the specific account you are checking is not tracking dynamic revenue values. But I did just check a pure lead-gen account, and ‘total conv. value’ is still a column option in keyword details (queries) page.

  • http://www.facebook.com/carrie.hill1 Carrie Hill

    That may be the case – my “value” columns are all returning 0′s. Its definitely worth looking into.

  • Terry Whalen

    Yes – where we are not really tracking revenue, those columns just return 0; but where we are, they are returning accurate data.

  • http://twitter.com/bgtheory Brad Geddes

    Hi Carrie,

    I also see the revenue column like Terry does.

    You mentioned that you need to cobble together reports to get all the data from GA into spreadsheets. There’s actually an easy way to get all the data at once (this works for any GA reports) that just involved changing the URL a tiny bit.

    First off, if you change the number of rows you are looking at to anything but the default, (10) near the end of the URL, you’ll see something like: explorer-table.rowCount%3D25/ Where the last number is the number of rows being displayed (25 in this case).

    You can change that number to anything you want (like 10,000 – don’t use commas in the URL string though) and the browser will load up 10,000 rows and the export will also contain that many rows. Sometimes you need a good machine to do it as if you choose 50,000+ rows, it will be rendered on the screen first – so it can crash a browser on occasion; but it’s must faster to download lots of GA data that way then merging reports.

  • http://twitter.com/WebmasterFormat Roko Nastic

    Revenue = Total conversion value

  • http://www.facebook.com/carrie.hill1 Carrie Hill

    Hi Brad,

    I see that now, there’s something not right about revenue tracking in my personal accounts, apparently.

    This does highlight one of my big Google gripes – WHY doesn’t AdWords and Analytics use the same words for the same thing? Why don’t they work together more closely? Why not use the word “Revenue” in the AdWords system?

  • Jörg Denner
  • http://twitter.com/edsaxman Ed Cehi

    Agreed…lol

    …Also… in the article Carrie mentions that “Cost per conversion is a figure that needs to be compared to revenue”… well…that’s what the “Conv. value / cost” column does… this is your Value to Cost Ratio which is what most companies use to determine if a keyword or campaign is profitable… the formula for it is “revenue ÷ cost” to make this a percentage of course just multiply by 100. For example:

    $1000 (revenue) ÷ $200 (cost) = 5 x 100 = 500% Value to Cost Ratio

    …so just take the “Conv. value / cost” Google already gives you, move the decimal over 2 places and there you have your Value to Cost Ratio.

    This article would be much better had further research been done I’m sorry to say, but at least it does bring awareness to those that were not already privy to this information… also may be worth noting that you can add filters to an profile in analytics to get this same information which would include your “Time on Site” data and “Bounce Rates” and such…but to much to list here…

  • http://www.facebook.com/matt.seakins.12 Matt Seakins

    Learnt this tip from Avinash around 2 years ago and it had helped me endlessly. I now find myself working in Analytics for analysis more than AdWords.