Dojo,
I am having some trouble with data inconsistencies and incorrect formatting of metrics within one of the Adobe Analytics Connections I made.
I tried 2 test connections to see where the problem was coming from. In one of my connections I brought in the External Campaign ID element, one broad segement and the Visits and Visitors metrics. When doing QA, I am able to view the correct amount of visits for the specific campaigns I was analyzing.
I created the exact same connection but this time I included the Visits, Visitors, Bounces, Bounce rate, LMG First Engagement Rate (a personal metric created in Adobe), LMG Most Valued Engagement (a personal metric created in Adobe) and Total Time Spent metrics. When I try viewing the metrics for the campaigns, there are completely different External Campaign ID names and missing data.
Furthermore when I do pull in these metrics, their default format is Text, however in Adobe, they are accurately displayed as numbers (rates). I tried utilizing the Magic ETL Data Flows to change the column format, but I receive errors.
There seems to be an error in the way these Adobe metrics are being pulled into DOMO only for one specific Suite, as I performed a similar analysis using the same Adobe credentials with other Suites and did not see either of these data problems. I also connected using separate Adobe credentials for a different website and did not see these data inconsistencies.
Why would the values of various metrics such as number of visits change and the External Campaign ID’s element options change when I bring in metrics other than visits and visitors such as Bounce Rate and Engagement Rate?
Please let me know if you have any insights into where these issues could be developing from.
Thank you!