Скрипт: Performance Max - показывает ключевые слова




function main() {
// enter your sheet url & the campaign ID below
let sheetUrl = 'https://docs.google.com/spreadsheets/d/1RYxQs1QJQTmiwpXnEjgaGj8cxxTRUwbsBsr7d9MOcbQ/edit#gid=0'; // enter sheet URL between the quotes
let campaignId = '16083516899'; // enter pmax campaign ID between quotes
// don't touch code below this line

let ss = SpreadsheetApp.openByUrl(sheetUrl);

let query = AdsApp.report(
`
SELECT
campaign_search_term_insight.category_label,
metrics.clicks,
metrics.impressions,
metrics.conversions,
metrics.conversions_value
FROM campaign_search_term_insight
WHERE
segments.date DURING LAST_30_DAYS
AND campaign_search_term_insight.campaign_id = '${campaignId}'
ORDER BY metrics.conversions
`
);

query.exportToSheet(ss.getSheetByName('Sheet 1'));

} // end main




Примечание: В поле: https://docs.google.com/spreadsheets/d/1RYxQs1QJQTmiwpXnEjgaGj8cxxTRUwbsBsr7d9MOcbQ/edit#gid=0

Копируем этот файл и ставим свою ссылку
В поле let campaignId = '16083516899' ставим ссылку какую нам нужно.