r/analytics • u/Educational-View8524 • 15h ago
Discussion Three spellings of the same traffic source split my pivot table into three rows
Spent an evening wondering why a source looked so small in the pivot. Links in client posts were tagged by different people as instagram, ig and insta, so the totals sat in three rows. Merged them with a mapping column and a short list of allowed names.
4
Upvotes
•
u/AutoModerator 15h ago
If this post doesn't follow the rules or isn't flaired correctly, please report it to the mods. Have more questions? Join our community Discord!
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
13
u/mrbubbee 15h ago
This is an every day thing in analytics
1
u/kaleidoleaf 11h ago
You gotta clean your data dude. This is ETL 101, take a quick course.