There are more options I'm going to mention, but some of the options available in Google Analytics only apply to Google Ads accounts. Here are some of the optional datasets to include if you want to implement other paid media channel information Referral path Advertising content Campaign Final URL Keyword Search query How to create your CSV for cost data import When creating your spreadsheet you can use this sheet as an example , each of the data points mentioned in the previous section should be in their own column. This example I'm giving is retrieving LinkedIn information for one of my clients campaign names changed for June.
How to import cost data into google analytics—csv template Format column header And when creating our column headings, we can't just add the words Campaign or Medium . We need to make sure our headers are formatted correctly. If you do not do this, your upload will be refused. So instead of having mobile number list Date as the column header, format it as ga date. Instead of using Medium as your column header, format it as ga medium. Date format The next important formatting rule is for the date. You must have your date formatted as. And because the format is YYYYMMDD, it means that all the date information you retrieve must be at the day level.
File name Finally, if you 're importing campaign names, I recommend making sure that the names in your file uploads match campaign names you might manually tag in your URLs. Failure to do so may result in duplicate campaigns appearing in Google Analytics and the data may be split between the same campaigns with different names. When you select your columns in Google Analytics, you will see the Schema ID as shown in the image below . how to import cost data into Google Analytics—schedule ID tab Now that we've entered this, let's go to Google Analytics and upload the data.