Hi all,
Need your help in a following question:
Our business is online retail. We track visits in google analytics and we track purchases on our site with accounting data stored in SQL server.
What we want to see in domo is conversion rate: number of purchases per day / number of visitis per same day.
First I think we need to connect data from SQL and from google analytics:
Data from SQL is already in DOMO and looks in the following way:
Date ; Order #
21 Nov 2017; 000001
21 Nov 2017; 000002
21 Nov 2017; 000003
Data from Google analytics is the following:
Date; Number of visits
21 Nov 2017; 6
22 Nov 2017: 10
23 Nov 2017: 11
What I need to build
Date; Number of visits; Number of Orders; Conversion rate
21 Nov 2017; 6 ; 3 ; 50%
22 Nov 2017; 10 ; 0 ; 0%
23 Nov 2017 ; 11 ; 0 ; 0%
Please help. I assume that 1st thing I need is to connect data with ETL but i tried to use data column and a common criteria and that doesn't work for some reason