I have an ads script which exports data to a sheet based on rules.

However, I only want to replace data within a certain cell range such as 'A2:J' within a Google sheet.

I know how to do this within spreadsheetApp script but unsure/struggling on Ads script/AWQL.

I have pasted the basics of the script below but really could do with insight into whether and how it is possible to push to a specific range.

function main(){ // Put your Google data sheet here var sheetURL = ''; // Enter the tab name here var tabName = ''; var QUERIES = [{'query' : 'SELECT Date, DayOfWeek, HourOfDay, Device, CampaignName, Impressions, Clicks, Cost, Conversions, ConversionValue ' +                         'FROM CAMPAIGN_PERFORMANCE_REPORT ' +             'WHERE Impressions > 0 ' +                       'DURING TODAY',                       //'DURING ' + dateRanges,             'spreadsheetUrl' : sheetURL,             'tabName' : tabName,             'reportVersion' : 'v201809'            }                       ]; //This is to gather the above query and push it to the spreadsheet stated above   for(var i in QUERIES) {     var queryObject = QUERIES[i];     var query = queryObject.query;     var spreadsheetUrl = queryObject.spreadsheetUrl;     var tabName = queryObject.tabName;     var reportVersion = queryObject.reportVersion;     //Logger.log(spreadsheetUrl + " " + query);     var spreadsheet = SpreadsheetApp.openByUrl(spreadsheetUrl);     var sheet = spreadsheet.getSheetByName(tabName);     var report = AdWordsApp.report(query, {apiVersion: reportVersion});     report.exportToSheet(sheet);   } } 

I am trying to disable caching with zeep as is described here: https://github.com/googleads/googleads-python-lib/blob/master/README.md#how-can-i-configure-or-disable-caching

adwords_client = adwords.AdWordsClient(   developer_token, oauth2_client, user_agent,   client_customer_id=client_customer_id,   cache=googleads.common.ZeepServiceProxy.NO_CACHE) 

But I lack understanding of what I should provided ot AdWordsClient as ‘oauth2_client’ attribute.

I am trying to find the solution here http://googleads.github.io/googleads-python-lib/googleads.oauth2.GoogleOAuth2Client-class.html but without success so far.

I am using For OAuth2 process google_auth_oauthlib and I managed retrieved refresh token, but at this point I am kinda lost, because due to the fact that I am running it on GCP App Engine, I am not able to use googleads.yaml file.

Can somebody enlighten me in a case of this oauth2_client?

Thanks sincerely!

I've tried many different permutations of gtag and ga codes and I can't seem to get a positive conversion on Google Analytics.

This code runs on form submit and the Google Ad conversion in the first line registers a positive conversion in that platform. Google Analytics is what isn't showing the goal.

I'm NOT using the Google Tag Manager, but including the following global tag.

<script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', 'XXXXXXXX'); </script> 

As you can see here the lines I've marked as the attempts are as follows:

// This Google Ad Conversion works properly gtag('event', 'conversion', {'send_to': 'XXXXXXXX'}); // Attempt 1 gtag('event', 'Submit', { 'event_category': 'Form', 'event_label': 'Outdoor Kitchens Landing Oct 2019', 'value': 1 }); // Attempt 2 ga('send', 'event', 'Form', 'Submit', 'Outdoor Kitchens Landing Oct 2019', 1); // Attempt 3 ga('send', {   hitType: 'event',   eventCategory: 'Form',   eventAction: 'Submit',   eventLabel: 'Outdoor Kitchens Landing Oct 2019',   eventValue: 1 }); 

In order to make the ga code work, I had to include the following snippet in the HEAD.

<script>   window['GoogleAnalyticsObject'] = 'ga';   window['ga'] = window['ga'] || function() {     (window['ga'].q = window['ga'].q || []).push(arguments)   }; </script> 

The setup of the goal in Google Analytics is as follows (the label that is cut off reads "Outdoor Kitchens Landing Oct 2019"

When i am trying to send message via CURL i am getting error

{"meta":{"version":"v2.25.2","api_status":"stable"},"errors":[{"code":1014,"title":"Internal error","details":"Connection refused. Please check if wacore is running: wacore:6250"}] 

i killed containers multiple time but still getting same error, while waweb is working as usual i am able to import certificate and get tokens.

Below is the log of wacore container

I1028 19:34:39.252485    21 main.cpp:36] ---- FieldStats initialization ---- req_id=Main I1028 19:34:39.252826    21 fieldstats.cpp:170] FIELDSTATS: initialized with existing wam file: stream_id = 0, record_count = 144, event_count = 23, size = 1255, create_ts = 1572286537, rotated_size = 0, buffer_sequence_number = 1, dropped_event_count = 0, dropped_event_size = 0 req_id=Main I1028 19:34:39.257371    21 util.cpp:2979] Calling Get Orchestration req_id=Main I1028 19:34:39.257485    21 util.cpp:2998] Calling Get TemplateVersion req_id=Main I1028 19:34:39.258282    22 apiendpointmanager.cpp:167] Endpoint "healthcheck" is listening on address "0.0.0.0" port 6253 req_id=Main I1028 19:34:39.259002    23 apiendpointmanager.cpp:167] Endpoint "control" is listening on address "0.0.0.0" port 6252 req_id=Main I1028 19:34:39.259256    21 main.cpp:41] ---- ConfigStore initialization ---- req_id=Main I1028 19:34:39.259436    21 dbsettings.cpp:103] Changed default database engine from "SQLITE" to "MYSQL" req_id=Main I1028 19:34:39.260638    21 datastore.cpp:677] "create_configStore_139693946207872" connectOption: "MYSQL_OPT_RECONNECT=1;MYSQL_OPT_CONNECT_TIMEOUT=15;MYSQL_OPT_READ_TIMEOUT=30;MYSQL_OPT_WRITE_TIMEOUT=30" req_id=Main I1028 19:34:39.296638    21 datastore.cpp:94] Created database "configStore" req_id=Main I1028 19:34:39.298108    21 datastore.cpp:677] "configStore" connectOption: "MYSQL_OPT_RECONNECT=1;MYSQL_OPT_CONNECT_TIMEOUT=15;MYSQL_OPT_READ_TIMEOUT=30;MYSQL_OPT_WRITE_TIMEOUT=30" req_id=Main I1028 19:34:39.298339    21 datastore.cpp:148] Initiated DB connection "configStore"  of engine type "MYSQL" req_id=Main I1028 19:34:39.344069    21 datastore.cpp:354] Set sql_mode to "NO_AUTO_CREATE_USER,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE" req_id=Main I1028 19:34:39.345626    21 configstore.cpp:546] Creating cluster info req_id=Main I1028 19:34:39.345705    21 configstore.cpp:1064] App settings does not exist req_id=Main I1028 19:34:39.345715    21 configstore.cpp:857] Creating cluster_info table req_id=Main I1028 19:34:39.350646    21 configstore.cpp:870] cluster_info table created req_id=Main I1028 19:34:39.353032    21 configstore.cpp:1064] App settings does not exist req_id=Main I1028 19:34:39.363816    21 configstore.cpp:202] ConfigStore is initialized successfully req_id=Main I1028 19:34:39.364192    21 mainutil.cpp:473] trying to open log file  "/usr/local/waent/logs/wa-service-4be3d54f-crash.log" req_id=Main I1028 19:34:39.364240    21 main.cpp:324] "---- WhatsApp Service 2.25.2 wa-service Startup ----" req_id=Main I1028 19:34:39.364251    21 main.cpp:327] WhatsApp Account at startup: "" req_id=Main I1028 19:34:39.365712    21 crashloguploader.cpp:46] Crash log uploader upload req_id=Main I1028 19:34:39.365871    21 crashloguploader.cpp:59] uploader sees total files to upload  0 req_id=Main I1028 19:34:39.366093    21 util.cpp:3503] "invalid" should only contain numbers req_id=Main I1028 19:34:39.366130    21 util.cpp:3503] "invalid" should only contain numbers req_id=Main I1028 19:34:39.366142    21 util.cpp:431] Expire jitter adds 388 hours to the expire window req_id=Main W1028 19:34:39.366174    21 util.cpp:461] Missing login credentials: no username req_id=Main E1028 19:34:39.366215    21 chatapp.cpp:191] Aborting normal startup due to missing login credentials req_id=Main I1028 19:34:39.366266    21 chatservice.cpp:479] Unable to initialize the chat application req_id=Main I1028 19:34:39.366282    21 chatapp.cpp:1041] Setting chat state to: ChatState::Type(Disconnected) req_id=Main I1028 19:34:39.366291    21 cryptoprovider.cpp:48] Shutting down crypto provider req_id=Main W1028 19:34:39.366297    21 chatservice.cpp:208] Chat service could not initialize, send SIGHUP to retry req_id=Main I1028 19:34:39.366340    21 main.cpp:340] Chat service started, entering event loop req_id=Main 

It will be great help if someone can guide me the exact problem to resolve.

Following is the configuration which i used. BTW.

wacore: image: docker.whatsapp.biz/coreapp:v${WA_API_VERSION:?Run docker-compose with env var WA_API_VERSION (ex. WA_API_VERSION=2.23.4 docker-compose )} command: ["/opt/whatsapp/bin/wait_on_mysql.sh", "/opt/whatsapp/bin/launch_within_docker.sh"] volumes: - whatsappMedia:/usr/local/wamedia env_file: - db.env environment: # This is the version of the docker templates being used to run WhatsApp Business API WA_RUNNING_ENV_VERSION: v2.2.3 ORCHESTRATION: DOCKER-COMPOSE network_mode: bridge

<script data-ad-client="ca-pub-xxxxxxxxxxxxxxxx" async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> <script>(adsbygoogle = window.adsbygoogle || []).push({});</script>`<ins class="adsbygoogle" style="display:inline-block;width:728px;height:90px" data-ad-client="ca-pub-xxxxxxxxxxxxxxxx" data-ad-slot="xxxxxxxxxx"></ins>