You can create custom variables for your shop sales conversion action and upload your offline transactions to predefined variable values. This feature allows you to upload your offline sales data at a more granular level, and to see your online-to-offline conversions and ROI at slices that matter to your business.
By creating a custom variable with your shop sales conversion action in Google Ads, you can see how a campaign or ad group drives a specific kind of sales transaction, such as sales of a product type or sales by a specific customer segment.
On this page
- Learn the benefits of creating custom variables
- Find out the prerequisites you need before creating custom variables
- Learn how to upload and manage your custom variables
- Upload your shop sales data
- Troubleshoot 'Not Set' or 'Uncategorised' custom variables
Benefits
Apart from helping you draw insights for your offline business, using custom variables with your shop sales conversion action offers valuable features to help you maximise your online-to-offline marketing investments.
- Custom variable segmentation: Custom variables allow you to segment your conversion data by different groups (for example, by customer segment or by product category) for more detailed insights. In addition to receiving reporting for overall sales at the shop sales conversion action level, you can create custom variables (as a subset of this conversion action) and upload transactions for those relevant segments to receive reporting at this additional granularity.
Before you begin
To be able to use this feature:
- You should be a retail, restaurant or automotive business.
- You upload your in-shop transaction data.
- Your Google Ads account should have access to shop sales measurement and be properly set up.
This feature is automatically available to all advertisers meeting above requirements. Contact your Google Ads representative for more information.
Before you begin setting up your custom variables, learn the following definitions and examples to understand how custom variables work.
What's a custom variable?
A custom variable is a custom segment defined by you that dictates the upload and reporting granularity for your shop sales measurement. Custom variables are defined within a shop sales conversion action. You can define a custom variable to be a 'group of product categories', 'a group of customer types' or more. The specific values of this group are predefined by adding custom values associated with its custom variable.
What are the attributes of a custom variable?
There are two major attributes of a custom variable, as described here:
- Variable level: There are two types of variable levels, named 'Basket level' and 'Item level'.
- Basket level should be used when the custom variable is intended to track transactions at a sale transaction level. For example, if the custom variable is defined as 'Customer Type' (where you would like to upload and track your offline transactions by new versus returning customers), then you should choose 'Basket level' as the variable level.
- Item level should be used when you would like to upload and track your offline transactions based on specific items within a basket. For example, if you want to track sales of specific products or categories of products, such as 'shoes versus apparel'.
- Variable values: These are the specific values that are part of the variable. From the examples above, if the custom variable is defined as 'Customer Type', then variable values can be 'New Customer' and 'Returning Customer'.
Follow the instructions below to set up and upload to custom variables for your shop sales conversions.
Instructions
Note: The instructions below are part of the new design for the Google Ads user experience. To use the previous design, click the 'Appearance' icon and select Use previous design. If you're using the previous version of Google Ads, review the Quick reference map or use the search bar in the top navigation panel of Google Ads to find the page you’re searching for.
Important: When creating or uploading custom variables and custom variable values, don’t include any personally identifiable information (PII) or any sensitive categories (as per our data policies). Custom variables and their values should only reflect non-sensitive and non-personal data.
Create a new shop sales custom variable
- In your Google Ads account, click the Goals icon
.
- Click the Conversions drop-down in the section menu.
- If you're using a manager account, click Conversions in the page menu on the left.
- Click Custom variables.
- It's required that the upload metadata refers to the active custom variable (if using custom variables or values in the upload). Google Ads won’t accept any uploads for custom variables that aren’t active.
- You can add up to 20 custom variable values for each custom variable. These values should be mutually exclusive.
- Click the plus button
.
- Enter a name for your custom variable.
- Click the drop-down menu to select a variable level: Basket level or Item level.
- Enter your variable values. Make sure that the variable values are accurate, as you won’t be able to change or remove them after you save the custom variable.
Example
Basket-level variable values
- If you segment your shop sales by customer segments, then your variable values may include different customer loyalty tiers such as 'Bronze', 'Gold' or 'Platinum'.
Item-level variable values
- If you segment your shop sales by product categories, then your variable values may include 'Apparel', 'Grocery' and 'Electronics'.
- Click Save.
- To use the custom variable, click Save and Enable when prompted. If you would like to continue uploading to the last active custom variable, choose Save Only instead.
Edit an existing shop sales custom variable
- In your Google Ads account, click the Goals icon
- Click the Conversions drop-down in the section menu.
- If you're using a manager account, click Conversions in the page menu on the left.
- Click Custom variables.
- On the 'Custom variables' page in Google Ads, select the custom variable.
- (Optional) If you have less than 20 variable values, you may add new variable values until you meet the limit. Bear in mind that you can’t change or remove any previously added variable values.
- (Optional) Update the name of your custom variable.
- Click Save.
Enable or pause a shop sales custom variable
- In your Google Ads account, click the Goals icon
- Click the Conversions drop-down in the section menu.
- If you're using a manager account, click Conversions in the page menu on the left.
- Click Custom variables.
- On the 'Custom variables' page in Google Ads, click the status icon
next to a custom variable.
- Click Enable or Pause. If you enable the custom variable, this will pause another custom variable in your account, as only one custom variable can be enabled at a time.
- If you're working with a data partner for your shop sales uploads, you should inform the partner of any activation or deactivation made to custom variables in your Google Ads account.
Manage all shop sales custom variables
- In your Google Ads account, click the Goals icon
- Click the Conversions drop-down in the section menu.
- If you're using a manager account, click Conversions in the page menu on the left.
- Click Custom variables.
View custom variable reporting
- In your Google Ads account, click the Campaigns icon
.
- Click the Campaigns drop-down menu. Next, click Campaigns or Ad groups.
- Alternatively, you can click the Audiences, keywords and content drop-down menu. Next, click Search keywords.
- Click the Columns icon
above the statistics table.
- Select Modify columns from the drop-down menu.
- Under 'Select metrics', click Conversions.
- Add one or more relevant conversion columns, such as 'All conv.' (All conversions), 'All conv. value' or any other desired predefined conversion column.
- Click the segment icon
above the statistics table.
- Select Conversions, then Custom variables.
- Select the desired custom variable name from the list.
- You can now view rows listing data by the selected custom variable name.
above the statistics table.
above the statistics table.Upload instructions
- Once you complete the above set up, refer to Upload your shop sales data for detailed instructions on making an offline file upload. Make sure that you follow the nuances for custom variables while formatting your offline data file.
Note: After creating a new custom variable, it's recommended that you upload the last 90 days of your offline transaction data to the custom variable, irrespective of whether you were or were not using shop sales measurement before.
Why some conversions show as 'Not Set' or 'Uncategorised' with custom variables
- 'Not Set' can refer to:
- Non-shop sales conversions, if using 'all conversions' or other columns which include non-shop sales conversions, such as online. For example, you’re looking at a view that includes all conversions including online and shop sales, but only the shop sales conversions will have custom variable information.
- Data where the custom variable wasn't set up or available during the date range. For example, you set up custom variables on June 1 and you’re looking at data from 1 May to 30 June. The May data will show as 'Not Set'.
- 'Uncategorised' is shown when sales aren’t assigned to a category. For example, you have 100 sales and assign 80 of them to custom variable values, but 20 of them have no variable value assigned. These 20 will be shown as 'Uncategorised'.
