PPC & Ads · Blog post · source Jul 20, 2023
Keyword Harvesting Bulk File from the Search Term Report with ChatGPT
Move converting search terms into exact-match campaigns with one upload
He gives no time saved or performance figures; the post is about the workflow.
Per source Self-reported by the source, not independently verified.
Copy-paste prompt
I've uploaded an Excel file with two sheets: my Sponsored Products Search Term Report (last 60 days) and a map of source campaign -> destination exact-match campaign and ad group. Harvest every customer search term with at least [2] orders and ACOS under [30]% that isn't already a keyword in its destination ad group. Return an Amazon Ads Bulk Operations sheet that: creates each as an exact keyword in the destination ad group at a bid of [the term's CPC + 10%], and adds it as a negative exact in the source ad group. List the rows first so I can check them, then give me the file.
The source didn't publish its exact prompt. We wrote this starter so you can try the same workflow. Replace anything in [brackets].
What they did
An Amazon PPC specialist wrote a ChatGPT prompt that automates keyword harvesting. You upload one Excel file with your Search Term Report and a source-to-destination campaign map, and ChatGPT returns a Bulk Operations file ready to upload. The harvesting rules (number of orders, ACOS and so on) and the bids for harvested keywords can be changed in the prompt.
How it went
He gives no time saved or performance figures; the post is about the workflow. He offered to share the prompt if the post reached 500 likes.
We only report what the source says. Results are self-reported unless noted.
Worth knowing
Check the bulk file before uploading it: confirm campaign and ad group IDs match your account and that each harvested term is also added as a negative in the source campaign, or the two campaigns will bid against each other.