Automated Excel, AHREF, SEMRUSH, PRORANKTRACKER[ Edited ]
June 2017 - last edited June 2017
I am new using Google Data Studio and I am a bit lost. I have 2 questions:
1) How can you include an Excel which GDS checks automatically? For example, in order to upload an Excel with a call center sales information, how could I do so that GDS keeps track of the changes I do on my Excel sheet?
2) Can you include AhRef, SEM rush and PRORANKTRACKER data in GDS? Is there any direct connection between GDS and any of these tools?
Can you integrate any of them with a direct API?
Thank you very much!
Hope to hear from you asap!
Automated Excel, AHREF, SEMRUSH, PRORANKTRACKER
Instead of keeping your data in Excel, keep it in Google Sheets. There is a direct connection to Sheets from Data Studio (there's isn't to Excel). However, if you have sensitive data (like medical data that has privacy laws), then this might not be an option for you unless it's aggregate data without identifying personal information.
SEMRush does have an API through the Supermetrics plugin to Google Sheets. However, you have to have the top subscription level ($400/month). I have the $200/month and have checked with Supermetrics and they don't support and API in that case.
I don't have any info about the other tools you mentioned.