[SalesForce] Accessing those IGO_ and PI_ data extensions

I need to access the data collected via collect code and stored in the data extensions (DE) starting with PI_ or IGO_

I can see the DEs but they are all empty. I believe a SFMC service team can make the data come through, but somewhere I have read that it is possible to access the data via queries.

I made the simplest test, duplicating one of the DE:s ("IGO_PROFILES") and trying to populate it with this query:

SELECT *
FROM IGO_PROFILES

The result is that my target DE is as empty as it's "parent".

Any ideas on how to query those DEs or access the data without asking support for help?

The data I want is information on location, paths, referring sites. We don't have specific products so fields like "sku" is not interesting.

The data is visible in the Web and Mobile tab, so that part works.

Please fill me in on this. I think information/documentation is really poor regarding this.

Best Answer

From my understanding I think you need to contact your SFMC representative to have it activated before you can access it at all. That was the information I recieved in another thread here.

Related Solutions

[SalesForce] Triggered Send Data Extensions

Yes - it is a requirement to use the TS data extensions if you have a data extension available.
There is not a programmatic way of altering/converting the type.

The triggered send data extension is not meant to send to subscribers, but rather collect those who have been sent a triggered message. The data extensions with data already in them, aren't really important in this case, since you haven't started sending.

You should be able to set up new data extensions with the TS template, and use it in your TSD.

[SalesForce] Accessing _MobileAddress and _MobileSubscription Data Extensions

So, the field names are correct (though not a complete list). They contain an underscore before each of them in the Data Extension. This makes things difficult when pulling the fields out using SELECT * because fields in [user created] Data Extensions cannot have a leading underscore.

So if you want to pull all the records from _MobileAddress you will need the following query:

SELECT _CarrierID AS CarrierID,
_Channel AS Channel,
_City AS City,
_ContactID AS ContactID,
_CountryCode AS CountryCode,
_CreatedBy AS CreatedBy,
_CreatedDate AS CreatedDate,
_FirstName AS FirstName,
_IsHonorDST AS IsHonorDST,
_LastName AS LastName,
_MobileNumber AS MobileNumber,
_ModifiedBy AS ModifiedBy,
_ModifiedDate AS ModifiedDate,
_Priority AS Priority,
_Source AS Source,
_SourceObjectID AS SourceObjectID,
_State AS State,
_Status AS Status,
_UTCOffset AS UTCOffset,
_ZipCode AS ZipCode
FROM _MobileAddress

And all the records from _MobileSubscription can be pulled with the following query:

SELECT 
_CreatedBy AS CreatedBy,
_OptOutMethodID AS OptOutMethodID,
_MobileNumber AS MobileNumber,
_OptInDate AS OptInDate,
_Source AS Source,
_OptOutStatusID AS OptOutStatusID,
_OptOutDate AS OptOutDate,
_ModifiedBy AS ModifiedBy,
_SourceObjectId AS SourceObjectId,
_SubscriptionDefinitionID AS SubscriptionDefinitionID,
_CreatedDate AS CreatedDate,
_OptInStatusID AS OptInStatusID,
_OptInMethodID AS OptInMethodID,
_ModifiedDate AS ModifiedDate
FROM _MobileSubscription

Best Answer

Related Solutions

[SalesForce] Triggered Send Data Extensions

[SalesForce] Accessing _MobileAddress and _MobileSubscription Data Extensions

Related Topic