We are an analytics provider to websites. We provide a snippet of code, which is similar to google analytics pixel to our end clients to place on their website. Our snippet is generally placed on footer of every page on the website. This snippet works by saving certain unique ids in cookies such as CID - Cookie ID. We want to integrate our solution with google analytics account of the client.
For every user that interacts with the website, we should be send our tag generated cookie id (CID) to google analytics along with the google identification id, which is passed by google analytics itself.
Now that google analytics account has CID information of all visitors who have interacted with the website, a synchronization mechanism should be developed to extract data (additional fields) from our Amazon RDS server or API based on this CID and this data should be populated in google analytics with relation to the CID and other visitor details. This should be done automatically, without any user intervention. GA used should now be able to define audiences for marketing using these new fields that are added to the google analytics.
The deliverables should be website platform independent and visitor browser and device independent.
The solution should be tested on two websites, one is based on wordpress and another native website.