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 am looking for a way to get number of clicks per day between START_DATE and END_DATE. The documentation for Google ADS v10 is huge and so far I'm unable to get clicks per day.

NOTE: I'm able to get total number of clicks BETWEEN DATES but I need clicks / day. Could anyone help.

we are working with Google Big Query data with Google Ads native connector which transfers data from Google Ads to Google Big Query. We see all data about products in Smart Shopping/Shopping campaigns, but we have no data about products in Performance Max campaigns in Big Query.

Does anyone knows how to get data from these campaigns to Google Big Query or when it will be available?

Thank you

Disclaimer...I'm a Noob

I am writing a query from CampaignStats table that aggregates based on a stripped campaign label. The query returns correct values for all metrics except Impressions and Cost. No matter what I've tried so far, this figure still doesn't match. Here are the totals for two of my campaigns from yesterday (June 17th):

CampaignStats:

Date    label   Impressions cost    clicks  avg_cpc 6/17/2022   sat_brand   2687    140.472666  15  9.3648444 

CampaignBasicStats:

Date    label   Impressions cost    clicks  avg_cpc 6/17/2022   sat_brand   699 152.620961  15  10.17473073 

Utilizing the CampaignBasicStats table, I receive aggregated totals for all metrics that match the UI, including Impressions and Cost. The issue is there are metrics in CampaignStats and getting some illumination/information on what I may not be doing correct, will help in the future.

I did a JOIN with the Campaign table originally; the below query refers to a permanent table that I pulled out separately in case this was a cause of the discrepancy.

Code Below:

  SELECT     cs.Date,      EXTRACT(ISOWEEK FROM cs.DATE) AS isoweek,      cl.label,      (SUM(cs.Cost) / 1000000) AS cost,     SUM(cs.Clicks) AS clicks,      CASE WHEN SUM(Clicks)=0 OR SUM(Cost)=0 THEN 0 ELSE     ((SUM(Cost)/SUM(Clicks))/1000000) END AS avg_cpc,      SUM(cs.Impressions) AS Impressions,      CASE WHEN SUM(cs.Clicks)=0 THEN 0 ELSE     (SUM(cs.Clicks)/SUM(cs.Impressions)) END AS ctr,      SUM(cs.Conversions) as conversions,      CASE WHEN SUM(cs.Conversions)=0 OR SUM(cs.Clicks)=0 THEN 0 ELSE     (SUM(cs.Conversions)/SUM(cs.Clicks)) END AS cvr,      CASE WHEN SUM(cs.Conversions)=0 OR SUM(cs.Cost)=0 THEN 0 ELSE     (SUM(cs.Cost)/SUM(cs.Conversions))/1000000 END AS cost_per_conversion FROM    `bold-quanta-######.######_google_ads_dataset.CampaignStats_##########` cs JOIN   `bold-quanta-######.queried_permanent_tables.process_campaign_labels` cl ON   cs.CampaignId = cl.CampaignId GROUP BY   1, 2, 3 

I am trying to solve error from firefox console:

The resource from “https://googleads.g.doubleclick.net/pagead/viewthroughconversion/973891309/?random=1655454537427&cv=9&fst=1655454537427&num=1&guid=ON&resp=GooglemKTybQhCsO&eid=375603261&u_h=1080&u_w=1920&u_ah=1040&u_aw=1920&u_cd=24&u_his=5&u_tz=120&u_java=false&u_nplug=0&u_nmime=0&sendb=1&ig=1&frm=0&url=https%3A%2F%2Fwww.gm.gama-sklep.com.pl%2F&tiba=Meble%20-%20Internetowy%20Sklep%20Meblowy%20Gama&hn=www.googleadservices.com&rfmt=3&fmt=4” was blocked due to MIME type (“text/plain”) mismatch (X-Content-Type-Options: nosniff).

In previous topics on this forum usually problem was with script url and type but in this situation above url is called from google tag manager script which is delivered from google. Base script is typical for gtm and looks like this:

<!-- Google Tag Manager --> <script>     (function (w, d, s, l, i) {         w[l] = w[l] || [];         w[l].push({             'gtm.start':                 new Date().getTime(), event: 'gtm.js'         });         var f = d.getElementsByTagName(s)[0],             j = d.createElement(s), dl = l != 'dataLayer' ? '&l=' + l : '';         j.async = true;         j.src =             'https://www.googletagmanager.com/gtm.js?id=' + i + dl;         f.parentNode.insertBefore(j, f);     })(window, document, 'script', 'dataLayer', 'GTM-NXQN6F4'); </script> <!-- End Google Tag Manager --> 

Similar situation is when i try to add remarketing tag without gtm using js code from ads panel:

    <!-- Global site tag (gtag.js) - Google Ads: 482376610 --> <script async src="https://www.googletagmanager.com/gtag/js?id=AW-482376610"></script> <script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', 'AW-482376610'); </script> 

Above code will also report 400 error + mime type error.

Is this a problem releated to server?