I'm not sure if this is possible but I have a client who manually maintains a Google Sheets report to show the daily spend and effectiveness of their Google Ads campaigns.
The current process is that the Google Sheets template is updated at the end of the day around 6pm (Google Ads are scheduled to finish around 5pm) with the following information:
a) Actual Google Ads spend for each campaign - this is the part that needs automation at the end of each day b) Actual conversations - not the kind that Google Ads reports but this is based on successful telephone conversations and the client manually inputs these at the end of the day
This report is then used the next morning to determine the cost per campaign, lead, etc. and revised spend for that day. An example of the Google Sheets is attached. There is a worksheet/tab for each month and each row is a separate week, with columns for each campaign.
The columns highlighted yellow need the Google Ads spend to be included.
I'm not sure if there is a way to automate this or another way to do the same thing?
As a side point, I'm also looking for a specialist in PPC/Google Ads to provide ongoing support to our clients.