跳到主要内容 跳到补充内容

Spotify Ads 

Spotify Ads is a digital audio advertising platform.

Supported update methods

For more information, see 目标更新方法概览.

  • Change data capture (CDC)

  • Reload and compare

  • Change data capture (CDC) using Change Tables

  • Full load

  • Change data capture (CDC)

  • Reload

Preparing for authentication

To access your Spotify Ads data, you need to authenticate the connection with your account credentials.

信息注释Make sure that the account you use has read access to the tables you want to fetch.

To get your client ID and secret:

  1. Create an application on Spotify for Developers.

  2. Click Edit Settings.
  3. Set the redirect URI to https://connector.qlik.com/auth/oauth/v3.htm. Your client ID and secret are displayed. Your client ID must be in the allowlist.
  4. To add your client ID to the allowlist, contact the ADS Studio API support: ads-api-solutions@spotify.com.

Creating the connection

For more information, see 连接到 SaaS 应用程序.

  1. Click Authenticate when you have filled in the required connection settings.

    You may be asked to log in to the source application.

    A window is displayed with an authentication code.

  2. Copy the code to the clipboard and return to the connection dialog.

  3. Paste the code in Complete authentication with the code provided by the source and click Verify.

    提示注释You may need to scroll down to see this field.

    When status is Verified,the authentication is verified.

  4. Provide a name for the connection in Connection name.

  5. Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings
Setting Description
Data gateway

如果您的用例需要,请选择一个 数据移动网关

信息注释

此字段不适用于 Qlik Talend Cloud Starter 订阅,因为它不支持 数据移动网关。如果您有另一个订阅层并且不想使用 数据移动网关,请选择

有关 数据移动网关 的优势和需要它的用例的信息,请参阅Qlik 数据网关 - 数据移动

Client Id

Client ID.

Client Secret

Client secret.

Custom Report Dimensions One

Dimensions of the custom report one in uppercase, quotation marks and separated by commas.

The supported values are: CAMPAIGN, AD_SET, AD, ADVERTISER, YEAR, MONTH, DAY, HOUR, COUNTRY, REGION, DMA, PLATFORM, CURRENCY, COST_TYPE.

Example: "CAMPAIGN","MONTH".

Custom Report Metrics One

Metrics of the custom one in uppercase, quotation marks and separated by commas.

The supported values are: FETCHES, STARTS, FIRST_QUARTILES, MIDPOINTS, THIRD_QUARTILES, COMPLETES, IMPRESSIONS, CLICKS, SKIPS, ERRORS, SERVES, PAID_LISTEN_REACH, SERVE_REACH, SERVE_FREQ, PAID_LISTENS, PAID_LISTEN_FREQ, COMPLETION_RATE, SPEND, CTR, RENDER_RATIO, FETCH_REACH, STREAMS, NEW_LISTENER_STREAMS, LISTENERS, NEW_LISTENERS, INTENT_RATE, CONVERSION_RATE, NEW_LISTENER_CONVERSION_RATE, STREAMS_PER_NEW_LISTENER, STREAMS_PER_USER, OFF_SPOTIFY_IMPRESSIONS.

Example: "FETCHES","FIRST_QUARTILES","SPEND".

Custom Report Dimensions Two

Dimensions of the custom report two in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Two

Metrics of the custom report two in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Three

Dimensions of the custom report three in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Three

Metrics of the custom report three in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Four

Dimensions of the custom report four in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Four

Metrics of the custom report four in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Five

Dimensions of the custom report five in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Five

Metrics of the custom report four in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Six

Dimensions of the custom report six in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Six

Metrics of the custom report two in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Seven

Dimensions of the custom report seven in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Seven

Metrics of the custom report seven in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Eight

Dimensions of the custom report eight in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Eight

Metrics of the custom report eight in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Nine

Dimensions of the custom report nine in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Nine

Metrics of the custom report nine in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Ten

Dimensions of the custom report ten in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Ten

Metrics of the custom report ten in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

本页面有帮助吗?

如果您发现此页面或其内容有任何问题 – 打字错误、遗漏步骤或技术错误 – 请告诉我们如何改进!