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.
For years, advertisers have tolerated a big elephant in the room: the fact that their digital ads aren't always appearing where they would want them to.
How can marketers master the art of engaging their users on mobile? Here are five often overlooked but rewarding strategies you can use.
“You cannot succeed in analytics and marketing unless they are central to business operations and are helping business answer the questions that will drive dollars to the top or bottom line,” says Kerem Tomak, Sears Chief Digital Marketing & Analytics Officer.
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?