Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Need help merging two sets of data into 1 single record

Topic Labels: Data Formulas
718 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Thomas_Walker
6 - Interface Innovator
6 - Interface Innovator

Ok, this may be super basic, but I really need help here. 

I've got two sets of data: 

1. Google Analytics
2 aHrefs

The Google Analytics data shows values like traffic, user engagement time, pages visited per session, etc and gives all of this for a single url. 

The aHrefs data gives data like keywords, keyword difficulty, search volume, etc, but instead of showing all of this data on a single url, it will give 50 of the same url (this is an arbitrary number) because aside from the url, all of the other data is unique. 

What I would like to do is combine all of that information into a single URL, 

So if there is one url, it will show me all of the different keyphrases it is ranking for, an average of their difficulty, etc. 

I need it all in a single record. 

So far, I've tried de-dupe, but it won't merge the different keyword values into a single field, it will just eliminate multiple of the same, and I'm a weeny with formulas, but tried the CONCATENATE() formula, but it also didn't do what I was looking for. 

Any suggestions? 

2 Replies 2
Thomas_Walker
6 - Interface Innovator
6 - Interface Innovator

Nevermind, I have figured it out. 

What was your solution?


Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/