In one of my early blog posts for ClickZ, I wrote about features to use within Google Analytics to more efficiently access your data. What I want to talk more about in this post is the fourth item of the previous post, Cost Data Uploads. The feature holds a vast amount of potential for paid media teams, both online and traditional.
Cost Data Uploads possess this value by giving media teams the ability to directly tie campaign costs to outcomes, in one interface. Within a matter of seconds, marketers can see where their return on investment (ROI) is greatest, where they are lacking, and easily further segment into each group based on dimensions, such as location, device type, operating system, etc.
But, I’ve talked about this topic once already, so why again you ask? Well, recently Google announced the ability to perform Cost Data Uploads directly from the Admin interface. This has greatly reduced the previous barrier of needing to leverage the Google Analytics API to upload the data, and Google has also updated a few things, such as being able to upload multiple dates within one upload.
What this means for you, the marketer, is you can now achieve deeper insights than ever before, within about 30 minutes. So without further ado, if you are ready to optimize like you’ve never optimized before, here is a step-by-step guide on how to successfully upload cost data within Google Analytics:
1. From the Admin interface of Google Analytics, select the “Data Import” link under the Property to which you want to upload cost data.
2. Within this section, click on the “+New Data Set” button and then select “Cost Data.” Don’t worry if you see a different amount of options than in the screenshot below. If your account is not yet upgraded to Universal Analytics, you will have a lesser amount.
3. Once you proceed to the next step, provide a name for your data set and select the views within the property for which you would like this data imported.
4. Step four, and nearly done. From this section select the schema (dimensions and metrics) that you would like to import, beyond the minimum requirements. The schema you select will be tailored to the marketing channel you are using, the data you have available to import, and what data you need to perform optimizations. Here, I have selected what I find helpful when optimizing paid search campaigns, but again, your schema may vary.
Once you have your schema set up, click the Save button.
5. The last part of the configuration setup is to click the “Get schema” button, which will let you download an Excel template, and then click “Done.”
6. Now to actually import the data. Export your data from your various channel sources and fill in the data in the corresponding columns of your template. When you have your data in the properly formatted template, click on the Data Import link again from the Admin interface and click the “Manage Uploads” link to the right of your data set. From this page, upload your csv file. You should receive a status of Pending until Google Analytics has been able to process your file.
So there you have it, six quick, pain-free steps to gaining access to extremely valuable information for your media campaigns within Google Analytics. Once you have this information imported, start using it within the “Cost Analysis” report suite under the Acquisition section.
The use of psychology in marketing and sales is not new, but it may be more useful than ever in an attention economy where time is precious and focus is rare. How can you tap into a demanding consumer to check whether there is an actual interest in your product?
Two weeks ago, Foursquare announced what could be the most important component of its data business: the Pilgrim SDK. So what does it do, and what does it mean for location-based marketing?
Combining clickstream data with machine-learning technology, behavioral analytics helps enterprises create a tailored online experience for each visitor to their web or mobile sites.
Video performs better than any other type of content – with better engagement, more memorable adverts, and better recall experienced by viewers. But once you start creating video content, how do you know when it’s been successful?