Inconsistencies in data retrieval from ACS through ÃÛ¶¹ÊÓƵ Analytics
This article addresses an issue where differences in data retrieved in ÃÛ¶¹ÊÓƵ Campaign Standard (ACS) and ÃÛ¶¹ÊÓƵ Analytics are seen in the technical workflows which sync data between ACS and Analytics.
Description description
Environment
ÃÛ¶¹ÊÓƵ Campaign Standard (ACS)
Issue/Symptoms
You notice differences in the data retrieved in ACS and ÃÛ¶¹ÊÓƵ Analytics.
Steps to reproduce
- Log in to ACS, and check the delivery dashboard.
- Now, in ÃÛ¶¹ÊÓƵ Analytics, check if same values are fetched from ACS.
Resolution resolution
In ACS, KpiSharing and kpiReconciliation are the technical workflows that sync data between ACS and Analytics. Refer to this guide on Technical workflows for more information.
In this case, the following error is seen in the workflows:
19/06/2023 15:12:14 jsDataSource API call to ÃÛ¶¹ÊÓƵ Analytics failed - Url: https://api.omniture.com/admin/1.4/rest/?method=ReportSuite.GetTimeZone
Request body : {"rsid_list":[ "xxxxprod"] } Response: 400 Error: {"error":"Bad Request","error_description":"Access denied for some selected report suites.","error_uri":null}
19/06/2023 15:12:10 jsDataSource User name: userFirstName.LastName@domain.com:
It occurs because your user name (mentioned in the above error) no longer belongs to an active profile, but is still added to the external account Share KPIs with ÃÛ¶¹ÊÓƵ Analytics (shareKPI)  as the Web Service User Name.
Steps to resolve
- The user name in the external account needs to be changed to that of an active profile, which also has access to Analytics projects.
- Go to Administration
>Application settings>External account. - Choose Share KPIs with ÃÛ¶¹ÊÓƵ Analytics (shareKPI), and change the Web Service User Name.