We have a Google Analytics account with active e-commerce tracking.
I'm trying to find an easy way how to import offline conversions to GA (f.e. visitor like something on a web but makes a call to order (we don't know the User-ID of a visitor)).
My vision was to create a simple two row table:
Date of call (conversion) | Value of conversion | SKU
Feb-01 | $100 | 12345ABC
Feb-01 | $1337 | 12345ABCD
Feb-02 | $250 | 12345ABCDE
Is this somehow possible? I'm trying to avoid hardcore API or measurement protocol programming (because I need to make it as simple as possible for further use).
The idea was to gather a list of all offline conversions in past week and then import it through Data Import. I just can't figure out how to set up the right data set in GA (and if that is even possible or if we need to use API or measurement protocol techniques)
Data import does not allow to create hits from scratch, so your idea will not work.
One (relatively) easy idea would be to build an HTML form that allows your telephone operator to enter the products your visitor buys and that uses the standard e-commerce-tracking code to submit this to Google Analytics.
But if your backend system allows for modifications it would be better to connect your inventory management/fullfillment and GA via the measurement protocol (for one thing you would get consistent transaction ids between backend and GA).