Schema Information for Podscribe

Need help with something?

Talk to data expert

In this article, we will look at the schema information of the supported APIs and tables for Podscribe.

Find the links to other articles related to Podscribe below:

Tables/APIs Supported

The tables and APIs associated with the Podscribe connector are as follows.

Raw_Attribution_Conversions

Source API Documentation: https://docs.api.podscribe.com/#/paths/api-public-conversions/post

Replication Type: Key Based 

Name Data Type
Advertiser STRING
PurchasedAt STRING
Action STRING
Discountcode STRING
PurchaseAmount STRING
WeightedPurchaseAmount STRING
ConversionWeight STRING
Ordernumber STRING
MediaType STRING
Campaign STRING
Tags STRING
Category STRING
Publisher STRING
ShowLastListenedTo STRING
ShowLastListenedToID STRING
PublisherShowStationName STRING
Episode STRING
EpisodeID STRING
LastHeardAd STRING
LandingURL STRING
RefererURL STRING
Newcustomer STRING
ConversionUA STRING
ImpressionUA STRING
IP STRING
Currency STRING
ISPWeight STRING
MobileAdID STRING
DeviceID STRING
RawAction STRING
Country STRING
HashedEmail STRING
Meta STRING
CampaignInternalID STRING
PublisherID STRING
ProductfromCampaign STRING
Initiative STRING
SurveyResponse STRING
Creativeid STRING
ProductfromEvent STRING
BusinessLine STRING
ShowiTunesID STRING
CampaignInitiative STRING
ProgPublisher STRING
SessionLandingURL STRING
SessionRefererURL STRING
EventURL STRING
_daton_user_id NUMERIC
_daton_batch_runtime NUMERIC
_daton_batch_id NUMERIC


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Impressions

Source API Documentation: https://docs.api.podscribe.com/#/paths/api-public-impressions/post

Replication Type: Key Based 

Name Data Type
Week STRING
Day STRING
Advertiser STRING
MediaType STRING
Geo STRING
Type STRING
Tags STRING
Spend STRING
Publisher STRING
Campaign STRING
Show STRING
Episode STRING
PublishDate STRING
PodcastStreamingImpressions STRING
YouTubeViews STRING
Reach STRING
Visitors STRING
Visits STRING
Leads STRING
Installs STRING
Signups STRING
Purchases STRING
Revenue STRING
VisitorsModeled STRING
VisitsModeled STRING
LeadsModeled STRING
InstallsModeled STRING
SignupsModeled STRING
PurchasesModeled STRING
RevenueModeled STRING
Clicks STRING
CampaignID STRING
Product STRING
Initiative STRING
BusinessLine STRING
RumbleViews STRING
SpotifyVideoViews STRING
EpisodeGUID STRING
CampaignInitiative STRING
IncrementalVisitors STRING
IncrementalVisitorsModeled STRING
VisitorsChannelIncremental STRING
IncrementalLeads STRING
IncrementalLeadsModeled STRING
LeadsChannelIncremental STRING
IncrementalInstalls STRING
IncrementalInstallsModeled STRING
InstallsChannelIncremental STRING
IncrementalSignups STRING
IncrementalSignupsModeled STRING
SignupsChannelIncremental STRING
IncrementalPurchases STRING
IncrementalPurchasesModeled STRING
PurchasesChannelIncremental STRING
IncrementalRevenue STRING
IncrementalRevenueModeled STRING
IncrementalVisits STRING
IncrementalVisitsModeled STRING
VisitsChannelIncremental STRING
CampaignPromo STRING
CampaignStartDate STRING
CampaignExpectedDate STRING
CampaignEndDate STRING
_daton_user_id NUMERIC
_daton_batch_runtime NUMERIC
_daton_batch_id NUMERIC

 

Campaign_Show_Impressions

Source API Documentation: https://docs.api.podscribe.com/#/paths/api-public-campaign-show-impressions/post

Replication Type: Key Based 

Name Data Type
Week STRING
Day STRING
Advertiser STRING
MediaType STRING
Type STRING
Tags STRING
Spend STRING
Publisher STRING
Campaign STRING
Show STRING
Episode STRING
PublishDate STRING
PodcastStreamingImpressions STRING
YouTubeViews STRING
Reach STRING
Visitors STRING
Visits STRING
Leads STRING
Installs STRING
Signups STRING
Purchases STRING
Revenue STRING
VisitorsModeled STRING
VisitsModeled STRING
LeadsModeled STRING
InstallsModeled STRING
SignupsModeled STRING
PurchasesModeled STRING
RevenueModeled STRING
Promocodes STRING
Clicks STRING
CampaignID STRING
CampaignInternalID STRING
PublisherID STRING
Product STRING
Initiative STRING
BusinessLine STRING
RumbleImpressions STRING
SpotifyVideoImpressions STRING
EpisodeGUID STRING
CampaignInitiative STRING
IncrementalVisitors STRING
IncrementalVisitorsModeled STRING
VisitorsCampaignIncremental STRING
VisitorsChannelIncremental STRING
IncrementalLeads STRING
IncrementalLeadsModeled STRING
LeadsCampaignIncremental STRING
LeadsChannelIncremental STRING
IncrementalInstalls STRING
IncrementalInstallsModeled STRING
InstallsCampaignIncremental STRING
InstallsChannelIncremental STRING
IncrementalSignups STRING
IncrementalSignupsModeled STRING
SignupsCampaignIncremental STRING
SignupsChannelIncremental STRING
IncrementalPurchases STRING
IncrementalPurchasesModeled STRING
PurchasesCampaignIncremental STRING
PurchasesChannelIncremental STRING
IncrementalRevenue STRING
IncrementalRevenueModeled STRING
IncrementalVisits STRING
IncrementalVisitsModeled STRING
VisitsCampaignIncremental STRING
VisitsChannelIncremental STRING
CampaignPromo STRING
CampaignStartDate STRING
CampaignExpectedDate STRING
CampaignEndDate STRING
_daton_user_id NUMERIC
_daton_batch_runtime NUMERIC
_daton_batch_id NUMERIC