Google Ads Script Creation for P.MAX
Budget: €30 – €250 EUR
I'm in need of a skilled individual with experience in creating scripts for Google ads.
The project involves scripting for a Google Ads campaign.
I need to modify the script that I attached, now it's only for one account, and I want it for MCC.
Furthermore it have to do this extra thing:
The MCC script must creates one google sheet for each account in your MCC (I need to choose the account ID).
The sheet must gives you 3 main insights:
where Google is showing your ads (shopping, display, video or search/other)
which search categories your ads are showing for (sorta like search queries)
a ‘product matrix’ that puts all products into 1 of 6 buckets based on performance
the list of placement in display network, with the performance
For all of these, you get to choose the settings. You pick the date range & the range of metrics for those buckets.
Spend Allocation
You’ll get account-level insights with metrics for each of the four channels. As well as visuals & a table showing all campaign metrics in one place.
Then, for each individual campaign, you can dive deeper & see the channel split over time (you choose the date range). As well as the search categories for each campaign. And the metrics for each of those.
Search Categories
Based on a brand term (or terms) that you enter, each search category is put into 1 of 4 buckets. Blank, Brand (exact match to your entered terms), Close-Brand (self explanatory), or Non-Brand if it’s ‘different enough’ from any of your brand terms.
In addition, AOV, CTR & CvR is calculated for each bucket, as well as visualisations to show the performance of each campaign (with respect to these category buckets).
Product Matrix
This is probably the most popular part of the Insights sheet & is explained in great detail here. All products are put into 1 of 6 buckets & various metrics shown for each bucket.
This is done based on the product titles as well as the ID. In addition you get a sheet listing all product IDs with their bucket, so you can easily add a supplemental feed to GMC if you choose.
The Matrix also shows detail for Shopping campaigns, not just PMax by popular demand!
There are also tabs in the sheet to give you metrics of your Asset Groups & some detail about various video & display assets. This isn’t exhaustive as Google doesn’t make much data available for PMax sadly.
The project involves scripting for a Google Ads campaign.
I need to modify the script that I attached, now it's only for one account, and I want it for MCC.
Furthermore it have to do this extra thing:
The MCC script must creates one google sheet for each account in your MCC (I need to choose the account ID).
The sheet must gives you 3 main insights:
where Google is showing your ads (shopping, display, video or search/other)
which search categories your ads are showing for (sorta like search queries)
a ‘product matrix’ that puts all products into 1 of 6 buckets based on performance
the list of placement in display network, with the performance
For all of these, you get to choose the settings. You pick the date range & the range of metrics for those buckets.
Spend Allocation
You’ll get account-level insights with metrics for each of the four channels. As well as visuals & a table showing all campaign metrics in one place.
Then, for each individual campaign, you can dive deeper & see the channel split over time (you choose the date range). As well as the search categories for each campaign. And the metrics for each of those.
Search Categories
Based on a brand term (or terms) that you enter, each search category is put into 1 of 4 buckets. Blank, Brand (exact match to your entered terms), Close-Brand (self explanatory), or Non-Brand if it’s ‘different enough’ from any of your brand terms.
In addition, AOV, CTR & CvR is calculated for each bucket, as well as visualisations to show the performance of each campaign (with respect to these category buckets).
Product Matrix
This is probably the most popular part of the Insights sheet & is explained in great detail here. All products are put into 1 of 6 buckets & various metrics shown for each bucket.
This is done based on the product titles as well as the ID. In addition you get a sheet listing all product IDs with their bucket, so you can easily add a supplemental feed to GMC if you choose.
The Matrix also shows detail for Shopping campaigns, not just PMax by popular demand!
There are also tabs in the sheet to give you metrics of your Asset Groups & some detail about various video & display assets. This isn’t exhaustive as Google doesn’t make much data available for PMax sadly.