Query to get Conversion Action Names containing vertical bar (pipe) symbol not working

[De1]

Hi all,

I have Conversion Action Name where some of the names have the vertical bar symbol in them (eg; "some words | some more word") and others that do not contain the vertical bar (eg; "some word some more words").

However, the query to get only the ones with the vertical bar does not seem to be working

var query = "SELECT customer.descriptive_name, segments.conversion_action_name, segments.year, segments.month "

    + ",metrics.all_conversions"

    + ",metrics.all_conversions_value"

    + ",metrics.conversions"

    + ",metrics.conversions_value"

    + ",metrics.cross_device_conversions"

    + ",metrics.value_per_all_conversions"

    + ",metrics.value_per_conversion"

    + ",metrics.view_through_conversions"

    + " FROM customer"

    + " WHERE segments.date BETWEEN '2018-01-01' AND '2019-10-31' AND segments.conversion_action_name LIKE '%|%'";

It seem to ignore the vertical bar completely. I also tried to escape it with backslash (conversion_action_name LIKE '%\|%') but that did not work either.

Any ideas?

Thanks

De1

[Google Ads API Forum Advisor Prod]

Hi De1,

Thank you for reaching out to us. I’m looking into this internally with my team and will get back to you as soon as I can.

Thank you,
Bryan, Google Ads API Team

ref:_00D1U1174p._5001USwyyO:ref

[De1]

Great!

Thank you!

[Google Ads API Forum Advisor Prod]

Hi De1,

Can you please provide the client customer ID of your account via reply privately to author so that I can further investigate the issue? 


Thanks,
Poki, Google Ads API Team

 

 

ref:_00D1U1174p._5001USwyyO:ref