Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Adobe Analytics data feed via adobe datawarehouse and datafeed

Avatar

Avatar
Validate 1
Level 1
ahmedm66373109
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
ahmedm66373109
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
ahmedm66373109
Level 1

27-07-2018

Hello,

I am working as a Data Analyst using Adobe Analytics and have some questions.

I need to pull large dataset to extract, load and transform (ELT) and then load it to Tableau Server.

Options I have:

1. Report builder

Limitation: Too slow for huge data

2. Datawarehouse:

Limitation: Doesnt  support calculated metrics!

3. Data feed:

- Need to know if it can feed data to tableau server?

- Need to know whether it supports calculated metrics?

Thanks

Ahmed

contact.ahmedmukhtar@gmail.com

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct Reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct Reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile
PratheepArunRaj
Moderator

29-07-2018

Dear Ahmed,

Below are my comments:

Report builder: Use this only if you want to feed small amount data.

Data warehouse: This is the option I would recommend if your data is not live streaming. Calculated Metrics can be extracted via ETL process but the gap is that pathing metrics (entries, exits, bounces, etc) are not available in data warehouse.

So if you need pathing metrics, you should go with data feed.

Datafeed: This is most robust way of data extraction. Data feed is the just raw variables in a Server Call and you have to calculate all the metrics(Including calculated metrics) manually through ETL. Below the link on how the calculation is done : Calculating Metrics. I am not sure whether ETL will do everything in a perfect way.

Also, if you are planning to integrate Tablaeu with Adobe Reports and Analytics, can you check the connector Cognetik : https://www.cognetik.com/cloud-tableau-connector. It is free tool with limited capabilities. If needed, you can check for premium version.

Thank You

Arun

Answers (3)

Answers (3)

Avatar

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct Reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct Reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile
PratheepArunRaj
Moderator

30-07-2018

Dear Ahmed,

I am not proficient on ETL but we have done it using SAS and then uploaded into Tableau.

Thank You

Arun

Avatar

Avatar
Level 1
ahmedm70730944
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
ahmedm70730944
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
ahmedm70730944
Level 1

30-07-2018

Can you explain it further please?

"Calculated Metrics can be extracted via ETL process"

What kind of ETL process would that be?

Avatar

Avatar
Level 1
ahmedm70730944
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
ahmedm70730944
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
ahmedm70730944
Level 1

30-07-2018

Thank you Pratheep, Really Appreciate!

I am going to try Tableau connector for sure!!

Thanks