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?

I am getting a USER_PERMISSION_DENIED error while making google ads API call. Upon googling I got to know that we need to pass login customer id and client customer id while making API call?

1. I want to understand what is the difference between login customer id and client customer id?
2. How do I get login customer id and client customer id ?
3. When do I have to use both login customer id and client customer id while making API call? Some sample code examples to use both login customer id and client customer id using java library would be helpful