-
Notifications
You must be signed in to change notification settings - Fork 0
/
main.py
42 lines (31 loc) · 1.47 KB
/
main.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
import datetime
import presets
from amz_ppc_optimizer import AmzSheetHandler
from amz_ppc_optimizer import ApexOptimizer
from amz_ppc_optimizer import ApexPlusOptimizer
MARKET_PLACE = 'AE'
def main():
sheet_handler = AmzSheetHandler()
targets = sheet_handler.read_targets_report("Targets_Jun_8_2024.csv")
sheet_handler.read_bulk_sheet_report(filename="bulk-aw3emyt3cnq5r-20240505-20240605-1717849817485.xlsx")
keyword_optimizer = None
market_place_filler = ''
if MARKET_PLACE == "AE":
keyword_optimizer = ApexPlusOptimizer(data=sheet_handler.sponsored_prod_camp,
targets=targets,
presets=presets.ae_presets)
market_place_filler = "AE_"
elif MARKET_PLACE == "US":
keyword_optimizer = ApexPlusOptimizer(data=sheet_handler.sponsored_prod_camp,
targets=targets,
presets=presets.us_presets)
market_place_filler = "US_"
else:
print("[ EROR ] Marketplace is invalid!")
exit()
keyword_optimizer.optimize_spa_keywords(exclude_dynamic_bids=False)
datagram = keyword_optimizer.datasheet
filename = "Sponsored_Products_Campaigns_" + market_place_filler + str(datetime.datetime.utcnow().date()) + ".xlsx"
sheet_handler.write_data_file(filename, datagram, "Sponsored Products Campaigns")
if __name__ == "__main__":
main()