myTarget data source
Getting started
- Inside the admin panel click Add Data Source.
- Choose myTarget from the list.
- Click Authenticate with myTarget and go through the authentication flow.
- Enable required reports.
- Click Save.
Available reports
SegmentStream allows to import the following reports from myTarget.
Campaign statistics
Table name
myTargetCampaignStatistics_{USER_ID}_{YYYYMMDD}
Table schema
Field name | Type | Mode |
---|---|---|
cost | FLOAT | REQUIRED |
impressions | INTEGER | REQUIRED |
clicks | INTEGER | REQUIRED |
banner_id | INTEGER | REQUIRED |
campaign_id | INTEGER | REQUIRED |
campaign_name | STRING | REQUIRED |
Additional transformation settings
Besides default reports import, SegmentStream allows to apply additional transformations for the data and help prepare cost data reports grouped by UTM.
This might be very handy if you need to stitch cost data with website sessions or send cost data into Google Analytics.
To enable this transformation use “Import cost data grouped by UTM” setting. Once enabled, a new table with cost data grouped by UTM will appear in your data warehouse.
Table name
myTargetCosts_{USER_ID}_{YYYYMMDD}
Table schema
Field name | Type | Mode |
---|---|---|
date | DATE | NULLABLE |
utmSource | STRING | NULLABLE |
utmMedium | STRING | NULLABLE |
utmCampaign | STRING | NULLABLE |
utmContent | STRING | NULLABLE |
utmTerm | STRING | NULLABLE |
cost | FLOAT | REQUIRED |
clicks | INTEGER | NULLABLE |
impressions | INTEGER | NULLABLE |
currency | STRING | NULLABLE |
Supported dynamic URL parameters
By default myTarget allows to use a lot of dynamic URL tagging parameters to track campaigns.
SegmentStream supports the following parameters:
Name | Description |
---|---|
{{advertiser_id}} |
Advertiser’s ID. |
{{campaign_id}} |
Advertising campaign ID. |
{{campaign_name}} |
Advertising campaign name. |
{{banner_id}} |
Banner ID. |
This document was last updated on June 20, 2020. If you notice any gaps, outdated information or simply want to leave some feedback to help us improve our documentation, please let us know!