Attention! The Google BigQuery integration has to be enabled to use this feature.

Importing data from myTarget

After enabling this data source, myTarget advertising costs information will be uploaded to Google BigQuery once every 24 hours.

Connecting and configuring

The process of connecting data sources is described in detail in the overview.

After authorization you need to set the data source parameters.

(1) The name of the data source. It is displayed in the interface in the list of sources.

(2) Value multiplier. Multiplied by the cost in the final report.

(3) Import normalized costs report - enable normalized costs report import.

(4) Import banner statistics report - enable banner statistics costs report import, without normalizing the values ​​in the table.

Where to get data on advertising costs

  • myTargetCosts_{USER_ID}_{YYYYMMDD} - data for normalized costs
  • myTargetCampaignStatistics_{USER_ID}_{YYYYMMDD} - data for banner statistics report

Table structure

myTargetCosts

Field name Type Mode
cost FLOAT REQUIRED
clicks INTEGER NULLABLE
impressions INTEGER NULLABLE
utmTerm STRING NULLABLE
utmCampaign STRING NULLABLE
utmContent STRING NULLABLE
utmMedium STRING REQUIRED
utmSource STRING REQUIRED
currency STRING NULLABLE

myTargetCampaignStatistics

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

Supported substitutions

  • {advertiser_id}
  • {campaign_id}
  • {campaign_name}
  • {banner_id}