Skip to content

爬取整理广告数据

申请成为亚马逊开发者

创建一个安全配置文件,完成之后会获得:

  • 客户端编号 client_id
  • 客户端密钥 client_secret

https://developer.amazon.com/loginwithamazon/console/site/lwa/overview.html

申请 Amazon Advertising API

获取广告数据

通过自己的帐号和密码登录到亚马逊广告管理平台。寻找、点击、导出、下载广告数据,以 CSV 格式保存到本地。需要下载的广告数据包括:

  • Campaigns
  • Placement
  • Targeting

Campaigns

  1. Set page language to be English
  2. Filter all campaigns with "Active status: enabled"
  3. Filter active campaigns with product keywords "Sound Rise II"
  4. Set "Date range: Lifetime"
  5. Click "Export" button on the sorted page
  6. A CSV file "Campaigns_Date.csv" is automatically saved to C:\Users\Lenovo\Downloads
  7. Use Python (pandas or xlwings) to operate files: a. Copy from the downloaded csv file b. Open an existing Excel file c. Find the sheet named "Campaigns" and append the new data to the bottom d. Do the difference between the current week and the last week

操作数据

最近更新