During checking traffic source on e-commerce website i get confused.

I know that param gclid=.. means that user is tagged by GoogleAds, while fbclid works the same way but with facebook.

However, I dont understand what does it mean while they are both together in single url, like: www.example.com?gclid=CjwKCAiAyrXiBRAjEiwATI95mafT26kwak0CFBgICH0ZlLqafSBuyyoUBVZihf22pPdG9QK8DUmiZBoCh8YQAvD_BwE&gclsrc=aw.ds&fbclid=IwAR0oihEZbw0Q43GXiv4YW9n_G9odTEcpxzLtMxjYYqgrTt5EM-BcKqrJyuU

Is it possible that google ads is displaying ads on facebook and that is why gclid and fbclid are attached to url at the same time?

Is there any UI view to send some input parameters to an Ads-script?

In the documentation I see it's only hard-coding inside the script?

I write my first *.gs file of Google Ads-script.

Is there any IDE or environment where I can add breakpoints or see the variables state?

I saw only logger printing, but that's not efficient to work with.

I have tried @Andrew's reply, but didn't manage:

When I run an ads-script to call the app-script::spreadsheet API, I get the following error:

var sheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL); var rangeValues = sheet.getRange(1, 1, sheet.getLastRow(), sheet.getLastColumn()).getValues(); ==> Cannot find method getRange(number,number,number,number) 

How can it be? Only a subset of the app-script sheet api is available from ads-script?

I'm able to list ads:

https://developers.google.com/google-ads/api/fields/v5/ad_group_ad

select     ad_group_ad.ad.id,     ad_group_ad.ad.name from     ad_group_ad 

And media files:

https://developers.google.com/google-ads/api/fields/v5/media_file

select     media_file.id,     media_file.media_bundle.url from     media_file 

But I'm unable to connect the two. I tried many things:

This gives: The following field may not be used in SELECT clause: 'ad_group_ad.ad.image_ad.media_file'.

select     ad_group_ad.ad.id,     ad_group_ad.ad.image_ad.media_file from     ad_group_ad 

Then this gives: Unrecognized field in the query: 'ad_group_ad.ad.image_ad.media_file.id'.

select     ad_group_ad.ad.id,     ad_group_ad.ad.image_ad.media_file.id from     ad_group_ad 

And tried to remove all the prefixes from ad_group_ad.ad.image_ad.media_file.id without any success. I also tried the ad_group_ad_asset_view, but that returned empty response for all the customers I tried, and it also doesn't have a media file ID.

Is there a solution?