


CIGM
CIGM
27-10-2017
Hi,
I am trying to created a personalized report taking Adobe defaults one as an example to show email engagement stats (Campaign name, Delivered, Sent, CTR, CTOR, AR, Unsubscribes, etc). I want to create something very basic where o script is required so I am querying the delivery logs nms table, creating a table and feeding the data back to the query again. It looks like the below:
However when I double click on the edit storage tab within the table (filter entities, edit properties) the database field is empty so it's seems is not recognizing the delivery logs query created.
I reckon it's not recognizing where I am taking the data from and all the fields seem to be selected correctly on my delivery nms query.
Any help would be much appreciated.
Best,
C
florentlb
florentlb
06-11-2017
Hi C,
Have you tried following the examples in this page: Creating a new report ?
Can you share the details of your first query to retrieve delivery logs?
Florent
CIGM
CIGM
06-11-2017
Hi Florent,
I did thanks for sending it over. This is how I have my query built:
Best,
C
florentlb
florentlb
30-11-2017
Hi,
Not sure of the data you're extracting with the query. In your report, I'd guess you would want to display numbers but I don't see any count in your query. As an example, you can use the tracking indicators or summary of deliveries oob reports.
Let me know,
Florent
CIGM
CIGM
01-12-2017
Thanks, I will do that!
florentlb
florentlb
02-01-2018
Hi,
Were you able to pull the correct data?
Florent
CIGM
CIGM
11-01-2018
Yes, cheers Florent