Navigating through the endless universe of data within Google Analytics can sometimes be tough. Add external data sources to the equation, and you face quite a challenge. This is why every type of automation for data importing is more than welcome, allowing you to focus on data analysis, not the import itself.
Google Analytics generates vast amounts of data about websites and their visitors, so pieces of information can remain uncovered. Above that, you often have additional information sources that you need to integrate and consolidate in order to get the complete picture. Importing data from outside the Google universe requires steps that go beyond GA’s standard implementation.
Information from various sources can be added by using the “Data Import” feature, which you can find in the Admin section of Google Analytics for each of the Properties you have in your account. Several options are supported, enabling users to enrich on-site data with additional information from other sources. This powerful feature enables GA users to draw the full data picture, but manually uploading the external data would be tedious and time-consuming.
This is why we built the Google Analytics Destination for Datatap, which lets you import data from all connectors, fully automated, relieving you of repetitive and mundane import tasks. Below you will find five real-life examples how custom data imports could enable you to enrich your business intelligence.
Importing user data from Hubspot
By using our connector for Hubspot, or any of our other CRM connector, you can inject user data into Google Analytics. With this option users can be added to custom segments, and also lifetime values can be assigned.
But first you must be able to assign unique user IDs for your website visitors. This can be done by giving users the option to log in on your website, or by letting them fill in a form - Google’s best practices on these are described in this article. The same user ID must be then assigned via your Hubspot integration and can be ultimately used to connect the dots.
By pulling the according field (whose exact name depends on the implementation) from our Hubspot connector you can import the data to Google Analytics, and you will start seeing additional information. Ultimately, you will be able to segment your customers by newly added custom segments.
Importing click and cost data from Facebook
If you use advertising platforms other than the ones in the Google ecosystem, cost and click data from those might be the most important data points which you are missing in your Google Analytics account. However, it might also be one of the most simplest ones to import. Set up a datastream from any advertising connector in Datatap, pull cost data, map accordingly and import to Google Analytics. This will then enable you to see a comprehensive set of cost metrics under Acquisition > Campaigns > Cost Analysis in Google Analytics.
Importing product information from Shopify
Importing additional product information can be used to enrich Google’s enhanced ecommerce tracking. You can use our Shopify connector to retrieve information such as inventory quantity, promotions or custom groups. By importing the attributes as custom dimensions, product performance can be later re-segmented.
Importing campaign meta information from a Google Sheet
Classifying campaigns with UTM tags can be tedious and error-prone. If you do not want to rely on everyones’ neatness why not automate it? By using custom imports, data can be used to classify campaigns in Google Analytics. This enables you to analyze campaign performance in a more individual way.
You can include data in addition to Google Analytics' standard campaign tracking parameters, such as new campaign classifications and variations. In our case we used a Google Sheet to classify campaigns. Therefore, just set up a Google Sheets datastream and start exporting your classifications to Google Analytics.
Importing retail refund data from a database or SFTP
If your company regularly handles a lot of returns, which is quite common for large online shops, we suggest to adjust your sales data in Google Analytics accordingly.
Refunds should be reflected in your e-commerce reports; otherwise there will be a discrepancy between your Google Analytics sales and your actual sales data.
One option to do so would be to export data from your e-commerce system to an SFTP. The dataset has to contain Google Analytics’ transaction ID for each refund.
More information on how to perform this operation can be found here. By using Datatap’s integration, the refund data set can be uploaded to Google Analytics to adjust sales data accordingly.