get conversion type/name using adwords scripts

[Jenny C]

I have various conversion tracking set up for my account, some a leads and some are purchases. How can I write a script so that it segments my conversions by conversion type or name? Similar to what you get when you download a report with "Conversion>Conversion name" as the segment?

Thanks

[Anash Oommen]

Hi Jenny,

This is not supported in AdWords Scripts.

Cheers,
Anash P. Oommen,
AdWords Scripts Team.

[christian cespedes]

Hi there!

Do you will have support to segment by conversion type name?

In our case we have one account with several conversion tracking code....

[Anash Oommen]

Hi Christian,

If you run reports, ConversionTrackerId is a segmenting column. Just include that column in addition to ConversionTypeName.

Cheers,
Anash P. Oommen,

AdWords Scripts Team.

[christian cespedes]

Hi Anash!

Thank you for your answer. Is it posible get this information with adwords scripts?

Best!

Christian 

[Anash Oommen]

Hi Christian,

Yes, AdWords API reports are fully supported in AdWords Scripts. See https://developers.google.com/adwords/scripts/docs/examples/reports for code snippets on how to run reports.

Cheers,
Anash

[christian cespedes]

Anash!

When I run the code the log show me this: Invalid reporting query: Cannot select a combination of Clicks and ConversionCategory,ConversionCategoryName,ConversionTrackerId,ConversionTypeId,ConversionTypeName. (line 52)

I Attached the adwords script code.

Thank you for your help!

Kind regards,

Christian 

[David Cabanillas]

Hi Anash,

Really it is not possible to get  the segments my conversions name with the Adwords Scripts. Similar to what you get when you download a report with "Conversion>Conversion name" as the segment?

I need something similar to ConversionCategoryName that gets the Conversions=>Conversion Categories bu for the Conversions=>Conversion Names.

Best.

[Tyler Sidell (AdWords Scripts Team)]

Hi David,

You might be interested in using the ConversionTypeName from the Account Performance Report.  Please let me know if this helps what you were looking for. 

var report = AdWordsApp.report(
"SELECT ConversionTypeName " +
"FROM ACCOUNT_PERFORMANCE_REPORT " +
"DURING LAST_MONTH");

Thanks,

Tyler Sidell
AdWords Scripts Team

[David Cabanillas]

I am not able to obtain the data that I need. I have upload a picture with the data that I'm looking for.

At keyword I click over segment=>Conversion=>Conversion Name and I need the All Conv for each conversion name (each red rectangle in the picture 2 for F and 2 for T).

Best.

[Tyler Sidell (AdWords Scripts Team)]

Hi David,

Have you tried using the following:

function main(){
var spreadsheet = SpreadsheetApp.openByUrl('SPREADSHEET_URL');
var report = AdWordsApp.report("SELECT AdGroupName, AdGroupId, ConversionCategoryName, AllConversions FROM KEYWORDS_PERFORMANCE_REPORT DURING LAST_MONTH");
var sheet = spreadsheet.getActiveSheet();
report.exportToSheet(sheet);
}

Thanks,

Tyler Sidell

AdWords Scripts Team

[David Cabanillas]

Hi Tyler,

Your proposal doesn't work in the way that I'm trying to obtain.

My query report is this one.

var report = AdWordsApp.report(

    'SELECT CampaignName,AdGroupName, AdGroupId, ConversionCategoryName,ConversionTypeName, AllConversions FROM KEYWORDS_PERFORMANCE_REPORT '+

    'WHERE  Id='+keywordId);

Per each keyword I want to get the AllConv Segmented by => Conversions=>Conversions Name. For example, once selected this segment in the adwords console I have this values:

Keyword     Status    Max CPC    Clicks    Impr   CTR   AVC CPC    Cost   Avg Pos.   Conversions  All conv.

[word 1]    Eligible      0.1              22        100    22%   €0.40          100      3.4           100.00         104.00

X-F                                             --           --       --        --               --         --             90.00        92.00

X-P                                             --           --       --        --               --         --             2.00         3.00

X-T                                             --           --      --         --               --         --             8.00         9.00

The keyword has an All conv = 104.00 but I want to get the values segmented (i.e. X-F 92.00, X-P 3.00 and X-T 9.00).

[Tyler Sidell (AdWords Scripts Team)]

Hi David,

Reports in AdWords Scripts does not segment the data the exact way for your particular use case.  

Thanks,

Tyler Sidell

AdWords Scripts Team

[David Cabanillas]

Hi Tyler,

but the API will provided this functionality in a near future?

Theoretically, an API should provided the same functionality that the console/tool.

Thanks.

[Tyler Sidell (AdWords Scripts Team)]

Hi David,

I understand, but there are currently features available in the API that are not available in Scripts and vice-versa.  I can not speak about future roadmaps but I will update this thread if this becomes available in Scripts.

Thanks,

Tyler Sidell

AdWords Scripts Team

[João Gustavo Zanella]

Hi,

are there any updates related to that?
Can I run a script selecting entities based on "Conversion Name" metrics?

Thanks

[Anthony Madrigal]

Hi Joao,

You should be able to use the field ConversionTypeName in any of the reports listed here.

If you are facing issues in adding this field, can you please create a new thread with some details.

Regards,

Anthony

AdWords Scripts Team

[João Gustavo Zanella]

Hi Anthony,

what I want is to take an action based on one of the conversion rates (name based).
E.g: if the conversion rate (for an specific conversion name) is lower than X%, pause the keyword.

is this possible?

Thanks

[Anthony Madrigal]

Hi Joao,

Yes, this is possible. You will first need to run the report then use a selector to get the keywords that need to be paused. Please note that you won't be able to combine the ConversionTypeName with the fields listed under Not compatible with the following fields.

If you are only interested in one conversion name, you can use a withCondition on the ConversionTypeName.

If you are having trouble, please create a new forum thread detailing your issues.

Regards,

Anthony

AdWords Scripts Team