Export aggregated product data from pMax campaigns

[Djounaid Mukhadinov]

Hello everyone,

It's the fist time that I am contacting this forum, sorry If I missed anything. 

I'm not familiar at all using scripts, I'm barely discovering these technics. 

I have the following question: How do I export product data from my pMax campaigns in aggregated way ?

I know how to export product data for each campaign directly from Google Ads platform.

What I need is, export product data from all my pMax campaigns (16 in total) at once in a Google Sheet. As I have some of my products distributed accross different campaigns, I would like to merge same product data to avoid duplicates (via product_id) for example. 

Does anyone know the right script to do it ?

Thanks in advance.

Djounaid.

[Banse Mutner]

Vào Th 6, 2 thg 6, 2023 vào lúc 13:12 Djounaid Mukhadinov via Google Ads Scripts Forum <adwords...@googlegroups.com> đã viết:

--
-- 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/8104a31f-4dd8-4452-8629-99ce905ac4b8n%40googlegroups.com.

[Google Ads Scripts Forum Advisor]

Hi Djounaid,

 

Thank you for reaching out to the Google Ads Scripts Forum Channel.

 

Per my understanding, it appears that you are filtering on a specific campaign since you are able to retrieve information on one campaign. I believe you that if you would like to retrieve the same information, but would like it for all of your performance max campaigns, then you would just need to follow the same approach and remove the filter on the single campaign you're retrieving information on.

 

On the other hand, I would recommend creating a report using the shopping_performance_view <https://developers.google.com/google-ads/api/fields/v13/shopping_performance_view> as it provides Shopping campaign statistics aggregated at several product dimension levels. You would just need to include the field campaign.advertising_channel_type in your query filtered on PERFORMANCE_MAX.

 

If you would like to export the results in a spreadsheet, you may follow the following guides whichever fits your use-case:

• Append rows to a spreadsheet - https://developers.google.com/google-ads/scripts/docs/examples/spreadsheetapp?hl=en#append-rows-to-a-spreadsheet
• exportToSheet(sheet) - https://developers.google.com/google-ads/scripts/docs/reference/adsapp/adsapp_report?hl=en#exportToSheet_1

 

Let us know how it goes or if you have any clarifications.

 

This message is in relation to case "ref:_00D1U1174p._5004Q2lw1Gr:ref"

Thanks,
 

Google Ads Scripts Team