Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Adobe Analytics Connector Limiting Dimensions

I am using the Adobe Analytics connector for one of my reports. One of my 'Dimensions' is called 'Websites' and the data is a URL, we look at over 100 websites and I am looking at the traffic for eac...
Need Help
  • jeffshieldsdev's avatar
    jeffshieldsdev
    7 years ago

    You'll want to use the Top parameter with your dimensions.  You can get up to 50,000 dimension values per call.

    {Cube.ApplyParameter, "Top", {10000, "evar123"}},
{Cube.ApplyParameter, "Top", {1000, "evar234"}},

    If you open the log for the Report Builder, you should see which elements are using "top" in the json of the reportDefinition:

    ... ,
    "elements": [
      {
        "id": "evar123",
        "top": 10000,
        "startingWith": 1
      }
    ],
...

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

jeffshieldsdev Thank you for this fantastic tip. It really helps. I was looking to import the page dimension and by default I was getting 10 values back by date..but now I can expand this to higher limits.

Could you please share any relevant documentation where you got this information. I would like to understand better about 50,000 dimension values. Also, where were you able to find that by default it gives top 10 values. Any help would be appreciated. Thanks.

jeffshieldsdev's avatar
jeffshieldsdev
Solution Sage
5 years ago

It's a bit buried.

The connector uses Adobe's Analytics 1.4 API.  The Reporting API has a Report.Queue method it uses, and POSTs this reportDescription in the body.  The reportDescriptionElement in the reportDescription has the "top" parameter.

In a few reports, I've used the API and Postman to download historical data (2017,2018,2019) to .JSON files I store in OneDrive, and then only use the connector in the report to get "live" data (2020 forward).  I merge these together into one table in the Query Editor.