Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Merging Adwords data and Adobe Analytics data in a data lake

alv123456
Level 6
Level 6

Hello,

I wonder if anybody has experience in setting up a data lake containing Adwords and adobe analytic data?

How do you connect the two data sets? is there any linking element which could be used to join the visit of the user with the adwords data?

1 Accepted Solution
ursboller
Correct answer by
Community Advisor
Community Advisor

I have no experience with datalakes itself, but might work similar to AdvertisingAnalytics.

First, if you do not need it in a datalake by requirement, I would suggest you use Advertising Analytics. Basically you append a custom parameter at each Adwords Link which allows to connect backend data from AdWords.

See here: Advertising Analytics Overview

If you really want it in a data lake, either use above setup (and use the parameters as they are already available) or setup something yourself.

For a custom setup define a generic link parameter for each adwords campaign. you can use the generic parameters as described here: List of All ValueTrack Parameters in Google AdWords - Karooya basically you add the generic parameter in the top level of you accounts to append on any link.

next, track those URL parameters from the user in any analytics variable you want.

and finally, download both adobe analytics data as well as adwords data and match on the "parameter".

View solution in original post

1 Reply
ursboller
Correct answer by
Community Advisor
Community Advisor

I have no experience with datalakes itself, but might work similar to AdvertisingAnalytics.

First, if you do not need it in a datalake by requirement, I would suggest you use Advertising Analytics. Basically you append a custom parameter at each Adwords Link which allows to connect backend data from AdWords.

See here: Advertising Analytics Overview

If you really want it in a data lake, either use above setup (and use the parameters as they are already available) or setup something yourself.

For a custom setup define a generic link parameter for each adwords campaign. you can use the generic parameters as described here: List of All ValueTrack Parameters in Google AdWords - Karooya basically you add the generic parameter in the top level of you accounts to append on any link.

next, track those URL parameters from the user in any analytics variable you want.

and finally, download both adobe analytics data as well as adwords data and match on the "parameter".

View solution in original post