Automating Conversions Report on Google Analytics

 

Purpose: Sometimes there is some confusion about last click attribution i.e. who to allocate the sale to from the advertiser's end.

The data in this report will be tracked on the basis of the utms used in the tracking link on DCMnetwork. 

This report updates who was allocated the sale, and so we update our conversion report according to your data.

UTM Structure Example

https://www.domain.com/?utm_source=dcmn&utm_medium=affiliate&utm_content=1000_102727ae093739303ea8e5bb9949f3

Note utm_content is used by DCMnetwork for its own system reports.

Setting Up The Report:

Add dimensions: ad_content + Date + Order ID

Metrics: Transactions, sale amount, sessions

filters: source = dcmn

 

Sharing report:

Report Title:
Conversions For: [ BRAND NAME ]

Share report with:
Email: conversions-no-reply@dcmnetwork.com

File Format:
CSV

Email Body:

 

Schedule 2 emails 
1. Daily email.

2. A monthly email scheduled for the 3rd of every month. [The report should show all transactions that happened in the previous month]

3. Only if there are conversions 

Variables passed in reports:

Please note that the report should show the following data:

 

Field Name

Description Mandatory Example

Ad_content

DCMnetwork reference Yes 1000_102727ae093739303ea8e5bb9949f3
Date dd/mm/yyyy Yes 11/07/2018
Order ID Customer Order ID/Transaction ID No B2C3877983 / 1009
Revenue Without shipping charges Yes

1850.03

Example:

Automated_reports_Columns_Order.PNG

Also please check with your developer to find the variables that your Google analytics uses to pass revenue and Order ID.

Note: 

Please ensure that there is only one daily report & one monthly report being sent to conversions-no-reply@dcmnetwork.com

To check scheduled reports: 

Admin > View > All website data > Scheduled Emails 

Screenshot_070318_030954_PM.jpg

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.