Present what is the volume of email send requests we receive daily from our upstream, how much percent we finally send and the reason
MySQL:
I need to present what is the volume of email requests we receive daily from upstream, how much percent we finally send, and a break of all the exclusions along with the error reason
TableA- This table contains all the input data received from upstream(columns: uniqueid,emailaddr,timestamp)
TableB- This table contains all the request payloads that has rejected in the initial phase itself due to data issues or validation error’s (columns: uniqueid,emailaddr,timestamp,errorreason)
TableC- This table contains all the campaign output or email sent data( column names same as tableA)
TableD- This table contains all the records rejected during campaign run along with reason(column names same as tableB)
Present what is the volume of email send requests we receive daily from our upstream, how much percent we finally send and the reason
MySQL:
I need to present what is the volume of email requests we receive daily from upstream, how much percent we finally send, and a break of all the exclusions along with the error reason
TableA- This table contains all the input data received from upstream(columns: uniqueid,emailaddr,timestamp)
TableB- This table contains all the request payloads that has rejected in the initial phase itself due to data issues or validation error’s (columns: uniqueid,emailaddr,timestamp,errorreason)
TableC- This table contains all the campaign output or email sent data( column names same as tableA)
TableD- This table contains all the records rejected during campaign run along with reason(column names same as tableB)