Recently, we had some of excellent clients who have been demanding a unique feature that reduces time for analysts who manages larger accounts with more profiles.
The request was to have ability to extract multiple profiles data within one query. The use case was:
“I manage about 38 countries dashboard within one google analytics accounting with 38 profiles dedicated for each country. I have to compare visits, time on site, etcs all the time and the only way to do it is via creating many more queries in excel plugin– Is there a better way “
And we said “yes”. We figured that if we allow the country name to be extracted from list of profile names written in excel, we can pass that in our query and have it extracted from Google Analytics.
Here is the quick video representing the same.
In addition to this, we also have worked out similar solution for advance segment. For e.g. if you have 10 advance segments that you would like to compare for their performance against the same metrics, you can do the same as described in the above video for profiles.
As we continue to build more features, we are more committed to listen to ideas that you are looking forward to automate, please feel free to reach out to us if you have any feedback or feature request for Tatvic google analytics excel plug-in.
Note: To use this feature, you’ll need to update your Tatvic Excel plug-in. Here’s how to do it:
Before loging-in to the tool, click on “Check for update”.
Click on the link that appears at the bottom of the tool.
Done, enjoy the feature now.
Would you like to reduce the amount of time you usually spend on data extraction from your Google Analytics / Google Adwords account? We think you may like to watch our Webinar – How to simplify and automate data extraction process using Tatvic Excel Plugin. Watch the Replay Now!
Latest posts by Ravi Pathak (see all)
- Answering Every Marketer’s Dilemma – Which attribution model to choose? All about Fractional Attribution – Part 2 - September 12, 2019
- Answering Every Marketer’s Dilemma – Which attribution model to choose? All about Fractional Attribution – Part 1 - August 30, 2019
- How To Track AMP Accelerated Mobile Pages in Google Analytics [Guide] - June 29, 2018