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

Merging Adwords data and Adobe Analytics data in a data lake

Avatar

Avatar
Validate 10
Level 4
alv123456
Level 4

Likes

71 likes

Total Posts

118 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Boost 50
Boost 5
Boost 3
View profile

Avatar
Validate 10
Level 4
alv123456
Level 4

Likes

71 likes

Total Posts

118 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Boost 50
Boost 5
Boost 3
View profile
alv123456
Level 4

11-03-2019

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
MVP
ursboller
MVP

Likes

525 likes

Total Posts

1,020 posts

Correct Reply

257 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

525 likes

Total Posts

1,020 posts

Correct Reply

257 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile
ursboller
MVP

11-03-2019

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".

Answers (0)