Create a JavaScript Scripts to use in Microsoft Advertising / Google Ads.

Job ID: 36177308

Budget: $10 – $30 USD

WARNING, If you send me a proposal with your CV, it will automatically disqualify you. I am not interested in receiving your proposals. Instead, please review my needs and tell me if you understand me and can help me.

Just tell me if you are able to help me.

This script gets the XX number of keywords that generated the least impressions over the last week/yesterday
This script pulls data from the "KEYWORDS_PERFORMANCE_REPORT" in Google Ads /Microsoft Advertising and selects the campaign name, ad group name, keyword text, and impressions for the last X days where impressions are greater than 0.

It then formats the data into a table using pipe (|) separators and logs the output to the console with a message stating, "Keywords with impressions during the last X days".
expect output

Keywords with lower impressions during the last X days
"| Campaign | Ad Group | Keyword | Impressions |\n";
"|------------------|-----------------|----------------|---------------------|\n";

this have to send by email to the recipients specified in the script with the recipients specified as ["XXXXXXXXXXXX", "XXXXXXXXXXXX"]
subject: Google Ads KEYWORDS_PERFORMANCE_REPORT
subject: Google Ads. KEYWORDS_PERFORMANCE_REPORT

email: body massage

embed the table into the email body
Keywords with lower impressions during the last X days
"| Campaign | Ad Group | Keyword | Impressions |\n";
"|------------------|-----------------|----------------|---------------------|\n";

Nice to have
update the info into a Google sheet
Related categories: JavaScript Google Adwords Bing Ads