Ad Performance Report

[Daniel Heidt]

Hi,

 I used this link https://developers.google.com/google-ads/scripts/docs/solutions/ad-performance to add the template to my script. 

I changed the URL and added my email address as instructed. 

However, I'm encountering an error when I start the test.

This is the copy link I added into the script: 

https://docs.google.com/spreadsheets/d/1OAvi5TmsRFgbGXjnmaIxCy43_YrQyShP6TrNq6FgH-E/edit?gid=12#gid=12

6.9.2024 10:17:11
Error: Please specify a valid Spreadsheet URL. You can find a link to a template in the associated guide for this script. at validateAndGetSpreadsheet (Code:220:11) at copySpreadsheet (Code:85:23) at main (Code:11:23) at Object.<anonymous> (adsapp_compiled:20552:54)

I added the tamplate:

And changed the URL: https://docs.google.com/spreadsheets/d/1OAvi5TmsRFgbGXjnmaIxCy43_YrQyShP6TrNq6FgH-E/edit?gid=12#gid=12

What else do I have to change?

Kind regards,

Daniel

[Google Ads Scripts Forum Advisor]

Hi Daniel,

Thank you for reaching out to the Google Ads Scripts support team.

I would like to inform you that the error is related to defining an invalid spreadsheet or condition of the if statement to throw that error. Make sure that the last if condition in the code is “if (spreadsheeturl == 'YOUR_SPREADSHEET_URL')”. You might have added your spreadsheet url in this line. You have to add spreadsheet url and email address only in the “CONFIG” object and no need to add it in the if condition.

I hope this helps! Kindly get back to us with the below details if you still face any issues.

• Google Ads account ID or CID
• Name of the affected script
• Shareable spreadsheet link that you are using any in the script

You can send the details via Reply privately to the author option, or direct private reply to this email.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vFpmf:ref" (ADR-00267061)

Thanks,
 

Google Ads Scripts Team

[Nils Rooijmans]

did you insert the spreadsheet url at the right place in the code, and ONLY at that place (yellow)?

'spreadsheet_url': 'YOUR_SPREADSHEET_URL'

Hope this helps,

Nils Rooijmans
https://nilsrooijmans.com
See my Google Ads Scripts FAQ to avoid the same mistakes I made: https://nilsrooijmans.com/google-ads-scripts-faq/

[Google Ads Scripts Forum Advisor]

Hi,

@Nils - Thanks for your input.

@Daniel, I would suggest that you follow the inputs and kindly get back to us if you still face any issues. 

[DiSoTech]

Hi I don't know who is writing through my email, but I want to investigate!!!
I'm trying to change my password and I noticed that there are emails exchanged between someone and google... why??

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/ece85e05-b9c6-47b8-8358-5c65615b93e2n%40googlegroups.com.

[NTNM]

9/11/2024 12:48:36 AM
Using spreadsheet - https://docs.google.com/spreadsheets/d/17QksIazgAzgzflxA_EcjmUWKNy-cotvpfr1t3Svu_6E/edit?gid=3#gid=3.
9/11/2024 12:48:39 AM
Ca: MutateError.UNSPECIFIED: Specified version 'v10' not supported. at getReportRowForDuring (Code:267:24) at getReportRowForDate (Code:256:10) at main (Code:19:17)
How to resolve this?

[Google Ads Scripts Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads Scripts support team.

Kindly ignore my previous response.

I would like to inform you that the error “MutateError.UNSPECIFIED: Specified version 'v10' not supported” you are getting is due to the ‘apiVersion’ you are using in the script. Kindly change your ‘apiVersion’ in the code from ‘v10’ to ‘v17’ to resolve this error.

[hiền hoàng]

ok

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scrip...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/kzTiQ000000000000000000000000000000000000000000000SJJED300TQVCF-SfRtSLa1sSGYmlXg%40sfdc.net.

[Guillermo Caruana]

Hi guys,

I can't find any line in the code that refers to ‘apiVersion’ or ‘V10’ or ‘V17’.
Yours sincerely,

[Google Ads Scripts Forum Advisor]

Hi,

Kindly modify your ad performance script as follows: 

// Compute data.
  const fields = FIELDS.join(",");
  const results = AdsApp.search(`SELECT ${fields} FROM ad_group_ad ` +
        `WHERE metrics.impressions > 0 AND ` +
        `segments.date DURING LAST_7_DAYS`, {apiVersion: 'v17'});

If you face any issues, please provide us with the following details:

• Google Ads account ID or CID
• Name of the affected script
• Shareable spreadsheet link that you are using any in the script

You can send the details via Reply privately to the author option, or direct private reply to this email. 
 

[Guillermo Caruana]

Hello, 

I have modified the script but it still doesn't work.

account ID : 592-503-5061

Name of the script: Script RSA ad report 

Shareable spreadsheet : https://docs.google.com/spreadsheets/d/1L2pf3fp0jeTYN4PjaL9TikprshMNI0isjkvuRu1hvps

I have the following error message:

13/9/2024 11:46:59

Ca: QueryError.UNRECOGNIZED_FIELD: Unrecognized fields in the query: 'ad_group_ad.ad.discovery_carousel_ad.headline', 'ad_group_ad.ad.discovery_multi_asset_ad.headlines'. at outputSegmentation (Code:212:14) at main (Code:118:3)

 

Thanks,

Guillermo

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---

You received this message because you are subscribed to a topic in the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/i7HgfuJfhhU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/kNElv000000000000000000000000000000000000000000000SJPFNM00KG8mmvqUT_mEUWKVZZcUsQ%40sfdc.net.

--

CONFIDENCIALIDAD: El contenido de esta comunicación, así como el de toda la documentación anexa, es confidencial y va dirigido únicamente al destinatario del mismo. PRIVACIDAD: Para conocer la información sobre el tratamiento de sus datos personales visite nuestra política de privacidad.