Skip to main content
Notice removed Authoritative reference needed by mario ruiz
Bounty Ended with Jonas Lamberty's answer chosen by mario ruiz

I have a Sendable Data Extension with thousands of records. Each record represents an email request and its properties values. I was looking for a way to get a unique id for each row, if any exists. I seesaw this and I think isthought it might be useful Autonumber in Marketing Cloud?

However as athe existence of a row is not a warrantyguarantee that the email has been sent, how can I match or confirm if an email request that exists in the sendable Data Extension was really sent or not? Is there any other SQL query I can run to filter the sent from the unsent? Is there any row column referring to the send status?

I have a Sendable Data Extension with thousands of records. Each record represents an email request and its properties values. I was looking for a way to get a unique id for each row if any exists. I see this and I think is useful Autonumber in Marketing Cloud?

However as a existence of a row is not a warranty that the email has been sent, how can I match or confirm if an email request that exists in the sendable Data Extension was really sent or not? Is there any other SQL query I can run to filter the sent from the unsent? Is there any row column referring to the send status?

I have a Sendable Data Extension with thousands of records. Each record represents an email request and its properties values. I was looking for a way to get a unique id for each row, if any exists. I saw this and I thought it might be useful Autonumber in Marketing Cloud?

However as the existence of a row is not a guarantee that the email has been sent, how can I match or confirm if an email request that exists in the sendable Data Extension was really sent or not? Is there any other SQL query I can run to filter the sent from the unsent? Is there any column referring to the send status?

Notice added Authoritative reference needed by mario ruiz
Bounty Started worth 50 reputation by mario ruiz
added 52 characters in body; edited title
Source Link
mario ruiz
  • 382
  • 3
  • 22

filtering sent from unsent emails

I have a Sendable Data Extension with thousands of records. Each record represents an email request and its properties values. I was looking for a way to get a unique id for each row if any exists. I see this and I think is useful Autonumber in Marketing Cloud?

However as a existence of a row is not a warranty that the email has been sent, how I can I match or confirm if an email request that exists in the sendable Data Extension was really sent or not? Is there any other SQL query I can run to filter the sent from the not sentunsent? Is there any row column referring to the send status?

filtering sent from unsent

I have a Sendable Data Extension with thousands of records. Each record represents an email request and its properties values. I was looking for a way to get a unique id for each row if any exists. I see this and I think is useful Autonumber in Marketing Cloud?

However as a existence of a row is not a warranty that the email has been sent how I can match or confirm if an email request that exists in the sendable Data Extension was really sent or not? Is there any other SQL query I can run to filter the sent from the not sent?

filtering sent from unsent emails

I have a Sendable Data Extension with thousands of records. Each record represents an email request and its properties values. I was looking for a way to get a unique id for each row if any exists. I see this and I think is useful Autonumber in Marketing Cloud?

However as a existence of a row is not a warranty that the email has been sent, how can I match or confirm if an email request that exists in the sendable Data Extension was really sent or not? Is there any other SQL query I can run to filter the sent from the unsent? Is there any row column referring to the send status?

added 275 characters in body
Source Link
mario ruiz
  • 382
  • 3
  • 22

sendable data extension unique row id filtering sent from unsent

I have a Sendable Data Extension with thousands of records. Each record represents an email request and its properties values. I was looking for a way to get a unique id for each row if any exists. I see this and I think is useful Autonumber in Marketing Cloud?

I have a primary keyHowever as a combinationexistence of different properties in which case I can use it as a unique id for each row. However I was trying to find an internal unique id is not a warranty that the email has been sent how I can retrieve using SQL query. Is there such a thingmatch or confirm if an email request that exists in the sendable Data ExtensionsExtension was really sent or not? Is there any other SQL query I can run to filter the sent from SFMCthe not sent?

sendable data extension unique row id

I have a Sendable Data Extension with thousands of records. Each record represents an email request and its properties values. I was looking for a way to get a unique id for each row if any exists.

I have a primary key as a combination of different properties in which case I can use it as a unique id for each row. However I was trying to find an internal unique id that I can retrieve using SQL query. Is there such a thing in Data Extensions from SFMC?

filtering sent from unsent

I have a Sendable Data Extension with thousands of records. Each record represents an email request and its properties values. I was looking for a way to get a unique id for each row if any exists. I see this and I think is useful Autonumber in Marketing Cloud?

However as a existence of a row is not a warranty that the email has been sent how I can match or confirm if an email request that exists in the sendable Data Extension was really sent or not? Is there any other SQL query I can run to filter the sent from the not sent?

Source Link
mario ruiz
  • 382
  • 3
  • 22
Loading