Analytics
2.1K members online now
2.1K members online now
Learn how to set up goals and Ecommerce tracking, verify accuracy of attribution traffic sources, and discuss funnel visualization, Multi-Channel Funnels, the Goal Flow Report, and Enhanced Ecommerce
 
Guide Me
star_border
Reply

Import Offline Conversions in GA

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,

 

For our shop we have 90% conversions on the site, but about 10% offline conversions via phone or direct sales.

 

Is it possible to import these 10-20 offline conversions into Google Analytics per month or so? We don't have a CRM or something to connect the conversion to a client id, but we'd still like to view the total amount of conversions/conversion rate/revenue all together in GA.

 

Does anyone have any experience with this? Your help would be very much appreciated! Smiley Wink

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Hessel M
May 2016

Re: Import Offline Conversions in GA

Follower ✭ ✭ ✭
# 3
Follower ✭ ✭ ✭
Hello,

There are ways of doing it via the measurement protocol. https://developers.google.com/analytics/devguides/collection/protocol/v1/
An easy way to build the hit (after you read the documentation) is https://ga-dev-tools.appspot.com/hit-builder/

You can send it as an ecommerce hit.
However you need some king of user identifier to tie the data back to something.
If you don't care about it you can just add a random CID (even the same on for all of them) and all those offline transactions will show up for that "user"

View solution in original post

Re: Import Offline Conversions in GA

Rising Star
# 2
Rising Star
Hi Hessel,

Yes you can do this pretty easily. Without a CRM you will get diminishing returns though as that is where the real power comes in. Without persistent carts, log-ins, etc. to tie to the client id, the attribution will be to not set.

A couple of things, transactions show up on the day you push them so if you only do it once a month, then that day will have a spike - you could set a custom dimension with the date of the transaction but that's asking your analyst to go in an discern the actual revenue distribution and since you wont have a client id, you may want to just construct one to pass in for all offline transactions. (If you wanted to get really sophisticated you could create a function on your site to direct your visitors to execute which would get the client id you could call it customer number or something and they could pass to your call center folks and would give you proper attribution).

So my recommendation is to use the measurement protocol and bake it in your systems to push immediately an offline transaction is completed (or nightly in batch).

Here are some resources for you:

Client ID
https://developers.google.com/analytics/devguides/collection/analyticsjs/cookies-user-id#getting_the...

Measurement Protocol
https://developers.google.com/analytics/devguides/collection/protocol/v1/#getting-started

Bottom-line, you need developer resources to make this happen.

Best,

Theo Bennett

Analytics Evangelist at MoreVisibility | Contact Me
Connect on LinkedIn
Marked as Best Answer.
Solution
Accepted by topic author Hessel M
May 2016

Re: Import Offline Conversions in GA

Follower ✭ ✭ ✭
# 3
Follower ✭ ✭ ✭
Hello,

There are ways of doing it via the measurement protocol. https://developers.google.com/analytics/devguides/collection/protocol/v1/
An easy way to build the hit (after you read the documentation) is https://ga-dev-tools.appspot.com/hit-builder/

You can send it as an ecommerce hit.
However you need some king of user identifier to tie the data back to something.
If you don't care about it you can just add a random CID (even the same on for all of them) and all those offline transactions will show up for that "user"

Re: Import Offline Conversions in GA

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭
Ah thanks! The Hit Builder is exactly what I was looking for.

Do you know if it's also possible to overwrite a transaction via the Hit Builder? In that case I can rewrite a cancelled transaction to €0,00.

Re: Import Offline Conversions in GA

Rising Star
# 5
Rising Star
Hessel,

You can't technically overwrite the value or erase transactions. That said, the data is cumulative as you look over the date range of the hits so what you do is push another transaction with the same transaction id and a value to adjust. So if a transaction was originally for 100 and it was completely refunded you would send -100 as the revenue value for the transaction.

The problem you will have using the hit builder is that if this is not done programmatically, in real time, then your transaction will show on the days you push them in. That is, if you have a transaction that occurs on May 1 for 100 and you push the refund on May 30 when you look at the transaction with date range that included May 1 you will see the 100 revenue and if you look at a date range that includes both dates you'll see 0 and if you look at a range that only includes the 30th you'll see -100 for the transaction. Similarly, whenever you push the transaction in the hit builder it will register that day and not the day it occurred.

You can also do refunds both partial and full by using data import if you are using Enhanced Ecommerce.

https://support.google.com/analytics/answer/3191589?hl=en

Best,

Theo Bennett
Analytics Evangelist at MoreVisibility | Contact Me
Connect on LinkedIn

Import Offline Conversions in GA

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

This reply is very close to solving what we're struggling with! 

 

We need to set the date of a transaction to the date of the original session (not the date we're sending the transaction to UA). We are using CID to match the transacitons.

 

Is there a way to set the date in the hit? There doesn't seem to be a parameter for that..

 

 

Import Offline Conversions in GA

Rising Star
# 7
Rising Star

Hey Tom,

 

The transaction will always be tied to the dates the hit is sent.  You can; however, create a new custom dimension for this and send the custom dimension with the actual transaction date.

 

More on custom dimensions here:

 

https://support.google.com/analytics/answer/2709828?hl=en

 

Best,

 

Theo Bennett

Analytics Evangelist at MoreVisibility | Contact Me
Connect on LinkedIn