Automating Monthly Data Refresh in SEMrush for Traffic Analytics | Clay

Automating Monthly Data Refresh in SEMrush for Traffic Analytics

i am working in this table. i am using semrush's enrichment to get traffic analytics for a certain month. i want to refresh this data every quarter and change the month automatically to the previous month. how would i do this?

4 comments

Clay
APP
·
·
You can use Scheduled columns to automatically refresh your Semrush enrichment quarterly: 1. Click the ⛭ icon on the top right of your table 2. Under Run the table, select On a schedule 3. Choose Month frequency and set it to run every 3 months 4. Select Only selected columns and choose your Semrush column However, the Display month parameter in Semrush enrichment currently requires manual updates - there's no automatic way to change it to "previous month" each quarter. You'll need to manually update the month parameter in your Semrush enrichment settings each quarter when the scheduled run occurs. The scheduling will handle the quarterly refresh, but you'll need to adjust the month parameter manually each time.
Sources: Scheduled columns | Documentation | Clay University Scheduled columns | Documentation | Clay University Scheduled columns | Documentation | Clay University Semrush integration overview | Documentation | Clay University
Sans
·
·
is there some other way to get the same data so that i can refresh it automatically for a specific month?
LuisArturo
·
·
Hey there Sanskriti thanks for reaching out, currently while there is a way to schedule a column to run on a schedule such as every month, there is no way to automatically change what the input is going to be so in this case you would have to always manually go in and change whichever month you're interested in finding.
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.