Google Analytics: download advertising cost data from external sources
It is well known that, in terms of detailed data on advertising sources, Google Analytics previously only recognized Google (AdWords & AdSense), providing statistics on cost, CTR, cost per click, etc., in a separate group of “Advertising” reports. Statistics in this report is transmitted only if a set of Google Analytics and Google AdWords / AdSense accounts has been configured. Thus, if you needed to calculate the cost of achieving a specific goal (for example, an application) or an order for advertising sources, please upload the data to Excel, add the cost data from each system (Yandex.Direct, Begun, Vkontakte, FB, media platforms, etc.) and add a calculation field: the cost of placing / the number of orders or goals. Plus, you can still build a graph for clarity, in Excel or Google Spreadsheets.
In the GA interface, data on conversions of traffic sources was only in units and percentages, but not in money. Recently, Google Analytics has the opportunity Cost Data Upload (Expenditure Analysis - Public Beta). Initially, the download of expenditure data by source is made from a CSV file of a specific format for one day through the Google Analytics API (for more details, refer to GA Help).
Total to download the file you need:
')
Statistics on the downloaded data in Google Analytics can be seen in the report Traffic Sources - Cost Analysis.
Sample GA report with cost data
If you don’t want to write your application for working with the GA API, there are ready-made services, for example, Google Analytics Uploader (Free).
In the GA interface, data on conversions of traffic sources was only in units and percentages, but not in money. Recently, Google Analytics has the opportunity Cost Data Upload (Expenditure Analysis - Public Beta). Initially, the download of expenditure data by source is made from a CSV file of a specific format for one day through the Google Analytics API (for more details, refer to GA Help).
Total to download the file you need:
')
- create a source id at the account level. You can create one source and pour everything into it, or you can create your own one, keeping in mind the limit of 25 Custom Data Sources for the free version of GA
- prepare a csv file by format
CSV, ConstraintsEncoding: UTF-8, File size limit: 5 MB
- upload file via GA API
- Advertising cost data should appear in the appropriate Google Analytics profiles within the next 12 hours (I’ll have it instantly).
Statistics on the downloaded data in Google Analytics can be seen in the report Traffic Sources - Cost Analysis.
Sample GA report with cost data
If you don’t want to write your application for working with the GA API, there are ready-made services, for example, Google Analytics Uploader (Free).
Source: https://habr.com/ru/post/162327/
All Articles