Forum Discussion
Adobe Analytics External Connectors
Hello,
I tried to use PBI Adobe Analytics connectors, but I had lots of issues so I want to try some connectors such as Supermetrics. Do you have any experience with these tools?
Thanks
Tomas
Hi tomasmartinek ,
For Power BI Desktop connect to Adobe Analytics data:
1. Select Get Data from the Home ribbon in Power BI Desktop. Select Online Services from the categories on the left, select Adobe Analytics, and then select Connect.
2.To sign in to your Adobe Analytics account, select Sign in.
3.In the Adobe Analytics window that appears, provide your credentials to sign in to your Adobe Analytics account. You can either supply a username (which is usually an email address), or select Continue with Google or Continue with Facebook.
4.Once you've successfully signed in, select Connect.
For connect Supermetrics to Adobe Analytics:
Once you’ve created your service account and made note of its credentials, you’re ready to connect it to Supermetrics.
- Open Supermetrics in your destination.
- Under Data sources, select Adobe Analytics.
- Choose Connect with a service account.
- Enter the client ID, technical account ID, organization ID, and client secret from the service account creation process.
- Click Start.
- Once the credentials are validated, click Create to finalize the connection.
More reference: Adobe Analytics (service account): Permissions guide : Supermetrics Support Forum
New in Supermetrics: an Adobe Analytics connector
Power Query Adobe Analytics connector - Power Query | Microsoft Docs
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi tomasmartinek ,
For Power BI Desktop connect to Adobe Analytics data:
1. Select Get Data from the Home ribbon in Power BI Desktop. Select Online Services from the categories on the left, select Adobe Analytics, and then select Connect.
2.To sign in to your Adobe Analytics account, select Sign in.
3.In the Adobe Analytics window that appears, provide your credentials to sign in to your Adobe Analytics account. You can either supply a username (which is usually an email address), or select Continue with Google or Continue with Facebook.
4.Once you've successfully signed in, select Connect.
For connect Supermetrics to Adobe Analytics:
Once you’ve created your service account and made note of its credentials, you’re ready to connect it to Supermetrics.
- Open Supermetrics in your destination.
- Under Data sources, select Adobe Analytics.
- Choose Connect with a service account.
- Enter the client ID, technical account ID, organization ID, and client secret from the service account creation process.
- Click Start.
- Once the credentials are validated, click Create to finalize the connection.
More reference: Adobe Analytics (service account): Permissions guide : Supermetrics Support Forum
New in Supermetrics: an Adobe Analytics connector
Power Query Adobe Analytics connector - Power Query | Microsoft Docs
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi tomasmartinek were you able to find a solution? I've used Supermetrics and worked great but was quite expensive. I finally moved to windsor.ai's Adobe connector, it works great and is cheaper. In case you wonder, to make the connection first search for the Adobe connector in the data sources list:
Then, you should enter your Adobe credentials to make the connection. After that, you'll see a preview of your data where you can select the fields you want to see in PBI.
Finally, you just have to choose PBI as destination and copy and paste the url that will appear there in PBI desktop --> Get Data --Web > --> Paste the link
I would recommend to replace Supermetrics with your own code. This way you pay once for setting the code up and you never have to worry about subscription fees anymore. This way you are saving yourself money in the long terms. Here is an out of the box offer that does exactly this: https://vidi-corp.com/fixed-price-supermetrics-altertative/
