Posts tagged with google-ad-manager

I'm trying to convert the below PQL query (Publisher's Query Language) in to JSON format.

StatementBuilder statementBuilder = new StatementBuilder()   .where("CUSTOM_CRITERIA LIKE '%permutive'") .withBindVariableValue("orderId", orderId); 

Can any one help with this ? Thanks in advance !

I want to get the report as shown here https://prnt.sc/oG7ms7tOdVfH

The input is Country = USA Date from and Date to

But this gives non US states and it doesnt summarize the resuly by state names (not the state IDs)

Can anyone help me to get the REST API?

  curl "https://googleads.googleapis.com/v10/customers/${CUSTOMER_ID}/googleAds:searchStream" \    --header "Content-Type: application/json" \ --header "developer-token: ${DEVELOPER_TOKEN}" \    --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \    --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \    --data '{ "query": "       SELECT         PERFORMANCE COST       FROM LOCATION       WHERE COUNTRY = 'USA' AND           segments.date BETWEEN 20220101 AND 20220430      " }' 

Suppose if the value of Line item (Cost per Unit) is $45.45 in the report that we get from Google Ad Manager 360 UI , the same report when extracted through a java application using ad manager API gives value '45454000' . Why is this conversion done ? is it specific to any API version? I'm using v202111 in my application.

I'd like to set billing information for a Test Account, but I can't set it using the Google Ads library or even the Google Ads UI.

The message error is:

Your account's access level doesn't include billing information. If you need access to billing, speak with your account admin. 

I tried to search about it and found this google groups conversation, but I couldn't find what I'm looking for.

Any idea how to tackle this?