Loading
Integrate and Analyze Marketing Data with Marketing Cloud Intelligence
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            SEMrush API Connector

            You are here:

            1. Salesforce Help
            2. Docs
            3. Marketing Cloud Intelligence

            SEMrush API Connector

            SEMrush is a competitive research platform that allows you to analyze your competitors' domains, looking into their traffic, relevant keyword, and so on, SEMrush offers different types of data so you can set up the connector to your liking.

            • Data Lagging: 0 Days

            Prerequisites

            SEMrush API key. An API key is available as part of the SEMrush API package. When purchasing a package, note that Marketing Cloud Intelligence uses 'line' requests for live data only.

            Details

            • You can validate the data by comparing the Marketing Cloud Intelligence view to the table view under each report type, according to the report you chose to retrieve.
            • SEMrush displays in its platform either live data or historical data aggregated to a month granularity. Marketing Cloud Intelligence retrieves only live data from SEMrush, so data will start to aggregate from the stream's creation date moving forward. Note, however, that unlike SEMrush, that doesn't enable viewing the data in a daily granularity, Marketing Cloud Intelligence enables this view.
            • Since the report available in SEMrush displays only the current date's data, you won’t be able to reprocess past dates in SEMrush streams.
            • The SEMrush data is different in structure from the 'Search Keyword' data model. For example, the 'Position' field is defined as a Dimension in SEMrush, but as a Measurement in Marketing Cloud Intelligence. Furthermore, in SEMrush the 'Keyword Name' might be linked to several different 'Position' values. Mapping the data 'as is' might cause discrepancies. The best practice for mapping SeEMrush data is to make sure the 'Keyword Name' and 'Position' fields are linked in a 'many to many' relationship. Another option is to concatenate the two fields together to create a unique 'Keyword Key' for every pairing instance.
               csv['keyword_name']+ csv['position']
              Then map the 'Keyword Name' to the 'Keyword Name' field in the 'Search Keyword' data model, and map the 'Position' to the 'Keyword Custom Attribute' field.

            General Setup

            • Choose the Report you want to retrieve:
              • Domain_organic_search_Keywords - corresponding with the 'Positions' report in Semrush Buyer untargeted Segment Performance report - corresponding with the 'Competitors' report in Semrush.
            • Enter the domain you want to retrieve data for. If no domain is entered, the stream fails .
            • Choose the Database Type. This refers to the Databases available at the top of the report.
            • Select the appropriate Data Stream Type.
             
            Loading
            Salesforce Help | Article