Adwords revenue not showing in analytics

[pcs800]

I have started working for a company that already had adwords and analytics set up and linked. I have been asked to fingure out why no revenue shows up for adwords.
I've tried the official google forums to no avail so I thought I'd search out a different place to be, hopefully this is it.

Here's a sample from our adwords capaign management, does it look right?
347

Here's what shows in google analytics.
348

I have made sure the google tracking code, with correct ID is on the receipt page. I don't know what else to try.
I am new to adwords and analytics, but not new to seo or web admin.
Thanks for any help.

[deepsand]

You need to explicitly code the tracking script to capture the values of the data variables that you wish to have reported.

[pcs800]

The code that is in the receipt pages now is longer than the code given by google, so I think they've already tried that.
What would be a code snippet for capturing a sale that came from a customer clicking on a adwords ad of ours?
Like this?
'_TrackingItem.PriceEach', // unit price - required

[deepsand]

Assuming that it's the Order Dollar Value that you want to count as the Conversion Value, the AW script on your Conversion page will need to include the string "var google_conversion_value = <%= Total_Value %>", where "Total_Value" is the local variable computed by your server.

[pcs800]

Here's what's on there now.
XXXXX in place of our ID.
Also had to remove links because this is my second post, they'll allow me to post links after 10 posts.
Can you interpret it?

<script type="text/JavaScript">
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'XX-XXXXXXXX-X']);
_gaq.push(['_trackPageview']);
_gaq.push(['_addTrans',
'_Tracking.OrderID', // order ID - required
'_Tracking.AffiliateID', // affiliation or store name
'_Tracking.GrandTotal', // total - required
'_Tracking.TaxTotal', // tax
'_Tracking.ShippingAmount', // shipping
'_Tracking.BillingCity', // city
'_Tracking.BillingState', // state or province
'_Tracking.BillingCountry' // country
]);
<_LOOP Var="_Order">
<_ROW>
<_COLUMN>
_gaq.push(['_addItem',
'_Tracking.OrderID', // order ID - required
'_TrackingItem.SkuID', // SKU/code - required
'_TrackingItem.SkuName', // product name
'_TrackingItem.Category', // category or variation
'_TrackingItem.PriceEach', // unit price - required
'_TrackingItem.Quantity' // quantity - required
]);
</_COLUMN>
</_ROW>
</_LOOP>
_gaq.push(['_trackTrans']); //submits transaction to the Analytics servers

(function() {
var ga = document.createElement('script'); ga.type = 'text/JavaScript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https colon//ssl' : 'http colon //www') + '.google-analytics dot com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
</script>

[deepsand]

That's Analytics script, not AdWords Conversion script; two different things. Google's got so damned many ways of capturing & displaying data so as to be both confusing and providing of seemingly inconsistent data.

Select your AdWords column display to include Conversions / Total conv. value. If nothing shows up there, run an AW Report that includes "Total conv. value." Also, look to Reporting and Tools / Conversions. If still nothing, most likely the var google_conversion_value value is not being set.

In Analytics, look at the Ecommerce reports. Also, set up a Custom Report displaying the relevant Ecommerce Metric(s).

[pcs800]

I am not sure where to do this
Select your AdWords column display to include Conversions / Total conv. value Am I supposed to do this from AW or GA?
Are you also saying that I need to add a secondary script which is from AW along with the existing GA code that's on the receipt page?

[deepsand]

I am not sure where to do this

Select your AdWords column display to include Conversions / Total conv. value
Am I supposed to do this from AW or GA?
This is needed for Conversion Value to be displayed on AW pages. In order to get none-zero data, though, need AW Conversion script that sets the variable var google_conversion_value.



Are you also saying that I need to add a secondary script which is from AW along with the existing GA code that's on the receipt page?
You can use either or both.

AW Conversion data is of a limited nature (Conversion Count and Value only,) and reports only on AW transactions.

GA data are more diverse, and cover the universe of transactions.

[pcs800]

All we want to do is get some revenue data coming into GA that relates to the ads we payfor in AW, what would I do in addition to the script that's already in the receipt page?

[deepsand]

AdWords and GA data are different and separate.

To have the Conversion Revenue show in the AW display that you cited in your opening post, you need to have your AW Conversion code capture the Order Total per post no. 4 (http://www.webproworld.com/webmaster-forum/threads/111593-Adwords-revenue-not-showing-in-analytics?p=581886&viewfull=1#post581886), and then activate the Conversions / Total conv. value column of that display page, per post no. 6 (http://www.webproworld.com/webmaster-forum/threads/111593-Adwords-revenue-not-showing-in-analytics?p=581897&viewfull=1#post581897).

If you further want AW to pass data to GA, you need to link the two, per Google Analytics Help: How do I link my Google Analytics account to my AdWords account? (http://www.google.com/support/analytics/bin/answer.py?answer=55507).

[rebecca-may]

Make sure you have the e-commerce version of Analytics installed (it's just a tick box on the set up page). Then, generally, in you e-commerce system you can tick an other box to allow analytics to have access to your revenue data. Then Google does the rest with the code...

[pcs800]

Akright, if I want to include revenue then I need to use
"var google_conversion_value = <%= Total_Value %>"
Lets say a product is $74.95, I would use "var google_conversion_value = <%= 74.95 %>" ?

I don't know what you mean by "Select your AdWords column display to include Conversions / Total conv. value"
From within adwords I do not see an option to include Conversions/Total conv. value

The AW and GA accounts are already linked.

Sorry for all the seemingly simple questions, but yes you are right, google has a load of ways to collect data, and being new at it combined with jumping into a fairly large company with an already established aw and ga setup, it's quite confusing.
Thanks for your help so far, much appreciated.

[pcs800]

Rebecca, when you say e-commerce version of analytics installed, I am assuming you mean accessing it from googles servers rather than installing something local? I went to settings in GA and don't see any tick boxes for accessing AW revenue data, ugg this is a mess.

[pcs800]

Do I need to check the box marked "AdWords Cost Source Settings"?

[pcs800]

Ok, I have been searching on this all day.
1 - I cannot for the life of me find where to get the Adwords tracking code for one of my ads. I've looked all over Adwords web site, help sections, googled it, etc. Nothing. It seems the code is only given when you create an ad?
2 - The code (if I were able to get it, would need to go on the receipt page for the product the adwords are promoting. I've looked on the page and the only script on there is from Google Analytics.

I did find this in a forum, which seems to show an example of adding custom lines for tracking ROI.


Advanced Option
Purchase Conversion, $5.00 value: Sample code snippet only - DO NOT USE
<!-- Google Code for Purchase Conversion Page -->
<script language="JavaScript" type="text/javascript">
<!--
var google_conversion_id = 1234567890;
var google_conversion_language = "en_US";
var google_conversion_format = "1";
var google_conversion_color = "666666";
var google_conversion_label = "Purchase";
//-->
if (5.0) {
var google_conversion_value = 5.0;
}
</script>
<script language="JavaScript" src="http colon//www dot googleadservices dot com/pagead/conversion.js">
</script>
<noscript>
<img height=1 width=1 border=0
src="http colon //www dot googleadservices dot .com/pagead/conversion/1234567890/?value=5.0&label=Purch
ase&script=0">
</noscript>

So where do I get the code for my ads?

[deepsand]

Make sure you have the e-commerce version of Analytics installed (it's just a tick box on the set up page). Then, generally, in you e-commerce system you can tick an other box to allow analytics to have access to your revenue data. Then Google does the rest with the code...
However, the appropriate script, capturing the data to be operated on, first needs to be present on the user pages. GA can only report on user data to the extent that it is captured by the user.

[deepsand]

I don't know what you mean by "Select your AdWords column display to include Conversions / Total conv. value"
From within adwords I do not see an option to include Conversions/Total conv. value.
On the various AW management screens, immediately below the tabs for Campaigns / Ad groups / Settings / Ads / Keywords / etal. is an inconspicuous drop-down menu labeled "Columns," which provide the single option "Customize Columns."

Within that are several groups of data types, the second of which is "Conversions." Where available - different report screens provide different data - "Total conv. value" will be at or near the bottom.


Sorry for all the seemingly simple questions, but yes you are right, google has a load of ways to collect data, and being new at it combined with jumping into a fairly large company with an already established aw and ga setup, it's quite confusing.
Thanks for your help so far, much appreciated.
It's not just newcomers that get stymied. I've just discovered that a client's conversion tracking, which was working perfectly for years, has gone into a black hole; not even getting the raw counts, in either AW or GA. :(

[deepsand]

Ok, I have been searching on this all day.
1 - I cannot for the life of me find where to get the Adwords tracking code for one of my ads. I've looked all over Adwords web site, help sections, googled it, etc. Nothing. It seems the code is only given when you create an ad?
2 - The code (if I were able to get it, would need to go on the receipt page for the product the adwords are promoting. I've looked on the page and the only script on there is from Google Analytics.

I did find this in a forum, which seems to show an example of adding custom lines for tracking ROI.


Advanced Option
Purchase Conversion, $5.00 value: Sample code snippet only - DO NOT USE
<!-- Google Code for Purchase Conversion Page -->
<script language="JavaScript" type="text/javascript">
<!--
var google_conversion_id = 1234567890;
var google_conversion_language = "en_US";
var google_conversion_format = "1";
var google_conversion_color = "666666";
var google_conversion_label = "Purchase";
//-->
if (5.0) {
var google_conversion_value = 5.0;
}
</script>
<script language="JavaScript" src="http colon//www dot googleadservices dot com/pagead/conversion.js">
</script>
<noscript>
<img height=1 width=1 border=0
src="http colon //www dot googleadservices dot .com/pagead/conversion/1234567890/?value=5.0&label=Purch
ase&script=0">
</noscript>

So where do I get the code for my ads?
The above code is just a copy of dummy sample code published on Google's Help pages.

To get the AW Conversion Code for your site, see the instructions at Google AdWords Help: How do I set up conversion tracking? (https://adwords.google.com/support/aw/bin/answer.py?hl=en&answer=86283).

This will be the script that gets places on your Confirmation page(s); i.e., the page that a user first reaches following his taking the action(s) that counts as a conversion. For e-commerce, this will be the page displayed immediately after a user commits to an order, the one that confirms receipt of his order.

[pcs800]

On the various AW management screens, immediately below the tabs for Campaigns / Ad groups / Settings / Ads / Keywords / etal. is an inconspicuous drop-down menu labeled "Columns," which provide the single option "Customize Columns."

Within that are several groups of data types, the second of which is "Conversions." Where available - different report screens provide different data - "Total conv. value" will be at or near the bottom.
Thank you! I actually found it!
I am guessing the data is wrong though until I get the AW script onto the receipt page, right?
For example, for example, I see this under "keywords"
351


It's not just newcomers that get stymied. I've just discovered that a client's conversion tracking, which was working perfectly for years, has gone into a black hole; not even getting the raw counts, in either AW or GA.
stymied is right! Thanks for your patience :-)


The above code is just a copy of dummy sample code published on Google's Help pages.

To get the AW Conversion Code for your site, see the instructions at Google AdWords Help: How do I set up conversion tracking?.

This will be the script that gets places on your Confirmation page(s); i.e., the page that a user first reaches following his taking the action(s) that counts as a conversion. For e-commerce, this will be the page displayed immediately after a user commits to an order, the one that confirms receipt of his order.
I have looked in AW help and everywhere else I could find. It seems the code is only given when you first create an ad. I will look some more and see what I come up with.

There's an image above that is barely showing, just FYI.

[deepsand]

Thank you! I actually found it!
I am guessing the data is wrong though until I get the AW script onto the receipt page, right?
For example, for example, I see this under "keywords"
351
Absent the Column Headings, I believe that I've deduced the contents of all but the two rightmost data fields. Presumably the next to last, showing a zero value, is the "Total conv. value," as this is what would be expected until such time as the variable "google_conversion_value" is populated.


I have looked in AW help and everywhere else I could find. It seems the code is only given when you first create an ad. I will look some more and see what I come up with.
Looks like we're both looking for the same thing now. In regards to the aforementioned problem re. a client's conversion stats going AWOL, I've determined that the ASP that handles the order entry capture wiped the AW conversion code from the confirmation page. :mad: Oddly enough, they left the GA code alone. :confused:

[pcs800]

Have you been able to find out how to obtain the AW code?

[pcs800]

Ok I finally found how to get the code, sheesh.
Here's a link to the instructions http://adwords.google.com/support/aw/bin/answer.py?hl=en&answer=115794

Since the receipt page template is used for all product sales, I am wondering how it will collect data only for the chosen add and it's relation to sales of that product? Would it be this line in the code?
var google_conversion_label

[deepsand]

Those are basically the same instructions as those I pointed to several posts back.

I'm not certain, but I believe that the specific ad in question is identified by "var google_conversion_id = 1234567890."

BTW, it occurs to me that, since you're already getting Conversion Counts & Cost/Conversion data displayed in AW, you must somewhere already have AW conversion code in place.

[pcs800]

Yes, the company had put in place the aw code several years ago but it is on the wrong pages; download pages, install confirmation pages, etc. Those produce ncorrect data because a person can install a trial but not purchase.
Since poutting the code on the receipt page yesterday, there's still nothing reported. It shows "unverified", does that mean nobody has been to the receipt page at all, or nobody has been to the receipt page after clicking the ad?
If it says nobody has been there at all, it is mistaken and I have done something wrong. Or is there something I need to do in order to verify?

[deepsand]

Since poutting the code on the receipt page yesterday, there's still nothing reported. It shows "unverified", does that mean nobody has been to the receipt page at all, or nobody has been to the receipt page after clicking the ad?
If it says nobody has been there at all, it is mistaken and I have done something wrong. Or is there something I need to do in order to verify?
"Unverified" is returned until such time as a conversion resulting from an ad click is first recorded and reported, which can take several hours to be evidenced.

It's a good practice to test such by clicking on your own ad, and placing a dummy order, so that you can both capture the source code of the confirmation page that bears the conversion code, for possible troubleshooting purposes, and observe the reported data.

BTW, make sure that said code is in a static portion of the <body>, preferably close to </body>; and, that the confirmation page is not itself generated by a script call.

[pcs800]

Well nothing has changed as of the last post. Still says unverified so I went and did a google search for my adowrds keyword, clicked my ad and purchased the product. If that doesn't show up I don't know what to do nexrt. When I created the code for the receipt page, it said there will be a line of text on the page saying something like "data collected by google", but there's nothing of the sort on the receipt page.

[deepsand]

When I created the code for the receipt page, it said there will be a line of text on the page saying something like "data collected by google", but there's nothing of the sort on the receipt page.
The AW conversion script dynamically generates a small screen display advising buyer of their tracking action. If that was not displayed, then most likely either the code is in the wrong place, or the receipt page is being called by a script.

[pcs800]

Yes, the receipt page is a "Layout" called dynamically. I was unaware that was going to be an issue. What can I do to remedy the situation?
I have been speaking to support at our seller, they say the code has been placed in the right spot. They don't do it, I just told them where I put it and they said that is correct.

[pcs800]

Ok I found out that everything was correct, I had simply not "published" the layout I changed. So I have done another test purchase and "Google Site Stats - Learn More" was there this time, telling me it is working. Now I just have to wait for the sale to show up and see if I can get it over to analytics. Will keep you posted.

[pcs800]

Well, nothing is coming up in analytics that I can tell.As mentioned earlier, the two accounts are linked already.
Campaign says "not set" and revenue says zero.
Any ideas?

[deepsand]

Well, nothing is coming up in analytics that I can tell.
What about AW stats, which is what the conversion code that you just put the receipt page drives?

[pcs800]

Adwords shows this
377
From everything I have read, this shold be showing up in analytics too since I followed the instructions on linking the two in order to show AW data within Alanytics.

[pcs800]

Analytics shows this 378
I really need to get this populated, what does the "not set" mean?

[deepsand]

Adwords shows this
377
From everything I have read, this shold be showing up in analytics too since I followed the instructions on linking the two in order to show AW data within Alanytics.
Looks like you have yet to turn on display of "Total conv. value," as set froth at post no. 17 (http://www.webproworld.com/webmaster-forum/threads/111593-Adwords-revenue-not-showing-in-analytics?p=582185&viewfull=1#post582185), without which we can't see if the appropriate AW variable is being populated.



Analytics shows this 378
I really need to get this populated, what does the "not set" mean?
Not sure what screen you're viewing here; but, generally "no set" for GA means "not defined."

In this case,it appears that the data reported are an aggregation of all traffic, not just AW campaigns; i.e., you've not defined any report(s) that segregates data in any manner.

[pcs800]

Sorry it's been so long since I posted here. Got side tracked with other projects.
Total conv. value is turned on in adwords.
400

How do I define a new repor in analytics which includes only data from adwords clicks?

[pcs800]

I have been trying to create a custom report for this, but there's nothing for Adwords content available, only adsense. If there was another simple software product to perform this simple task I would switch to it in a heartbeat :-(

[pcs800]

Ok last post for the day....
Looking at adwords reports for the specific keyword i am trying to test with.
For specific date range
Clicks=285
Impressions=12,762
CTR=2.32%
Avergae CPC=0.09
Cost=$25.17
Conversions (1 per click)=28
Cost/Conv=0.90
Conv Rate=9.82%
View through conv=0
Total conv value=36.5

36.5 what? percent? sales? dollars?

How do I get a simple ROI on this?

[deepsand]

Total conv value=36.5

36.5 what? percent? sales? dollars?
Depends on how you have the AW conversion script coded.

[pcs800]

I don't know what that means, I have it copied and pasted right from their code page.
I set the dollar value to $34.95 which is the price of the product.

[deepsand]

Can you copy and paste here the code that you have in place?

[pcs800]

Sure, here it is.
--
<script type="text/javascript">
/* <![CDATA[ */
var google_conversion_id = XXXXXXXXXX;
var google_conversion_language = "en";
var google_conversion_format = "1";
var google_conversion_color = "ffffff";
var google_conversion_label = "n26aCKqSogIQ2J2I_wM";
var google_conversion_value = 0;
if (34.95) {
google_conversion_value = 34.95;
}
/* ]]> */
</script>
<script type="text/javascript" src="https://www.googleadservices.com/pagead/conversion.js">
</script>

[deepsand]

The syntax of the JavaScript If statement is


if (condition)
{
code to be executed if condition is true
}


As 34.95 is not a valid conditional test, the results are unpredictable.

In your case, with a fixed conversion value, you don't need a conditional setting of google_conversion_value.

Remove the if statement; and, change the one above it to read


var google_conversion_value = 34.95;

[pcs800]

So it should look like this?
-
<script type="text/javascript">
/* <![CDATA[ */
var google_conversion_id = XXXXXXXXXX;
var google_conversion_language = "en";
var google_conversion_format = "1";
var google_conversion_color = "ffffff";
var google_conversion_label = "n26aCKqSogIQ2J2I_wM";
var google_conversion_value = 0;
{
var google_conversion_value = 34.95;
}
/* ]]> */
</script>
<script type="text/javascript" src="https://www.googleadservices.com/pagead/conversion.js">
</script>

[deepsand]

Replace these two lines


var google_conversion_value = 0;
{
var google_conversion_value = 34.95;
}

with the single line


var google_conversion_value = 34.95;

[pcs800]

Like this?
-
<script type="text/javascript">
/* <![CDATA[ */
var google_conversion_id = XXXXXXXXXX;
var google_conversion_language = "en";
var google_conversion_format = "1";
var google_conversion_color = "ffffff";
var google_conversion_label = "n26aCKqSogIQ2J2I_wM";
var google_conversion_value = 34.95;
/* ]]> */
</script>
<script type="text/javascript" src="https://www.googleadservices.com/pagead/conversion.js">
</script>

[deepsand]

Looks right to me.

[pcs800]

Thanks, I'll try it.

[deepsand]

Please do not report that that failed as well. My hair is thin enough as 'tis. ;)

[pcs800]

I just put the code in place this morning so I will let you know tomorrow, try to think about something else to relieve the stress :-)

[pcs800]

I guess I am going to owe you some rogain....
As you can see from the screen shot below, the hits did start to show up around August 25th, but the revenue still says a big fat ZERO.
469

This is really taking more time than I anticipated, but the boss wants the info so i have to keep at it.

[deepsand]

That's a GA screen.

The data variable that you're setting via the AW script would, as earlier noted, drive the "Total Conv. Value" in the AW display that you earlier posted a screen shot of at post #35 (http://www.webproworld.com/webmaster-forum/threads/111593-Adwords-revenue-not-showing-in-analytics?p=586909&viewfull=1#post586909).

[pcs800]

Ok, so what do i need to do to get a number showing up in analytics?

[deepsand]

Are the Conv. Value data now being properly accumulated and displayed in AW?