ACCOUNT_PERFORMANCE_REPORT for selected campaigns

715 views
Skip to first unread message

EladB

unread,
Sep 30, 2021, 2:18:29 PM9/30/21
to Google Ads Scripts Forum
Hello,

Is there any abstraction that gathers one or more campaigns and allow selecting ACCOUNT_PERFORMANCE_REPORT for this group only?


I haven't seen such, but I wanted to make sure. Stats are at account level only. right?


Thanks

Google Ads Scripts Forum Advisor

unread,
Oct 1, 2021, 12:07:12 AM10/1/21
to adwords...@googlegroups.com
Hi EladB,

Thanks for reaching out. Harry here, from the Google Ads Scripts Team.

If you are inquiring about the Account Performance Report from the AdWords API in general, it is best to post questions in the AdWords API and Google Ads API Forum instead for better assistance. Nevertheless, let me provide insights as much as I can regarding your concern. I believe the account performance report would not let you filter reports data by specific campaigns. A workaround would be retrieving corresponding ExternalCustomerId of specific campaigns from the Campaign Performance Report and use those customer IDs to filter the account performance report by its ExternalCustomerId.

On the other hand, stats or metrics would be available across reports. In the Google Ads script perspective, the AdsApp.​Stats object can be retrieved across entities by using the getStatsFor method if available.

If you have other scripts related concerns, please let me know.

Thanks,
Google Logo
Harry Cliford Rivera
Google Ads Scripts Team
 


ref:_00D1U1174p._5004Q2OVbWy:ref

Elad Ben-David

unread,
Oct 1, 2021, 5:11:57 AM10/1/21
to Google Ads Scripts Forum on behalf of adsscripts
Thanks,

I was referring to the Ads-script ACCOUNT_PERFORMANCE_REPORT.

A few questions, please:
1) Can I use a similar workaround with ads-script? (Saw this mapping table)
*AdsApp.Stats is perfect but requires more sum calculations.

2) Is there any easy snadbox or way to see the structure of a campaign's ExternalCustomerId? I thought ExternalCustomerId = AccountId only.

Another off-topic question:
Is there an automated way to duplicate an existing GAds account (create a new account & copy an existing account structure into the new one) ?

I have Googled a bit but haven't found such an API.
I saw this can be done manually with the Editor.

https://www.webmasterworld.com/google_adwords/3541656.htm
https://lucidgen.com/en/how-to-copy-google-ads-campaign/

Is there an automatic option with the Editor?
Is there an automatic option without the Editor?




--
-- 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/9Vpf4wICs9M/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/BCveZ000000000000000000000000000000000000000000000R0A63V004rTkraUxTLqcNYSQd9mGTQ%40sfdc.net.

Google Ads Scripts Forum Advisor

unread,
Oct 3, 2021, 11:07:19 PM10/3/21
to adwords...@googlegroups.com
Hi EladB,

Thanks for coming back. I would like to emphasize that reports are from the Google Ads API and AdWords API where they are just made available through scripts by using the AdsApp.​Report method but please see answers to your questions below:
  1. Can I use a similar workaround with ads-script? (Saw this mapping table)
    • Yes, the workaround provided should be applicable through scripts. Kindly assume that the all solutions from our team are in the Google Ads scripts perspective.
  1. Is there any easy sandbox or way to see the structure of a campaign's ExternalCustomerId? I thought ExternalCustomerId = AccountId only.
    • I believe the information on the structure of the ExternalCustomerId would not be externally available. However, I can confirm that the ExternalCustomerId is the same as AccountId or CID.
  1. Is there an automated way to duplicate an existing GAds account (create a new account & copy an existing account structure into the new one) ?
    • This is currently not supported through Google Ads scripts or even more so creating new copies of Google Ads entities like campaigns or ad groups.
  1. Is there an automatic option with the Editor?
    • ​​​​​​​This would be best answered by the Google Ads Editor Team and you can reach out to them through this link .
  1. Is there an automatic option without the Editor?
    • ​​​​​​​Please see #3. I believe this only currently possible through the Google Ads UI and the Editor.
Let me know of anything else specific to Google Ads scripts. 

Elad Ben-David

unread,
Oct 9, 2021, 5:57:49 PM10/9/21
to Google Ads Scripts Forum on behalf of adsscripts
Thanks, I will look into it.

Another question I have:

I have followed the official code [from][1]:

[![enter image description here][2]][2]



But Ads-script editor in GAds says my query is invalid:

      var today = AdsApp.report("SELECT HourOfDay, DayOfWeek, Clicks, Impressions, Conversions, Cost FROM ACCOUNT_PERFORMANCE_REPORT DURING 20211009,20211009", {apiVersion: 'v201809'});


`Invalid reporting query: ACCOUNT_PERFORMANCE_REPORT.` 


Thanks!

--
-- 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/9Vpf4wICs9M/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.

Google Ads Scripts Forum Advisor

unread,
Oct 11, 2021, 3:47:36 AM10/11/21
to adwords...@googlegroups.com
Hi EladB,

Thanks for getting back. I have replied to the new thread you have created so I'd appreciate it if you can reply there for better tracking of issues on our end. If you have questions still on the conversation we have on this thread, please do let me know.
Reply all
Reply to author
Forward
0 new messages