Updating conversion value of conversions (transactions) imported form Google Analytics

[Boštjan]

Hope this is not a copy of another thread - looks like my previous post wasn't sent :(

I want to update conversion value of conversion which is set up as Import from GA, where I selected Transactions (not goals):

So I have a GA view which tracks transactions. I have gAds account with settings above and which imports GA transactions OK. And I want to update conversion values inside gAds.

I was testing few things and at the end tried to update conversion value with gSheet upload, using Order ID (https://docs.google.com/spreadsheets/d/1pRCbG2MFOKzh1hOqt4k3HY8QWpSMDiRkCAaje-ecDY8/edit). It didn't work (errors about conversion name not found in gAds although I was using exactly the same name as in column Conversion action in image above) so I asked our local gAds support team for help. They said that uploading conversion adjustments for conversions that are imported from GA doesn't work. BTW, uploading conversion adjustments for conversions that were set up as Website conversions (sent with JS - gTag inside website's HTML code) works OK.

They suggested API method OrderIdOfflineConversionAdjustmentFeed (https://developers.google.com/adwords/api/docs/reference/v201809/OfflineConversionAdjustmentFeedService.OrderIdOfflineConversionAdjustmentFeed). Since I want to suggest to our client the solution that is verified (they'd have to implement Google Ads API which could take quite a lot of time and money), I have few additional questions that gAds support team wasn't able to answer:

1. Since this method does actually the same as I was trying to do with gSheet upload and since upload didn't work for GA conversions - will this method work for conversions imported form GA?
2. If yes, the only parameter that I see appropriate in the specs to match GA transaction (order) and gAds conversion is orderID, where I'd use the value of Transaction ID in GA?
3. If no, is there any other API method that can achieve what I want?

Best,

Boštjan

[Boštjan]

Or am I just stuck with simply sending adjusted conversion value already into the GA (as adjusted transaction revenue) ?

[Bharani Cherukuri (AdWords API Team)]

Hello Boštjan, 

There are two types of adjustments that can be made using the OfflineConversionAdjustmentFeedService, one using the GCLID and the other using the Order ID. You can adjust a conversion by uploading an OrderIdOfflineConversionAdjustmentFeed object when you have an order ID available instead of a click ID and conversion time. Google Ads uses the combination of order ID and conversion action name in your spreadsheet to identify the conversion that you'd like to adjust. When using Order ID, please make sure to enter the order ID as a string. You may refer to the code samples available here in different languages as a reference. 

Let me know if you are facing any issues with this. 

Regards,

Bharani, AdWords API Team

[Boštjan]

Hi, thanks for the answer. I've seen these help articles, but they don't answer my questions. Articles explain how to update conversion value with API if conversion data is sent into gAds directly from the website through conversion tag, present in the HTML code. I understand that logic. And since I can achieve same result with uploading conversion values with gSheets I'm sure it works fine.

What I'm trying to find out (hopefully I'll get quicker answer here instead of setting up my own API tests) is if I can update conversion value with API if conversion data is sent into gAds from Google Anayltics. In this case gSheet upload doesn't work. So the only other option is using API, which I'm not sure it works ...

I'll just post few images to make a simple case.

Step 1: I have a convesrion (transaction) in GA: see that my transaction ID is T003

Step 2: Conversion setup in gAds: just ignore no recent conversion status since I've tested this a while ago, but you can see that the conversion is present in gAds and the value is 12.34 €:

My question: since this is GA transaction (not transaction directly from gAds conversion tag on the website) - if I use API method an OrderIdOfflineConversionAdjustmentFeed object with correct parameters' values, can I change the conversion value (to let's say 333.33), so my report in gAds would actually look like (see the difference in last column):

I just need to know if this is possible?

If it is, I should use correct parameter's values, the most important are orderId: 'T003' and conversionName: 'Transactions (All Web Site Data)'.

[Boštjan]

I have a couple of additional question if the scenario that I want in my previous post doesn't work.

I'm assuming that if I send conversion (online transaction) from my website into gAds directly with API (not with gTag conversion snippet and not through analytics import), then I'd be able to also update conversion value with OrderIdOfflineConversionAdjustmentFeed object, right? It sounds logical. In that case:

1. I'm wondering which method I should use with API?

2. I'm wondering if/how will gAds know which campaign/ad/keyword it should attribute the conversion to? Is this done automatically or do I need to send any additional params?

Thanks

[Bharani Cherukuri (AdWords API Team)]

Hello, 

You can adjust a conversion by uploading an OrderIdOfflineConversionAdjustmentFeed object when you have an order ID available instead of a click ID and conversion time. However, please note that the conversion has to already be reported in order to adjust it. 

For your second concern, you can use the AdWords API to upload offline conversions into Google Ads, giving you more flexibility in associating clicks with conversions. You may use the OfflineConversionFeedService to upload the click conversions offline. Please take a look at the validation rules and Tips which help you upload them successfully. You may then use the OfflineConversionAdjustmentFeed object to make adjustments. In order to map that specific click back to the Campaign or AdGroup, you may use the Click Performance Report  which will return these details. You can also add Value track parameters to the tracking template URL which will populate these values in the click URL. 

Let me know if you have any questions. 

[Boštjan]

Hi, sorry for late reply - I'm a bit occupied:) Please read below.

 

You can adjust a conversion by uploading an OrderIdOfflineConversionAdjustmentFeed object when you have an order ID available instead of a click ID and conversion time. However, please note that the conversion has to already be reported in order to adjust it. 

Yes, I understand that, but my question is about very specific scenario: will this 100% work if the conversion in gAds I'm trying to update the value of is set up as imported from Analytics and in this case I use Transaction ID from Analytics as a value for gAds API parameter orderID?

 

For your second concern, you can use the AdWords API to upload offline conversions into Google Ads, giving you more flexibility in associating clicks with conversions. You may use the OfflineConversionFeedService to upload the click conversions offline. Please take a look at the validation rules and Tips which help you upload them successfully. You may then use the OfflineConversionAdjustmentFeed object to make adjustments. In order to map that specific click back to the Campaign or AdGroup, you may use the Click Performance Report  which will return these details. You can also add Value track parameters to the tracking template URL which will populate these values in the click URL. 

I understand. Question: will I be able to see stats regarding those uploaded conversions like Number of conversions, All conversions value, Specific conversion value etc. (all those additional columns in default reports  that I can set/add, i.e. in Keywords report)? Something like this (check last columns):