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?
