Hi Clay S., I hope you're all having a wonderful day! I'm currently facing a challenge in obtaining the percentage growth of website traffic in the last six months for a list of companies. While I can access the traffic data, I'm unsure how to get the exact percentage growth. If anyone could assist me with this, I would greatly appreciate it. I have a deadline approaching, so any help as soon as possible would be fantastic. Thank you so much in advance!
๐ค You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Here is the URL of the table: https://app.clay.com/workspaces/291952/tables/t_H4xRJmtAWdTQ/views/gv_xaRAEHf5q9KJ
Hi Taha! Happy to help! To calculate the percentage growth over the last six months, you would: * Retrieve the traffic data for the starting month (six months ago). * Retrieve the traffic data for the most recent complete month. This would be August, or if you can wait 1 day, then September. * Calculate the growth for each company by comparing the two sets of data. * Use the formula: ((Recent Month Traffic - Starting Month Traffic) / Starting Month Traffic) * 100 to get the percentage growth. Let me know if you need additional help setting this up! :)
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!