What is Tatvic?

Tatvic is a MarTech company that specializes in providing a suite of marketing, analytics, and infrastructure solutions to businesses. With a focus on leveraging data-driven insights, Tatvic offers advanced analytics services, including Google Analytics 4, Looker BI, and a Content Recommendation Engine. Their marketing solutions encompass media activations, advanced funnel optimization, and conversion rate optimization, aiming to help businesses enhance their online engagement and conversion rates.

In addition to its marketing and analytics solutions, Tatvic provides infrastructure services that include the Google Maps Platform and Google Cloud Platform, aiding businesses in optimizing their Google Cloud infrastructure. By utilizing custom Machine Learning (ML) models, Tatvic assists companies in generating leads and reducing drop-offs from their websites. Tatvic's robust MarTech solutions help clients improve website engagement, reduce cloud storage costs, and increase page views.

Furthermore, Tatvic data types are an integral part of their offerings. These custom variables are designed for Google Analytics, tracking visitor, session, and page level activities. Stored in cookies with varying expiration times, Tatvic data types are pivotal in tracking multiple-session interactions, within session activities, page types, and specific actions such as button clicks. This enables businesses to drive data-driven decision making, adapt marketing strategies effectively, and achieve advanced funnel optimization.

Tatvic Plugins for Excel

Introduction to Tatvic Excel Plugin

Tatvic's Excel plugin, launched in 2011, revolutionizes the way users can interact with data from various advertising and analytics services. It provides the ability to extract data from Google Analytics, Adwords API, and the Keyword estimator directly into Excel. The plugin is specifically designed for use with MCC accounts and has been enhanced to allow for more extensive data extraction in its newer version.

Data Extraction Features

With the Tatvic Excel plugin, users can pull data from various sources, including Google Analytics, Adwords API, and Google Doubleclick for Publishers (DFP). The integration with the Adwords API also includes the capability to extract details from the Keyword estimator tool. This comprehensive data access streamlines the process of data analysis for users.

Query Management

Efficiency is key when handling data, and the Tatvic plugin understands this by enabling the saving and sharing of queries. This feature ensures that queries can be easily reproduced or distributed among team members, facilitating collaborative work and consistent reporting.

Future Developments

Tatvic is actively considering the integration of additional APIs, such as SEOmoz, to further enhance the plugin's capabilities. This potential expansion would open new avenues for data analysis and insights for its users.

Free Trial Offering

Interested users can try the Tatvic plugin before committing to a purchase by enrolling in a 7-day free trial. This trial is available directly through the Tatvic website, providing a risk-free opportunity to evaluate the plugin's features and benefits.

Common Use Cases

• T

  
  Use case 1: Extracting and analyzing Adwords campaign data within Excel for improved advertising strategies
• T

  
  Use case 2: Using the Keyword traffic estimator feature to forecast and plan marketing efforts
• T

  
  Use case 3: Integrating Google Analytics data with Excel for advanced reporting and data manipulation
• T

  
  Use case 4: Saving and sharing Excel queries for collaborative digital marketing campaigns
• T

  
  Use case 5: Preparing for future API integrations by encouraging user feedback to enhance the plugin’s capabilities

Frequently Asked Questions

How do I refresh data in my Excel dashboard using the Tatvic plugin?

To refresh data in your Excel dashboard, first ensure that you have logged in to the plugin. Then, input your desired 'from' and 'to' dates in the specified cells and click the refresh button. The plugin will automatically extract the updated data from your Google Analytics account and refresh the dashboard.

Can I set the Tatvic plugin to auto-refresh my data?

Yes, the Tatvic plugin includes an auto-refresh feature that updates your dashboard by changing input criteria, such as date ranges, in specific cells on your Excel sheet.

What should I do if the 'Time on Site' metrics are in total seconds?

If the 'Time on Site' and 'Avg. Time on Site' metrics are reported in total seconds, you can use Excel formulas to convert these values into hours, minutes, and seconds. Apply a formula to convert the total seconds into hours and format the values in 'h:mm:ss'.

How does the Tatvic plugin help with selecting parameters for data analysis?

The plugin allows users to select the required parameters and metrics for analysis, enabling a tailored approach to data extraction and reporting from a Google Analytics account.

Who is behind the creation of the Tatvic plugin?

Ravi Pathak is the co-founder of Tatvic, the company that developed the Tatvic plugin for Excel.