This is awesome! Love the clear, concise explanation for this. Also, it's absolutely ridiculous how Google wants to make their campaign management a black box so that they can direct ad dollars to which ever product they want to hit their revenue targets for their investors!
Hi. The google sheet has not updated although I checked the scrip 100 times and is exactly like yours. Can it be because the campaign only runed for 2 days(it had clicks)?
Have you replaced the campaign id and Google Sheet url with your own? If you have set it to run on a weekly schedule, it may not have run yet after your initial setup.
Thanks a ton! I have one question though, after filling details in the 'keyword list' tab with the list name, do they automatically add new keywords when the 'exclusion list' is updated with new negatives or do we need to follow this process again for adding the new negatives.
Technically yes. You can change it to any date that suits you. So if you replace this section of code "WHERE segments.date DURING LAST_7_DAYS" with this "WHERE segments.date BETWEEN '2023-01-01' AND '2023-12-31" and replace the dates with the dates from when your campaign started to today's date, that will work.
@@wiktorawetisjan It's possible that your traffic isn't coming from search and is coming from display or RUclips instead. Can you see the split between the traffic?
Google still holds back some keyword data even with this workaround. They do the same thing in Google Search, if you check the search terms in one of your search campaigns you'll notice close to half of your impressions/clicks don't have any associated search terms.
I would avoid doing that unless you have a lot of data in your account and you are very familiar with the mechanisms Google uses to "acquire new customers". Most of the time, you're better off avoiding that option.
That can happen when the account you are signing into doesn't have access to the Google Ads account. You have to use the account you are signed into Google Ads with.
Thanks for the brilliant video. Very useful! I set this up last month but the negative keywords are still showing up in google sheet. Any help would be much appreciated.
Hi, I'm glad you found it useful! It's possible that your ads aren't showing in search and so not generating any search term data. Have you implemented the solution to see where your PMAX budget is being spent? You can find it here ruclips.net/video/6iW6BA59Njs/видео.html
@@3b1agency Thanks for getting back to me. I hadn't but I have done it now. It says search 60% and shopping 20% in the pie chart then below in the list it says Search 19% and shopping 60%. Not sure why they are different but in the pie chart, search is in the yellow part and shopping is in the blue.
@@aidsi3717 Ok so there should definitely be some search terms in your sheet. If they aren't in there still, can you try go through the setup process step by step again?
@@3b1agency Yes, I have search terms in the sheet and have added ST's to the negative keyword list but they still show in the sheet. The ST sheet is updating weekly.
thanks, this worked on one account but not another account. Remade several times so cant figure out what is going wrong. I get the headings with one row of numbers but no other data. Can anyone help please?
I would advise starting from scratch again on the second account, there might just be some small detail in the script code that wasn't pasted properly, or potentially a different name or URL on the Google Sheet.
@dmytrozozulia8086 That should be enough. However, it's possible your PMAX campaign isn't spending your budget on search ads or shopping ads. If that's the case, then you won't get any search terms in there. Here's a video that will show you how to implement a script to see your budget breakdown on PMAX - ruclips.net/video/6iW6BA59Njs/видео.html
You have to create the negative list yourself, they just add it to the PMAX campaign for you. But yes you will be able to find it in the same place as all of your other negative keywords lists.
Hi, I've tried to create the script but get this error "Could not create script at this time. Please try again at a later time." I'm definitely the admin on the account. I've tried various browsers and incognito. Any ideas?
Hey, so I did everything as shown in the video but it gives me a 400 error and I can not see the search terms or anything. Any idea what could be causing this?
Where are you seeing the 400 error? Is it in Google Ads or on the Google Sheet? Have you definitely created your own sheet and placed it into the script where indicated? This is the line of code I'm referring to "let sheetUrl = 'paste your spreadhseet url here'; // enter sheet URL between the quotes"
Hi Mari. Would you mind taking a few troubleshooting steps? Have you input the correct campaign id into the script? Is the PMAX campaign live and generating impressions?
Pmax been recording alot of conversions on my campaigns lately which are not conversions ! Not sure what is happening. My regular search campaigns are working fine and don't have this problem using the same container and tags
That sounds like an issue with your conversion tracking setup, which would be a bit different from this script. If your site is on WordPress, this conversion tracking webinar might be useful for you. ruclips.net/video/fqOS3UaXLFk/видео.html
hi! for what time period is the data displayed? I have over 1000 conversions in my PMAX ad, but the spreadsheet from the script only shows 300 in total. i would like to collect data since the start of the ad.
Hi Luca, by default it's set to 30 days. But you can change it to suit your needs. In this section of code "WHERE segments.date DURING LAST_30_DAYS", you can replace the 30 with 7, 14 and it will show that number of days. If you have a specific date you want to look at then you can change the dates completely, for example, you would replace that entire section I mentioned with "WHERE segments.date BETWEEN '2023-01-01' AND '2023-12-31" and replace the dates with whichever dates you like.
You will have to create a new script for each campaign, but you can send them all to the same Google Sheet. If you add a 2nd Sheet to the same file and call it Sheet2, then replace this code "query.exportToSheet(ss.getSheetByName('Sheet1'));" with "query.exportToSheet(ss.getSheetByName('Sheet2'));" it will send all of the data for your 2nd campaign there.
That conversion number sounds way high unless you have a really large budget, I think you might have setup your conversion tracking incorrectly. In terms of the sheet, have you set the script to recur automatically? It may just not have triggered again.
@@premanand4476 How often have you set it to run? If you have set it to repeat weekly as I suggested in the video, then it may not have run again yet. Can you try to run it manually? That should populate it. If that doesn't work then it's possible that one of the other steps along the way was missed, or else none of your PMAX traffic is coming from search or shopping ads (unlikely).
these "search terms" are not just being triggered on search though they are the keywords that are also triggering the ads on the display inventory of the PMAX campaign. So unless you are able to break out the volume from search vs display isnt the data misleading?
Hi Alan, I don't think it's misleading. You can break out the volume from search vs display with another script if you want to. Mike Rhoades has a great PMAX spend allocation script that gives a lot of insight into your PMAX spend mix.
Bro! You crushed it in this video. Super clear, super helpful! I hope this video blows up. THANK YOU!
Thanks Michael!
So helpful, thank you so much.
This is awesome! Love the clear, concise explanation for this. Also, it's absolutely ridiculous how Google wants to make their campaign management a black box so that they can direct ad dollars to which ever product they want to hit their revenue targets for their investors!
Thanks Saurabh!
Such a great, to-the-point video with a script that actually works!!! Thank you so so much, Christian!
Your welcome Megan!
Hi. The google sheet has not updated although I checked the scrip 100 times and is exactly like yours. Can it be because the campaign only runed for 2 days(it had clicks)?
Have you replaced the campaign id and Google Sheet url with your own? If you have set it to run on a weekly schedule, it may not have run yet after your initial setup.
Thanks gor your reply. I have replaced everything as per your video. I tough that if I refresh the page will load the kw automatically 😅.
@@studentu05 No problem, glad you were able to get it working.
Thanks a ton!
I have one question though, after filling details in the 'keyword list' tab with the list name, do they automatically add new keywords when the 'exclusion list' is updated with new negatives or do we need to follow this process again for adding the new negatives.
A perfect example of highly useful information without the fluff - great job thank you!
I'm glad you found it useful!
Thank you, the report is for the last 30 days. Can it be done to show entire history?
Technically yes. You can change it to any date that suits you. So if you replace this section of code "WHERE
segments.date DURING LAST_7_DAYS" with this "WHERE
segments.date BETWEEN '2023-01-01' AND '2023-12-31" and replace the dates with the dates from when your campaign started to today's date, that will work.
For those who are not using Google Sheets in English, try to change the sheet title to Sheet1 like in the 27th line of the script.
Thanks Joao, very helpful tip!
Very helpful, thanks for sharing! Is there a way to add cost metrics to this script to see avg. cpc and total cost for keywords?
Hi Clay, unfortunately not at this time.
In my sheet, the column under "campaign_search_term_insight.category_label" is blank. What gives?
Hi Arby, are the other columns populated?
@@3b1agency Same problem
"campaign_search_term_insight.category_label" is blank and there's only 1 row of the rest of the metrics
@@wiktorawetisjan It's possible that your traffic isn't coming from search and is coming from display or RUclips instead. Can you see the split between the traffic?
this seems to have stopped working. Getting an error around the sheet declaration in the script
This is great. How come on my sheet when it runs, the top result is a blank keyword and has loads of clicks and impressions attributed to it?
Google still holds back some keyword data even with this workaround. They do the same thing in Google Search, if you check the search terms in one of your search campaigns you'll notice close to half of your impressions/clicks don't have any associated search terms.
I have an Ecommerce furniture brand and plan to launch a Pmax campaign. Should I select the option "Optimize campaign for acquiring new customers" ?
I would avoid doing that unless you have a lot of data in your account and you are very familiar with the mechanisms Google uses to "acquire new customers". Most of the time, you're better off avoiding that option.
Excellent tutorial! To clarify, is campaign_search_term_insight.category_label pulling the search term category rather than the specific search term?
Hi Gabe, your google sheet will be populated with the exact search terms.
After I click run and authorize it makes me sign into a google account and then it gives me a 404 error?
That can happen when the account you are signing into doesn't have access to the Google Ads account. You have to use the account you are signed into Google Ads with.
Thanks for the brilliant video. Very useful!
I set this up last month but the negative keywords are still showing up in google sheet.
Any help would be much appreciated.
Hi, I'm glad you found it useful! It's possible that your ads aren't showing in search and so not generating any search term data. Have you implemented the solution to see where your PMAX budget is being spent? You can find it here ruclips.net/video/6iW6BA59Njs/видео.html
@@3b1agency Thanks for getting back to me. I hadn't but I have done it now.
It says search 60% and shopping 20% in the pie chart then below in the list it says Search 19% and shopping 60%.
Not sure why they are different but in the pie chart, search is in the yellow part and shopping is in the blue.
@@aidsi3717 Ok so there should definitely be some search terms in your sheet. If they aren't in there still, can you try go through the setup process step by step again?
@@3b1agency Yes, I have search terms in the sheet and have added ST's to the negative keyword list but they still show in the sheet. The ST sheet is updating weekly.
@@aidsi3717 Can you go in and double-check that Google have applied the negative keyword list to your campaign?
thanks, this worked on one account but not another account. Remade several times so cant figure out what is going wrong. I get the headings with one row of numbers but no other data. Can anyone help please?
I would advise starting from scratch again on the second account, there might just be some small detail in the script code that wasn't pasted properly, or potentially a different name or URL on the Google Sheet.
Same issue. Just one row under the titles poppulated
@@chiragdiwani3812 How long has the campaign been running? It may not have enough data to populate yet.
@dmytrozozulia8086 That should be enough. However, it's possible your PMAX campaign isn't spending your budget on search ads or shopping ads. If that's the case, then you won't get any search terms in there. Here's a video that will show you how to implement a script to see your budget breakdown on PMAX - ruclips.net/video/6iW6BA59Njs/видео.html
Once google add you negative list, is this visible in the ads interface like other negative lists would be?
You have to create the negative list yourself, they just add it to the PMAX campaign for you. But yes you will be able to find it in the same place as all of your other negative keywords lists.
It fails when I try
Hi, I've tried to create the script but get this error "Could not create script at this time. Please try again at a later time." I'm definitely the admin on the account. I've tried various browsers and incognito. Any ideas?
Hi Jane, that sounds like a temporary issue. If it continues then I think only Google support will be able to look into it for you.
Will adding the negative keywords at account level works
You're better off adding them to your list to keep more control
Hey, so I did everything as shown in the video but it gives me a 400 error and I can not see the search terms or anything.
Any idea what could be causing this?
Where are you seeing the 400 error? Is it in Google Ads or on the Google Sheet? Have you definitely created your own sheet and placed it into the script where indicated? This is the line of code I'm referring to "let sheetUrl = 'paste your spreadhseet url here'; // enter sheet URL between the quotes"
Is there any way to get spend by keyword?
my script came back with the header rows but no data, any way to troubleshoot? Thanks! Been wanting to find a workaround like this!!
Hi Mari. Would you mind taking a few troubleshooting steps?
Have you input the correct campaign id into the script?
Is the PMAX campaign live and generating impressions?
same issue
Pmax been recording alot of conversions on my campaigns lately which are not conversions ! Not sure what is happening. My regular search campaigns are working fine and don't have this problem using the same container and tags
That sounds like an issue with your conversion tracking setup, which would be a bit different from this script. If your site is on WordPress, this conversion tracking webinar might be useful for you. ruclips.net/video/fqOS3UaXLFk/видео.html
@3b1agency thank you much appreciated
Great video Christian. Clear and to the point. Well done.
Thanks Andy!
well done, this video deserves more views and likes
hi! for what time period is the data displayed? I have over 1000 conversions in my PMAX ad, but the spreadsheet from the script only shows 300 in total.
i would like to collect data since the start of the ad.
Hi Luca, by default it's set to 30 days. But you can change it to suit your needs. In this section of code "WHERE
segments.date DURING LAST_30_DAYS", you can replace the 30 with 7, 14 and it will show that number of days. If you have a specific date you want to look at then you can change the dates completely, for example, you would replace that entire section I mentioned with "WHERE
segments.date BETWEEN '2023-01-01' AND '2023-12-31" and replace the dates with whichever dates you like.
What about for multiple Pmax Campaigns?
You will have to create a new script for each campaign, but you can send them all to the same Google Sheet. If you add a 2nd Sheet to the same file and call it Sheet2, then replace this code "query.exportToSheet(ss.getSheetByName('Sheet1'));" with "query.exportToSheet(ss.getSheetByName('Sheet2'));" it will send all of the data for your 2nd campaign there.
Hello
My ad showed 398 conversions its been running from 4 days but in sheets there is nothing. Can you help me?
That conversion number sounds way high unless you have a really large budget, I think you might have setup your conversion tracking incorrectly. In terms of the sheet, have you set the script to recur automatically? It may just not have triggered again.
@@3b1agency my budget was for a week and it is large. Yes i have set the script to recur automatically too
@@premanand4476 How often have you set it to run? If you have set it to repeat weekly as I suggested in the video, then it may not have run again yet. Can you try to run it manually? That should populate it. If that doesn't work then it's possible that one of the other steps along the way was missed, or else none of your PMAX traffic is coming from search or shopping ads (unlikely).
So helpful video bro
these "search terms" are not just being triggered on search though they are the keywords that are also triggering the ads on the display inventory of the PMAX campaign. So unless you are able to break out the volume from search vs display isnt the data misleading?
Hi Alan, I don't think it's misleading. You can break out the volume from search vs display with another script if you want to. Mike Rhoades has a great PMAX spend allocation script that gives a lot of insight into your PMAX spend mix.
Nothing showing on my spreadsheet. :o(
Hi @seasoncookshop did you remember to paste in your Google Sheet url to the script?
love this man
Can I hire you?
Hi Richard, absolutely! You can book a consultation by visiting us online at 3b1.ie/
super
Brillant
Thanks Ryan!