Data migration from Omniture to Google Adwords

tushart16982

14-01-2019

I have a site where leads are being submitted. My purpose is to capture this data from Adobe Analytics and set up a process of sending this data to Google Adwords. What possible options do I have?

Accepted Solutions (0)

Answers (3)

Answers (3)

tushart16982

14-01-2019

Can the data retrieved from Adobe Analytics (which is mapped against gclid) be uploaded to Adwords using Offline Conversion tracking option in Adwords? I only know about this option in theory but haven't done this is in practical. What would be your thoughts?

ursboller

MVP

14-01-2019

don't know of any direct solution, so I'm interested in this as well.

one way we already tested manually, but not automated is as follow.

idea: use googlesheet to upload offline converts from adobe analytics to google ads account, identifier is gclid

steps to do

1) add the GCLID as generic parameter in your adwords account. eg. add the parameter gclid={{gclid}}. this will add the gclid to each link where a user clicked

2) add a processing rule and write the parameter gclid to an evar

3) create new VRS with basic privileges regarding data reporting (just basic reporting on converts for gclid's)

4) create new API user who has access to the VRS

5) create google sheet with google script: the script downloads each day at 4:00 am the convert data for each gclid for the last 2 days and writes them to a sheet

6) setup ads account to automatically import data in the google sheet (each day at 6:00 am)

having this setup would allow you to see offline converts directly in google ads account.

what I haven't done yet is the google script as described in step 5. everything else works as expected...

but maybe there is an easier way?