Merging Amazon reports on google sheets
Budget: $30 – $250 USD
Hello,
I need to merge 2 different Amazon reports on Google sheets by Apps script. Those reports has a maximum 60 days backworth date. Since statistically the information I have from clicks on Amazon after 60 days is not enough to make a decision, at the moment, I need to paste 2 different reports with 2 diffrent dates intervals and then manually merge them.
In the spreadsheet that I'm sending there are 2 sheets from 2 different date intervals. One from 09/06 - 30/06 and another one from 01/07-04/08. On the merge report sheet I already made the copy paste from the other 2 sheets.
On project file, you can find in the details the algorithm that need to be done
Thank you!
I need to merge 2 different Amazon reports on Google sheets by Apps script. Those reports has a maximum 60 days backworth date. Since statistically the information I have from clicks on Amazon after 60 days is not enough to make a decision, at the moment, I need to paste 2 different reports with 2 diffrent dates intervals and then manually merge them.
In the spreadsheet that I'm sending there are 2 sheets from 2 different date intervals. One from 09/06 - 30/06 and another one from 01/07-04/08. On the merge report sheet I already made the copy paste from the other 2 sheets.
On project file, you can find in the details the algorithm that need to be done
Thank you!