CAMPAIGN_PERFORMANCE_REPORT WHERE Conversion action name CONTAINS "abc"

[Avkeren]

Hi All,

Is there an option to create a CAMPAIGN_PERFORMANCE_REPORT WHERE Conversion action name CONTAINS "abc"?

I want a report that will include only some of the Conversion action names of the Imported leads.

Thanks for the help,
Avkeren

[Google Ads Scripts Forum Advisor]

Hi Avkeren,

Could you please provide a screenshot of your Google Ads UI showing the report that you want to pull through Google Ads Scripts? This will greatly help us finding its equivalent field on the script reporting side.

Regards,

Teejay Wennie Pimentel Google Ads Scripts Team

ref:_00D1U1174p._5004Q2Ujdv3:ref

[Nils Rooijmans]

Hi Avkeren,

you might try something like this:

```javascript

var report = AdsApp.report("SELECT Conversions, ConversionTypeName FROM CAMPAIGN_PERFORMANCE_REPORT WHERE ConversionTypeName IN ['<CONVERSION_TYPE_NAME_1>', '<CONVERSION_TYPE_NAME_2>'] DURING LAST_30_DAYS");

```

Hope this helps,

Nils Rooijmans
https://nilsrooijmans.com
See my Google Ads Scripts FAQ to avoid the same mistakes I made: https://nilsrooijmans.com/google-ads-scripts-faq/

[Google Ads Scripts Forum Advisor]

Hello Nils,

 

Thank you for sharing your insight on the issue.

 

@Avkeren, you may try the solution provided by Nils and let us know if it fits to what you are trying to achieve in your use case.

 

If it still doesn't fit to your requirements, kindly share to us the screenshot of your Google Ads UI showing the report that you want to pull through Google Ads Scripts. This will help for better illustration of the issue and so we can provide a more precise solution.

Regards,

Michael Angelo Legaspi Google Ads Scripts Team

ref:_00D1U1174p._5004Q2Ujdv3:ref

[Avkeren Cohen]

Hi All,

Nils thank you very much...

Your direction was 1/2 way of what I needed. I was able to get the number of conversions in the Campaign for the selected ConversionTypeName.

The other 1/2 was to get also the cost but for that part, I got an error.

Invalid reporting query: Cannot select a combination of ConversionTypeName and AbsoluteTopImpressionPercentage,ActiveViewCpm,ActiveViewCtr,ActiveViewImpressions,ActiveViewMeasurability,ActiveViewMeasurableCost,ActiveViewMeasurableImpressions,ActiveViewViewability,AllConversionRate,AverageCost,AverageCpc,AverageCpe,AverageCpm,AverageCpv,AverageFrequency,AveragePageviews,AveragePosition,AverageTimeOnSite,BounceRate,ClickAssistedConversionValue,ClickAssistedConversions,ClickAssistedConversionsOverLastClickConversions,Clicks,ContentBudgetLostImpressionShare,ContentImpressionShare,ContentRankLostImpressionShare,ConversionRate,Cost,CostPerAllConversion,CostPerConversion,CostPerCurrentModelAttributedConversion,Ctr,EngagementRate,Engagements,GmailForwards,GmailSaves,GmailSecondaryClicks,ImpressionAssistedConversionValue,ImpressionAssistedConversions,ImpressionAssistedConversionsOverLastClickConversions,ImpressionReach,Impressions,InteractionRate,InteractionTypes,Interactions,InvalidClickRate,InvalidClicks,NumOfflineImpressions,NumOfflineInteractions,OfflineInteractionRate,PercentNewVisitors,RelativeCtr,SearchAbsoluteTopImpressionShare,SearchBudgetLostAbsoluteTopImpressionShare,SearchBudgetLostImpressionShare,SearchBudgetLostTopImpressionShare,SearchClickShare,SearchExactMatchImpressionShare,SearchImpressionShare,SearchRankLostAbsoluteTopImpressionShare,SearchRankLostImpressionShare,SearchRankLostTopImpressionShare,SearchTopImpressionShare,TopImpressionPercentage,VideoQuartile100Rate,VideoQuartile25Rate,VideoQuartile50Rate,VideoQuartile75Rate,VideoViewRate,VideoViews.

I no longer need this info but if you have an idea I will be happy to learn something new today. (but please don't spend too much time on it....)

Again thank you very much and all the best...

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to a topic in the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/FtgUfV18pyE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/SSZxQ000000000000000000000000000000000000000000000R5UE1O00DRmJ9NJTTEe-MGnNn30E5g%40sfdc.net.

[Google Ads Scripts Forum Advisor]

Hello Avkeren,

 

Thank you for responding back to us.

 

Could you kindly check if you have included incompatible fields with the ConversionTypeName in your query, you may check here for reference: https://developers.google.com/adwords/api/docs/appendix/reports/campaign-performance-report?hl=en#conversiontypename. Just click the Not compatible with the following fields icon and the list should show up.

 

If there is none, and the issue still persist, kindly provide to us the following information for us to check on our end:

• Customer ID / CID
• scriptname
• shareable link to the template sheet
• screenshot of the issue

You may send the requested details privately via "Reply To Author" button. If that doesn't work for you, you may send it directly to our alias at googleadsscr...@google.com. Then let us know here once the information has been sent.