Author: Nils Rooijmans

Automating Google Ads reports is like teaching a philosopher to code.

Suddenly, you have more time to ponder the bigger questions, like the true ROE (Reason Of Existence) of your Google Ads account.

You can ask yourself questions that (really?) matter, such as:

• “Why does this audience dance more gracefully with my main KPI than that other group of ad-clicking-tire-kickers?”
• “What is it that makes this group of best-selling products so special?”
• “What seasonal trends do I see upcoming in the near future, that I can act upon today?”

Questions that impact your account’s performance far beyond the mere act of compiling reports.

If you agree, meet Swydo.

Swydo is like a Zen garden, automating Google Ads reports and cultivating peace in your workday.

It allows you to contemplate the profound instead of getting lost in the data-gathering and number-crunching weeds.

I’ve found Swydo to offer me huge time savings when it comes to automated reporting:

• It aggregates data from all the major platforms.
• It has a very small learning curve (and is easier to implement than Looker Studio).
• It offers a free plan with a great onboarding service. You can get your specific report running in 20 minutes.
• It allows for copy-paste templates you can use for each new client.
• It’s the cheapest solution out there unless you want to spend a lot of time on the plumbing and client setups.
• It is reliable and robust. Reports go out on time, every time.

Again, their support is amazing; just book a support call via Calendly, and skilled professionals will help you create any report you need.

Yes, my firsthand experience with Swydo support took me by surprise, after numerous calls with other “platform professionals”. (*) 

– Nils

(*): Interested to learn how I handle all the endless calls from Google Reps? If so, hit reply.

PS: If you want a reliable and affordable solution to automate your performance reporting -> sign up for a free trial at: https://www.swydo.com/

When you are happy with the tool and ready to upgrade, mention “NilsRooijmans” during the upgrade to get a $100 discount.

I’d still share these tips without the kickback, but a few extra bucks is nice! Here’s the link again: https://www.swydo.com/

Here’s a little-known Google Ads feature that is actually quite useful: campaign-level headlines and descriptions.

Google says:

“Campaign-level headlines and descriptions can be scheduled if you have assets that you want to show during a specific time period. 

Additionally, these assets can be pinned to certain positions if you want to ensure they show“

I absolutely love this feature, because:

1. You can easily schedule assets to show across all ad groups inside a campaign. Think: promotional messaging that has a specific start and end date, you can schedule them in advance!

2. It is great for headlines and descriptions that need frequent updating across RSAs. No more manually editing many ads in multiple ad groups when you enable/disable promotions!

Here’s a 9-minute video by our PPC friends from Paid Media Pros that clearly explains this great feature and how to use it:
https://www.youtube.com/watch?v=m35xGQjTFpE (play at double the speed)

If you haven’t used them thus far, I highly recommend checking them out. It only takes 10 minutes and I am sure you will benefit from using them in the near future.

– Nils

Here’s a quick and easy productivity win for you:

If you service multiple clients in different industries, group similar clients in your workweek.

For instance: 

• Monday is the lead-gen day, when I service my lead-gen clients.
• Tuesday is e-comm fashion day, when I service my B2C fashion clients.
• Wednesday is coaching day, when I service my coaching clients.

Client batching works because it allows your brain to focus on one type of client strategy and the type of work involved at a time.

No need to let the mind wander off in supplemental feeds when you are working on lead gen clients. Skip the e-comm blog post that popped up in your notifications, etc.

And if you are lucky, coming up with an idea for client A immediately translates into an almost copy-paste strategy for client B that is already open in a second window.

– Nils

Do you ask yourself any of these questions?

“Is my account in optimal shape?”

“Am I wasting budget on parts that don’t convert?”

“Are all my settings set to the best, and still in place?”

“Am I missing opportunities for significant growth?”

If so, come join me in my SMX Advanced workshop:

Google Ads Auditing (partly automated via scripts)

In this hands-on workshop, we will go over some of the more advanced auditing techniques for Google Ads, that you will immediately check in your account.

We will also automate some of the checks and analyses via scripts. Don’t worry if you don’t have any scripting skills; the scripts will be readily available for you to copy-paste during the workshop.

After the workshop, you’ll be able to impress your potential clients, colleagues, and your boss with unique insights to improve almost any Google Ads account!

Curious?

Here’s a sneak peek of one of the things we’ll cover (based on a post from /r/PPC):

“I have on multiple occasions turned off the Google search partners option, but the next day somehow the option keeps turning back on. Eating up my entire budget with useless leads. Any ideas on why this might be happening and how I can fix it?”

Turns out, it was an auto-apply recommendation setting…

Easy fix: check the recommendations tab and the auto-apply settings.

But here’s the thing: you CANNOT sit back and simply trust Google to apply automations that will benefit your objectives.

Don’t trust, verify!

Verify by testing.

Use scripts to continuously monitor the test data for you.

Here’s one of my favorite examples:

[Google Ads Script] Search Partner Performance Alerts

This script compares the performance of the Search Partners to the Google Search Network.

In case of a significant difference in CPA/ROAS performance, the issue is logged in a sheet and an alert is sent via email. That way you’ll know when Search Partners aren’t performing, and you can opt out of the Search Partner network for these campaigns.

Interested in more info like this?

Sign up for the workshop 🙂

Click here to apply »
https://smxadvanced.eu/workshop/hands-on-google-audit/

(Use discount code ATFPPCP24 to get 20% off the workshop and the rest of the event.) 

Seats are limited. It’s not too late, but it will be soon.

I hope to see you there!

– Nils

Are you interested in some advanced PPC Hacks to optimize your Google Ads account?

If so, join me and the talented Nadine Maier at SMX Advanced in Berlin.

Here’s a sneaky sneak peek: we’ll be talking all things from budgets to bidding, from audiences to creatives, and from feeds to reporting.

Hack #13:

In the past, we used to run all of my competitor campaigns(*) on manual bidding with a CPC bid to ensure we ranked at the top of the page.

We noticed that it was hard to make these kinds of campaigns profitable because Quality Scores, CTRs, and Conversion Rates tend to be very low compared to the generic keywords in our accounts. This resulted in CPAs that were mostly too high.

Not anymore.

A few months ago, we started testing smart bidding on competitor campaigns and the results are very convincing.

Here’s the data from one of the latest experiments:

Note that the only difference between the original and the experiment is the bidding strategy. Moreover, search term analyses did not show a significant difference in the types of searches our ads showed for.

What this tells me is that Google’s target CPA bidding learned how to discriminate between clicks from people who are open to an alternative, versus the people who really are looking to buy from the competitor.

Great job Google, smart bidding FTW!

(*) Note: competitor campaigns are campaigns that only contain competitor brand names as keywords.

Want to see more “hacks” like these and learn much more from other PPC professionals?

 –> Get access to SMX Advanced Berlin (10-11 Sep, 2024) !

– Nils

P.S. I’ll also present a Google Ads Audit workshop at SMX Advanced. In this hands-on workshop, we will go over some of the more advanced auditing techniques for Google Ads, which you will immediately check in your own account. We will also automate some of the checks and analyses via scripts.

If you’d like to attend, you can apply below:

Click here to apply »
https://smxadvanced.eu/workshop/hands-on-google-audit/

(Use discount code ATFPPCP24 to get 20% off the workshop and the rest of the event.) 

Seats are limited. It’s not too late, but it will be soon.

I hope to see you there!

Have you ever wanted to create multiple site links for a single landing page?

I did. Today.

Today was about all about onboarding a new client for me.

The client (lead gen) offers a single service, on a single landing page.

The problem: Google Ads requires unique URLs for each site link (sometimes, using the same URL gets them disapproved).

The solution? This simple hack from our PPC friend Mykyta Soima: 

PRO TIP: use different UTM parameters to easily track the clicks on the various site links in GA4 and make the URLs unique at the same time.

NOTE: technically, it is against Google’s policy to use site links with the same page content. In practice, I never ran into problems. Use the trick, while we can 🙂

– Nils

P.S. Exactly two weeks from now, I’m presenting a Google Ads Audit workshop at SMX Advanced.

In this hands-on workshop, we will go over some of the more advanced auditing techniques for Google Ads, which you will immediately check in your account. We will also automate some of the checks and analyses via scripts.

If you’d like to attend, you can apply below:

Click here to apply »
https://smxadvanced.eu/workshop/hands-on-google-audit/

(Use discount code ATFPPCP24 to get 20% off the workshop and the rest of the event.) 

Seats are limited. It’s not too late, but it will be soon.

I hope to see you there!

Did you know? 

Starting June 10, 2024, Google is rolling out a permanent change that automatically pauses Google Ads keywords that haven’t had any impressions during the last 13 months. 

Last week, many PPC practitioners (including me) saw a ramp-up of this activity in our accounts.

Here’s what that looks like:

Whether or not pausing low-activity keywords is a good thing is up for debate. However, Google automatically applying this kind of change in our accounts without our consent… that’s something completely different!

Organizing the account is something that is best left to advertisers/PPC practitioners if you ask me.

And it gets even worse: even when you’ve opted out of all the auto-applies, Google will still automatically pause low-activity keywords (and ad groups).

Here are my auto-apply settings:

Now, luckily for me, I run a Google Ads Script that monitors the Change History of my accounts.

The script alerted me of this change, and I could undo the change to make sure I can still promote my workshop using the specific keyword.

Interested in the script?

Go here -> https://nilsrooijmans.com/google-ads-script-change-history-alerts/

– Nils

P.S. Exactly two weeks from now, I’ll be presenting a Google Ads Audit workshop at SMX Advanced.

In this hands-on workshop, we will go over some of the more advanced auditing techniques for Google Ads, that you will immediately check in your own account. We will also automate some of the checks and analyses via scripts.

If you’d like to attend, you can apply here:

Click here to apply »
https://smxadvanced.eu/workshop/hands-on-google-audit/

(Use discount code ATFPPCP24 to get 20% off the workshop and the rest of the event.) 

Seats are limited. It’s not too late, but it will be soon.

I hope to see you there!

Last week, I was in Riga.

The friendly people of Marketing Shake invited me for a speaking gig on Google Ads and AI.

The event itself was great. Getting there, not so much.

The morning of the event, the weather was good. 

Google Maps told me it was a 30-minute walk. 

So, I went walking to enjoy the lovely city of Riga. (Beautiful Jugendstil architecture!)

Google Maps pointed me to a spot in an industrial area, the route looked easy, and for some reason, I did not look up the exact location.

Turns out, that exact location was hidden between some big buildings with no clear directions.

Long story short: the 30-minute walk turned into 60 minutes of strolling back and forth in little alleys,  and being almost late for my presentation.

The whole adventure reminded me of how Google Ads is also hiding locations from us — the exact location of the user.

In the distant past, the Google Ads UI had an easy-to-access report called “User locations.” This report would list the physical location of the users that got to see your ads.

That report has been gone.

Now, some of you might think: “Right Nils, but we’ve still got the ‘Matched locations’ report under ‘Insights and reports’-> ‘When and where ads showed’, right?”

Yep, very true.

BUT, here’s the thing: matched locations do NOT show you the physical location of the user. 

Matched locations show your performance based on the locations that matched your ads. These locations could be users’ physical locations or locations of interest.

For example, you target a keyword [hotel Riga] in a campaign that geo-targets the Netherlands. If someone in Amsterdam searches for “hotels in Riga,” Riga would show as the ‘Matched location’.

But then, how do you see the user location ‘Amsterdam’?

That is no longer a default report inside Google Ads.

For that, you have to create a custom report via Report Editor.

Here’s what that looks like:

Notice the difference in performance between the different User locations?

It might be interesting to update your location targets, maybe exclude some locations (especially for PMax), and/or change some advanced geo targeting settings.

Now, go grab a coffee and create this User location report for your accounts. 

It only takes 5 minutes and the insights might surprise you!

– Nils

Once upon a time, PPC Peter worked at an agency that served 100+ clients with a team of three PPC specialists.

Every day, Peter worked his PPC magic: routinely adjusting budgets, tinkering with some CPC bids, putting in one or two (negative) keywords here and there, adding a few exclamation marks in headlines, and throwing in some audience targeting where suits fit.

His tasks took little time, and little energy.

And even when he skipped a beat, no one ever noticed.

His salary was decent. 

Life was good!

That is, until his boss added this extra task: “Send out detailed monthly reports to all of our clients, on day 1 of every month!”

Suddenly, Peter’s life changed.

No more 1.5-hour lunch breaks.

No more stress-free evenings with the 5-year-olds.

No more practical jokes in the coffee corner.

Life was work!

At least, until Peter took “my” advice below.

In PPC, question everything (especially when it comes to reporting).

1. “Why do we need to send reports?”

2. “Why do we report these things we report?”

3. “Why do we manually create these reports?”

I love asking these kinds of questions (and they are easy to ask).

Answering them is not that easy.

However, based on many, many question-answering first-second-and-third dates, I can tell you:

Almost, almost, never is spending your time on creating reports the best use of your time.

The reporting itself doesn’t change anything in the accounts.

As for new insights gained from reporting… that’s a different story.

And conversations about these insights? Yes, they create value for sure!

Here’s the thing: if you truly need to send out reports, you want to spend as little time as possible on the task of creating the report.

You want to spend time on the new insights.

If you agree, here’s your go-to solution: Swydo.

I’ve found Swydo to offer me huge time savings when it comes to automated reporting:

• it aggregates data from all the major platforms
• it has a very small learning curve (and is easier to implement than Looker Studio)
• it offers a free plan with great onboarding service (you can get your specific report running in 20 minutes)
• it allows for copy-paste templates you can use for each new client
• it’s the cheapest solution out there unless you want to spend a lot of time on the plumbing and client setups
• it is reliable and robust (reports go out on time, every time)

Don’t get me wrong, I still think you should question the purpose (the “Why”) of reporting first. 

However, if you decide there is a purpose, Swydo is a great tool to get it done for you. Quickly, and easily.

– Nils

PS: If you want a reliable and affordable solution to automate your performance reporting -> sign up for a free trial at https://www.swydo.com/

When you are happy with the tool and ready to upgrade, mention “NilsRooijmans” during the upgrade to get a $100 discount. 

Note: I’d still share these tips without the kickback, but a few extra bucks is nice!

Here’s the link again: https://www.swydo.com/

(For your convenience, the link to part 1 of this is provided below.)

Have you ever had an e-commerce client that wanted to maximize profit instead of revenue?

If so, join me and our PPC friends at Product Hero in their upcoming webinar next week ‘Everything you need to know about POAS’.

In the webinar, I’ll present my A/B testing approach for Standard Shopping, which allows for optimizing your ROAS/POAS targets to maximize your profit.

Here’s a sneak peek:

Here’s the link to the webinar (7 August, 13:00 CET, 30 minutes):
https://producthero.com/en/profit-on-ad-spend-poas-webinar

See you there?

– Nils

P.S. As promised, here’s the link to the first part: https://nilsrooijmans.com/daily/how-i-use-standard-shopping-to-maximize-profit

With the deprecation of SKAGs and the rise of STAGs, single ad groups often contain tens of keywords.

And your ad groups most probably contain more than one ad.

This is all well and good, but how do you know what keyword triggered what ad?

Luckily for us, the Google Ads UI has a hidden feature that gives some clarity:

1. Navigate your way to your ad group
2. Click “Ads” 
3. Click “Segment”
4. Click “Keyword text”

Here’s what that looks like:

Hey Mom, look at that, I’ve got keyword stats per ad! 🙂

You can use these insights to optimize your ad copy and/or lander.

For example: 

• Include the top keywords in your headlines 
• Address the intent behind the top keyword in your description 
• Create a separate lander for a popular keyword that has a slightly different intent from the rest of the keywords

Enjoy!

– Nils

PS: Sharing is caring! If you enjoyed this episode, please consider sharing it with a few friends who might find it useful. Thanks!

Here’s a pop quiz question: name a conversion rate killer that tanks results AND is often very tricky to spot.

…

You’ve guessed it! 

It’s high page load times!

Even the best landing page copy with the best design can’t stop high page load times from tanking your conversion rates.

And the bad news is that it can be tricky to spot them.

Right now, your landing page might load within 1.3 seconds.

A few minutes from now, it might take over 8 seconds!

An 8-second page load time = 0 conversions!

Here’s the thing: unless you frequently monitor page load times of your top landing pages, you are wasting $$$ on clicks that don’t convert for the wrong reason.

Here’s a short list of my favorite tools to help you spot and fix the issue:

1. Chrome extension: Page Load Time
This extension shows the page load times for every page you load in your browser. Quick and simple!
URL: https://chromewebstore.google.com/detail/page-load-time/fploionmjgeclbkemipmkogoaohcdbig?pli=1

2. Chrome Lighthouse 
This tool allows for automated page performance audits. The report lists improvements by priority and can easily be sent to webdev.
URL: https://developer.chrome.com/docs/lighthouse/overview/

3. Webpage Test
A reliable webpage performance test for free, from almost any location on earth.
URL: https://www.webpagetest.org/

4. GA4 page load times report
Track actual page load times from your users using GA4.
URL: https://measureschool.com/track-ga4-page-load-time/

5. GT Metrix
Reports how fast your website loads, PageSpeed, YSlow scores, and other page details. It also allows you to compare your site to other websites’ performance, set up alerts, and even monitor your load time. 
URL: https://gtmetrix.com/

– Nils

Not convinced you can create your own scripts without any coding skills? 

Watch this.

Campaigns Reporting Script (Fun Edition)

What it does:
This Google Ads script creates a nicely-formatted email that reports the performance of your campaigns. It includes funny emojis to help you discriminate between good-performing campaigns and bad performers.

Why you’d care:
Simple reports like this can give you a quick and easy look into your account’s performance and ensure all is well. Peace of mind with a single click 🙂

Why I like it:
This script is 100% generated with AI. In a few minutes. Without any coding skills required! The author, Geert Groot, used the latest version of the Large Language Model Claude AI to create the script for him. It only took two prompts:
1st: Make me a Google Ads reporting script for enabled campaigns.
2nd: How can we make this more fun.
Note: Geert doesn’t know how to code. He has learned the basics of scripting (partly via my course on using GPT to create scripts for you), and has experimented a lot with prompts to learn how to have LLMs create scripts for him — with success!

URL: https://docs.google.com/document/d/1UcGx48fPzEV2FFaA29S273TzZH8NFY_6bQvLkVsQp7k/edit?usp=sharing

PRO TIP:
After installing and running the script, have a look at the output in your inbox. Come up with some ideas to improve the report and customize it to your own needs. Then, head over to your favorite LLM (e.g., ChatGPT/Claude/Gemini), feed it the script, ask it to explain the script, and then ask it to improve the script and implement your requirements.

Don’t give up if it doesn’t work immediately. Simply feed error messages back to the LLM and ask it to fix them. Treat the LLM like your new intern. Be patient, and be concrete in your requests. Be surprised 🙂

Happy scripting!

– Nils

Ever had an e-com client that preferred increased profit over revenue growth?

If so, be sure to join me and our PPC friends at Product Hero in their upcoming webinar ‘Everything you need to know about POAS’.

In the webinar, I present my “Gatekeeper Architecture” for Standard Shopping, which allows for controlled growth of your profit.

Here’s a sneak peek:

(The parts in green are automated via Google Ads Scripts.)

Here’s the link to the webinar (7 August, 13:00 CET, 30 minutes):

https://producthero.com/en/profit-on-ad-spend-poas-webinar

See you there?

– Nils

Have you ever had to fill out a form tens of times just to test if conversion tracking is set up correctly?

Re-populating these empty input fields with dummy data, countless times…

Ugh.

Here’s the good news: with the Lorem Fill plugin you can skip the horror of these endless mouse-click-type repetitions.

This plugin allows you to complete all input fills in a single stroke.

Here’s what that looks like:

Here’s the link:

https://chromewebstore.google.com/detail/lorem-fill/jfjnfhfeibkcokofbeipmehclfdojpaa

– Nils

I just got back from my vacation.

A motorcycle road trip through Oregon and Idaho.

There’s something magical about motorcycle road trips.

You go where the roads take you.

You don’t know where you are going.

You don’t know where you’ll end up.

There’s no way to get lost.

If you are on a motorcycle you can’t get lost.

You are there.

I’ve created my best scripts while having the same magic feeling.

Not knowing where I am going.

Just open up the white space in the script editor and start scripting.

See where the code takes you.

It’s magical.

– Nils

I’ve got a confession to make.

In Wednesday’s mail, I told you I don’t do fancy reporting, and offered you a script to automate the very limited data that I do report. (Email repeated below for your convenience.)

It’s true; I do not send fancy reports to my clients.

However… I do advise many of my coaching clients to use a fancy reporting tool!

What’s that, Nils? You don’t eat your own consulting dog food?

No. And yes.

Here’s what happens.

Many of my coaching clients are small to medium-sized agencies that want to do more with less hands. I help them automate the work so they can increase revenue without increasing headcount.

They typically serve tens if not hundreds of clients.

One of the main things that takes my clients forever? Sending out monthly, or even weekly, reports to their clients!

Many agencies have clients that simply expect them to send detailed reports. On time, every time. If they don’t, the client starts dialing numbers.

Many agencies use detailed reports as an entry point to start a conversation. That conversation with the client increases client retention.

Many agencies simply promised it in their initial offering.

Many reasons. Many hours of tedious, labor-intensive data gathering, number crunching, dashboarding, writing summaries, sending out emails…

Many hours of wasted time.

Wasted? 

Yes. Because you can automate almost all of it, and I’ve got just the solution for you.

IF…

• you are swamped with daily reporting tasks and are losing your mind over it
• or, you’ve cobbled together some data source connectors that should work, but never do
• or, you are fed up with time-consuming setups for each new client
• or, you simply do not have the time to learn new complex tooling
• or, you don’t have the money for overpriced reporting solutions

THEN…

your GO-TO solution is Swydo.

I’ve found Swydo to offer the best price-to-quality ratio when it comes to automated reporting, for these reasons:

• it aggregates data from the major platforms
• it has a very small learning curve (easier to implement than Looker Studio)
• it offers a free trial with a great onboarding service (get your specific report running in 20 minutes!)
• it allows for copy-paste templates you can use for each new client
• it’s the cheapest solution out there unless you want to spend a lot of time on the plumbing and client setups
• it is reliable and robust (reports go out on time, every time)

Don’t get me wrong, it won’t give you the flexibility of a custom reporting setup using Supermetrics, Big Query, and Looker Studio. If that’s what you need, go for it.

Swydo is low effort, low cost, and just good enough. And good enough is what most agencies need.

– Nils

PS: If you want a reliable and affordable solution to automate your performance reporting -> sign up for a free trial. 

When you are happy with the tool and ready to upgrade, mention “NilsRooijmans” during the upgrade to get a $100 discount. 

I’d still share these tips without the kickback, but a few extra bucks is nice!

Here’s the link again: https://www.swydo.com/?utm_source=nilsrooijmans&utm_medium=newsletter&utm_campaign=jun2024)

Lastly, as promised, here’s the email from Wednesday: https://nilsrooijmans.com/daily/google-ads-script-monthly-reporting-my-very-basic-version

One of the most annoying things in my PPC workday?

Google Ads Editor stalling.

It’s constantly freezing when downloading my account, not responding at all after multiple attempts. Again, and again. 

Yes, also after checking my internet connection, resetting my machine, downloading the latest version of the tool, and only selecting the basic download of a selection of the campaigns.

I’ve tried everything from signing in and out, removing temp files, disabling virus checkers, using VPN, and turning off Cloudflare… nothing works.

It still freezes.

Sounds familiar?

If so, try this solution for large accounts: you can force the download to finish by changing the download mode in Google Ads Editor! 

For Windows:

• Select Start > Run, then type cmd.
• Press Enter.
• Enter the following command: cd “C:\Users\%USERNAME%\AppData\Local\Google\Google Google Ads Editor”
• Press Enter.
• Enter the following command: start google google_ads_editor_launcher.exe -dlMaxRequests
• Press Enter.
• Restart the account download.

FINALLY! I got the complete account downloaded in Editor again. (It still took 3 hours, though.)

Here’s a bunch of additional resources that will help you get the job done and Google Ads Editor back up to speed:

Uninstall and remove temp files:
https://support.google.com/google-ads/editor/answer/30515?hl=en

Download and install the latest version:
https://support.google.com/google-ads/editor/answer/30513

Select a portion of the account and download only basic data:
https://support.google.com/google-ads/editor/answer/30542

Make sure to not download images and videos:
https://support.google.com/google-ads/editor/answer/38872?hl=en

Log diagnostics to see what went wrong:
https://support.google.com/google-ads/editor/answer/94249?hl=en&ref_topic=9314

Hope this helps,

– Nils

I don’t do fancy reporting.

In the end, there are only 4 numbers that matter:

1. Google Ad Spend
2. Gross Profit (from Google Ad Spend)
3. My Google Ads Management Fee
4. Your Net Result (‘net result’ = ‘profit’ – ‘ad spend’ – ‘management fee’)

Here’s what that looks like:

Here’s how I automate that via Google Ads Scripts: https://nilsrooijmans.com/google-ads-monthly-reporting-script-my-very-basic-version/

Go ahead, try the script right now!

It only takes 5 minutes to set up, and your clients will love you for the simplicity.

Happy scripting!

– Nils